Subscribe to this blog
Archives: August 2008
Deleting Duplicates without a unique key
The following was sent to me by my friend and colleague Dave Miller:
Dave's Email:
Wanted to pass along something I hadn't used before and found useful to easily get rid of duplicates in a set of data. The functionality has existed in the SQL language and was supported in… Read more
0 comments, 487 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 21 August 2008
What every DBA that manages a large number of SQL Servers should know about SQL 2008!!
Error when importing RegServer list from SQL 2005 to SQL 2008
I discovered the already known bug in SQL 2008 that you can't import a SQL 2005 server list (exported as a regsrvr file). For someone like me who deals with a large numger of SQL Servers, this is a… Read more
6 comments, 1,087 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 19 August 2008
How do I automatically respond to mirrored database failovers?
Automatic Failover - an incomplete solution
Automatic failover with Database Mirroring is great, but what about all of the other things that you need to happen when the database fails over? There is no built-in support in Database Mirroring for anything external to the database. This is where automatic activation… Read more
0 comments, 671 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 18 August 2008
How do I .... grant access permissions for SSIS to users?
- Component Services -> Computers -> My Computer -> DCOM Config -> MSDTSServer
- Right click on MSDTSServer
- Click properties
- Click on the Security tab
- Select Customize and add the…
2 comments, 6,110 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 13 August 2008