SQL Prompt 7 by RedGate

RedGate unleashed their newest version of SQL Prompt recently. It is no secret to those of you who know me...

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

Storing Event Data

Among the several core concepts of Extended Events is the concept of storing event payloads / data. When an event fires, it...

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

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

Actions In Extended Events

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

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