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

Archives: December 2018

Finding Installed Event Sessions

As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying to figure things out for yourself. It may even be very common to feel the icy pain of the development cold shoulder (intentional or not) as you go about doing… Read more

1 comments, 193 reads

Posted in SQL RNNR on 31 December 2018

SQLs Black Box Recorder – sp_server_diagnostics

Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore,… Read more

1 comments, 290 reads

Posted in SQL RNNR on 30 December 2018

SQL Servers Black Box Recorder – system_health

Yesterday i shared the first article in a three part series about the SQL Black Box Recorder, that you can read here, with a promise of at least two more posts. The first article in the series laid the groundwork about the black box recorder in SQL Server. Furthermore,… Read more

1 comments, 312 reads

Posted in SQL RNNR on 29 December 2018

SQL Servers Black Box Recorder – Def Trace

Across many professions and industries there is often a need to have some sort of device that “audits” everything that happens with a device or process. We are probably all quite familiar with the infamous black box recorders used by the passenger airline and train industries. It is also quite… Read more

1 comments, 257 reads

Posted in SQL RNNR on 28 December 2018

How to: File Target use in Extended Events

I have been doing a lot of posts of late about extended events but have failed to share some of the essential building blocks. I am not looking to do a series of definitions, but just share a couple of quick tips and examples here and there that will make… Read more

2 comments, 373 reads

Posted in SQL RNNR on 27 December 2018

Upgrading From SQL Server Profiler

I just shared an article describing how to use Extended Events to perform your SQL Server Profiler duties. If not, you can read all about it here.

In that article, I showed one common use-case for SQL Server Profiler and how to achieve the same result via Extended… Read more

2 comments, 970 reads

Posted in SQL RNNR on 26 December 2018

How To: XEvents as Profiler

A common excuse for not delving into extended events seems to be the jump from Profiler to extended events.  There appears to be an inherent fear with how to use extended events.  In addition to that fear, is the fear that extended events does not do what Profiler can do… Read more

1 comments, 532 reads

Posted in SQL RNNR on 25 December 2018

Quick and Easy XE for Azure DB

The Cloud

It has been a minute since I gave much love or attention to Extended Events in Azure SQL DB. Things have changed a touch since then. We will see about some of those changes in a future article. As for this time, let’s focus on how to… Read more

0 comments, 1,479 reads

Posted in SQL RNNR on 24 December 2018

File Maintenance – Cleaning Up Old Files

Using SSIS to Maintain the File System

We have all run into a need or a desire to clean up old stale files from the file system, whether it be to remove old backup files or flat files that are created from one process or another.  And based on this… Read more

1 comments, 2,868 reads

Posted in SQL RNNR on 21 December 2018

Encrypting a Database Never Finishes

There is plenty of legislation and regulation in place these days that strongly suggest the encryption of data within a database.  In SQL Server, we have the ability to comply with these regulations in a couple of different ways.  We can choose to encrypt at the column level or we… Read more

0 comments, 380 reads

Posted in SQL RNNR on 20 December 2018

T-SQL Tuesday Participation Over the Years

Loads of TSQL Tuesdays

Years ago the TSQL Tuesday party was started by Adam Machanic (b|t). The premise of the monthly event is to get people a topic each month to try and ease some of the difficulty with writing (figuring out what to write) and… Read more

0 comments, 219 reads

Posted in SQL RNNR on 19 December 2018

T-SQL Tuesday 109: Influence Somebody Recap

How have you impacted somebody in the community?

This month I am in charge of the topic for TSQLTuesday. The invite was published here a couple of weeks ago. I knew I was picking something rather difficult for people in general and probably more difficult for technologists due to the… Read more

0 comments, 198 reads

Posted in SQL RNNR on 18 December 2018

Synonyms in SQL Server – Good and Bad

When SQL Server 2005 was released, a nifty little feature was included called synonyms.  Despite being around since SQL Server 2005, I think this feature is often under-utilized or, more importantly, it is implemented in a very bad way.

Today I want to share a couple of examples.  We will… Read more

0 comments, 288 reads

Posted in SQL RNNR on 14 December 2018

Maintenance Plan Owner – Back to Basics

We all inherit things from time to time through our profession.  Sometimes we inherit some good things, sometimes we inherit some things that are not so good.  Other times we inherit some things that are just plan annoying.  Yet other times, we inherit things that may be annoying and we… Read more

0 comments, 214 reads

Posted in SQL RNNR on 13 December 2018

To Influence or Be Influenced?

How have you impacted somebody in the community?

Well, have I come up with a doozy of a topic for this month for the TSQLTuesday party. Its not easy to step out of ones own comfort zone. Its even more difficult to fathom the thought and action of performing a… Read more

0 comments, 178 reads

Posted in SQL RNNR on 11 December 2018

The Mystery of Missing Backup Files

Yoink – Backups Gone

Not only is this mystery of missing backup files worth discussing now, but has been a mystery worth talking about previously (albeit in slightly different form). One such exploration into this mystery can be read here. And as a requirement for exploring any mystery some… Read more

1 comments, 226 reads

Posted in SQL RNNR on 10 December 2018

Capture the Flag – The Trace Flag

Many people work in a tightly controlled environment. Every change requires a change control form and approval to make a change. In some environments, things are more lax, but you still wish you could tell when certain changes were made. That is even true in some of those tightly controlled… Read more

1 comments, 2,505 reads

Posted in SQL RNNR on 6 December 2018

T-SQL Tuesday 109: Influence Somebody Invite

How have you impacted somebody in the community?

It has now been 28 months since the last time I hosted a TSQL Tuesday, that was TSQL Tuesday 81. I recapped that event here with the original invite here. It continues to amaze me how quickly time flies and how… Read more

7 comments, 219 reads

Posted in SQL RNNR on 4 December 2018

SHUTDOWN SQL Server

Recently a friend by the name of Chris Bell (blog | twitter) wrote about an easy way to disrupt SQL Server.  That disruption comes in the form of the SHUTDOWN TSQL command.  You can read what Chris wrote from his article here.

Granted, you do need to… Read more

4 comments, 3,500 reads

Posted in SQL RNNR on 3 December 2018