[Database Series 07] Understand Indexes! Why the Same SQL Can Have Vastly Different Search Speeds

The theme for this session is database "indexes".Indexes are one of the technologies you absolutely must understand when ...
techtarget

Executing SQL statements using prepared statements and statement pooling

A prepared statement is a SQL statement that has been compiled, or prepared, into an access or query plan for efficiency. A prepared statement is available for reuse by the application without the ...

[Database Edition 08] Understand SQL Execution Plans! Essential Knowledge for Finding the Cause of Slow SQL

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...
Redmondmag.com

SQL Server Connection Strings Made Easy

SQL Server Management Studio can help take the guesswork out of creating connection strings for PowerShell applications.