Category Archives: Tech Videos

SQL Server 2012 – Data Quality Services (DQS) – Learning Resources

SQL Server 2012 – High Availability Enhancements – Learning Resources
SQL Server 2012 – Database Engine Enhancements – Learning Resources
SQL Server 2012 – Transact-SQL Enhancements – Learning Resources
SQL Server 2012 – Data Quality Services (DQS) – Learning Resources
SQL Server 2012 – Integration Services (SSIS) Enhancements – Learning Resources
SQL Server 2012 – Analysis Services (SSAS) Enhancements – Learning Resources
SQL Server 2012 – Reporting Services (SSRS) Enhancements – Learning Resources
SQL Server 2012 – Power View – A New Self Service BI Tool – Learning Resources
SQL Server 2012 – PowerPivot – Enhanced Self Service BI Tool – Learning Resources
SQL Server 2012 – SQL Server Management Studio (SSMS) Enhancements – Learning Resources
SQL Server 2012 – SQL Server Data Tools (SSDT) – A New IDE – Learning Resources
SQL Server 2012 – Other Features & Enhancements – Learning Resources


Data Quality Services (DQS) is a new feature introduced in SQL Server 2012 (code-named “Denali”). This feature helps organizations to improve the quality of existing data and to maintain the quality of existing and incoming data.

Following are the links, references, White Papers, E-Books, and Videos etc. for learning Data Quality Services (DQS).

Articles/FAQs/Case Studies

Blogs/Sites/Forums

Virtual Labs

Videos

White Papers/Guides

That is all about Data Quality Services for now. Let me know your feedback/comments. Also, if you feel there is any other useful links related to DQS, please share that in the comments section below and I will add it to the above list.

Stay tuned to my blog for more updates, links, and references on SQL Server 2012’s Latest and Greatest Features. Also, you can subscribe to receive new posts via email using the Subscription Section (on the right side).

Advertisements

SQL Server 2012 – High Availability Enhancements – Learning Resources

SQL Server 2012 – High Availability Enhancements – Learning Resources
SQL Server 2012 – Database Engine Enhancements – Learning Resources
SQL Server 2012 – Transact-SQL Enhancements – Learning Resources
SQL Server 2012 – Data Quality Services (DQS) – Learning Resources
SQL Server 2012 – Integration Services (SSIS) Enhancements – Learning Resources
SQL Server 2012 – Analysis Services (SSAS) Enhancements – Learning Resources
SQL Server 2012 – Reporting Services (SSRS) Enhancements – Learning Resources
SQL Server 2012 – Power View – A New Self Service BI Tool – Learning Resources
SQL Server 2012 – PowerPivot – Enhanced Self Service BI Tool – Learning Resources
SQL Server 2012 – SQL Server Management Studio (SSMS) Enhancements – Learning Resources
SQL Server 2012 – SQL Server Data Tools (SSDT) – A New IDE – Learning Resources
SQL Server 2012 – Other Features & Enhancements – Learning Resources


SQL Server 2012 (code-named “Denali”) has introduced some major enhancements to improve the Availability of SQL Server and ensure High Availability all the time.

Following are the High Availability Enhancements in SQL Server 2012:

  • AlwaysOn Failover Cluster Instances
  • AlwaysOn Availability Groups
  • Online Operations

AlwaysOn Failover Cluster Instances

This feature enhances the existing SQL Server Failover Clustering feature with advanced capabilities like Failover across Data Centers and lot more.

AlwaysOn Availability Groups

This feature goes on to extend and enhance the feature of SQL Server Database Mirroring to ensure High Availability of the User/Application Databases. This feature allows Failover at a database level thereby allowing us to Failover a set of databases together as against the previous approach of Failover on a Server.

Online Operations

Some of the operations which previously used to be allowed only in offline mode, are not allowed in online mode thereby increasing the availability of SQL Server. This includes the following two features:

High Availability – Additional Learning Resources

Articles/FAQs/Case Studies

Virtual Labs

Videos

White Papers/Guides

Free E-Book on "Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery"

If you know of any other resources that will make a good addition to the above list, please do let me know in the comments section below and I will be happy to add it to the above list 🙂

That is all for now. Stay tuned for more updates, links, and references on SQL Server 2012’s Latest and Greatest Features.

SQL Server 2012 – Transact-SQL Enhancements – Learning Resources


Last week I delivered a session on T-SQL Enhancements in SQL Server 2012 (code-named “Denali”). 40+ people attended the session and the response was awesome. One of the asks during the session was to share some links and references on the new and enhanced features. Hence I thought of putting together links to some of the best resources that I have found so far on the web.

Here is a list of New and Enhanced Transact-SQL Enhancements in SQL Server 2012.

New Features

OFFSET AND FETCH

SEQUENCES

WITH RESULT SETS

THROW Statement

FORCESCAN

Functions

Conversion Functions

PARSE

TRY_PARSE

TRY_CONVERT

Date and Time Functions

Logical Functions

CHOOSE

IIF

CHOOSE and IIF Logical Functions:

String Functions

CONCAT

FORMAT

CONCAT and FORMAT String Functions:

Analytical Functions

Enhanced Features

OVER Clause

FORCESEEK

In addition to the links to various articles/blogs, here are few additional resources – Virtual Labs and Videos.

Virtual Labs

Videos

E-Book (Free)

That is all for now. Hope you find this article useful. Please do share your feedback.

If you find any other articles, which you think can be a good addition to the above list, please share the link in the comments section below and I will add it to this article. Until we meet next time, happy learning 🙂