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

Maintenance Plan Owner

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 probably just haven't discovered them yet.

By |June 25th, 2012|SQL, SQL Group|Comments Off on Maintenance Plan Owner

Maintenance Plan Owner

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 probably just haven't discovered them yet.

By |June 25th, 2012|SQL, SQL Group|Comments Off on Maintenance Plan Owner

Maintenance Plan Owner

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 probably just haven't discovered them yet.

By |June 25th, 2012|SQL, SQL Group|Comments Off on Maintenance Plan Owner

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

SQL Saturday #91 – Omaha, NE

This is a bit late but wanted to post about my experience at the recent SQL Saturday held in Omaha, Nebraska. This was a fantastic event, particularly given that it was the first SQL Saturday held in Omaha. It was well-organized, had great sponsor support, and the facility at the University of Nebraska […]

By |September 2nd, 2011|SQL, SQL Group|0 Comments

Using RoboCopy in SQL Server Agent Jobs

One of the most important tasks for the DBA is managing backup files. Often the SQL Server backups files themselves are written to a drive local to the database server, but we then need to copy them off to a remote share.  RoboCopy is a fantastic utility included in Windows that is great at doing […]

By |July 13th, 2011|SQL, SQL Group|0 Comments

Truncate Tables that have Foreign Keys

One of the issues I often run into is the need to truncate very large tables. But if there is a foreign key constraint on the table, SQL Server will not allow a truncate, only a delete. This is fine for smaller tables but if the table has millions of rows, we want to do […]

By |April 1st, 2011|SQL, SQL Group|1 Comment