Joe Webb

Musing and observations about SQL Server, other technogies, and sometimes just life in general
posts - 85, comments - 857, trackbacks - 0

My Links


This blog has moved!

Click here for the new location.

Follow me on Twitter
Add to Technorati Favorites

Search this Blog


Post Categories

About me

Other Technologies

Discussion about other technologies I find cool or interesting
Desktop Virtualization

The past couple of years has seen a great increase in the interest of server consolidation and virtualization. Once considered an almost impossible to achieve ideal, today more and more companies are taking a serious look at its benefits. And those benefits are quite alluring. I have talked with colleagues who swear by virtualization. They claim that when properly configured, SQL Server can perform every bit as well on a virtual server as when on a dedicated box. So for them, the benefits greatly outweigh any potential drawbacks. Although I don't have a great deal of experience with server virtualization, I...

posted @ Wednesday, January 14, 2009 7:38 AM | Feedback (24) | Filed Under [ Other Technologies ]

SQL Server Security Vulnerabilities

At the 2007 PASS Community Summit in Denver, a keynote speaker made a passing comment about how there has not been a security bulletin released for SQL Server in over three years! I forget which speaker made the statement, but I found it utterly amazing. Not a single security bulletin released in over three years! Could this be true? If you've worked with SQL Server for a while, you'll undoubtedly remember SQL Slammer, the worm that hit thousands of SQL Servers around the world in 2003. It's effects were nothing short of devastating for many companies. I made a mental...

posted @ Tuesday, April 15, 2008 9:31 PM | Feedback (9) | Filed Under [ Other Technologies SQL Server Current Events ]

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. For example, we used C0 to display a currency value with no numbers to the right of a decimal point. One question that almost always comes up during the class is: where can I find a list of those predefined formatting strings? Microsoft has them on the MSDN Library site, but the...

posted @ Wednesday, March 12, 2008 5:46 PM | Feedback (4) | Filed Under [ C# Other Technologies SQL Server ]

Copying and pasting rectangular blocks of code in Visual Studio and Management Studio

One of the things I really like about teaching technical classes is getting to know and talk with students, learning of the challenges they face and how they've addressed them. Frequently, I can learn from their experiences, too. So, it works out well for both student and instructor. In a custom Visual Studio/SQL Server class last week, I made a passing comment about Visual Studio being a very good text editor, but that it lacked one feature that I really like in other editors - block copy and paste. I lamented that the Visual Studio editor doesn't allow you to select a rectangular...

posted @ Tuesday, November 06, 2007 7:45 AM | Feedback (17) | Filed Under [ C# T-SQL Other Technologies SQL Server ]

Powered by:
Powered By Subtext Powered By ASP.NET