COPY_ONLY backup option more obvious in SQL Server 2008

I feel like I keep finding reasons to use SQL Server 2008 Management Studio with SQL 2005 instances, and here’s another – the COPY_ONLY option now appears on the Backup dialog box (others include the DROP & CREATE scripting option, multi-server queries and the Select Top 1000 Rows menu entry). It’s not a new option … Continue reading COPY_ONLY backup option more obvious in SQL Server 2008

“No Match Output” in SSIS 2008

The hairy Irishman (his description – I just call him Sacha) is presenting to the Adelaide SQL Server User Group today, talking about improvements in SQL Server 2008 Integration Services. Right now he’s talking about the No Match output of the Lookup Component, and I’m wondering why I had always just accepted that in SQL … Continue reading “No Match Output” in SSIS 2008

PowerShell changes in SQL Server 2008 RC0

Regular readers of my blog will remember my post about how to get PowerShell for SQL into your regular PowerShell window. Except that if you’ve just installed SQL Server 2008 RC0, you may have noticed it doesn’t work any more. Never fear, they’ve just changed the name a bit. They’ve put 100 on the end … Continue reading PowerShell changes in SQL Server 2008 RC0