-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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,390 reads

Posted in SQL RNNR on 1 August 2016

T-SQL Tuesday #081: Sharpen Something

Sharpen Something

It has now been 30 months since the last time I hosted a TSQL Tuesday, that was TSQL Tuesday 51. I recapped that event here with the original invite here. I can’t believe it has been that long since I last hosted. It only seems like yesterday. Read more

10 comments, 338 reads

Posted in SQL RNNR on 27 July 2016

You Deserve to be an MVP

I have been sitting on this article for a while now. I have been tossing around some
thoughts and finally it is time to share some of those thoughts with the masses. I hope to provoke further thought on the topic of being an MVP.

I want to preface all… Read more

2 comments, 274 reads

Posted in SQL RNNR on 25 July 2016

Another Query to Help Find the Right Event

Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events. In this follow-up article to Extended Event Help Queries, I will share another means to quickly explore the… Read more

3 comments, 1,302 reads

Posted in SQL RNNR on 21 July 2016

Extended Event Help Queries

Enjoy this article re-publication from my original work at SQL Solutions Group.

When working with Extended Events, there are times when a little more information is, well, helpful.  You know you want to use extended events to try and monitor for a specific thing to happen.  But sometimes you don’t… Read more

1 comments, 425 reads

Posted in SQL RNNR on 19 July 2016

SQL Server CTE – Back to Basics

Quick Flashback

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

I… Read more

2 comments, 2,980 reads

Posted in SQL RNNR on 14 July 2016

SQL Server Desired Enhancements

Happy Belated Birthday

The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month – or at least is supposed to happen on that day. This month, the formidable Chris Yates (blog | twitter) has invited everybody to a birthday party Read more

4 comments, 274 reads

Posted in SQL RNNR on 13 July 2016

Awesome SQL Server Feature

The second Tuesday of April 2016 is now upon us and you know what that means. Well, I hope you know what that means.

It is time for TSQL Tuesday. It is now the 77th edition of this monthly blog party. This month the host is Jens Vestergaard (blog Read more

2 comments, 321 reads

Posted in SQL RNNR on 13 April 2016

SQL Server Select – Back to Basics

Prelude in SQL Minor

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet Read more

0 comments, 402 reads

Posted in SQL RNNR on 2 April 2016

SQL Agent Job Schedules

Many moons ago, I posted a script to help report on the human friendly scheduling information for SSRS subscriptions. You can read all about that here.

In a very similar fashion, today I want to share how easy it is to turn the internal schedules for SQL Agent jobs… Read more

2 comments, 1,894 reads

Posted in SQL RNNR on 29 March 2016

Index Cannot Be Reorganized…

Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your purview.

As a part of this maintenance you have scripted solutions to intelligently manage and maintain the fragmentation levels for each of the indexes within each database on each instance. Read more

0 comments, 288 reads

Posted in SQL RNNR on 16 March 2016

The Virginia Tour 2016

Long Time Coming

With less than a week before the Richmond SQLSaturday event, I am finally getting this post done – maybe.

This is not just a one day event for me. No no! I will be presenting for three consecutive days on many things SQL Server related. The Virginia… Read more

0 comments, 269 reads

Posted in SQL RNNR on 11 March 2016

SQL Server Locks – Back to Basics

Prelude in SQL Minor

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet Read more

0 comments, 2,523 reads

Posted in SQL RNNR on 1 March 2016

SQL Server Principals – Back to Basics

Prelude in SQL Minor

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet Read more

3 comments, 2,218 reads

Posted in SQL RNNR on 28 January 2016

All about the Change

The second Tuesday of January 2016 is now upon us and you know what that means. Well, I hope you know what that means.

It is time for TSQL Tuesday. It is now the 74th edition of this monthly blog party. This month the host is Robert Davis (blog Read more

1 comments, 1,020 reads

Posted in SQL RNNR on 12 January 2016

Alter Event Session

Ready for a change of pace? Good! Today is a really good time to start looking into one of the more basic concepts related to Extended Event Session management.

Consider the occasional need to change a trace. Maybe you added the wrong event to the trace, or maybe you neglected… Read more

0 comments, 1,439 reads

Posted in SQL RNNR on 8 January 2016

Waiting, is it a Bad Thing?

Despite the desire to get away from the GUI talk in these articles about Extended Events, I have so far been unable to do it. Each article of late has something more to deal with the user interface. Let’s see what we can do with the GUI today.

One of… Read more

0 comments, 508 reads

Posted in SQL RNNR on 6 January 2016

A day in the Stream

Enough talk of the GUI with Extended Events (see previous articles in the series if you want to revisit the stickiness of the GUI – here). It is time for a bit of a diversion and something quick.

While it may be a quick traipse today, it won’t be… Read more

4 comments, 323 reads

Posted in SQL RNNR on 5 January 2016

Hidden GUI Gems

The GUI for Extended Events offers some power to help you get started with trying to work with Extended Events. As I have shown over the past few articles, some of this power comes with a bit of cost and may in fact not be as powerful as just using… Read more

0 comments, 1,151 reads

Posted in SQL RNNR on 2 January 2016

Filtering Logged Data

Over the course of the past couple of articles, I have shown some interesting if not useful functionality in the user interface for working with Extended Event log files. Those articles on merging files and customizing the view can be read here and here.

Today, I am going to… Read more

0 comments, 976 reads

Posted in SQL RNNR on 1 January 2016

Newer posts

Older posts