SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: August 2016

Events By Feature

Within the world of SQL Server there are a few things one can be certain of – things will change. This is true of the features in SQL Server. Additionally, Extended Events is constantly evolving which underscores this constant change.

With all of this change occurring within SQL Server, sometimes… Read more

0 comments, 526 reads

Posted in SQL RNNR on 30 August 2016

Finding the Right Path

I have a fairly large backlog of articles that are in progress or that are planned for my series about Extended Events. Despite the backlog and planned articles, every now and then something else comes up that bumps things around. This article is an example of bumping the schedule around.… Read more

0 comments, 1,335 reads

Posted in SQL RNNR on 24 August 2016

T-SQL Tuesday #081: Recap

Sharpen Something

In case you missed it (many did), TSQL Tuesday was a challenging event this month. I invited people to do a put a little more into writing a post than what they may usually do. There were some very good reasons for this. If you are interested, take… Read more

4 comments, 300 reads

Posted in SQL RNNR on 18 August 2016

T-SQL Tuesday #081: Getting Sharper

Sharpen Something

This month I am the host of the TSQL Tuesday blog party. In the invite, which can be read here, I asked people to decide on something to work on, plan out and then report the success/failure.

Not only am I the host, but I am a… Read more

0 comments, 240 reads

Posted in SQL RNNR on 16 August 2016

Audit All Select Statements

Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required that queries be audited and tracked to reach compliance with the legislation or regulation. To achieve this compliance, this article will demonstrate how to use Extended Events to audit statements… Read more

4 comments, 2,421 reads

Posted in SQL RNNR on 8 August 2016

BIT9 PathNames

We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news. In our quest to improve security we seemingly always find more and more products that are supposed to help with that security. Sometimes, those products require a data… Read more

4 comments, 589 reads

Posted in SQL RNNR on 5 August 2016

T-SQL Tuesday #081: Sharpen Something – Reminder

Sharpen Something

Last week I sent out the invite for the August TSQL Tuesday blog party. In that invite I promised to send out a reminder seven days prior to the event. Well – it is that time.

You are cordially invited to read the invite for TSQL Tuesday 81 Read more

0 comments, 1,282 reads

Posted in SQL RNNR on 2 August 2016

Easily Shred Event Data

It has been nearly a year since I started an extensive series about Extended Events. Previous to that start, I had already written a bunch of articles about Extended Events.

Among the batch of articles preceding the 60 day series one can find an article about shredding extended event data.… Read more

8 comments, 1,779 reads

Posted in SQL RNNR on 1 August 2016