Learning SQL #1–Start from buying a Copy of SQL Server Developer Edition

If learning SQL is in your New Year Resolution, then you will be happy to read this post.
We all make...

On Failure

The first rule of blogging is that you should write about topics you know a lot about. And I know...

Reports In SSISDB

I was approached with an in shop issue where a group could not view the execution reports in the SSISDB....

Six practical tips for social media success in 2015

Social media is the new résumé.  In many ways, it’s even better than a résumé – a person’s social media stream...

SQL – Split delimited columns using XML Or UDF function

The requirement is to convert the delimited column into rows
Input data and required output details are given below
EnoEnameEslocEDept1ABCNJ10,20,30,40,50Output:-
EnoEnameEslocEDept1ABCNJ101ABCNJ201ABCNJ301ABCNJ401ABCNJ50Download the Script Split...

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...