Archives For SQL Server 2012


Learn SQL Server 2012 with Free Guide and Books

 

image
5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
EPUB
MOBI
PDF
image
A Hitchiker’s Guide to Microsoft StreamInsight Queries
EPUB
MOBI
PDF
image
Data Mining Extensions (DMX) Reference
EPUB
MOBI
PDF
image
Data Quality Services
EPUB
MOBI
PDF
image
High Availability Solutions
EPUB
MOBI
PDF
image
Master Data Services
EPUB
MOBI
PDF
image
Monitor and Tune for Performance
EPUB
MOBI
PDF
image
Multidimensional Expressions (MDX) Reference
EPUB
MOBI
PDF
image
SQL Server Distributed Replay
EPUB
MOBI
PDF
image
Transact-SQL Data Definition Language (DDL) Reference
EPUB
MOBI
PDF
image
XQuery Language Reference
EPUB
MOBI
PDF
image
Extracting and Loading SharePoint Data in SQL Server Integration Services
EPUB
MOBI
PDF
image
Integration Services: Extending Packages with Scripting
EPUB
MOBI
PDF
image
Multidimensional Model Programming
EPUB
MOBI
PDF
image
Optimized Bulk Loading of Data into Oracle
EPUB
MOBI
PDF
image
Planning Disaster Recovery for Microsoft SQL Server Reporting Services in SharePoint Integrated Mode
EPUB
MOBI
PDF
image
SQL Server 2012 Tutorials: Reporting Services
EPUB
MOBI
PDF
image
SQL Server 2012 Tutorials: Writing Transact-SQL Statements
EPUB
MOBI
PDF
image
SQL Server Community FAQs Manual
EPUB
MOBI
PDF

 


Source:http://blogs.msdn.com/b/farukcelik/archive/2013/05/21/new-tool-quot-microsoft-kerberos-configuration-manager-for-sql-server-quot-is-ready-to-resolve-your-kerberos-connectivity-issues.aspx

You can download “Microsoft Kerberos Configuration Manager for SQL Server” from here

Microsoft Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server.

Kerberos authentication provides a highly secure method to authenticate client and server entities (security principals) on a network.  To use Kerberos authentication with SQL Server, a Service Principal Name (SPN) must be registered with Active Directory, which plays the role of the Key Distribution Center in a Windows domain.  In addition, many customers also enable delegation for multi tier applications using SQL Server.  In such a setup, it may be difficult to troubleshoot the connectivity problems with SQL Server when Kerberos authentication fails.

The Kerberos Configuration Manager for SQL Server is a diagnostic tool that helps troubleshoot Kerberos related connectivity issues with SQL Server.   It can perform the following functions:

  • Gather information on OS and Microsoft SQL Server instances installed on a server.
  • Report on all SPN and delegation configurations on the server.
  • Identify potential problems in SPNs and delegations.
  • Fix potential SPN problems.
Supported Operating System

Windows 7, Windows 8, Windows Server 2008 R2 SP1, Windows Server 2012

The following are required on the machine where the Kerberos Configuration Manager for SQL Server is launched:

    • .Net framework 4.0 or higher

To Install:

  1. Download the 32bit or 64bit version of the Kerberos Configuration Manager installer that matches your computer’s OS architecture.
  2. Click Open to start the installation immediately or click Save to save the installation .msi file to disk and install it later.
  3. Accept the license term of this tool.
  4. Click Next to complete the installation.

To Launch the Tool:

  1. After the installation is complete successfully, double click the KerberosConfigMgr.exe  to launch the application.

To Generate SPN List from Command Line:

  1. Go to command line.
  2. Switch to the folder where KerberosConfigMgr.exe is.
  3. Type KerberosConfigMgr.exe -q -l
  4. For more command line option, type KerberosConfigMgr.exe -h

To Save a Server’s Kerberos Configuration Information:

  1. Connect to the target windows server.
  2. Click on Save button on the toolbar
  3. Specify the location where you want the file to be saved at.  It can be on a local drive or network share.
  4. The file will be saved as .XML format.

To View a Server’s Kerberos Configuration Information from Saved File:

  1. Click on the Load button on the toolbar.
  2. Open the XML file generated by Kerberos Configuration Manager.

To Generate a Script to Fix SPN from Command Line:

  1. Click on the Generate button for the SPN entry.
  2. The generated script can be used by a user who has privilege to fix the SPN on the server.

