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

Archives: December 2017

Failed to Create the Audit File

One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to create the audit file“. It just so happens that the audit had been working and then suddenly stopped and started flooding the error logs with this message. Read more

0 comments, 520 reads

Posted in SQL RNNR on 31 December 2017

Failed to Create the Audit File

One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to create the audit file“. It just so happens that the audit had been working and then suddenly stopped and started flooding the error logs with this message. Read more

0 comments, 351 reads

Posted in SQL RNNR on 31 December 2017

An Introduction to Templates

Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can be found everywhere in just about everything that do.

In SQL Server, templates are readily available for your use in so… Read more

0 comments, 260 reads

Posted in SQL RNNR on 30 December 2017

An Introduction to Templates

Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can be found everywhere in just about everything that do.

In SQL Server, templates are readily available for your use in so… Read more

0 comments, 587 reads

Posted in SQL RNNR on 30 December 2017

Audit Domain Group and User Permissions

No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit more. No matter how many times we hand an audit report over to the auditor, there is always “just one” more… Read more

3 comments, 873 reads

Posted in SQL RNNR on 29 December 2017

Audit Domain Group and User Permissions

No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit more. No matter how many times we hand an audit report over to the auditor, there is always “just one” more… Read more

3 comments, 263 reads

Posted in SQL RNNR on 29 December 2017

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

Posted in SQL RNNR on 28 December 2017

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, 405 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

1 comments, 520 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

1 comments, 145 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, 112 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, 378 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, 1,154 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, 110 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, 107 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, 2,076 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, 1,837 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, 82 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, 472 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, 428 reads

Posted in SQL RNNR on 18 December 2017