Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping

Migration Guide: Migrating to AlwaysOn Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping – SQL Server AlwaysOn Team Blog – Site Home – MSDN Blogs

http://blogs.msdn.com/b/sqlalwayson/archive/2012/08/20/migration-guide-migrating-to-alwayson-availability-groups-from-prior-deployments-combining-database-mirroring-and-log-shipping.aspx

SQL 2012 PowerShell script to detect CPU’s configured for licensing

SQL 2012 has changed the license model around CPUs/Cores. The below script can be used to help detect how many CPU’s are on the host and also configured in SQL. If you detect that you do not have the correct CPU’s, then you may need to reconfigure SQL.

Example outputs:

SQL Server CPU check
Checking server instance TESTSQL
—————————————————
Server Physical Cores : 4 ( 2399 mhz )
Server Logical Cores  : 4
SQL Server Cores      : 4
SQL Edition           : Standard Edition (64-bit)
—————————————————

SQL Server CPU check
Checking server instance TESTSQL
—————————————————
Server Physical Cores : 4 ( 2399 mhz )
Server Logical Cores  : 4
SQL Server Cores      : 2
SQL Edition           : Standard Edition (64-bit)
—————————————————

Script:

################################################################################
#
# Script: DetectCPUCores.ps1
#
# Author: Craig Wilson
# Date: 22/06/2012
# Version: v1.0.0
#
# This script will connect SQL and the WMI of then host to collect CPU core
# information
################################################################################

function DetectCPUCores ([string]$SQLINSTANCE, [string]$HOSTNAME)
{

    Write-Host "SQL Server CPU check"
    Write-Host " Checking server instance $SQLINSTANCE"
    Write-Host "---------------------------------------------------"    

    $SqlConnection = New-Object System.Data.SqlClient.SqlConnection 
    $SqlConnection.ConnectionString = "Data Source=$SQLINSTANCE;Integrated Security=TRUE" 
    $SqlConnection.Open() 

    $SqlCmd = New-Object System.Data.SqlClient.SqlCommand 
    $SqlCmd.CommandText = "select serverproperty('ProductVersion')" 
    $SqlCmd.Connection = $SqlConnection 
    $sql_ProductVersion = $SqlCmd.ExecuteScalar() 

    $SqlCmd = New-Object System.Data.SqlClient.SqlCommand 
    $SqlCmd.CommandText = "select serverproperty('Edition')" 
    $SqlCmd.Connection = $SqlConnection 
    $sql_edition = $SqlCmd.ExecuteScalar() 

    $SqlCmd = New-Object System.Data.SqlClient.SqlCommand 
    $SqlCmd.CommandText = "select count(*) from sys.dm_os_schedulers where status = 'VISIBLE ONLINE'" 
    $SqlCmd.Connection = $SqlConnection 
    $sql_schedulers = $SqlCmd.ExecuteScalar() 

    $SqlConnection.Close() 

    $property = "systemname","maxclockspeed","addressWidth","numberOfCores", "NumberOfLogicalProcessors"
    $cpu_info = Get-WmiObject -computername $HOSTNAME -class win32_processor -Property  $property | Select-Object -Property $property 

    Write-Host "Server Physical Cores :"$cpu_info.numberOfCores "("$cpu_info.maxclockspeed"mhz ) "
    Write-Host "Server Logical Cores :"$cpu_info.NumberOfLogicalProcessors
    Write-Host "SQL Server Cores : $sql_schedulers"
    Write-Host "SQL Edition : $sql_edition"
    Write-Host "SQL Product Version : $sql_ProductVersion"
    Write-Host "---------------------------------------------------"

}

DetectCPUCores "SQLInstance" "LOCALHOST"



For more information on how the licensing impact you check out the following blog posts

SQL Server 2012 Enterprise Editions

http://blogs.msdn.com/b/saponsqlserver/archive/2012/06/15/sql-server-2012-enterprise-editions.aspx

SQL Server 2012 Licensing (Resources Pane)

http://www.microsoft.com/sqlserver/en/us/get-sql-server/licensing.aspx

SQL Versions and their latest Cumulative Updates (CU)

Microsoft releases a number of updates for SQL and other products. The following table outlines the current versions of SQL server with the Service Pack and Cumulative update levels.

Product Version Latest Service Pack Latest Cumulative Update Release of CU Build Number
SQL Server 2012 CU 2 (KB 2703275) 18-06-2012 11.0.2325.0
SQL Server 2008 R2 SP1 (KB 2528583) CU 6 (KB 2679367) 16-04-2012 10.50.2811.0
SQL Server 2008 SP3 (KB 2546951) CU 5 (KB 2696626) 31-05-2012 10.00.5785.00
SQL Server 2005 SP4 (KB 2463332) CU 3 (KB 2507769) 22-03-2011 9.00.5266
SQL Server 2000 SP4 (KB 290211)

Cumulative update package 2 for SQL Server 2012 is available

Microsoft has now released Cumulative update package 2 for SQL 2012.

Check the Update Center for Microsoft SQL server(http://technet.microsoft.com/en-us/sqlserver/ff803383.aspx) for other SQL updates.

SQL Server 2012 CU 2 (Build 11.0.2325.0) Download:

KB 2703275 http://support.microsoft.com/kb/2703275

Microsoft SQL Server 2012 Exams

The entire Microsoft SQL Server 2012 exam portfolio is now available!

Explore the different exams available on SQL Server 2012.

Learning Plans and Classroom Training for this exam:

Learning Plans and Classroom Training for this exam:

Learning Plans and Classroom Training for this exam:

Learning Plans and Classroom Training for this exam:

Poster showing SQL Azure Federation features, process, and key terms

Microsoft has releases a poster explaining the federation process for Azure.

http://www.microsoft.com/en-us/download/details.aspx?id=29213

Overview

The poster explains the federation process, including creating the federation root database, creating the scheme, and then using the split operation to partition the federation member into two partition members by row. It also explains the database infrastructure and includes sample T-SQL statements.

image

http://www.microsoft.com/en-us/download/details.aspx?id=29213