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 79    Older >>
 

SQL Server 2012 Window Function Basics

For some time, Microsoft had a few window functions, but not the full set specified in the SQL 2003 standard. Now, in SQL Server 2012 we have the whole range, and extremely useful they are too. There's no longer an excuse to avoid them, particularly now you have Rob Sheldon's gentle introduction.  Read more...
By Additional Articles 2013/04/04 | Source: SimpleTalk | Category: sql server 2012
Rating:  Rate this |   Briefcase | 4,359 reads

SQL Server 2012 Integration Services - PowerShell-Based Project Deployment

You have the option of using PowerShell when automating management of SQL Server 2012 Integration Services. While this functionality is not as straightforward as those accustomed to traditional PowerShell cmdlets might expect, the steps required to accomplish the most common SSIS administrative tasks follow a relatively consistent pattern.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,813 reads

Getting Started with Extended Events in SQL Server 2012

Extended Events provide a way of unintrusively monitoring what's going on in a SQL Server instance. Unlike SQL Server Profiler and SQL Trace, it has little performance impact. Now, in SQL Server 2012 SSMS, it is relatively easy to use, as Robert Sheldon shows.  Read more...
By Additional Articles 2013/03/13 | Source: SimpleTalk | Category: extended events
Rating:  Rate this |   Briefcase | 3,179 reads

Dynamically Download FTP Files Using SSDT

Dynamically initialise FTP connection using expressions and retrieve files stored in multiple FTP directories using SQL Server Data Tools  Read more...
By Sifiso W. Ndlovu 2013/03/11 | Source: SQLServerCentral.com | Category: ftp
Rating: |  Discuss |   Briefcase | 7,851 reads

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,331 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,165 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through SP2 CU2.  Read more...
By Steve Jones 2013/04/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 12,345 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,783 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,800 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,828 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,111 reads

SQL Server 2012 Build List

A list of the builds of SQL Server 2012 through SP2 CU2.  Read more...
By Steve Jones 2013/04/18 (first published: 2012/04/17) | Source: SQLServerCentral.com | Category: sql server 2012
Rating: |  Discuss |   Briefcase | 12,345 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,728 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,833 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,498 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,349 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,590 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,574 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,302 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,297 reads
<< Newer    Items 21 to 40 of 79    Older >>