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

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