A Moment For Reflection…

While this is a personal blog, I try to keep it focused on either technical topics or personal development and...

Azure Storage pricing

Azure storage is a great, inexpensive solution for storing your data in the cloud.  There are many types of Azure...

Connecting to Azure SQL Database

Recently I created my first Azure SQL Database. But now I need to connect to it.
You can connect using...

The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

“The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)” error may occurs when executing PowerShell scripts using WMI query.
There can...

10 SQL Server Data Warehouse Design Best Practices to Follow (Part 1 )

This past Saturday I had the pleasure of speaking at SQL Saturday #552 here in beautiful Jacksonville, Florida. My good...

Changing Your PASS Credentials

I got an email today from PASS, noting that credentials were changing from username to email. That’s fine. I don’t...

Database Restore Fails with Msg 3154

Have you ever tried to restore over an existing database only to receive the following error message?

Msg 3154, Level 16,...

Live execution plans

SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the...

Live execution plans

SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query...

Live execution plans

SQL Server 2016 brings one of the new features – The live execution plan. You can enable it by clicking the highlighted icon on the Toolbar. Then running a query...