Author: Prashant Kumar

PowerShell Script to Manipulate SQL Server Backup Files

Scenario I use Ola Hallengren’s famous backup solution to back up my SQL Server databases. The destination for full backups is a directory on local disk; let’s say D:\SQLBackup\ If you are familiar with Ola’s backup scripts, you know the…

Read More >

Why is Affinity Mask Negative in sp_configure?

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value. name                                minimum     maximum     config_value run_value ———————————– ———– ———– ———— ———– affinity mask                       -2147483648 2147483647  -1066394617  -1066394617 Affinity mask is a…

Read More >

SQL 2008 Patch Setup Fails if Patch Source is on a Shared Disk

I recently worked on a case where Service Pack 2 for SQL 2008 clustered instance failed with this error (Summary.txt). The resolution (or workaround I would say) is simple, use a local disk to launch SP2 setup, here’s a step by step how to.

Read More >

SQL Server 2012 Denali: Discussion On Usage Scenario for “Extended Events” (Part-1)

In this blog, I am going to demonstrate how we can use the wait event category sqlos.wait_info* to track the wait resources the queries running in a particular session undergo.

Read More >