Facebook Twitter LinkedIn YouTube E-mail
Home Microsoft Archive for category "SQL Server 2012" (Page 4)
formats

SQL Server 2012 Certification Paths

Share

As you may have heard, there is a new road map for SQL Server professionals to gain certification in SQL Server’s latest version—SQL Server 2012. I have categorized the information below by certification level: If you are a new exam-taker, you can follow “Table 1.” Level Certificate Title Exam Title Training Exam Associate Level Microsoft certified Solutions

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on SQL Server 2012 Certification Paths  comments 
formats

Segregating Monster Queries with SQL Server Resource Governor

Share

Overview To be honest, Resource Governor is one of my favorite features in SQL Server. This feature was introduced in SQL Server 2008 and was further enhanced in SQL Server 2012. Right now, it is quite stable and practical; however, the bitter reality is that not many DBAs embrace this amazing feature. As a consultant,

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Segregating Monster Queries with SQL Server Resource Governor  comments 
formats

Runtime Debugging Using Data Taps in SSIS 2012

Share

One of the cool features introduced in SQL Server Integration Services that adds real value add for the developers are Data Taps. Data taps provides a method of debugging packages programmatically during runtime. One of the greatest strengths of Integration Services is the availability of good debugging features thanks to Visual Studio’s feature rich Integrated

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Runtime Debugging Using Data Taps in SSIS 2012  comments 
formats

Introduction to a SQL Server 2012 “ColumnStore” Index (Part II)

Share

Overview In Part I, I introduced the new index structure in a SQL Server 2012 “ColumnStore” index, examined the storage mechanism, and illustrated how this index helped us to boost the query performance in a data warehouse. (http://blog.gnetgroup.com/bi/2012/10/22/introduction-to-sql-server-2012-columnstore-index-part-i/)  Today, some related topics will be covered, including considerations in loading data into the “ColumnStore” index-enabled table,

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Introduction to a SQL Server 2012 “ColumnStore” Index (Part II)  comments 
formats

Synchronizing Data Between On-Premise and Cloud Databases

Share

With Azure products gaining popularity, it’s a common scenario these days to find a part of data being held in the cloud (Windows Azure database) environment. This makes it essential to keep the reference data synchronized between on-premise as well as cloud databases. This post will provide you with couple of ways in which you

(More)…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
Comments Off on Synchronizing Data Between On-Premise and Cloud Databases  comments