Category Archives: SQL Server

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