Author Archives: Stephen

The 2016 Ambitions

Well, it is day 2 of  a new year, and I’ve already oversubscribed my time and expanded my ambitions.  But hey, it’s go big or go home, right? So, the first priority on my 2016 list is to finish up the … Continue reading

Posted in Personal | Comments Off on The 2016 Ambitions

Thanks for the Help with Deadlocks

This is a copy of a blog post I put on my SQLServerCentral blog site “Adventures with Data”.  Really have to figure out that syndication thing someday. For a time there a few weeks ago (been meaning to post this … Continue reading

Posted in SQL Server | Comments Off on Thanks for the Help with Deadlocks

Passed Again

Passed the 70-463 exam last week, making the Florida vacation that immediately followed that much nicer.  Again, I found that a good amount of detail on a broad variety of topics was needed.  I did like the training kit book: … Continue reading

Posted in SQL Server | Comments Off on Passed Again

Passed!

Passed the 70-461 exam today, step one on my goal for the MCSE: Business Intelligence.  Man, that thing was way harder than the practice tests I took.  I purchased the book “Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012” … Continue reading

Posted in SQL Server, Uncategorized | Comments Off on Passed!

MERGE and DELETE

Have you used WHEN NOT MATCHED BY Source THEN DELETE much in your work with MERGE? I’ve been using SQL Server’s MERGE statement since a little before my previous post on it, but I never used the clause above much at … Continue reading

Posted in SQL Server | Comments Off on MERGE and DELETE

Starting up again

What he said:  George Woods. George and I were talking about blogging after finding Colleen Morrow’s excellent blog again recently.   We both agreed that blogging is a good thing to do, yet difficult to keep current.  I’ve got a number of  goals … Continue reading

Posted in Personal, SQL Server | Comments Off on Starting up again

SQL Saturday #171 — The Schedule is Up

SQL Saturday #171 Pittsburgh preparations continue, and the schedule has been posted for your review. If you’re anywhere in the area on October 6th, please join us at La Roche College for some great free SQL training. Personally, I’ve had … Continue reading

Posted in Uncategorized | Comments Off on SQL Saturday #171 — The Schedule is Up

ComputeReach

Man it’s tough to get in all that you want to do, isn’t it? I’ve been trying to get my blogging activities rebooted, and do some volunteer work as well. I’m starting to combine the two by volunteering on the … Continue reading

Posted in Personal | Comments Off on ComputeReach

Update

Well, the owl has flown the coop, there will be no nestcam.   I suspect the owl found a mate and is nesting somewhere else more appropriate.  I’m planning to build a bigger nest box over the summer, and hopefully next … Continue reading

Posted in Personal | Comments Off on Update

MERGE in SQL Server 2008

MERGE!  You’ve arrived just in time to help me with my ETL operations. Introduced in SQL Server 2008, MERGE lets one update one table by inserting, updating, or deleting fields as appropriate based on a join with another table.  I … Continue reading

Posted in T-SQL | Comments Off on MERGE in SQL Server 2008