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

Correlate Trace and XE Events

Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler or Server Side trace to something meaningful and useful within Extended Events.

That was years ago and really is ancient history now. Microsoft has provided a couple of maps to… Read more

0 comments, 71 reads

Posted in SQL RNNR on 28 December 2017

Message in a Bottle of XE

One of the age old features that most probably take for granted in SQL Server happens to be the error messages. What? How can a message be a feature, right?

Well, I concede. Maybe calling it a feature may be too much. Then again, consider it for just a touch… Read more

0 comments, 55 reads

Posted in SQL RNNR on 27 December 2017

Message in a Bottle of XE

One of the age old features that most probably take for granted in SQL Server happens to be the error messages. What? How can a message be a feature, right?

Well, I concede. Maybe calling it a feature may be too much. Then again, consider it for just a touch… Read more

0 comments, 335 reads

Posted in SQL RNNR on 27 December 2017

12 Days Of Christmas and SQL

One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because it is supposed to remind us to try and be better people. And for me, it does help. In all honesty, it should be a better effort year round, but… Read more

0 comments, 245 reads

Posted in SQL RNNR on 26 December 2017

12 Days Of Christmas and SQL

One of my all-time favorite times of the year happens to be the Christmas Season. I enjoy the season because it is supposed to remind us to try and be better people. And for me, it does help. In all honesty, it should be a better effort year round, but… Read more

0 comments, 22 reads

Posted in SQL RNNR on 26 December 2017

Best New(ish) SSMS Feature

We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say that means we use it at least once a day. I think it is safe to say, we have all been wanting to see something cool released for SSMS for… Read more

2 comments, 21 reads

Posted in SQL RNNR on 26 December 2017

Best New(ish) SSMS Feature

We all probably use SQL Server Management Studio (SSMS) on a very frequent basis. Just for giggles, lets just say that means we use it at least once a day. I think it is safe to say, we have all been wanting to see something cool released for SSMS for… Read more

2 comments, 928 reads

Posted in SQL RNNR on 26 December 2017

Extended Events Permissions

A common question that I am asked about Extended Events relates to what kind of permissions are required in order to use this awesome feature. In this article, I am going to compare and contrast the permissions required for Profiler as well as Extended Events.

Extended Events changed a lot… Read more

1 comments, 466 reads

Posted in SQL RNNR on 26 December 2017

Extended Events Permissions

A common question that I am asked about Extended Events relates to what kind of permissions are required in order to use this awesome feature. In this article, I am going to compare and contrast the permissions required for Profiler as well as Extended Events.

Extended Events changed a lot… Read more

1 comments, 15 reads

Posted in SQL RNNR on 26 December 2017

An Identity Crisis: Is it Profiler or is it Extended Events?

I have been working on this article for far longer than one might think is necessary for something of this nature. Truth be told, I was reluctant because there are so many people that quickly jumped on the wagon to write about this feature as soon as it was released.… Read more

1 comments, 10 reads

Posted in SQL RNNR on 22 December 2017

An Identity Crisis: Is it Profiler or is it Extended Events?

I have been working on this article for far longer than one might think is necessary for something of this nature. Truth be told, I was reluctant because there are so many people that quickly jumped on the wagon to write about this feature as soon as it was released.… Read more

1 comments, 1,597 reads

Posted in SQL RNNR on 22 December 2017

Capture Index Maintenance Operations

One good database maintenance practice is to keep the indexes in good working order. This is typically done via index defragmentation routines. Some people perform routine index maintenance, some people do not, and still others have done some sort of “set it and forget it” script provided by a vendor… Read more

1 comments, 302 reads

Posted in SQL RNNR on 20 December 2017

T-SQL Tuesday #097: Learning Plans

Stylishly Late

I am fabulously late and therefor breaking the guiding rules that make up TSQLTuesday. Where’s the ruler to slap my fingers as I blatantly type this post so late?

Well, I did ask for a special pardon from the host this month. My friend Mala Mahadevan (blog Read more

0 comments, 327 reads

Posted in SQL RNNR on 18 December 2017

Incorrect Syntax – What?

Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to throw the laptop out the window. What do we do though when the error message really does look to be pretty… Read more

0 comments, 178 reads

Posted in SQL RNNR on 17 November 2017

T-SQL Tuesday #096: Inspiration Abounds

Who Inspires You?

Today is a bit of a divergence from the usual geekery that may abound on my blog. As prompted by Ewald Cress (blog | twitter), it is time to take a step back and put forth a bit of reflection. Ewald has requested we do… Read more

2 comments, 252 reads

Posted in SQL RNNR on 15 November 2017

SQL Server Haunt 2017

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

Posted in SQL RNNR on 1 November 2017

What’s that SSIS Password

A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that relates to SSIS. Clients will call for help with an SSIS package that has started failing and they are stuck trying to figure it out. They are all stuck at… Read more

0 comments, 696 reads

Posted in SQL RNNR on 30 October 2017

Drop That Schema

An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of the latter, there is an occasional requirement for change. When this need arises, it can turn into a bit of a problem. That is of course if we are… Read more

0 comments, 1,827 reads

Posted in SQL RNNR on 27 October 2017

Seattle SQL Pro Workshop 2017 Schedule

Seattle SQL Pro Workshop 2017

You may be aware of an event that some friends and I are putting together during the week of PASS Summit 2017. I have created an Eventbrite page with all the gory details here.

With everybody being in a mad scramble to get things… Read more

0 comments, 268 reads

Posted in SQL RNNR on 26 October 2017

Seattle SQL Pro Workshop 2017

Seattle SQL Pro Workshop 2017

October is a great time of year for the SQL Server and Data professional. There are several conferences but the biggest happens to be in the Emerald City – Seattle

Some friends and I have come together the past few years to put on… Read more

0 comments, 920 reads

Posted in SQL RNNR on 19 October 2017

Newer posts

Older posts