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|6 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

SQL Saturday #120 – Orange County, CA

Looking forward to heading to Southern California this weekend for SQL Saturday #120 in Huntington Beach.  They always put on a great event and you can’t beat the location.  Not to mention that it is very close to where I grew up so I get to see some old friends while I’m there.

I will be […]

By |March 19th, 2012|SQL, SQL Group|0 Comments