Category Archives: SQL Server

SQL Server 2005 migration to 2012

Upgrade to SQL Server 2012:
http://msdn.microsoft.com/en-us/library/bb677622.aspx

Supported upgrade versions: 2005 SP4 or better
http://msdn.microsoft.com/en-us/library/ms143393.aspx

Things not to do:
http://thomaslarock.com/2011/12/7-mistakes-you-cant-afford-to-make-when-upgrading-to-sql-2012/

Technical guide
http://www.google.com/url?sa=t&rct=j&q=sql%20server%202005%20migration%20to%20sql%20server%202012&source=web&cd=3&ved=0CEsQFjAC&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F9%2F5%2F3%2F9533501A-6F3E-4D03-A6A3-359AF6A79877%2FSQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf&ei=s4zwUeExxNbJAfDXgYAM&usg=AFQjCNGkAVIR2vx0T52CugXZKPM-sTUnLA

SQL Server Lifecycle

I have been in several meetings discussing the need to move off of SQL Server 2005.  Below are the support end dates for the primay SQL Server versions and a link to get update information for new versions.  As you can see, mainstream support for SQL Server 2005 ended in 2011.  Extended Support for SQL Server 2005 ends on 4/12/2016.

Important Dates for SQL Server:
10/08/2013 SP2 is required for support for SQL Server 2008 R2
01/14/2014 SP1 is required for support of SQL Swerver 2012
07/08/2014 SQL Server 2008 and 2008 R2 mainstream support ends
04/12/2016 SQL Server 2005 Extended support ends
07/11 2017 SQL Server 2012 mainstream support ends

 

Products Released Lifecycle Start Date Mainstream Support End Date Extended Support End Date Service Pack Support End Date Notes
SQL Server 2005 Compact Edition 2/19/2007 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Developer Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Enterprise Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Enterprise Edition for Itanium-based Systems 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Enterprise X64 Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Express Edition 6/1/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Express Edition with Advanced Services 7/16/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Standard Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Standard Edition for Itanium-based Systems 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Standard X64 Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2005 Workgroup Edition 1/14/2006 4/12/2011 4/12/2016 7/10/2007
SQL Server 2008 Developer 11/6/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Enterprise 11/7/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Express 11/11/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Express with Advanced Services 11/22/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 R2 Datacenter 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Developer 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Enterprise 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Express 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Express with Advanced Services 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Parallel Data Warehouse 11/9/2010 7/8/2014 7/9/2019 Hardware products will receive 5 years of support following Microsoft’s end of sales date for the Major Product version. Minor Product releases follow the Support Lifecycle of their respective Major Product versions.
SQL Server 2008 R2 Standard 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Standard Edition for Small Business 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Web 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 R2 Workgroup 7/20/2010 7/8/2014 7/9/2019 7/10/2012
SQL Server 2008 Standard 11/6/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Standard Edition for Small Business 11/6/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Web 11/6/2008 7/8/2014 7/9/2019 4/13/2010
SQL Server 2008 Workgroup 11/6/2008 7/8/2014 7/9/2019 4/13/2010

SQL Server Replication

SQL Server Replication 2008 R2:
http://msdn.microsoft.com/en-us/library/ms151314(v=sql.105).aspx

Architect InfoCenter (Replication):
http://msdn.microsoft.com/en-us/library/ms151827.aspx

SQL Server Replication: Providing High Availability using Database Mirroring:
http://download.microsoft.com/download/d/9/…/ReplicationAndDBM.docx

Defense of Replication for HA:
http://www.sqlskills.com/blogs/paul/in-defense-of-transactional-replication-as-an-ha-technology/

SQL Server Blogs, Sites and Useful links

Sites:
Simple Talk:  https://www.simple-talk.com/
SQL Skills:  http://www.sqlskills.com
SQL Sentry: http://www.sqlsentry.net/
SQL Server Central:  http://www.sqlservercentral.com/
PragmaticWorks: http://pragmaticworks.com/
MSSQLTips:  http://www.mssqltips.com/
Blogs:
Jamie Thomson:   http://sqlblog.com/blogs/jamie_thomson/archive/tags/Continuous+Integration/default.aspx
Brent Ozar:  http://www.brentozar.com/blog/
Glenn Berry: http://sqlserverperformance.wordpress.com/
Paul Randall: http://www.sqlskills.com/blogs/paul/
Kimberly Tripp: http://www.sqlskills.com/blogs/kimberly/
Thormas LaRock: http://thomaslarock.com/rankings/  List of bloggers and blog.
Derik Hammer: http://www.sqlhammer.com/blog/
Grant Fritchey:  http://www.scarydba.com/
Jason Strate: http://www.jasonstrate.com/

White Papers:
http://msdn.microsoft.com/en-us/library/hh403491.aspx
http://technet.microsoft.com/en-us/library/hh403491.aspx
S
QL Server Best Practices:  http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

 

SQL Server Online Resources and Training

SQL Server Virtual Labs: http://www.microsoft.com/en-us/sqlserver/learning-center/virtual-labs.aspx
TechNet Evaluation Center:  http://technet.microsoft.com/en-us/evalcenter:
SQL Version List: http://sqlserverbuilds.blogspot.com/
PragmaticWorks Free Learning: http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars.aspx
Microsoft Virtual Academy: http://www.microsoftvirtualacademy.com/
Microsoft Free e-book library: http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx#MicrosoftSQLServerAlwaysOnSolutionsGuideforHighAvailabilityandDisasterRecovery

Powershell Scripts for Azure VMs:
http://sqlblog.com/blogs/marco_russo/archive/2013/10/29/powershell-script-to-deploy-multiple-vm-on-azure-in-parallel-azure-powershell.aspx

List of sites: http://www.mssqltips.com/sqlservertip/948/sql-server-websites/
List of Free Resources:  http://sqlblog.com/blogs/aaron_bertrand/archive/2010/10/26/useful-free-resources-for-sql-server.aspx

Microsoft Video Archive:
https://technet.microsoft.com/en-us/dn912438

Performance Tools:
DMV’s
WhatIsRunning?
Glenn Berry’s DMV Queries (Includes several proc cache queries)

Misc:

http://technet.microsoft.com/en-us/sqlserver/hh273157

http://www.mssqltips.com/
http://www.sqlpass.org/
https://www.simple-talk.com/sql/t-sql-programming/
http://www.sqlservercentral.com/
http://www.brentozar.com/
http://sqlserverperformance.wordpress.com/
http://blog.sqlauthority.com/author/pinaldave/
http://comp-phil.blogspot.com/
http://sqlmag.com/  — subscription required
http://sqlskills.com/