One of the intersting post in forums and replies to them: I recently took a new position as the DBA for a web app company. Getting to understand the performance issues that are a major concern for the company I have started monitoring the servers. The...

Over the last few months Microsoft has been having many different launch events worldwide for their 2008 products: Visual Studio 2008, Windows 2008, and SQL Server 2008. I had the opportunity to attend one of these launch events. Being a SQL Server DBA...

If you live in Canada, or nearby Toronto, consider attending SQLTeach and DevTeach this May. I will be presenting three sessions on SQL Server you might want to check out: DBA 101: Best Practices for New DBAs How to Use SQL Server Hints Introduction to...

As most of you probably already know Cummulative Update #7 for SQL Server 2005 was released on April 17 th . (http://support.microsoft.com/kb/949095). Also Microsoft has now said they will be providing a Service Pack 3 sometime after SQL Server 2008 has...

SQL Server 2005 has some new GIS data types. How many of you are GIS savvy? Well I’ll by the first one to admit that I don’t work with GIS data. But I am starting to look at SQL Server 2008 and trying to encourage our GIS guy to look at the new GIS data...

Three Visual Studio 2008 MCTS came out today (see below). Passing one of these exams along with the Exam 70-536 TS: .NET Framework, Application Development Foundation are need to get ceritfied . Exam 70-502 TS: .NET Framework 3.5, Windows Presentation...

Did you think this post had something to do with the routers, switches and wires connecting SQL Server machines to the World Wide Web? If so you are wrong. This post has to do with my experience working one of the vendor booths at the “Heroes Happen Here...

How many of you do a Performance Audit of your SQL Server instances? I’ll have to admit I have never done a formal performance audit of our SQL Server instances. But to give myself some credit, back in 2007 I identified a number of DBA goals for 2008...

Last week there was a forum post about getting certified for SQL Server. The poster was asking about resources and how one should prepare for the MCDBA certification. The MCDBA certification is a SQL Server 2000 certification. At one point a number of...

On Tuesday I went to the SQL Server 2008 launch in Seattle. Of course the launch was more than just SQL Server 2008, it also included Windows Server 2008 and Visual Studio 2008. So there was a lot of BUZZ about 2008 stuff going on. I attended one of the...

I was spending some time over the last few weeks researching new features in SQL Server 2008 for a presentation I gave today at the Olympia Area SQL Server User Group in Tumwater, Washington, USA. So of course I had to take a closer look at the new date...

SQL Server guru Kalen Delaney, with help from http://sqlserverdvd.com , is offering a series of two-hour DVDs on SQL Server Internals. The first of the DVD series, Lesson 1: Architecture and Metadata, is currently available for $29.95 from http://sqlserverdvd...

This is anothe FAQ within the forums about what is the major difference between 32 bit and 64 bit application, well the answer you get is Memory. I feel there is much more associated between them, follow this ForumDiscussion topic for more information...

As Saint Patrick’s Day approaches I’m sure a number of you will be thinking about lifting a few green beers at your local watering hole. Why you are thinking about all the green items that come along with Saint Patty’s day, how about thinking green for...

I suppose by now all of you know about the lastest SQL Server 2005 beta (CTP6), which was released in February. If you have downloaded and installed this beta or any one of the prior CTP’s you will noticed there are no sample databases installed, which...