To See the Log Files for this Tool:

  1. By default, one log file is generated in the user’s application data folder.

To Get Help:
Option 1: Hover the mouse cursor over the command for tooltip.
Option 2:  Run KerberosConfigMgr.exe –h from command line
Option 3: Click the Help button in the toolbar.


Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15th 2013, and is available for download at the Microsoft Download Center at http://www.microsoft.com/en-us/download/details.aspx?id=39046.


Flash technology is changing everything, nothing new there. Chances are the device you are reading this BLOG on contains some type of Flash memory. Within the datacenter, it has been well documented that the increasing performance capabilities of today’s CPUs have created an I/O performance gap. Processor speeds and network bandwidth have been able to keep pace with new enterprise application requirements. Spinning disk drives just can’t keep up with these new performance needs. Most performance trouble shooting today points to I/O resource requirements, or the lack thereof.

Read More: http://blogs.technet.com/b/dataplatforminsider/archive/2013/05/01/leveraging-flash-across-the-microsoft-sql-server-stack.aspx


Steps by steps instruction for installing SQL Server 2012 in Windows Server 2012. I am installing SQL Server 2012 for trying SharePoint 2013 in VirtualBox machine

1. Open your ISO image files  and double click to start installation process

Install-SQL-2012-1

Install-SQL-2012-2

 

2. Double click on Run Setup.exe to start the SQL Server 2012 Installation

Install-SQL-2012-3

3.   In SQL Server Installation Center 2010, Click Installation

SQL-Server-Installation-Center-2012-4

4. In SQL Server Installation Center 2012, Click new sql server stand alone installation or add features to an existing installation.
This will launch a wizard to install SQL Server 2012 in a non-clustered environment or to add features to an existing SQL Server 2012 instance.

SQL-Server-Installation-2012-Installation

 

5. Setup Support Rules for SQL Server 2012
Setup Support rules identify problems that might occur when your install SQL Server setup support files.
Failures must be corrected before setup can continue

Setup Support Rules for SQL Server 2012

6. Product Key SQL Server 2012 Setup
Specify the edition of SQL Server 2012 to install

SQL-Server-2012-Setup-Product-Key

7. Setup Support Rules

Setup Support rules identify problems that might occur when your install SQL Server setup support files.
Failures must be corrected before setup can continue. I get warning message for installing SQL in domain controller

SQL-Server-2012-Setup-Support-Rules-8

 

8. SQL Server 2012 Setup Role
Click the SQL Server feature installation option to individually select which feature components to install, or click a feature role to install a specific configuration

SQL-Server-Setup-2012-Feature-Installation

9. SQL Server 2012 Feature Selection

SQL-Server-Setup-2012-Feature-Selection

10. SQL Server 2012 Setup Instance Configuration
Specify the name and instance ID for the instance of SQL Server. Instance ID becomes part of the installation Path

SQL Server 2012 Setup Instance Configuration

11. SQL Server 2012 Server Configuration
Specify the services accounts and collation configuration

SQL Server 2012 Server Configuration

12. SQL Server 2012 Setup Database Configuration, Server Configuration
Specify the authentication mode and administrators for the Database Engine.

 

SQL-Server-Installation-Database-Engine-Configuration-12

13. SQL Server 2012 setup database engine configuration
Specify database engine authentication security mode, administrators and data directories

SQL-Server-Installation-Data-Directories-13

14. SQL Server 2012 Setup : Read to Install
Verify the SQL Server 2012 features to be install and click Install

SQL-Server-Setup-2012-Ready-To-Install-15

15. SQL Server 2012 Installation completed. Click close the window

SQL-Server-Setup-2012-complete-16


Download the datasheets, white papers and technical presentations that will help you evaluate Microsoft SQL Server 2012

Overview

The SQL Server 2012 product guide download contains the latest datasheets, white papers and technical presentations to help you evaluate the SQL Server 2012. The product guide organizes the content for easier viewing. This version of the includes the top content from the prior versions of the product guide plus 24 new presentations covering level 200 and 300 content for the 12 od 2012. The overview page includes a link to the hosted SQL Server Virtual labs so that you can try out SQL Server 2012 without having to download the product

Download SQL Server 2012 Product Guide


Where can I download SQL Server 2012 Code Name "Denali" CTP3?
Download SQL Server 2012 CTP3


Where can I download SQL Server 2012 Code Name "Denali" CTP3?
Download SQL Server 2012 CTP3