The tools a DBA installs on day one include SSMS, command line utilities, a checked script library, and managed source control.
SQLAuthority Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008
At the August 30 Ahmedabad User Group meeting we talked about the quality of programmers and hiring, and why free user groups are great for developers.
SQLAuthority Author Visit – Microsoft Student Partner Conference
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.
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.
GREATEST and LEAST: Find Row Extremes With NULLs
GREATEST and LEAST compare several expressions within one row. These typed decimal examples show negative numbers, ties, partial NULLs and an entirely missing row.