On August 30, 2008 I presented a technical session at the Microsoft Student Partner conference in my city, and I explain what the MSP program offers students.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
COMPRESS and DECOMPRESS: Restore Text With Its Original Type
COMPRESS and DECOMPRESS return binary data, so I restore text with its original character type explicitly. A decompressed value is not automatically a readable string. Its bytes still need the correct interpretation.
SQL SERVER – Introduction to Filtered Index – Improve performance with Filtered Index
A Filtered Index in SQL Server 2008 indexes only some rows of a table, which can speed up queries and cut index storage and upkeep. Example on the Employee table.
SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example
Table-Valued Parameters in SQL Server 2008 let you pass many rows to a stored procedure without a temp table. I walk through the steps with a Department example.
SQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0x7e, status code 0x60
TDSSNIClient initialization failed with error 0x7e, status code 0x60, stopped me from connecting to SQL Server 2008. Here is how I solved it.
SQL SERVER – Few Useful DateTime Functions to Find Specific Dates
Useful DateTime functions from Vivek Jamwal: find today, yesterday, and the first and last day of the current or last week and month with DATEADD.
SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE
The SQL Server 2008 Merge Statement does INSERT, UPDATE and DELETE in one statement and reads the data only once. An introduction to how it works and its syntax.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.