Stuart Padley's Web Log

Windows Live

Continued...

...over at www.stuartpa.com

Author: stuartpa Date: 12/16/2006

An unwanted surprise when changing the SQL Server 2005 Service Account

When changing the Microsoft SQL Server 2005 Service Account you might get back this rather alarming...

Author: stuartpa Date: 10/12/2005

A strange problem with 'ADD SIGNATURE' and the new SQLCMD command line utility

This one is a little odd: But, when using the new 'ADD SIGNATURE' DDL in SQL Server 2005, if you are...

Author: stuartpa Date: 10/03/2005

An error starting a SQL Server 2005 User Instance when using Remote Desktop

Late last week, I was using the new 'User Instance' support in SQL Express 2005. I was connecting...

Author: stuartpa Date: 10/03/2005

Protecting the SQL Server 2005 'Service Master Key', the root of all encryption

Microsoft SQL Server 2005 introduces a new feature set, known internally as 'Secret Storage'. Secret...

Author: stuartpa Date: 09/25/2005

SQL Server 2005 password change without server restart, small issue with 32 bit installs on x64 OS

In an earlier post, I said it will be possible to change the Microsoft SQL Server 2005 service...

Author: stuartpa Date: 09/15/2005

Using SQL Server Management Studio (and Profiler) Tools with SQL Express 'User Instances'

In the SQL Server 2005 Express Edition, available for free here, there is new connection string...

Author: stuartpa Date: 09/05/2005

Change the SQL Server Service Account password without Server Restart

A couple of weeks ago, we checked-in a feature to Microsoft SQL Server 2005, that allows the various...

Author: stuartpa Date: 09/02/2005

Setup Secure SQL Server Service Broker across databases in less than 10 seconds!

One of the most interesting new features in SQL Server 2005 is Service Broker. If you need more...

Author: stuartpa Date: 07/25/2005

Table Valued Function magic in SQL Server 2005 using the new SQL/CLR integration

In my last post, I said we would look at how we could return a table that contains a directory...

Author: stuartpa Date: 07/21/2005

Getting those XML files into your brand spanking new relational database system

Up until now, XML documents have generally languished as mere files in the lowly file-system, our...

Author: stuartpa Date: 07/19/2005

Wrapping up Microsoft SQL Server 2005 - looking at the new features

As we work on wrapping up the Microsoft SQL Server 2005 release (formerly known as 'Yukon'), I am...

Author: stuartpa Date: 07/18/2005