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
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