|
|
-
|
|
Exciting news! Microsoft announced today that SQL Server 2012 has released to manufacturing (RTM). Customers and partners can download an evaluation (or here) of the product today and can expect general availability to begin on April 1.
If you’re an MSDN/TechNet subscriber, you can download it as ......
|
|
-
|
|
SQL Server 2012 contains six new features for SSRS:
Excel Renderer for Microsoft Excel 2003, 2007 & 2010 - Excel renderer will support the Excel 2007 XLSX format. To enable this feature, Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint must be installed. This extension rend......
|
|
-
|
|
Database Recovery Advisor is a new feature in SQL Server 2012 that introduces significant user experience enhancements to the ways DBAs can now restore databases using SQL Server Management Studio:
An enhancement for point in time recovery using a new visual timeline feature, which consists of a Ba......
|
|
-
|
|
Extended Events is a general event-handling system for performance monitoring that was introduced in SQL Server 2008. It has a highly scalable and highly configurable architecture that allows users to collect as much or as little information as is necessary to troubleshoot or identify a performance......
|
|
-
|
|
FileTable is a new feature in SQL Server 2012 that is built on top of SQL Server FILESTREAM technology, which allows BLOB data to be stored as individual files separate from a database’s data files. Interactions with the FileStream files took place only through T-SQL or through code which eng......
|
|
-
|
|
Version 2 of PowerPivot (download) is being made available with SQL Server 2012. There are many new features, and my top 5 are:
Diagram View – Instead of looking at the defined relationships in a list format, v2 allows you to view the relationships in a diagram. This makes it much easier to......
|
|
-
|
|
Microsoft StreamInsight, first introduced in Microsoft SQL Server 2008 R2, is a way to effectively analyze large amounts of event data streaming in from multiple sources. You can derive insights from critical information in near real-time. StreamInsight is a platform for Complex Event Processing (......
|
|
-
|
|
SQL Server 2012 has a number of new T-SQL features. Listed below are all of the new features, along with the best links I have found that describe each feature:
WITH RESULT SETS, OFFSET AND FETCH, THROW, SEQUENCE: See New T-SQL Features in SQL Server 2012 and SQL Server 2012-DENALI-whats new in T-......
|
|
-
|
|
A problem that has plagued SQL Server for a long time is that a database is not very portable. Sure, you can backup or detach a database and restore or attach it elsewhere, but when you do that, you are missing a lot of the pieces that make that database a part of an application, and a lot of those......
|
|
-
|
|
Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a knowledge base, and use that knowledge base to perform a variety of critical data quality tasks such as correction, enrichment, standardization and de-duplication of your data. DQS enables a......
|
|