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

The Demo Dementors Strike Again

Whenever a demo fails, it always seems to be something really stupid.  This time was no exception.  In my first session today here at SQL Saturday #153 in Salt Lake City, my last demo inexplicably didn’t work.  I had tested it this morning right before the session. So I promised the attendees I would post […]

By |October 20th, 2012|SQL, SQL Group|0 Comments