T-SQL Tuesday 107 – Viral Demo

• by Matthew McGiffen

• Matthew McGiffen DBA

For this month’s T-SQL Tuesday. Jeff Mlakar invites to talk about “a project you worked on or were impacted by...

2018-10-19 (first published: 2018-10-09)

1,860 reads

Checking for Membership of a Specific Active Directory Group

• by Matthew McGiffen

• Matthew McGiffen DBA

As part of my job I manage a bunch of SQL instances for Development and Test.
Access is managed though Active...

2018-10-15 (first published: 2018-10-02)

2,255 reads

Extended Events Made Easy: Using XEvent Profiler

• by Matthew McGiffen

• Matthew McGiffen DBA

In this post we’ll look at how quick and easy it is to use the XEvent Profiler to create an...

2018-10-08 (first published: 2018-09-25)

3,612 reads

Table Variable Performance “Fixed” in SQL 2019

• by Matthew McGiffen

• Matthew McGiffen DBA

Reading the new features for SQL 2019 I spotted this:
One of the most popular posts on my blog last year...

2018-10-03 (first published: 2018-09-25)

2,526 reads

Don’t Just Rely on Query Execution Stats for T-SQL Execution

• by Matthew McGiffen

• Matthew McGiffen DBA

I recently had an incident where I was looking into the cause of a long running process for a client....

2018-09-28 (first published: 2018-09-18)

2,072 reads

TRY_PARSE

• by Matthew McGiffen

• SQLServerCentral.com

• T-SQL

Introducing the PARSE function, brought to us in SQL Server 2012.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.55 (11)

Log in or register to rate

2018-09-13

2,377 reads

• Discuss

T-SQL Tuesday #106 – The Trouble with Triggers

• by Matthew McGiffen

• Matthew McGiffen DBA

For this month’s T-SQL Tuesday Steve Jones asks us to talk about our experiences with Triggers:
https://voiceofthedba.com/2018/09/03/t-sql-tuesday-106-trigger-headaches-or-happiness/
In my post I’m going...

2018-09-12

246 reads

Exporting Extended Events Session Data to a Table

• by Matthew McGiffen

• Matthew McGiffen DBA

If you’re a long time Profiler user like me then you probably often take the option of saving (or loading)...

2018-08-23 (first published: 2018-08-08)

1,871 reads

Using the built-in System Health session

• by Matthew McGiffen

• Matthew McGiffen DBA

When Microsoft introduced Extended Events (XE) in 2008, they also gave us a built-in XE session called system_health (though it’s...

2018-08-16 (first published: 2018-08-01)

3,846 reads

There’s Still a Place for SQL Server Profiler

• by Matthew McGiffen

• Matthew McGiffen DBA

Follow a few of the SQL Family on Twitter and you’ll mostly see one view regards SQL Profiler, and it’s...

2018-08-09 (first published: 2018-07-25)

2,248 reads