Transfer SQL Server Object Task fixed

It’s nice to give Microsoft feedback and get the product changed! I first mentioned this in a post last month and logged a connect.microsoft.com entry. Microsoft checked it out, invesigtaed, and have now put a new property into SQL Server 2008 to resolve it! They write: Thanks a lot for your feedback. We are taking … Continue reading Transfer SQL Server Object Task fixed

User Groups in Second Life

The morning after the Adelaide launch of the 2008 products, I got to enjoy breakfast with quite a handful other Adelaide community leaders, and few of the Microsoft DPE team. Conversation was remarkably varied, and one of the things that came up was Community Credit and the Second Life .Net User Group.  I’ve never done … Continue reading User Groups in Second Life

Video of Excel Pivot Tables

A little while back someone asked me how to make a PivotTable in Excel, showing the Min, Max and Avg of a field. So I recorded a movie. Now, thanks to the wonder of Silverlight, it should be here for your viewing pleasure. No sound, so you can keep listening to whatever’s in your ear … Continue reading Video of Excel Pivot Tables

Local Server Group queries

This is really quite cool, especially since it’s a tool feature, and one that will help SQL Server 2005 installs. Suppose you have many servers, all registered in Management Studio, in the Registered Servers window. Now you can right-click on the Local Server Group, and pick the “New Query” option. Write a query, and it … Continue reading Local Server Group queries

Quicker backups by ignoring index data

Sick of how slow backups can run, even though you’re using compression from some tool like Hyperbac? Greg Linwood‘s had a good idea to help. A large amount of the data in any database system is the data stored in indexes (copies of the data in tables, just ordered differently) to help your queries run … Continue reading Quicker backups by ignoring index data

SQL Server 2008 PowerShell SnapIn

Installing SQL Server 2008 gives you SQLPS.exe, an application you can run which is a PowerShell including the PSDrives for SQL Server (and compatible with SQL Server 2005 as well!). But how do you make this work with your current copy of PowerShell? Well, I just worked this out. Darren Gosbell was lamenting with me … Continue reading SQL Server 2008 PowerShell SnapIn

Using ScriptingOptions with SQLPS

I’ve written before that SQL Server 2008 (February CTP) gives you SQLPS – a PowerShell interface to SQL Server. So I was trying to get the ScriptingOptions happening, and this is the only way I’ve found so far. It’s ugly, and if you have a better way of doing this, please post a comment for … Continue reading Using ScriptingOptions with SQLPS

Melbourne Launch

So I’m at the Heroes launch in Melbourne today. I’m going to hang out at the Experts booth, so if you’re here and have a question about SQL Server 2008, why not come over?