Posts Tagged ‘SQL-Server’

Managing SQL Server Sprawl with HP Polyserve

I went to a really interesting presentation this morning given by Nick Coombs on behalf of ITEX, an IT Services company specialising in offshore jurisdictions. The breakfast talk was about a product called PolyServe which helps companies consolidate SQL Server instances onto a small number of machines, helping to reduce...

SQL Server 2005 SP2 released

Microsoft has just release SP2 for SQL Server 2005. These are the benefits it claims to bring to the table: Data Mining Add-ins for the 2007 Microsoft Office system enable data mining functionality from SQL Server Analysis Services (SSAS) to be used directly within Excel® 2007 and Visio® 2007. SQL...

Backup SQL Server with IBackup

I’ve been looking at IBackup in a bit more detail and I’ve found a few more features that are pretty impressive. The one that stuck in my mind is the ability to back up MS SQL Server databases directly to IBackup. There’s a step-by-step walkthrough on how to do this...

10 ways to lose your DBA job

Here’s a good post from SQL Server Central talking about some essential skills and reminders that SQL Server DBAs should keep in mind. They range from the basic (keeps servers patched, don’t use blank password) to the essential (Loading, Tuning, Optimising) and is a valid read for anyone using SQL...

Cocky Answer – Fixing @@SERVERNAME = NULL

Was looking for a solution on how to fix a known SQL problem where @@SERVERNAME is NULL and came across this posting. Someone wanted to fix this problem without restarting the box and the reply was as follows: It is much more complicated if you can’t stop and restart SQL...

Virtual PC woes

I just spent a week swearing at Virtual PC. Everything seems to work nicely in the beginning. Got the latest Biztalk 2004 build from Gavan to play with. It works fine for a couple of times, then BANG!! Everything stops working. The cause of the problem seems to be SQL...

Thanks for subscribing!

Ugh!!’s Greymatter Honeypot