Administration

Backup testing with PowerShell

This week I released a two part blog series on SQLShack.com. The series covers automated testing for your backup files and reporting on the results. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered. Abstract Once your…

Query Cached Execution Plans

Often I need to examine an execution plan from a production server. Just as often, I can’t re-run the stored procedure in that environment. There are several techniques for simulating the environment on a test server such as exporting statistics…

SQL Server 2012 SP2 released

Microsoft SQL Server 2012 SP2 is now available Build number: 11.0.5058.0 Microsoft SQL Server 2012 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP2. This service pack contains up to and including…

April SQL Server Updates

SQL Server 2014 Cumulative Update #1 is Available Microsoft has released Cumulative Update #1 for SQL Server 2014. KB Article: KB #2931693 114 fixes listed at time of publication (121 total) Build number is 12.0.2342 Relevant for @@VERSION 12.0.2000 through 12.0.2341…