Joffer's Notepad

Just found a great blogpage that keeps an overview over SQL version, updates, builds etc. Check it out here: http://sqlserverbuilds.blogspot.no/ Short cuts for some useful articles, as this blogpage lists: How to identify your SQL Server version and edition SQL Server Internal Database Versions Microsoft SQL Server Support Lifecycle Microsoft SQL Server Home Microsoft SQL Server Developer Center Microsoft TechNet: Microsoft SQL Server Microsoft Knowledge Base Sqlservr.exe versions

Just found a few great blog series I'd like to share: vSphere 5.5 Install http://www.derekseaman.com/2013/10/vsphere-5-5-install-pt-1-introduction.html SQL 2012 Failover Cluster (on VMware) http://www.derekseaman.com/2013/09/sql-2012-failover-cluster-pt-1-introduction.html Windows Server 2012 Unattended Installation http://www.derekseaman.com/2012/07/windows-server-2012-unattended.html

SQLEXPR_x64_ENU.exe Vs SQLEXPR_x86_ENU.exe Vs SQLEXPR32_x86_ENU.exe etc. Found a few pages that explains this: http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/cdbcae49-fafc-4718-abb1-506e02a0b2f7/ http://blogs.msdn.com/b/sqlexpress/archive/2008/08/22/the-sql-express-2008-family-is-getting-bigger.aspx Download SQL Server 2012 w/SP1 here:  http://www.microsoft.com/en-us/download/details.aspx?id=35579

Install on active node first. Install on passive node(s) afterwards. Needs to update non-cluster services and components Source:  http://www.db-staff.com/index.php/microsoft-sql-server/87-upgrade-sql-2005-cluster-to-sp3

Upgrade passive node N2 Boot passive N2 Move resources from N1 to N2 Patch new passive node N1 Boot passive N1 Source: http://blogs.technet.com/b/mdegre/archive/2010/01/16/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx  

How to configure DTC for SQL Server in a Windows 2008 cluster

http://support.microsoft.com/kb/321185 SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

http://technet.microsoft.com/en-us/magazine/2008.08.database.aspx?pr=blog

http://blogs.msdn.com/sqlreleaseservices/