Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag sql server 2012 Rss

Search for any content tagged sql server 2012

<< Newer    Items 21 to 40 of 75    Older >>
 

Resource Governor in SQL Server 2012

SQL Server 2012 delivers enhancements to the Resource Governor that reflect a growing need for centrally managed database services to provide multitenancy to customers who require isolated workloads. This document describes the enhancements and why they were added. It includes a self-contained walk through that you can try in order to gain familiarity with the new features.  Read more...
By Additional Articles 2013/02/21 | Source: TechNet Blogs | Category: resource governor
Rating:  Rate this |   Briefcase | 2,269 reads

SQL Server 2012: Time Marches On

Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.  Read more...
By Additional Articles 2013/02/13 | Category: date manipulation
Rating: (not yet rated)  Rate this |   Briefcase | 3,111 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through CU#9 for SP1.  Read more...
By Steve Jones 2013/04/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 10,920 reads

Securing SQL Server 2012 Integration Services Packages using Digital Certificates

There are several different ways of restricting access to SSIS packages and confidential information they contain. However, preventing unauthorized users from running or viewing the content of your code is not the only security measure that you should take into consideration.   Read more...
By Additional Articles 2013/01/24 | Source: Database Journal | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 1,754 reads

Handling Errors in SQL Server 2012

The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included in SQL Server 2012 that, when combined with the TRY...CATCH block, makes error handling far easier. Robert Sheldon explains all.  Read more...
By Additional Articles 2013/01/17 | Category: error handling
Rating:  Rate this |   Briefcase | 7,695 reads

Auditing SQL Server 2012 Server Roles

My organization is looking at SQL Server 2012 and I know that the ability to create roles at the server level is a new feature. Since this is new and impacts security, how do I handle them and how do I audit them?  Read more...
By Additional Articles 2012/11/30 | Source: SimpleTalk | Category: server roles
Rating: (not yet rated)  Rate this |   Briefcase | 1,771 reads

SQL Server 2012 AlwaysOn: Multisite Failover Cluster Instance

SQL Server Failover Clustering, which includes support for both local and multisite failover configurations, is part of the SQL Server 2012 AlwaysOn implementation suite, designed to provide high availability and disaster recovery for SQL Server. The multisite failover clustering technology has been enhanced significantly in SQL Server 2012. The multisite failover cluster architecture, enhancements in SQL Server 2012 to the technology, and some best practices to help with deployment of the technology are the primary focus of this paper.  Read more...
By Additional Articles 2012/11/16 | Source: Microsoft MSDN | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 2,046 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through CU#9 for SP1.  Read more...
By Steve Jones 2013/04/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 10,920 reads

Exporting Master Data from Master Data Services

This white paper describes how to export master data from Microsoft SQL Server Master Data Services (MDS) using a subscription view, and how to import the master data into an external system using SQL Server Integration Services (SSIS). The white paper provides a step-by-step sample for creating a subscription view and an SSIS package.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,690 reads

Getting Started with the New Column Store Index of SQL Server 2012

Column Store Index, a new feature in SQL Server 2012, improves performance of data warehouse queries several folds. Arshad Ali shows you how to create column store index, and how to use index query hint to include or exclude a column store index.  Read more...
By Additional Articles 2012/10/09 | Source: Database Journal | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 2,781 reads

Data Access Tracing in SQL Server 2012

Learn how to apply the tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server database engine.  Read more...
By Additional Articles 2012/09/28 | Source: Microsoft MSDN | Category: tracing
Rating: (not yet rated)  Rate this |   Briefcase | 2,457 reads

SQL Server 2012: Migrating BLOBs to FILETABLEs

Learn about this new feature in SQL Server 2012 and how to move your binary data.  Read more...
By Additional Articles 2012/09/18 | Source: MSDN Communities | Category: filetable
Rating: (not yet rated)  Rate this |   Briefcase | 2,307 reads

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.  Read more...
By Additional Articles 2012/09/14 | Source: Microsoft MSDN | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 2,486 reads

Upgrading SSIS Custom Components for SQL Server 2012

Having finally got around to upgrading my custom components to SQL Server 2012, I thought I’d share some notes on the process. One of the goals was minimal duplication, so the same code files are used to build the 2008 and 2012 components, I just have a separate project file.   Read more...
By Additional Articles 2012/09/05 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 1,530 reads

SQL Server 2012’s Information on Parallel Thread Usage

In the SQL Server 2012 execution plan we can see better the true thread reservations for a query and not just information on the maximum degree of parallelism and row distribution across parallel threads; thanks to the new parallel thread usage information.  Read more...
By Joe Sack 2012/08/09 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 3,271 reads

SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery

The aim of the new Database Recovery Advisor in SQL Server 2012 is to simplify the task of piecing together a recovery sequence from multiple backup files, comprising full, differential, and log backups. In this article, I'll demonstrate how the tool makes it easier to plan for, and perform, a point in time recovery from a series of backups, in order to recover data that may have been lost due to an application bug, or user error.  Read more...
By Jonathan Kehayias 2012/07/13 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 2,265 reads

SQL Server 2012 - New Service Broker Features

SQL Server 2012 came with bells and whistles for service broker, that give you plenty reasons to start using service broker in your applications.  Read more...
By Sanil Mhatre 2012/06/29 | Source: SQLServerCentral.com | Category: service broker
Rating: |  Discuss |   Briefcase | 2,732 reads

Simplified Restores with SQL Server 2012 Recovery Advisor

Occasionally, a DBA may need to restore a database from a multiple backup files that originated from multiple servers. This requirement might arise, for example, in a database-mirroring configuration, where backups may be from either of the servers.  Read more...
By Jonathan Kehayias 2012/06/27 | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 2,739 reads

Adding Map Callout Boxes in Reporting Services

A callout text box outside the map area would help to enhance the visual effect of presenting data in reporting services.  Read more...
By Haining Liu 2012/06/21 | Source: SQLServerCentral.com | Category: map tool
Rating: |  Discuss |   Briefcase | 5,734 reads

Stop Food Waste - OS Open Data & SQL Azure

An attempt to use Ordanance Survey OS Open Data, SQL Server and SharePoint in the construction of a system for supermarkets to supply expiring food to nearby homeless shelters.   Read more...
By Paul Brewer 2012/06/14 | Source: SQLServerCentral.com | Category: ordnance survey os data
Rating: |  Discuss |   Briefcase | 2,720 reads
<< Newer    Items 21 to 40 of 75    Older >>