Build useful SQL Server alerts with Agent, operators, failed-job notifications, and a review routine that verifies the whole delivery path.
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.
How to Patch SQL Server Without a Bad Morning
Before you patch SQL Server, check backups, plan replica and cluster sequencing, record builds, and prepare a tested recovery path.
Auditing Who Changed What, and When
Plan SQL Server auditing around the question you need answered, then distinguish security events from row history, change tracking, and CDC.
SQL SERVER – Introduction to Business Intelligence – Important Terms and Definitions – 2
Important terms and definitions in business intelligence, explained in plain words and grouped by how data moves from source systems to reports.
SQLAuthority News – Download – SQL Server 2008 Developer Training Kit
Download the SQL Server 2008 Developer Training Kit by Microsoft to learn how to build web applications with the new data types in SQL Server 2008.