AG Worker Thread Blocked by Log Backup

We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email...

PowerShell – Install PowerShell

Recently got a question regarding PowerShell installation hence this post took an existence.
How to Install PowerShell various versions
http://technet.microsoft.com/en-us/library/hh847837.aspx
http://social.technet.microsoft.com/wiki/contents/articles/21016.how-to-install-windows-powershell-4-0.aspx
Can we have...

Painting with PowerShell: SQL Server Administration

This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.

Here...

SQLSaturday Iowa City is this weekend!

If you’re within driving distance of Iowa City, IA, I’d love to see you at SQLSaturday Iowa City this weekend!...

Monday Morning SQL Break – June 6, 2016

It’s Monday time for this week’s Monday Morning SQL Break.  A chance to catch up on links I’ve shared and...

SQL Compare 12 Beta

The Beta is out. I’ve been waiting for this, and was glad to see Carly’s post on the product. I’ve...

Congrats to MSSQLTips on 10 Years!

MSSQLTips has posted about their 10 years as a resource to the SQL Server community. It’s where I do the...

Elastic Query in Azure SQL Database and Views

The question came up, how do the constructs necessary for Elastic Query within Azure SQL Database affect your ability to...

Painting with PowerShell SQL Server Administration

This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.

Here...

I need help with DBCC

Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I...