Tag: SQL Server

Extended Security Updates for SQL Server and Windows Server 2008 and 2008 R2 on Azure Stack

Extended Security Updates for SQL Server and Windows Server 2008 and 2008 R2 on Azure Stack

SQL Server and Windows Server 2008 and 2008 R2 will both be out of extended support within the  next 12 months (detailed dates below). This means if you have these versions, you’ll need to migrate to newer versions of SQL Server or Windows Server or buy Extended Support soon to maintain support and receive security updates and fixes. Buying Extended Support is not cheap. Customers with active Software Assurance or subscription licenses can purchase Extended Security Updates annually for 75 percent of the full license cost of the latest version of SQL Server or Windows Server. A lot of customer should start migrating to newer versions of these products to avoid these extra costs.

Extended Support dates

  • Extended Support for SQL Server 2008 and 2008 R2 will end on July 9, 2019.
  • Extended Support for Windows Server 2008 and 2008 R2 will end on January 14, 2020.

However, in mid-2018 Microsoft announced a new option for SQL Server 2008 and Windows Server 2008 End of Support. Customers running 2008 or 2008 R2 versions of SQL Server and Windows Server in Azure virtual machines will get Extended Security Updates for free. This will give customers some extra time to migrate to newer versions of SQL Server and Windows Server. Or even better, to Azure PaaS and serverless computing like Azure Functions.

The great thing about this, is that you can also combine this with your Azure Hybrid benefits, to use your SQL Server and Windows Server on Azure with your on-premise licenses.

Extended Security Updates on Azure Stack

If you are thinking to migrate to the cloud, this new option will bring down costs for you. However, not everyone is fully ready to move all their servers to the public cloud. You might still need or want to run some servers on-premise in your datacenter. This will leave you with buying Extended Support or what a lot of people don’t know, you can also run your SQL Server and Windows Server 2008 and 2008 R2 on Azure Stack and get Extended Security Updates for free, since it is basically Azure!

This is great, especially since Azure Stack also comes with great IaaS capabilities. And if you are thinking about using Azure in the mid-term, Azure Stack provides you with Azure capabilities, but still allows you to stay in your own datacenter.



System Center Logo

System Center 2012 R2 and Azure Pack get supports for SQL Server 2014 in Update Rollup 5

Microsoft just released System Center 2012 R2 Update Rollup 5, which includes a lot of new features and fixes. The update also brings support for SQL Server 2014 as a database server for most of the System Center 2012 R2 components. There will be support for the rest of the System Center components in the Update Rollup 6.

Supports SQL 2014 now:

Operations Manager
System Center Orchestrator
Service Management Automation
Service Provider Foundation
Virtual Machine Manager
Windows Azure Pack

Will support SQL 2014 in UR6:

Service Reporting
Service Manager
Data Protection Manager

For information check out the Microsoft System Center Team Blog.

 



Cisco Microsoft

Cisco and Microsoft Announce Sales and Go-to-Market Agreement

At the Worldwide Partner Conference 2014 Cisco and Microsoft announced a multi-year sales and go-to-market agreement designed to modernize data centers through the delivery and acceleration of integrated solutions. This will focus on bringing a deeper integration between the datacenter technologies of both companies. This includes Cisco UCS and Nexus products as well as Microsoft’s CloudOS solutions based Windows Server, Hyper-V, System Center, SQL Server and Microsoft Azure.

Highlights:

Go-to-Market:

  • Cisco and Microsoft agree to a three-year go-to-market plan focused on transforming data centers through the delivery of integrated solutions for enterprise customers and service providers.
  • In year one, the companies will focus on six countries — the United States, Canada, UK, Germany, France, and Australia — with expansion to additional countries in the following years.
  • Cisco and Microsoft will align partner incentive programs to accelerate solutions selling via mutual channel partners.
  • Cisco and Microsoft sales teams will work together on cloud and data center opportunities, including an initial program focused on the migration of Windows 2003 customers to Windows 2012 R2 on the Cisco UCS platform.

Integrated Solutions:

  • Integrated solutions will focus on private cloud, server migration, service provider, and SQL Server 2014
  • Cisco technologies to include Cisco UCS, Cisco Nexus switching, Cisco UCS Manager with System Center integration modules, and Cisco PowerTool.
  • Cisco-based integrated infrastructure solutions will include FlexPod with NetApp and Cisco Solutions for EMC VXPEX.
  • Microsoft technology includes Windows Server 2012 R2, System Center 2012 R2, PowerShell, Microsoft Azure and SQL Server 2014
  • Cisco Application Centric Infrastructure and Cisco InterCloud Fabric to be integrated in the solutions in future releases

Source and More information: www.streetinsider.com

As you may know I am a Microsoft MVP and a Cisco Champion and I really like doing project with Cisco Hardware since they do a lot of integration with the Microsoft Stack especially System Center and PowerShell. In my opinion this could be a strong partnership and will make life of a lot of people a lot easier.



Windows Server 2012 R2 and System Center 2012 R2 Preview available

Windows Server 2012 R2 and System Center 2012 R2

Microsoft made the preview bits for System Center 2012 R2 and Windows Server 2012 R2 available on TechNet and MSDN. So for all of you who have a MSDN or TechNet account you can download them and test them in your lab environments.

