Problems When Running DBCC SHRINKFILE On SQL Server Database

Overview of the Situation
While accessing data files in SQL Server, many issues may occur that may lead to frustrating situation...

What do you want to learn about SSRS 2016 at PASS Global Summit?

I’m thrilled to have been selected to deliver a session at the 2016 PASS Global Summit titled “Reporting Services 2016:...

Are my SQL logins weak?

Security is a vital component of data security. In today’s day and age it is imperative to think about security....

Is Resource Monitor (resmon) all I need to troubleshoot storage?

I was recently doing some work on my Windows 10 desktop and placed a drive on one of the slower...

Struggling With Due Diligence

It’s been a while since my last post, there are various reasons for my absence:  work, illness, having our house...

Update duplicate xml attribute values to unique value

I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why...

Update duplicate xml attribute values to unique value

I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...

Update duplicate xml attribute values to unique value

I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...

Automating Azure Resource Management Authentication

I love Azure and I love PowerShell.  They are a perfect marriage. It’s amazing how much automation you can do...

Comparing databases using SSDT

Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!

The...