Announcing SQL Server Infernals

Today I’m starting a new blog series called “SQL Server Infernals”.
Throughout this series, I will take your hand and walk...

Speaker of the Month: May 2015

When I attend sessions at events, I try to mix it up. I’ll go to a session that, really, I...

T-SQL Tuesday #67 – Extended Events for DBCC

It’s the second Tuesday of the month and time for another T-SQL Tuesday. This time it’s #67 from Jes Borland...

SQL Saturday Albany (#sqlsat386) – Look Who’s Speaking!

So on June 3rd I got this email from Edward Pollack.

I had submitted a few weeks earlier and had been...

A walk-through of creating the Activity Tracking template using Extended Events.

It’s the second Tuesday of the month and that means T-SQL Tuesday time! T-SQL Tuesday is a blog party started...

Talking TypeScript on the .NET Rocks! Podcast

I appeared on the .NET Rocks podcast show #1149 this week.  I had a blast talking about TypeScript, the new...

Columnstore Indexes – part 55 (“New Architecture Elements in SQL Server 2016”)

Continuation from the previous 54 parts, the whole series can be found at http://www.nikoport.com/columnstore/
The architectural changes in the upcoming SQL...

Installing and upgrading default scripts automation – part one – Introduction

First I must say thank you to all of the wonderful people who have put time and effort into providing...

Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8

Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database...

SQL Server 2016 features to look for -2

In Previous post we have seen the new features of SQL server 2016 in short and had a brief discussion...