Where did the Database Go?

What do you do when a developer comes to you and asks, “Where did the database go?  The database was there one minute, and the next it was not.”  Only one thing could be worse than the feeling of losing a database on your watch, and that would be losing a production database. It’s like […]

By |April 7th, 2015|SQL, SQL Group|0 Comments

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 so easily.

Today, I would like […]

By |March 11th, 2015|SQL, SQL Group|2 Comments

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 the use of extended events a […]

By |February 17th, 2015|SQL, SQL Group|0 Comments

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 and may or may not […]

By |January 21st, 2015|SQL, SQL Group, SQL Server|3 Comments

The Mystery of Missing Backup Files

We are now on the eve of Halloween Month. Yes, the holiday of Halloween is much better when celebrated all month rather than just a single day. What better way to kick it off than with a bit of a mystery?

Not only is this mystery of missing backup files worth discussing now, but has been a mystery […]

By |September 30th, 2014|SQL, SQL Group, SQL Server|0 Comments

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 can choose to encrypt the […]

By |September 2nd, 2014|SQL, SQL Group|9 Comments

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 take a look at examples of […]

By |July 1st, 2014|SQL, SQL Group|0 Comments

Winter 2012 Performance Palooza!

This Thursday, December 6, 2012, the SQL PASS Performance Virtual Chapter will be holding online sessions all day long in an the first ever Performance Palooza!.  There are  eight one-hour online sessions, covering a variety of performance related topics.  It is a fantastic speaker line-up, of which I feel privileged to be part of.  All […]

By |December 4th, 2012|SQL, SQL Group|0 Comments

Another First. Speaking at the PASS Summit 2012

I have spoken at a lot of SQL Server Events over the past few years including a bunch of SQL Saturdays, User Groups, PASS Virtual Chapters, and PASS SQL Rally.  But my abstracts for The PASS Summit were never accepted.  Until this year.  So a few weeks ago, I had my chance to speak for […]

By |November 30th, 2012|SQL, SQL Group|0 Comments

Using Linked Servers the Right Way

Linked Servers are a very popular way to access distributed data in environments with lots of SQL Server instances on different serves, or even on other Database Management Systems like Oracle or MySQL. While linked servers can be very useful if used correctly, I have found that more often than not, they are not used […]

By |October 28th, 2012|SQL, SQL Group|8 Comments