SQL Saturday NYC Update #3

SQL Saturday NYC Planning is in going well and we are now getting ready to finalize our precons as 2...

The mysterious permission issue

As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...

T-SQL script to find the growth size of database files

Below query can be used to see the growth size of database files.

DECLARE @filename NVARCHAR(1000);
DECLARE @bc INT;
DECLARE @ec INT;
DECLARE @bfn...

T-SQL script to find the highly populated tables in database

Sometimes we need to check which tables of our database is highly populated. Below is the T-SQL Script which we...

"OR" pattern causing indexing scans in parameter based queries

#Tl;dr article (time constraints prevented me from reworking significantly)
An article on SQL-Server-pro was forwarded over to me to research by...

(Ctrl+E) was pressed. Waiting for the second key of chord…

I first came across the error “(Ctrl+E) was pressed. Waiting for the second key of chord…” last year, these weird errors...

Better late than never…

Just like last year, I’m a bit late with the obligatory “how was last year and what is this year...

Building Connection Strings

I ran across a great article on Connection Strings from my good friend, Allen White (b, t, c), recently. Quite...

Enabling Portable Git in Node.js command prompt on Windows

GitHub for Windows doesn't put Git in the PATH by default.  If you'd like your Node.js command prompt to have...

SQL Judo’s Monthly Challenge – January 2014 – Restore the Master

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be...