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, such as the use of the file target. I am not looking to do a series of definitions, but just share a couple of quick tips and examples here and there that […]

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

Encrypting a Database Never Finishes

There is plenty of legislation and regulation in place these days that strongly suggest encrypting 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 entire database using TDE […]

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 correctly […]

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

SQL Saturday #153 in Salt Lake City

Really looking forward to the event this Saturday (October 20, 2012) at Neumont University in South Jordan.  SQL Solutions Group has been a sponsor of the event for 5th event we have sponsored and and it has always been a great experience.  We’ll be there with a booth so stop by and say hello.

In addition […]

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

Dynamic SSIS Error Logging

When building ETL processes, one of the things we always like to do is to account for every row.  But setting up error data flows can be very time consuming since they are schema dependent.  The following solutions is a generic way to log bad rows that can be re-used without modification. It is also […]

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