Tricks - Copy T SQL Result to Excel

Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy...

Hardware Wrestling

A few weeks back I had some issues. They were related to this:

My standing desk was down and as you...

How to check advanced options in SQL Server?

To check the available advanced options configured at instance level in SQL Server, you need to use the  sp_configure system...

Login failed for 'NTAUTHORITY\ANONYMOUS LOGON' - the fix you probably haven't tried yet

Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups.
If you've ever received the message "login failed...

SQL Puzzle 4: The Beale Papers

I’ve not done a SQL puzzle for a while so thought it was getting overdue…
I set this one for my...

SSIS Issues : A Day of Learning

Seldom are the days when you run into complex issues but resolve them in the shortest interval of time.

Thanks to...

Time Zones are a Drag … Seriously

Time Zones were definitely being a drag today. I got an email from one of the developers at work asking...

Azure SQL Database – Service Tiers

Naturally the cost of Azure SQL Database directly relates to what tier and performance level you are using. Starting from...

Dealing with disquiet

Last week I listened to a podcast from one of my best friends in the sql community – Kendra Little. In...

SQL SERVER ON LINUX INSTALLATION – PART3 – INSTALL SQL SERVER COMMAND-LINE TOOLS ON RHEL

As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it...