This release includes:

  • System Center 2012 R2 Preview Virtual Machine Manager
  • System Center 2012 R2 Preview Service Manager
  • System Center 2012 R2 Preview Data Protection Manager
  • System Center 2012 R2 Preview App Controller
  • System Center 2012 R2 Preview Configuration Manager
  • System Center 2012 R2 Preview Orchestrator
  • System Center 2012 R2 Preview Operations Manager
  • Microsoft Hyper-V Server 2012 R2 Preview
  • Windows Server 2012 R2 Datacenter Preview
  • Microsoft Hyper-V Server 2012 R2 Debug/Checked Preview
  • Windows Server 2012 R2 Language Pack Preview
  • Windows Server 2012 R2 Datacenter Debug/Checked Preview
  • Windows Server 2012 R2 Datacenter Virtual Machine Preview
  • Windows Server 2012 R2 Datacenter Virtual Machine Core Preview
  • Windows Server 2012 R2 Essentials Debug/Checked Preview
  • Windows Server 2012 R2 Essentials Preview

Microsoft also released a Community Tech Preview of SQL Server 2014. Make sure you reserve some time for tomorrow when Microsoft makes the Windows 8.1 Preview available for the public.



Microsoft Server Posterpedia Windows 8 App

I know for a lot of people this is not something new, but in the courses I presented in the past weeks I always mentioned this great Windows 8 App called Server Posterpedia.

Server PosterPedia

Server Posterpedia is an interactive app that uses technical posters as a reference for  understanding Microsoft technologies. This app includes all the reference posters from different Microsoft Server Technologies such as Windows Server 2012 Hyper-V, Exchange or Windows Azure. The great thing about this App, you can not only checkout the different posters and zoom in, if you click on a specific topic for you get directly linked to the right TechNet article. This can help find some TechNet references really easy and fast.
You can get Server Posterpedia for free in the Windows Store: Server Posterpedia


How to integrate (slipstream) SQL Server 2008 and SP1

To install SQL Server 2008 on a Windows Server 2008 R2 you need a slipstream version of SQL Server 2008 with integrated Servicepack 1. At the moment you can’t download SQL Server 2008 with integrated SP1, so you have to create your own slipstream version.

1. Copy your original SQL Server 2008 source media to c:\SQLServer2008_FullSP1

2. Download Service Pack 1 from http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19. The three architectures of Service Pack 1 should be included, the package names are as follows:

  • SQLServer2008SP1-KB968369-IA64-ENU.exe
  • SQLServer2008SP1-KB968369-x64-ENU.exe
  • SQLServer2008SP1-KB968369-x86-ENU.exe

3. Extract the packages as follows:

  • SQLServer2008SP1-KB968369-IA64-ENU.exe /x:c:\SQLServer2008_FullSP1\PCU
  • SQLServer2008SP1-KB968369-x64-ENU.exe /x:c:\SQLServer2008_FullSP1\PCU
  • SQLServer2008SP1-KB968369-x86-ENU.exe /x:c:\SQLServer2008_FullSP1\PCU

4. Copy Setup.exe and Setup.rll from the PCU extracted location to original source media location

  • robocopy C:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.exe
  • robocopy C:\SQLServer2008_FullSP1\PCU c:\SQLServer2008_FullSP1 Setup.rll

5. Copy all files not the folders, except the Microsoft.SQL.Chainer.PackageData.dll, in c:\SQLServer2008_FullSP1\PCU\<architecture> to C:\SQLServer2008_FullSP1 \<architecture> to update the original files.

  • robocopy C:\SQLServer2008_FullSP1\pcu\x86 C:\SQLServer2008_FullSP1\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
  • robocopy C:\SQLServer2008_FullSP1\pcu\x64 C:\SQLServer2008_FullSP1\x64 /XF Microsoft.SQL.Chainer.PackageData.dll
  • robocopy C:\SQLServer2008_FullSP1\pcu\ia64 C:\SQLServer2008_FullSP1\ia64 /XF Microsoft.SQL.Chainer.PackageData.dll

6. Determine if you have a defaultsetup.ini at the following locations:

  • C:\SQLServer2008_FullSP1\x86
  • C:\SQLServer2008_FullSP1\x64
  • C:\SQLServer2008_FullSP1\ia64

If you have a defaultsetup.ini, add PCUSOURCE=”{Full path}\PCU”.

NOTE: The {Full path} needs to be the absolute path to the PCU folder. If you will just be running from local folder it would be C:\SQLServer2008_FullSP1. If you will eventually share this folder out, {Full path} would be \\MyServer\SQLServer2008_FullSP1.

See question #11 here if you would like to use a relative path.
;SQLSERVER2008 Configuration File

[SQLSERVER2008]

PCUSOURCE=”{Full path}\PCU”
If you do NOT have a defaultsetup.ini, create one with the following content:
;SQLSERVER2008 Configuration File

[SQLSERVER2008]

PCUSOURCE=”{full path}\PCU”
and copy to the following locations:

C:\SQLServer2008_FullSP1\x86

C:\SQLServer2008_FullSP1\x64

C:\SQLServer2008_FullSP1\ia64
This file will tell the setup program where to locate the SP1 source media that you extracted in step 3.
7. Now run setup.exe as you normally would.

More Information can be found on this msdn blog. Thanks to Peter Saddow.



Shrinking the Transaction Log in SQL Server 2000

  • Use the SQL Query Analyzer


BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
GO

  • (replace XXX with the database name)