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

How to resolve connection errors when loading data in SSAS Tabular project

This post actually applies to both multidimensional (cube) projects and Tabular projects which manage data source connectivity in a similar...

Building Connection Strings

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

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

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

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

Parameterization Part 7: Summary

This is a summary of the parameterization blog post series. If you read the previous posts in the series, then...

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

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