Storing Event Data

Among the several core concepts of Extended Events is the concept of storing event payloads / data.
Related Posts:

How to: File Target use in Extended Events December 27, 2018

Dynamics...

The Trouble with Rules

I love running. I wake up at 5am three times a week, run for an hour, and by 6:30am I’m...

T-SQL Tuesday #70 – The Enterprise

It’s hard to believe this is the 70th edition of T-SQL Tuesday. I haven’t missed many, and I’ve enjoyed them...

Using @@ROWCOUNT can be a bit tricky

@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...

What is the Difference Between Full Load and Incremental Load

When you start working in ETL (Extract, Transform, and Load) or SSIS projects, you’ll be faced with two basic terms:...

Actions In Extended Events

The next component to discuss is Actions. I have discussed various aspects of events, schemas, categories and packages as some...

Actions In Extended Events

an action invokes memories of verbs and "to do" something. If you recall from the quick definition in the article on Extended Events Objects, an action is "a means...

Building Better SSIS Packages Class in Dallas

I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better...

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

Continuation from the previous 65 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing writing about the improvements added to...

Creating Time Calculations in Power BI

One of the current issues in Power BI is the inability to specify a Date table. The Date table is...