Joe Webb Blog

Musing and observations about SQL Server, other technogies, and sometimes just life in general

SQL Server locks: a sleeping process still holds them

Fellow SQL Server enthusiast and online friend of mine, Jonathan Kehayias is very active in the MSDN Forums. He frequently provides good, insightful information to those seeking advice. In response to a recent question in the Database Engine Forum, Jonathan provided a good example how a process marked as sleeping can still hold locks on a SQL Server resource. Read more →

SQL Server Virtualization

Next week at the Nashville SQL Server User Group, John Rives of Amniox is going to speak about using SQL Server with clustered virtualization. Unfortunately, I'm not going to be able to attend due to a prior commitment, however I have spoken with John about his presentation and it definitely sounds promising. Read more →

Working with tempdb

I was searching for something online the other day and stumbled upon this TechNet article - Working with tempdb in SQL Server 2005. It's a good little article and I wanted to share it with you. Read more →

Identifying Performance Bottlenecks

Thanks to everyone who attended my "Identifying Performance Bottlenecks" session this morning at DevTeach/SQLTeach. As promised, here is the PowerPoint slide deck I used during the presentation. Regarding the question of on the performance of LINQ, Bob Beauchemin recently posted a series of blogs entries on the topic. Read more →

What SQL Server service pack do I have installed?

If you've used SQL Server for a while, you're probably familiar with the @@version function. Selecting the function in a query window produces the following results on my system. From this, you can quickly determine that I'm running SQL Server 2005 Developer Edition version 9. Read more →

Microsoft SQL Server Reporting Services White Paper

Interested in learning more about Microsoft SQL 2008 Server Reporting Services? I recently stumbled upon a White Paper on the Microsoft site that provides a good overview. While weighing in at only 14 pages including the title page, table of contents, and copyright stuff, it does provide a good, abeit somewhat general, overview of the product and it's capabilities. Read more →

Real world DBA podcast

I recently worked with Buck Woody to turn one of my blog posts into a podcast. It's my first podcast! :) I recorded it about midnight one evening after everyone else in my family had retired for the evening. Read more →

Formatting strings

I just completed teaching a Microsoft SQL Server Reporting Services class in Charlotte, North Carolina - a wonderful and beautiful place to visit! In a couple of the demonstrations, we used some predefined formatting strings to customize the way a user can see a value in a report. Read more →