Browse by Tags

SQL Server 2005 Bug Report
21 February 08 07:43 PM | robcarrol | with no comments

Saw this link to a SQL Server 2005 bug report on the Microsoft Connect site. I guess someone was having one of those days https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=253524&wa=wsignin1.0

Filed under: SQL Server, 2005, Tools

SQL Server 2008 Certifications
19 February 08 11:50 PM | robcarrol | with no comments

As I am currently preparing for the MCDBA to MCITP 2005 upgrade exam (70-447) it may seem a bit premature to talk about SQL Server 2008 certifications, but there is a webcast available at Trika's blog (from the Microsoft Learning team) below. http://blogs...

Filed under: SQL Server, 2005, 2000, Certification

Top Tips for SQL Server Clustering
13 February 08 05:10 PM | robcarrol | with no comments

As part of a current project I am working on, I came across this article , which includes a tip for clustering SQL Server workgroup edition using a combination of Windows clustering and virtual server !

Filed under: SQL Server, 2005, Windows, Clustering

Error with SQL Server 2005 Database Mail
02 February 08 11:45 PM | robcarrol | with no comments

I was passed an interesting issue with database mail to have a look at on one of our clustered production SQL Server systems earlier this week. We have a large multi-node PolyServe cluster running our SQL Server 2005 64-bit Enterprise Edition platform...

Filed under: SQL Server, DB Mail, 2005, Windows

Dual Database Monitor Tool
02 February 08 11:42 PM | robcarrol | with no comments

I was giving a database mirroring demo last week and needed a way to quickly demonstrate the automatic failover capabilities in SQL Server 2005. I was at a session at TechEd IT Forum last year run by Paul Randal and Kimberley Tripp and remebered seeing...

Filed under: SQL Server, Mirroring, 2005, Tools

DTS Support in SQL Server 2005
02 February 08 11:24 PM | robcarrol | with no comments

Had a call this morning from a SQL Server developer looking to run DTS packages on a SQL Server 2005 machine with Integration Services installed. The user's problem was that he could not edit or run the DTS package via Management Studio. There is a simple...

Filed under: SQL Server, 2005, DTS, Integration Services, Tools