SQL Server 2012 New edition and additional change in Installation

SQL Server 2012 New edition and additional change in Installation

Since couple of month I have started using the SQL server 2012 extensively and here everybody curious about that SQL server 2012 Business Intelligence Edition and what is additional point keep it in mind during Installation

Microsoft has changed the available editions with the launch of SQL Server 2012. A new Business Intelligence Edition now joins Standard and Enterprise; however if you are looking for Datacenter, Workgroup, or Web Editions, you will not find them as Microsoft has dropped them. Developer and Express Editions are still very much alive.

If you do not want the whole feature set that Enterprise Edition offers, but need to do some business intelligence gathering and processing, then this new edition may do the job. The database engine supports up to 16 cores, while SSRS and SSAS can use the maximum that your OS supports.

It am bit surprised that  columnstore indexes feture is not supported on the 2012 Business Intelligence Edition as these new indexes will bring performance gains to any data warehouse. However, if you decide on Business Intelligence Edition, you will benefit from most of the other BI features available in Enterprise Edition including Power View, PowerPivot for SharePoint Server, Data Quality Services (DQS) and Master Data Services (MDS).

Installation Future change


Once your Windows server is prepared, double-click on the setup.exe file to begin installing SQL Server. On the Planning screen, For a new installation, click on the top

link: New SQL Server stand-alone installation…This will start the setup process:

Enter your license key number or choose to run it as an evaluation On the next screen click to accept the software license terms. When you arrive at the Setup Support Rules screen, you will need to address any reported issues before proceeding.

Once you are on the Setup Support Role screen, leave the first option of SQL

Server Feature Installation checked, unless you want to change it, and click on Next.

Business Intelligence Developer Studio (BIDS) has been replaced with SQL Server Data Tools, which is used to develop reports, create packages, and build Analysis Services objects such as cubes and dimensions.

If you are installing Analysis Services, then you will get the so the screen for SSAS options appears. Choose your server mode, either Multidimensional and Data Mining Mode (your analytical objects are stored in the OLAP engine and queried using MDX) or Tabular Mode (your analytical objects are stored in the xVelocity engine and queried using DAX). If you are unsure, choose the default and if you need to run both modes, you can later install a separate instance to run in the other mode.

How are Citagus Oracle and SQL Server DBA services different from others in the Marketplace?

Citagus Software (www.citagus.com) provides world-class SQL Server consultants. All Citagus consultants exceed the highest qualifications in the industry to ensure that our clients receive world-class SQL Server support and SQL Server consulting services. With our Remote DBA services, you buy only those Remote DBA hours that you require, and only up to the level you require the service. You are guaranteed to have a certified SQL server Remote DBA constantly watching your databases.

How Citagus SQL Server Remote DBA services different from others in the Marketplace?

  • Help out to reduce Downtime and Helps Its Customers to Improve Service.
  • Supports Expansion by Boosting Speed, Control, and Savings with Microsoft SQL server
  • Reduces risk by speeding automatic failover by 100 percent
  • Accelerated data access and increased security
  • Reduces performance bottlenecks to handle higher sales volumes
  • Improves availability of a mission critical reservation system
  • Supports rapid business growth
  • SQL Server Reporting Services, Power View and AlwaysOn
  • Increased speed of ad-hoc analysis and productivity.
  • Simpler solution enables 99.999 availability
  • Rapidly provisions new virtual machines with IT control
  • Helps Customers Make Better Decisions with Higher Quality Data by Data quality services and master data services
  • With the Power View tool in SQL Server 2012 Reporting Services, our analysts have flexible, powerful data visualization tools that help them make better and faster business decisions
  • Create business solutions fast, on your terms across server and private or public cloud
  • With SQL Server running in the private cloud, we  only need a few minutes to deploy a new instance
  • Dedicated expert remote DBA teams for every client (with onsite DBAs if required)
  • Reduces workload for IT staff and information workers
  • Service delivery approach driven by ITIL/ITSM frameworks, customized to unique client environments
  • 24/7*365 round the clock high availability of Expert Senior DBA teams (most certified at the highest levels)
  • We offer innovative services, and ensure customer satisfaction. With any SQL Server version  that’s what we can do: deliver better solutions up to 50 percent faster, for less money

At Citagus, our primary objective is what we affectionately call “Clients for Life” – by this we mean that because we have served our clients so well, they keep coming back to us for their next need, or they may even stay with us in a Support mode.  Secondly, we like to tell new prospects that we are “big enough to offer quality and small enough to care”.  Our well known clients have all been with us for 4-6 years continuously and we provide a variety of our services to them.  While we work hard, we also have some fun along the way and strive to achieve balance between our personal lives and the way we work.

We look forward to hearing from you so that we may better understand your business needs in this regard.