Not a really hard thing to figure out, but for some crazy reason I always forget. So, hopefully actually writing it out for the world to see will help me remember. Since tempdb is created every time that SQL Server restarts, the created date for that database can be used to determine the last time … Continue reading Last Time SQL Server Restarted
Tag: SQL Server 2008
Upgrade Issues When ‘sa’ Renamed
I've not done recommended changing the sa account name at a client for quite a while. Since the account can be disabled there isn't any good reason to rename it that I've been able to come up with. But if you do and plan to upgrade to SQL Server 2008, beware of the following... http://blogs.msdn.com/psssql/archive/2008/09/10/upgrade-for-sql-server-2008-can-fail-if-you-have-renamed-the-sa-account.aspx
SQL Server 2008 Resources
Sometimes I just post a blog with a link so that I can go back and look at it later. This is one of those cases... hopefully others find this as useful as I hope I will. SQL Server 2008 Videos, Webcasts, Courses, Datasheets, and Downloads
Strate SQL 