April 2010 - Posts

21 April 2010
R2 is RTMd!
Check it out: http://www.microsoft.com/presspass/presskits/sqlserver/default.aspx No sign at MSDN downloads yet :( Read More...
2 comment(s)
Filed under:
19 April 2010
Runaway version store in tempdb
Today was really a new one. I got back from a week off and found our main production server's tempdb data file had gone from its usual 200MB to 36GB. Ironically I spent Friday at the most excellent SQLBits VI and one of the sessions I attended was Christian Bolton talking about tempdb issues - including... Read More...
no comments
Filed under:
09 April 2010
Copying logins to another server
I'm busy setting up a new server to replace our main live server and part of that is to get the logins copied over. The database users will come over when I restore the databases but I wanted to get the logins they relate to, with the same SIDs, passwords and other properties as they have on the... Read More...
3 comment(s)
Filed under: ,