SQL Shack round – up – November 3rd, 2014 – Backup testing with PowerShell, unit testing with SSDT, database snapshots, data cleaning, and index strategies

In the latest SQL Shack articles, we wrote about backup testing with PowerShell, unit testing, database snapshots, index strategies, and data cleaning:

Backup testing with PowerShell – Part 1: The test – see how to setup automated testing of your backup files with PowerShell, Central Management Server, and the SQL Server Agent

Backup testing with PowerShell – Part 2: Reporting results – this article builds on part 1, backup testing, by demonstrating the queries and reporting mechanisms available for displaying the results of backup file testing.

Unit testing with SQL Server Data Tools – the second part of the series about SSDT and database development.

Third post in the series about database development and testing using SQL Server Data Tools and Team Foundation Server – Automating database tests with Visual Studio and Team Foundation Server

Exposed to “dirty data”? See how to win a battle in How clean is YOUR data!! article.

Recover dropped objects or data removed using database snapshots – SQL Server Database Snapshots

Continued discussion on choosing the right table structure – Index Strategies – Part 2 – Memory Optimized Tables and Columnstore Indexes
 

Related posts:

  1. SQL Shack round-up – October 17th, 2014 – Performance reporting and auditing in SQL Server, Cryptographic features, Continuous integration with SSDT and TFS, and Index strategies
  2. SQL Shack round – up – November 19th, 2014 – Loading data from SharePoint, Slipstreaming SQL Server, and Reporting Services
  3. SQL Shack round – up – December 31st, 2014 – 14 new articles including SSRS, auditing, transaction log, Buffer Pool extension, and more
  4. SQL Solution center round-up – November 1st, 2013 – SQL Server database snapshots and methods for tracking data changes on SQL Server
  5. SQL Shack round – up – January 16th , 2015 – 4 new articles including data security, database deployment, DAX, and SMB fileshare
November 3, 2014