Last week I was working with a client on upgrading one of their systems from SQL Server 2000 to SQL Server 2012, while also performing a collation change of the database and all of the table columns from Latin1_General_BIN to SQL_Latin1_General_CP1_CI_AS. What started out as a straight forward upgrade, this actually became quite a challenge. […]
Jonathan Kehayias
The Rambling DBA
ALTER DATABASE failed. The default collation of database ‘%.*ls’ cannot be set to %.*ls.
Posted on: July 30, 2013 3:35 pm
Updated Availability Group Demonstrator
Posted on: July 23, 2013 12:32 pm
Since the first release of the SQLskills Availability Group Demonstrator, I’ve had an number of requests to add the ability to enable MultiSubnetFailover in the connection string, and to specify a Timeout value. I made these changes months ago but never got around to actually releasing the newer build on my blog. However, after releasing […]
SQL Server 2012 Extended Events Add-in to Manage 2008/R2 Instances
Posted on: July 22, 2013 1:36 pm
Extended Events are a powerful new way of troubleshooting problems with SQL Server, and the addition of UI support in SQL Server 2012 Management Studio has helped increase the awareness and usage of this feature. One short-coming is that the new UI for Extended Events only works for SQL Server 2012 instances leaving administrators that […]
Synchronize Availability Group Logins and Jobs
Posted on: July 22, 2013 12:51 pm
An important part of ensuring application functionality with Availability Groups is manually maintaining any uncontained objects across each of the replicas in the Availability Group. As more of our clients upgrade to SQL Server 2012 and implement Availability Groups, we’ve had to face the challenges of maintaining uncontained objects across replicas multiple times and there […]
