I have often made an effort to attend conferences in the past to grow my career. Even today, when I speak at a conference, I’ll try to go to...

2024-09-23

21 reads

Additional Use for sp_statement_completed

by Grant Fritchey

The Scary DBA

Another discussion in Gothenburg (such a great group of people) around Extended Events lead to a (admittedly, tiny) idea for an additional use for sp_statement_completed. The basics for sp_statement_completed...

2024-10-09 (first published: 2024-09-23)

389 reads

Are You Making These Mistakes? Using Standard SQL Functions for Database Queries Like a Pro!

by Tracy McKibben

RealSQLGuy - Helping You To Become A SQL Hero

Let's be honest – SQL can be a bit of a beast. At first glance, it seems simple enough. But as you dive deeper, the complexity ramps up. Suddenly,...

2024-09-23

68 reads

SQL Query Stats via Powershell

by alevyinroc

FLX SQL

Sometimes, work tasks and questions that come up in the SQL Server Community Slack coincide.
A couple weeks ago, DrData asked
With SET STATISTICS IO ON, is there really no way...

2024-10-07 (first published: 2024-09-22)

299 reads

A New Word: Mottleheaded

by Steve Jones

The Voice of the DBA

mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family, or friends and colleagues, or colleagues and family – mixing a medley of ingredients that...

2024-09-20

23 reads

Microsoft Purview GA menu’s

by James Serra

James Serra's Blog

The new data governance features in Microsoft Purview are now being made generally available as they are gradually rolled out across various regions. You can view the deployment schedule...

2024-10-02 (first published: 2024-09-19)

171 reads

Connect to Power BI as a Guest User in another Tenant

by Koen Verbeeck

Koen Verbeeck

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as a guest user in another tenant. This happens quite a lot when you’re a...

2024-09-27 (first published: 2024-09-19)

384 reads

Parsing EXE Output in PowerShell

by Steve Jones

The Voice of the DBA

I saw a post internally that asked this question: Anyone have a handy powershell script testing if the installed flyway version matches a specific string? That seemed simple, but...

2024-10-04 (first published: 2024-09-18)

455 reads