Microsoft SQL Server 2012 Best Practices Analyzer is a diagnostic tool that gathers information about all the SQL Server 2012 components installed on the system and determines if the configurations are setup according to the recommended best practices.
It indicates potential problems with the SQL Server installation and recommends a solution.
You can download the tool from here
The pre-requisites are:
Supported operating systems: Windows 7, Windows Server 2008, Windows Server 2008 R2
The following are required for using SQL Server 2012 Best Practices Analyzer (BPA):
Microsoft Baseline Configuration Analyzer V2.0
I tried installing BPA on my Windows 2008R2 development environment and it prompted me with this message: “Microsoft Baseline Configuration Analyzer 2.0 is not installed….”
So, I went ahead and installed the Baseline Configuration Analyzer 2.0
After that the BPA setup completed with no problem:
Here is a real quick video of SQL Server BPA in action:
Start by launching the Master Data Services Configuration Manager:
Start by Creating a Database:
Connect to the SQL Server and Provide a Database Name:
Provide an Administrator Account and click Next:
On Success, you should see the configuration page with default properties as seen below:
Now let’s configure the Web Component:
This will prompt you to create an application:
Go ahead and create an application:
Next we will associate the web application with the database:
Uh Oh! hit a wall – need to research this issue.
HTTP Error 500.19 - Internal Server Error
The requested page cannot be accessed because the related configuration data for the page is invalid.
Wondering what am I missing? Anybody?
With SQL Server 2012, there are two types of Analysis Services projects in Business Intelligence Development Studio (BIDS). You can create and edit the multidimensional projects that you all know and love. You can also use BIDS to create tabular projects.
Check out these additional resources on Tabular Models:
- Download and launch the Web Installer
- Select the labs, demos and presentations that you want to download
- Install prerequisites (optional)
- When the download process completes, browse to the folder(s) where you installed the content
So Earlier today I installed it and here is my experience:
For some of the downloads, the web installer will open the web browser and let you download PowerPivot for Excel 2010, AdventureWorks database for SQL 2012 etc. So its good to know upfront that the installation is not all self contained, you may have to download and install some items outside the web installer. See below for an example.
Try Hands on with Power View without installing a thing: