What is data mining? A simple introductory note on finding hidden patterns in large data, with a supermarket example and who takes part in the work.
SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction
Backup and Restore lessons from my consulting work: conventional backups, split file backups, mirrored backups and the FORMAT clause, each with an example.
SQL SERVER – Download Script of Change Data Capture (CDC)
Many readers asked for the script from my Change Data Capture (CDC) article for SQL Server 2008. Here it is to download, with a recap of how CDC tracks changes.
SQLAuthority News – Baby SQLAuthority is here!
Baby SQLAuthority is here! God has blessed Nupur and me with a healthy baby girl on September 1, 2009. Do you have a suggestion for an Indian name?
Oracle to SQL Server: Translating NVL, ROWNUM and Sequences
Translate Oracle to SQL Server expressions for NULLs, row limits, dates, sequences and concatenation, and test where they differ.
Central Management Servers and Registered Servers
Use Central Management Servers and registered servers in SSMS to organize SQL Server instances and run safe read-only queries across groups.
Finding Single-Use Plans Wasting Memory in the Cache
Find single-use plans, compare their cache memory with the total, and inspect parameterization before discussing server-wide cache settings.