(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...  Read more...

I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or I...  Read more...

Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m...  Read more...

A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...  Read more...

This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH It had a massive...  Read more...

Please, please, please Admins do not leave your default index fill factor at 0. This means you are telling SQL...  Read more...

This is also a part of a basic series on git and how to use it. There are lots of git...  Read more...

Years ago I bought a Pebble smartwatch. I didn’t back the Kickstarter, but a few friends did and I liked...  Read more...

PASS has continues to ramp up the plans for the PASS Summit in Seattle this October, and my precon session, “Virtual...  Read more...

I had someone that told me recently that they needed to find a way to get code coverage in T-SQL....  Read more...

Excited for next week as I’m heading down to Cork to speak at the User Group there. Over 3 years...  Read more...

Very quick blog post today. While setting-up a development server at a client who is still using SQL Server 2012,...  Read more...

I am still trying to get up to speed on blogging after a gap. Today I managed to push myself...  Read more...

For those that don’t know, I live in Texas. Been here all my life. There are two main things north...  Read more...

The schedule for SQL Saturday #682 Minnesota 2017 is out, and I will be giving my talk on Extended Events: -- Getting...  Read more...

Thanks to everyone at a joint meeting of the Baton Rouge .NET and SQL Server User Groups who joined my...  Read more...

If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...  Read more...

Hello friends, Please find the link of my new article – https://social.technet.microsoft.com/wiki/contents/articles/40102.microsoft-azure-how-to-check-the-available-extensions-for-a-virtual-machine-using-powershell.aspx Tagged: Azure, AzureSubscription, Microsoft Azure, Powerhsell, Powershell, Sql Server,...  Read more...

Schemas are a very useful tool for managing the objects in your database. From security through process, through placement, schemas...  Read more...

I just realized that our two SQL Server on VMware sessions that I co-presented on Tuesday at VMworld USA, both of which made the top...  Read more...