Extended Event Management Power Tools

PowerShell can pack a pretty big punch when dealing with Extended Events. Using PowerShell as one of your Extended Events Management Tools, there could be a bit of a...

Extended Event Management Power Tools

So far in this series I have introduced a couple of tools that are suitable for helping with the management...

Load Testing Your Storage Subsystem with Diskspd – Part III

In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output from Diskspd and run some tests and interpret results....

The Future Virtualization of the Workforce - Telecommuting

Welcome to the 21st century!  20th
century habits die hard! What am I
talking about today? I’m talking about the virtuous virtue...

Overview of Published Articles – 2015Q3

Here is an overview of the articles I published in the third quarter of 2015.
Retrieve file sizes from the file system...

Table valued parameters (TVP)

Table values parameters
How we can pass multiple rows in stored procedure or function as a parameter?
Table-valued parameters are a new...

Handling decimal and non numeric types using Case statement

Hi Guys

Just encountered a scenario where I needed to handle numeric and non numeric types using Case statement. Here is the...

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour

Detect Worst Performing SQL Queries During Peak Hour