February 2009 - Posts

I checked in an update release of the Extended Events Manager and source code onto CodePlex this evening. The following changes are included in this release of the application: Updated Scripting Logic to Reduce Script Errors Added checks Read More...

One of the great things about answering questions online is that every now and then you get one of those Aha! moments and you create a solution to a problem that once written seems really obvious and makes you wonder how that ever escaped you previously. Read More...

Every now and then I get frustrated trying to look something up to answer a question on the forums on the MSDN SQL Site, but tonight I have a new found respect for just how wonderful the SQL Site is after trying to find a piece of information on Windows Read More...

With SQL Server 2008 passing its 6 months since RTM date, a common problem is popping up in the forums and is now listed on Connect . When an install of Evaluation Edition Expires, the services stop functioning until an upgrade is made to a full Read More...

Whether you are just starting out in SQL Server, or you have been working in SQL Server for many years, eventually in your work, you cross a boundary where someone will want data formatted in a different manner than it is stored in the database server. Read More...

Lately there have been a series of SQL Quizes that have circulated the blogging community. Some of them are silly, like the Wordle one , and some have a purpose behind them, like the two greatest mistakes one . I decided that since my nature Read More...

As a DBA I often find myself back tracking on myself when it comes to newer technologies and how they affect SQL Server. In 2006 if you had asked me about SQLCLR, my response was adamantly, "Not in my server." As me about it today, Read More...

One of the goals that I have in building the Extended Events Manager is that it would be able to work around the fact that Extended Events currently do not have a streaming target available where the event sessions can be subscribed to for real time consumption Read More...

I've talked to a few people who are looking to upgrade from SQL Server 2000 recently, and it seems that most would rather go onto SQL Server 2005 than take the complete step up to SQL Server 2008. Most people also plan on changing from Enterprise Read More...

Andy Warren announced this yesterday, but in case you missed it, the PASS web site now has an updated blogger directory for SQL centric blogs that may be of interest to the community. I have found quite a few interesting blogs on the list that I Read More...

I've been working on this application for a long time, and it has been quite a learning experience. I'll break this post into two parts, the meat/goodies that are included in the latest release, and the History of the application that got it to Read More...

I happened to have the need to go back after the fact and add Integration Services to a Server. The server has been in production use for almost two years now and one of our new applications needed an Integration Services package to load data from Read More...

Yesterday an article I wrote on troubleshooting deadlocks in SQL Server 2005 was published on the SQL Server Central site . Its a quick, straight to the point article on how to use SQL Server Profiler to extract deadlock graphs for further analysis. Read More...

I was working with Change Data Capture this weekend and I happened upon a interesting problem while configuring the AdventureWorks2008 database for CDC. I was working on my laptop in a disconnected state from the Active Directory Domain that my windows Read More...