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

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, 125 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, 195 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

0 comments, 1,383 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, 154 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, 151 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,160 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

1 comments, 1,670 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, 857 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,192 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, 341 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, 189 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, 994 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, 839 reads

Posted in SQL RNNR on 1 January 2016

Customize the XEvent Log Display

In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I mentioned the ability to customize the display in the GUI for the merged log files.

Today, I am going to explore how to configure the GUI with filters and… Read more

1 comments, 225 reads

Posted in SQL RNNR on 31 December 2015

Log Files from Different Sources

Well, it has been quite a pause between articles in the series. It is well past time to continue the series. With such a delay in the series, it is prudent to remind all that there is a series on Extended Events I had done over the course of two… Read more

1 comments, 1,015 reads

Posted in SQL RNNR on 30 December 2015

Tricks and Treats with XE

Halloween is a great time of year. It is unfortunate that it is just one day of the year. That said, I do like to think of the month of October as Halloween Month. I have several posts over the years that geek out over the cross-over between Halloween and… Read more

0 comments, 275 reads

Posted in SQL RNNR on 30 October 2015

Default Sessions

So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that has been covered with layers of building blocks that have been stacked. Now it’s time to take a step back as I near the end of the original goal for… Read more

0 comments, 226 reads

Posted in SQL RNNR on 29 October 2015

Azure SQL Database

So far I have strictly focused on Extended Events for SQL Server installations. This means I have been looking at Extended Events from the “physical” or on-premises perspective. Installing SQL Server into an Azure VM falls into this category as well.

What hasn’t received any TLC is Extended Events from… Read more

1 comments, 249 reads

Posted in SQL RNNR on 28 October 2015

Exposure to Internals

For me, some of the most fun stuff with SQL Server is diving deep into the internals. Diving into the internals is not always an easy adventure. Sometimes, it requires a lot of trial and error sometimes. There are times where a dive into the internals can get me “into… Read more

0 comments, 209 reads

Posted in SQL RNNR on 27 October 2015

Short Circuit Events

I introduced the importance about predicate order previously. I recommend either reading that article for the first time or reading it again if you have already read it. You can find that article – here.

The predicate order is critical. Having the wrong order can result in not trapping… Read more

0 comments, 246 reads

Posted in SQL RNNR on 26 October 2015

Older posts