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

SQL Script to find the last executed commands on the SQl Server

Sometimes we needs to find out the last executed commands on the database server. 
Below is the SQL script share by...

Effects of Max Mem on Plan Cache

Reading a Microsoft Article (which can be found here) while making sure I understood what can cause a query plan to...

Finding the reason for the error “Subquery returned more than 1 value”

First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In...

Overview of Published Articles – 2014Q4

Here is an overview of the articles I published in the last quarter of 2014.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...

Script to find the Fragmentation of indexes

Below is the script to find the fragmentation of the indexes created on a database.

SELECT OBJECT_NAME(OBJECT_ID), index_id,index_type_desc,index_level,
avg_fragmentation_in_percent,avg_page_space_used_in_percent,page_count
FROM sys.dm_db_index_physical_stats (DB_ID( N'Database name')...

SSIS 2012 Design Patterns by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ufford

During my vacations at the end of 2014 I have finally finished a book on “SQL Server 2012 Integration Services...

Using Power BI to access on-premise data

The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on...