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

Use Twitter to get #PowerShell help

A quick post today just to add some weight to something that Mike Fal b | t has kicked off. The #SQLHelp...

How to deploy SSIS Package ? Step by Step SSIS TIP #114

Dear Friends,
In last post we have successfully created our fist basic package. So, Now the next thing is how...

018 – Learn Like A Pro! - Syndication – WaterOx Consulting

Learn Like A Pro In WOxPod!, episode # 018 – “Learn Like...
The post 018 – Learn Like A Pro! appeared first on WaterOx...

Buffer Pool Extension in SQL Server 2014 part 4: benchmark testing for update operations

One of my previous articles was devoted to carrying out a range of tests to compare speed of data read...

Speaker of the Month: September 2015

Feast or famine.
The last several months I just haven’t seen that many speakers, let alone that many community speakers. Then,...