Packtpub - Microsoft
#SQLBITS
www.sqlserver-qa.net@sqlmasterIT ExperienceBeen in the IT field over 18 years (using SQL Server ver.4.2 onwards)Principal Architect – D Bi A Solutions (consulting@dbiasolutions.co.uk )PublicationsAuthor: Microsoft SQL Server 2008 R2 Administration cookbook – Packt Publishers (May 2011)Co-author for MVP Deep Dives Volume II – Manning Publications (October 2011)SQL Server MVP since 2006Founder (SQLMaster) & blogs at www.sqlserver-qa.net; (SQL Server Knowledge Sharing Network)Contributing Editor & Moderator - www.sql-server-performance.com [SSP]Quiz Master & Blogger: www.beyondrelational.com & www.sqlservergeeks.comActive participation in assorted forums such as SSP, SQL Server Central, MSDN, SQL Server magazine,dbforums etc.
www.packtpub.com
www.codeplex.com
spxFromToSQL Server 2000/2005 EnterpriseSQL Server 2008 R2 EnterpriseSQL Server 2000/2005 StandardSQL Server 2008 R2 StandardSQL Server 2008 R2 EnterpriseSQL Server 2005 MSDESQL Server 2008 R2 Express
SQL Server 2000/2005/2008InstanceSQL Server 2008 R2InstanceCompareandVerifyVerified!13
m in SP1 orSQL Server 2008 R2Upgrading from SQL Server 2000 IA64 is not supportedUpgrading a clustered SQL Server 2000 Analysis Services to SQLServer 2008 (R2) is not supported15
Best PracticeKB 93744416
Customer case – Initial configurationActive Windows Server 2003 R2EE SP2, 64-BitPassiveStorage SQL Server 2000 EE SP464-Bit17
Customer case – Installation of prerequisitesStep #2:Install Prerequisites:1- .Net Framework 3.5 SP12- Windows Installer 4.53- Windows QFE (KB937444)4- SQL2008 R2 Setup Support filesREBOOT .ActiveStep #1:Install Prerequisites:1- .Net Framework 3.5 SP12- Windows Installer 4.53- Windows QFE (KB937444)4- SQL2008 Setup R2Support filesREBOOT .PassiveSQL Instance Manual Failover18
Customer case – Upgrade clustered componentsStep #4:Upgrade to SQL Server 2008 R2 on Active NodeStep #3:Upgrade to SQL Server 2008 R2 on Passive NodeSQL Server 2008 R2Removed fromCluster GroupPossible OwnersPassiveActiveNo client connection for 1-2minutes while db is beingupgraded to 2008 on the leftnodeSQL Server 2008 R2ActiveStep 5: SQL Instance Automatic Failover19
Database mirroring1. Upgrade MirrorFirst2. Wait for LowActivity Window4. Failover to Mirror:(New Principal)3. ALTER Mode toSYNCHRONOUS5. ALTER Mode toASYNCHRONOUS6. UPGRADE NewMirror InstanceAsynchronousMirroring: Steps 1 6SynchronousMirroring: Steps 1,4, 6
Customer case – Failover cluster with mirroringStep #1:Upgrade to SQL Server 2008 R2 onmirrored totothethedatabasedatabasemirroringmirroring partnerpartnerforforeacheachdatabasedatabaseSQL 2008 R2SQL Server ClusterStep 21PrincipalSQLMirroredSQLServer2008 R2
22
23
www.dtsxchange.com24
with Partitioned TablesUsing Filtered Statistics
Upgrading Replication from SQL Server 2000 32-Bitto SQL Server 2008 64-Bit without re-initialization
Available at the following locations:- The SQL Server Installation Center- On the source media in the [Servers\redist\Upgrade Advisor] folder- Through the SQL Server 2008 R2 Feature Pack displaylang en&FamilyID ceb4346f-657f-4d28-83f5-aae0c5c83d52
www.scalabilityexperts.com/ssua
spx
/details.aspx?FamilyID 66d3e6f5-6902-4fdd-af759975aea5bea7&displaylang 50.aspxhttp://sqlserver-qa.net/blogs/Bloggers.aspx
www.packtpub.com
SpeakerTitleRoomKlaus AschenbrennerUnderstanding SQL Server Execution PlansAintreeThomas KejserFinding the LimitsLancasterAlberto FerrariMany-to-Many Relationships in DAXPearceMark WhitehornMDX and DAX-compare and contrastBoardroomBob DuffySQL tuning from the dot.net perspectiveEmpireFrancesco QuaratinoThe forgotten DBA daily essential checklistDerby#SQLBITS
Step #3: Upgrade to SQL Server 2008 R2 on Active Node Upgrade to SQL Server 2008 R2 on Passive Node Step 5: SQL Instance Automatic Failover No client connection for 1-2 minutes while db is being upgraded to 2008 on the left node SQL Server 2008 R2 SQL Server 2008 R2 Active Removed from Cluster Group Possible Owners 19
o Microsoft Outlook 2000 o Microsoft Outlook 2002 o Microsoft Outlook 2003 o Microsoft Outlook 2007 o Microsoft Outlook 2010 o Microsoft Outlook 2013 o Microsoft Outlook 98 o Microsoft PowerPoint 2000 o Microsoft PowerPoint 2002 – Normal User o Microsoft PowerPoint 2002 – Power User o Microsoft PowerPoint 2002 – Whole Test
Business Ready Enhancement Plan for Microsoft Dynamics Customer FAQ Updated January 2011 The Business Ready Enhancement Plan for Microsoft Dynamics is a maintenance plan available to customers of Microsoft Dynamics AX, Microsoft C5, Microsoft Dynamics CRM, Microsoft Dynamics GP, Microsoft Dynamics NAV, Microsoft Dynamics SL, Microsoft Dynamics POS, and Microsoft Dynamics RMS, and
Microsoft, Microsoft Dynamics, logo systemu Microsoft Dynamics, Microsoft BizTalk Server, program Microsoft Excel, Microsoft.NET Framework, program Microsoft Outlook, Microsoft SharePoint Foundation 2010, Microsoft SharePoint Ser
Microsoft Dynamics 365 for Operations on-premises, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Microsoft Dynamics AX 2012 or prior versions, or Microsoft Dynamics CRM 2016 or prior versions. This guide is not intended to influence the choice of Microsoft Dynamics products and services or provide technical specification.
References to Microsoft Word, Microsoft Excel, and Microsoft PowerPoint are to the latest version of Microsoft Office as of May 1, 2005. The information on Microsoft Word, Microsoft Excel, and Microsoft PowerPoint contained herein has been derived from the applicat
2007 Microsoft Office System Microsoft Office Project 2007 Microsoft Office Visio 2007 Visual Studio 2005 Microsoft Dynamics CRM 3.0 Product Licensing — Systems . The Microsoft Licensing Reseller Handbook is a one-stop partner resource to help you understand Microsoft licensing options and complete more Microsoft solution sales. .
Upon submission of a request to register a .Microsoft domain name, or by asking Microsoft to renew a .Microsoft domain name registration, Registrant represents and warrants that Registrant's .Microsoft domain name registration does and will at all times comply with the .Microsoft Registration Policy and the .Microsoft Registry T&Cs.
Operations, on-premises, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Microsoft Dynamics AX 2012 or prior versions, or Microsoft Dynamics CRM 2016 or prior versions. This guide also does not apply to the Microsoft Dynamic CRM Online or Microsoft Dynamics AX online services. This guide is not intended to influence the .
