Monthly Archives: July 2009

Microsoft Releases Silverlight 3.0

Posted on July 9, 2009 by Glenn Berry

Microsoft has released Silverlight 3.0 one day before the scheduled July 10 release date. It uses your GPU to support 720p resolution video, and it can also run outside the browser. It runs pretty well on my humble, little Toshiba … Continue reading →

Posted in Microsoft | 8 Comments

Useful Database Mirroring System Stored Procedure

Posted on July 9, 2009 by Glenn Berry

I was spelunking around SQL Server 2008 Books Online (BOL), and I ran into a system stored procedure called sp_dbmmonitorresults, which is very useful for keeping track of what is going on with any database mirroring sessions that you have … Continue reading →

Posted in SQL Server 2008 | 2 Comments

Looking For Unused Stored Procedures In SQL Server 2008

Posted on July 8, 2009 by Glenn Berry

One thing you should periodically do as a “good” DBA, is to look for unused objects in your user databases, to make the database easier to maintain and understand. If you use T-SQL stored procedures, (which I highly recommend), you … Continue reading →

Posted in SQL Server 2008 | 5 Comments

Microsoft Changing Name Of SQL Portions of Azure

Posted on July 8, 2009 by Glenn Berry

The Data Platform Insider Blog has a post up announcing the renaming of Microsoft SQL Services to Microsoft SQL Azure, and of SQL Data Services to Microsoft SQL Azure Database. This is interesting to me because we are looking at … Continue reading →

Posted in SQL Server 2008 | 1 Comment

Fun With A Toshiba NB205 Netbook

Posted on July 5, 2009 by Glenn Berry

After a little bit of research and shopping around, I decided to buy a new Toshiba Mini NB205-311NW netbook at Best Buy. This model comes with the Intel Atom N280 1.66GHz CPU, which is slightly faster, than the Atom N270 … Continue reading →

Posted in Computer Hardware | 18 Comments

Scanning Your Database Code, Looking For Problems

Posted on July 1, 2009 by Glenn Berry

Kimberly Tripp has a good post up about how she likes to scan a database, looking for some obvious security vulnerabilities, using this query: — Check for security vulnerabilities (Kimberly Tripp) SELECT OBJECT_NAME(object_id) AS [Procedure Name], CASE WHEN sm.definition LIKE … Continue reading →

Posted in SQL Server 2008 | 4 Comments