SQL Server 2012 New Features and Your DBA Role

There’s a lot of exciting new features in SQL Server 2012 now. But it really boils down to what you actually do as a DBA. You will start to appreciate these new features depending on your specific DBA role.

1. Production DBA

The Production DBA is in charge of, well, the production servers. All fingers points to the production DBA if there is an unexpected shutdown in the database servers. The production DBA is also in charge of making sure that the servers are healthy and performs optimally. I sometimes fit into this role as I also assist in troubleshooting and project consultations in my current organization.

The new features in SQL Server 2012 that will excite the production DBA are

  • AlwaysOn High Availability – I was able to play around this feature in TechNet virtual lab and it was so cool!
  • Additional file-base data storage
  • Extended Events
  • improved functionality and stability in SSMS which is now fully integrated in Visual Studio 2010 – the developer DBA will also appreciate this
  • Columnstore indexes for optimization of large data volumes
  • Improved statistics algorithm for very large database
  • Improved compression and partitioning capabilities

2. Developer DBA

This is the role that I currently fit in. Its more of a one-man team or in my case, one-woman team. I belong to all project teams as I collaborate with them for their database design that they want to work on and eventually implement. I make sure that all objects are designed with optimization and performance kept in mind. I also wear the developers hat because i actually do some programming and consultation on how to address issues like when to use a table variable and temp table and which columns to place an index.

The new feature that I’m totally thankful for in SQL Server 2012 is the full integration of the development environment with Visual Studio. Now I need not have SSMS and Visual Studio open in my desktop at the same time. And i love the color blue.

Other new features that I’m excited about also are

  • Spatial functionality
  • New DAX expression language
  • New tabular model for Analysis Services

3. Business Intelligence DBA

This is the latest addition to the types of DBA role. I think its because of increased business requirements for data warehousing and reporting and the increasing capabalities of SQL Server to address these requirements. In our organization for example, we have a growing needs for dashboards and reporting sites for our business development team. To address this new requirement our Head of IT decided to hire one SSIS developer. He is an expert with reports development using SSRS and ETL packages via SSIS.

Usually, the BI DBA peeps is responsible for reports development using Reporting Services or maybe responsible for developing SSIS packages using Business Intelligence projects in Visual Studio. They are also responsible for data warehousing projects like development of Anaylsis Services cubes and deployment of these projects to pass on to the Production DBA.

The SQL Server 2012 has a lot of improvements in Reporting Services area, and a new data exploration tool such as Power View. So these following new features in the SQL Server 2012 may excite the BI DBA peeps.

  • Rapid data discovery with Power View and PowerPivot
  • Managed self services BI with BI Semantic Model
  • Data Quality Services and the Master Data Management
  • Parallel Data Warehouse and Reference Architectures

To summarize, it will help a lot if you focus on your current role and any future shift in other DBA roles to fully understand and appreciate more what the new SQL Server 2012 has to offer you and your organization.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

SHE GOES GLOBAL

Travel the world, change your life.

My Time to Travel

The travels of an old(er), solo, woman

Blog Home for MSSQLDUDE

The life of a data geek

unfoldthecreativity

Traveller Observer

The SQL Pro

(Ayman El-Ghazali - www.thesqlpro.com)

Meels on Wheels

Meels for breakfast, lunch and dinner.

juliansherman.net/

Building A Business While Having A Life

Paul Turley's SQL Server BI Blog

sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

Coding Tips

We are crazy about programming and we want to share our craziness with you!!!

SQL Studies

 Live, Learn, Share

Sql And Me

My Experiments with SQLServer

Dimitrios Kalemis

I am exactly like Jesus Christ: an atheist and anarchist against society and bad people with influence and power (judges, social workers, politicians, priests, and teachers).

Clint Huijbers' Blog

Senior Certified Microsoft BI Consultant

Blog of Many Useless Wonders

Where Uselessness Abounds!

Steve Spevack's Blog

IT Recruitment