XEvent Session Supporting Cast

Beyond the metadata in the the catalog views and DMVs, there are a few more objects that come in handy when dealing with Extended Events. I call these the...

XEvent Session Supporting Cast

So far, in this series, I have discussed the means to view the metadata associated with Extended Events. I also demonstrated...

Hekaton Part 5: Introduction to Indexes in "In Memory Tables"

After a short little break on Hekaton series, we are now back with the 5th post.

Two new index types...

Executing DBCC for SQL Server Analysis Services 2016

In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability...

Growing Pains for the Networking Dinner

A few years ago Andy Warren had this idea for a networking dinner. We had been chatting about all the...

SSIS – Unexpected Termination

I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages...

Viewing Running XEvent Metadata

Running session metadata, while it can be still be viewed in the catalog views, is exposed via DMVs. Putting it a slightly different way, if I query DMVs that...

Viewing Running XEvent Metadata

In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata...

SQL Server 2014 Buffer Pool Extension part 3: system monitoring

In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of...

Columnstore Indexes – part 64 (“T-SQL Improvements in SQL Server 2016”)

Continuation from the previous 63 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to write a rather...