SQLSaturday - Portland : Detect Worst Performing SQL Queries During Peak Hour

SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them is a single most efficient technique to fix unexpected...

SQLSaturday – Portland : Detect Worst Performing SQL Queries During Peak Hour

Detecting worst performing queries executed in a particular duration and how many times it got executed and fine tuning them...

Webinar with PernixData – Tuesday at 1PM Pacific

Join PernixData and me tomorrow at 1PM Pacific for a webinar discussing an exciting technology from PernixData!
In-memory computing is gaining...

Columnstore Indexes – part 69 (“Operational Analytics – Disk Based”)

Continuation from the previous 68 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is dedicated to one of...

Step by Step SSIS Multicast Transformation TIP #121

Dear Friends,
This is another post in the series of step by step SSIS ,Zero to hero series. In this post...

The Whirlwind That Is October – Part 2

October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...

A New Achievement

To celebrate a recent achievement, I have decided to create a whole new section to my blog that will be...

SQL Saturday #437–Boston BI Edition 2015–You Can Still Analyze Data with T-SQL

Thanks for attending my session on analyzing data with TSQL. I hope you learned something you can take back and...

Step by Step SSIS–Union ALL tip # 119

 
Dear All,
In the series of  zero to hero SSIS series this is one of the simplest transformation control which...