|
|
-
|
|
As a follow-up to my posts SQL Server “Denali”: New Certifications and SQL Server 2012: New Certifications, there are now final details coming out about the SQL Server 2012 certifications. The major news:
Two new Professional-level certifications will be...
|
|
-
|
|
In SQL Server 2012, there is a new data model, called tabular, that is part of the new feature called the Business Intelligence Semantic Model (BISM). BISM also includes the multidimensional model (formally called the UDM).
The Tabular model is based on concepts like tables and relationships that ......
|
|
-
|
|
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes
As a followup to a question from the presentation about clustering the appliances, I have found that Dell offers......
|
|
-
|
|
What is the best methodology to use when creating a data warehouse? Well, first off, let’s discuss some of the reasons why you would want to use a data warehouse and not just use your operational system:
You need to integrate many different sources of data in near real-time. This will all......
|
|
-
|
|
Power View is installed when you run the SQL Server 2012 install and on the Feature Selection page choose “Reporting Services Add-in for SharePoint Products”. This is a newer version of the add-in that is installed with SharePoint 2010, with one of the new features being Power View.
Th......
|
|
-
|
|
In SQL Server 2008, if you wanted to run Reporting Services in SharePoint integrated mode, these where the steps you took (see How to: Install and Configure SharePoint Integration on a Stand-alone Server):
Install SQL Server 2008 and on the on the Feature Selection page select the Database Engine......
|
|
-
|
|
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......
|
|