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

Headed to Louisville for SQL Saturday on 1/21

Finishing up some work at a client today and will be headed to Louisville, KY tomorrow to present two sessions at a SQL Saturday (link). For those who are not familiar, SQL Saturday is a series of free training events held all over the country, usually sponsored by the local chapter of PASS (link) the […]

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

Expired Passwords and the Oracle Provider

I ran into a problem a while back that caused me a lot of grief so I thought I’d post it here. The package in question was used to traverse hundreds of Oracle databases and run the same query on all of them. This data was then loaded into a data mart. The databases all […]

By |January 15th, 2011|SQL, SQL Group, SQL Server|1 Comment