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

Debugging SQL Server CLR Objects

Just a quick shout out to a great article on how to Debug CLR Projects.

http://www.mssqltips.com/tip.asp?tip=1624

By |March 29th, 2011|SQL, SQL Group|0 Comments

SQL Saturday #67 (Chicago)

Headed to Chicago tomorrow for SQL Saturday #67.  Heading out a day early to attend a pre-conference seminar on Friday on troubleshooting and performance tuning.  While I feel pretty strong in these areas, one thing I haven’t done as good of a job of as I should is keeeping up on new features to assist […]

By |March 23rd, 2011|SQL, SQL Group|0 Comments

Utah Code Camp

I’ve been doing a lot of traveling lately speakng at SQL Saturday events.  This last weekend it was my great pleasure to speak at Utah Code Camp, a local event.  Not only was it nice to be local, but I really enjoyed the code camp.  Unfortunately I didn’t get to stay all day as I […]

By |March 23rd, 2011|SQL, SQL Group|0 Comments

This discussion came up on Twitter so I …

This discussion came up on Twitter so I thought I’d blog about it. UPDATE FROM (sometimes called an UPDATE JOIN) is an language construct that is an extension to the ANSI-92 standard supported by several DBMS’s, but not by Oracle. I first discovered this when doing some ETL work in SSIS with an Oracle destination. […]

By |February 16th, 2011|SQL, SQL Group|0 Comments

SQL Server Developer Job Description

I was asked by a client today to provide 4 bullet points to include in a job description for a developer position that will be primarily responsible for SQL Development. I explained that my preference is to focus on database engine first, then worry about T-SQL. Too many times I see customers who focus on […]

By |February 4th, 2011|SQL, SQL Group|2 Comments

Headed to Houston

Next stop on the SQL Saturday tour is Houston. This will be my third week in a row of travel and as much as I love the SQL Community, I will be ready for a couple of weekends to myself before Phoenix. I am presenting just one session at this event. Visual Studio 2010 Database […]

By |January 26th, 2011|SQL, SQL Group|0 Comments

SQL Saturday #45 – Louisville, KY

I need to get better at blogging about my experiences presenting at SQL Saturday so I’m writing this one on my way home. I had a great time in Louisville, even though it was VERY cold. It was 7 degrees Fahrenheit when I left the hotel Saturday morning. I don’t care who you are or […]

By |January 23rd, 2011|SQL, SQL Group|1 Comment