Build useful SQL Server alerts with Agent, operators, failed-job notifications, and a review routine that verifies the whole delivery path.
SQL SERVER – Introduction to Cloud Computing
An introduction to cloud computing for database people: what it means, how it differs from grid and utility computing, and its key characteristics.
SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers
It’s my birthday, so I am taking a break from tech posts to spend time with family and to thank my top 7 commenters who help readers on this blog.
SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
SQL Server 2008 lets you copy database with data: turn on Script Data in the Generate Scripts wizard to get INSERT statements for the rows in your tables.
SQL SERVER – 2008 – Design Process Decision Flow
Explaining SQL Server to a room with no SQL experts? The design process decision flow from the SQL Server 2008 IPD guide made my job much easier.
SQL SERVER – List All Missing Identity Values of Table in Database
Reader Yasmin asked how to find tables with missing identity values across a database, and Imran Mohammed answered with a well commented script.
Full-Text Search Basics
Full-text search basics explains catalogs, full-text indexes, CONTAINS, and LIKE so SQL Server searches match the question and the data.