House Price Predictions @ PASS 2015

The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty...

How Many Times Will You Change a Password?

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

SQL Saturday #413 Denmark 2015

David Postlethwaite will be giving his SQL Azure “Putting your head in the clouds – Working with SQL Azure” at SQL...

Report Builder Changes in SQL Server 2016

As a lot of features, Report Builder will improve as well in SQL Server 2016. At the moment of writing CTP 2.3...

Dustin Ryan: Power Pivot 101: An Introduction

The PASS Excel Business Intelligence virtual chapter presents Dustin Ryan introducing everybody to Power Pivot in Excel. This chapter has...

Extended Events Packages

The first core building block to the data that builds Extended Events is the concept around packages.
Related Posts:

Correlate Trace and XE Events December 28, 2017

SQL Servers Black Box...

Extended Events Packages

Today, I continue on with exploring some of the metadata concerning Extended Events. To date, I have explored various aspects...

Populating My DBA Database for Power Bi with PowerShell – SQL Info

Following my post about using Power Bi with my DBA Database I have been asked if I would share the...

VARCHAR = @NVARCHAR and SARGability

In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....

Columnstore Indexes – part 65 (“Clustered Columnstore Improvements in SQL Server 2016”)

Continuation from the previous 64 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This article is dedicated to the improvements...