I recently had cause to change the SQL Collation of the tempdb database on a SQL 2005 Cluster. The installed collation was SQL_Latin1_General_CP1_CI_AS and I needed to change it to Latin1_General_CI_AS. After some brief research it became apparent that the process isn’t as straightforward as you’d imagine. My first attempt, based on a couple of [...]
How to install Bugzilla on CentOS - http://techgurulive.com/2009/07/01/how-to-install-bugzilla-under-redhatcentos/ How to reset Windows Server 2008 administrator passwords:- http://www.petri.co.il/reset_domain_admin_password_in_windows_server_2008_ad.htm Windows 2008 AD Design Guide - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=88f0184c-8f03-4f0f-b3f9-5109255fb461 Configure SQL Server Instances to use static ports - http://msdn.microsoft.com/en-us/library/ms177440.aspx HTML5 V FLASH: - http://www.readwriteweb.com/archives/does_html5_really_beat_flash_surprising_results_of_new_tests.php Microsoft drops Hardware Virtualisation Requirement for XP Mode - http://blogs.zdnet.com/microsoft/?p=5607 Jonathan Schwartz reveals some interested titbits from his tenure as SUN Microsystems CEO – [...]
How to transfer the logins and the passwords between instances of SQL Server 2005. On Source Server Create stored procedure sp_help_revlogin from code on http://support.microsoft.com/kb/918992/. Run the stored procedure and copy the output. On Destination Server Paste the Output from source server into a query window and run it. Job done!
Sometime ago I imported a small MSDE database into SQL Server 2005. Overtime the database has grown significantly and is now over 100gb. For the first time last week we had to do some maintenance which necessitated shutting down and restarting the SQL Service. When SQL came back up I noticed that the database in [...]
SQL Server Management Studio Keyboard Shortcuts – technet.microsoft.com/en-us/library/ms174205.aspx MSTSC /console switch in Windows Server 2008 and Windows Vista SP1 – http://blogs.msdn.com/nickmac/archive/2007/11/28/mstsc-console-switch-in-windows-server-2008-and-windows-vista-sp1.aspx CSS Reference Chart for SharePoint 2007 – http://www.heathersolomon.com/content/sp07cssreference.htm