SSMS Connection Information

If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...

Advanced SSIS Training Course Preview

If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and...

Power Bi, PowerShell and SQL Agent Jobs

Continuing my series on using Power Bi with my DBA Database I am going to show in this post how...

Why I Don't Use the Architect Title

I get nervous when I see the title "architect" in IT job roles.

I've had this title before as an employer's...

Table partitioning

What is partitioning.
To start with partition is the feature provided by SQL server in which very large tables are split...

SQL Saturday as an Attendee

Last week I did something that many people have already done. However this was my first experience, and I really...

Thoughts on the 2015 PASS Election

We had a decent election this year. Thanks to all four candidates – Argenis Fernandez, Jen Stirrup, Ryan Adams, and Tim...

The Extended Event GUI

The Extended Events GUI provides a visual access to the Extended Events engine that can help to better understand the XEvents Engine and how a Session is built.
Related Posts:

Profiler...

The Extended Event GUI

In the previous article in this series I shared the basics around assembling an XEvent session. The method used in...

SQL Server SSIS: ReplaceNull

One of widespread problems in SSIS packages is to replace NULL values with some specific value. Unfortunately, before it was not a simple task as Integration Services didn’t have...