I just had my first encounter with having to write a PowerShell script. The request seemed pretty harmless when I originally got it. The request was much like others I had gotten in the past where I needed to check to make sure that data had been loaded and kick off another process. In the […]
SQL Saturday 89 Pre-Con
Why am I attending Kevin Kline’s pre-con on “Troubleshooting & Performance Tuning Microsoft SQL Server 2008 R2” at SQL Saturday #89 in Atlanta on September 16th? For starters I am a production DBA. Sure I create SSRS reports and build ETL processes with SSIS and the like, but at the end of the day I […]
Listing Stored Procedures From Every Database
Recently I answered a question on AskSSC that I thought I would create a quick blog about. Someone had asked if there was an easy way to run SELECT * FROM SYS.PROCEDURES on every database. I immediately thought of the undocumented stored procedure sp_msforeachdb. I posted a response and gave a bit of advise to […]
Planning a SQL Saturday
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted sessions at a previous SQL Saturday, an alert went out to sponsors and the event was live. Immediately emails started coming in, people started registering and sessions were being submitted. The event really took on […]
Getting Ahead and Getting Involved
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question “Where do I start learning more about SQL” will come up where someone has just taken on the role of DBA within his or her organization. Or possibly it is from someone who has been […]
SQL Saturday #89 Atlanta GA
The official launch of SQL Saturday #89 was June 8th. Within the first week of the launch we have registered over 100 attendees and have over 30 sessions submitted. We have been overwhelmed with the response. We have made a few updates to the Event Website The most import change has been to list links […]
Using “NOT IN” in a query can provide mixed results
The topic came up at work awhile back with using various includes/excludes such as IN, NOT IN, and EXISTS. A co-worker was working on an ETL process when he discovered that using “NOT IN” in a sub query with a data set that contained NULL values was giving him incorrect data. Lets take a look […]
Using an Excel Destination in SSIS with x64
My first real experience with SSIS began in late Feb of this year. I was upgrading a system from SQL 2000 to SQL 2005 (app not yet supported on 2008). This time around I decided to do things the right way and migrate from DTS to SSIS not just import the DTS and execute legacy […]