How many times the T-SQL inside the CTE is executed?

Introduction

Common Table Expression (CTE) has become very popular these days. However, many users of CTE still have a myth that...

How the SQL Agent Job schedule_uid broke my heart, and my jobs!

This is something that has caused me some grief in my life as a DBA. I hesitate to call it...

IoT Hub vs. Event Hub

There can sometimes be confusion, in IoT scenarios, between IoT Hub and Event Hub, as they can both be valid...

Let NonAdmins Get Logins

I saw a question recently about how to allow some users to see the logins on a server without being...

Speaking at SQLSaturday Chicago – 600!

Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow, 600 SQLSaturdays! This one won’t let you down....

Speaking at SQLSaturday Chicago – 600!

Speaking at SQLSaturday Chicago!
I’m proud to announce that I will be speaking at SQL Saturday Chicago on March 11th 2017! And wow,...

TugaIT – Pre-conference workshop on PowerShell on Linux

Where – Thursday, May 18, 2017 Where – TUGA IT – Lisbon, Portugal
Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your Heterogenous Data Center“ ...

TugaIT – Pre-conference workshop on PowerShell on Linux

Where – Thursday, May 18, 2017

Where – TUGA IT – Lisbon, Portugal

Full Day Session – “Open Source PowerShell on Linux – Skills to Manage Your...

Where is that Preemptive Wait coming from? Database Ownership and Performance: a journey through SQL Server internals with XEvents, Windbg and Wireshark

(EN)
In this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when...

JSON Support Is The Best New Developer Feature in SQL 2016 — Part 3: Updating, Adding, and Deleting…

This is the third article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON...