Powershell Quick Parameters for Scripts

I was working on a script recently to manage a particular process and wanted to make it generic by allowing...

Easy way to diagnose SQL Server “sp_Who2” TIP #84

 
Why the SQL Server is running slow ?
What are the processes running currently on SQL SERVER instance ?
Many other like...

This one enhancement makes AlwaysOn Availability Group better in SQL Server 2014 !

I keep getting questions on what is improved other than the increased number of secondaries(8 now) with AlwaysOn Availability Group(AG) in...

SQL Cruise Caribbean 2015 Wrap Up

I just returned home from this year’s SQL Cruise in the Caribbean. WOW!

This trip was our first SQL Cruise, but it...

Parsing SQL Saturday Data – Looping Through And Loading All XML Files

After my last post on parsing the XML, I decided to continue forward and get ready to put the data...

Power BI Made Simple

In an effort to understand Power BI and all the products it encompasses, I have made this slide deck to...

VMware vExpert 2015

VMware has announced the list of 2015 recipients of the vExpert award, and I am humbled and honored to have been...

Triggering a System Center Configuration Manager deployment task

A slightly different topic today.
Once you have built up knowledge, you become the person that people ask to solve things....

Free Video for Accidental DBA’s

Recently, Mike Walsh and John Sterrett teamed up with Embarcadero to give a 60 minute presentation focusing on the skills...

Test your UPDATEs and DELETEs before you run them

This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you...