May Question: How soon will you begin implementing SQL Server 2012?
Question of the Month | May 1, 2012 | 1:14 pmNow that SQL Server 2012 has been released, this month’s question is “How soon will you begin implementing SQL Server 2012?” If you have done so already, share with us your experience. If you will be waiting to implement 2012, tell us why.
Post your responses to the SQL Server Question of the Month in the comments section below (at www.bradmcgehee.com if you are viewing this from a syndicated newsfeed). And don’t forget to enter your e-mail address when you post your response, so I can contact you if you win.
Because there is no right or wrong answer, this month’s winner will be selected randomly from all the entries that are received.
|
This Month’s Prizes
|
The prizes this month are an Amazon.com voucher worth US $50.00 and a license for SQL Virtual Restore with one year of support and upgrades. SQL Virtual Restore lets you mount your backups as live, fully functional databases – save space and time compared to a physical restore. Find out how. |
- April Question: Which high availability option(s) do you employ for SQL Server instances, and why did you choose them?
- SQL Server 2012 Certifications Revamped
- October Question: Tell us about your favorite experience as a participant in the SQL Server community.
- When Will You Upgrade to SQL Server 2012?
- Have You Planned Which SQL Server Events You Will be Attending in 2012?
RSS
Twitter
Linked In
we have sa licensing, so hoping to upgrade for the new bi tools (power view, ssas new tools) and always on.. just got a box sorted with sys team to start playing
We don’t have any plans to upgrade at this time. We’re still running a critical database on SQL 2005 in compatability level 7 so that would need to be fixed first. But I’d love to take advantage of some of the new features. I’m especially curious to see how a filetable structure would work for document storage.
We’re planning to go in production with one of our applications in August. This application sadly doesn’t support the use of read-only secondaries yet, but hopefully the vendor will add support before we go in production. This so we can offload the operational reporting workload more easily.
I’m also doing some personal tabular+power view development and depending on the results i’m able to produce this might get in production before summer.
My current client is using SSAS Tabular Model for their pilot Data Warehouse project with Excel front end to start with. The prototype has been built and we are in the final process of data reconciliation prior to launch. There will be more and more Tabular models built and with Power View in the upcoming months. The beauty of this is that it’s easier and quicker to build (compared to Multidimensional), and suitable for our reportig needs. Having said that, we are not ignoring the Multidimensional model option at all.
On the other hand, there are existing SQL Server source databases that are in SQL Server 2005 but we are looking at upgrading very soon. We’re not 100% confident to migrate existing SQL Server 2005 databases to SQL Server 2012 yet. We are investigating this now.
I am keen to hear back from others in regards to their experience with SQL Server 2005 to SQL Server 2012 upgrade path.
Our client is the NHS (UK health service) which is cash strapped in the current economy.
I’ll start learning new functionality in my own time, but implementing SQL 2012 live will sadly be a long way off.
R
as we are JUST now getting our SQL 2000 boxes migrated over to 2005, it most likely will be a while.
We are looking at the new features of 2012, however we’ve no plans to upgrade our environment soon. We just got done with an 2008R2 upgrade 5 months ago.
We have a couple of planned deployments later in the year with SQL 2012. Looking forward to using some of the new tools.
No sooner than 2015 – now migrating to 2008 R2. Corporate standards are the driver.
Surprisingly (to me at least) my company is looking at adopting 2012 this year to take advantage of the BI Tools. We are also excited to use columnstore index for our data warehouse development.
We’ve only just upgraded to 2008R2. That took about 12 months once we finally committed to upgrading, and that followed a period of about 6 months familiarising/working with 2008 in training environments. We still have a couple of databases running with 2000 compatibility level.
When we need another server then 2012 might be considered, far more likely to keep everything on 2008R2 though. We won’t start thinking about 2012 until late next year at the earliest.
Are CPU licences being replaced by number of cores too? That will play a big factor in our schedule!
I’m downloading it now, I will learn SQLServer 2012 new features .
And hopefully the new features will justified me to upgrade my software database (SQLServer 2008 R2).
We have SQL Server 2008 environment at the moment.
I’m still learning about the new features of the new 2012 version.
If I’ll find anything that will really justify fast upgrading, then we’ll definitly think about it (however – only after the release of SP1).
But I won’t find anything in perticular, then I would wait a little more.
I recently upgraded a client from 2005 to 2008 R2 for testing, when done we decided to upgrade it to SQL 2012 to see what would happen, and it went well. Great product.
Chris.
Most likely we are going to do the upgrade in a couple of years or so. Since we are using the database to support a vendor application, we would need vendor approval and also we would need to do our internal testing to do the upgrade.
Right now I’m in evaluating stage. Maybe, we will be implementing it in next two months.
Ravi.
I will install on some test servers and start exploring over the next few months. First Production upgrade will probably Datawarehouse / SSRS before the end of the year and then hopefully SharePoint.
We have SQL Server 2012 Installed now on test machines.
We are on our way to test the performance of ColumnStore Indexes on one of our scenarios for advance search.
Power View is the next thing we will be using, with probably data from Cubes in SSAS being fed data from HIVE queries over Hadoop on Azure.
Not soon enough…
We upgraded Sharepoint to include 2012 PowerPivot. Likely we will experiment for awhile, since we already have a robust cube on 2008 R2. Security changes are one question. From what we have seen, some things may run faster, and some might need some re-architecting. Being up and running on the platform we are on, with a rather mature datawarehouse, leaves us with time to explore the new features.
Running multiple products on separate servers gives us more flexibility than some others might have.
Greg
I work in the Health Care industry and we tend to stick with what works! Like we still have 12 SQL 2000 that I’m pushing to get rid of! So when are we going to implement SQL 2012 … Not soon! I’m guessing in 2014!
We haven’t even started evaluating yet. So implementation won’t be this year. Probably 2013.
We had already started to spin up 2 environments for SSAS & SSDS. We are very much close in moving up our sharepoint 2007 to sharepoint 2010, so we cuddling together next week, to decide whether to push it to sql 2012 or 2008 r2.
We have no current plans to implement 2012
We currently work with SQL Server 2005 and 2008 and have an application on a client with SQL Server 2012. Still no migration plans but we carefully the great changes in the new version.
After SQL 2012 SP1 has been released.
We are letting our applications drive the upgrades unless we get in a non-supported situation. Any new applications we will strive to push them to 2012. We have no current plans to push the upgrade at this time.
In the process of migrating data from one environment to a different another. The existing setup is on 2k8 other legacy DB’s. Not sure of 2k12 implementation. Let see if we can create some opportunity for 2k12. It would be interesting indeed..
No plans at this time. I’ll probably setup a test box in late summer.
We are doing a proof of concept. If all goes well within 6months we will be deploying.
As far as I am aware, one of our customers is planning to upgrade to SQL Server very soon (in the next few months). I strongly believe that its the Columnstore index that made their minds toward this decision as they have a lot of VLDBs, which are all used in their datawarehouse environment, where terabytes of data per db is considered normal. However, I will not participate in the upgrade projecct and that makes me said.
We just finished upgrading to SQL 2008 R2. Budget restrictions & application support drive our SQL upgrade plans. We have no future plans to upgrade to SQL 2012 at the present time. Maybe in a couple years…
We are currently building out several SQL 2012 AlwaysOn clusters which will be put into production next month. Very excited to use some new features such as read-only replicas which will be used for SharePoint FAST Search crawling. Earlier this month we utilized the SharePoint BI features for a client using the SQL 2012 PowerView and PowerPivot tools. So far the user reviews have been nothing short of great.
Our plan at this time is to start implementing 2012 in September, starting with the BI / Data Warehouse group. We’ll start phasing in the rest of our instances beginning January 2013, but aside from our BI group and another highly customized package, many vendor apps will dictate how soon we can move others.
We have no current plans to implement 2012 this year.
We were involved in the SQL 2012 TAP program, and found very few issues running our existing workload on SQL 2012. SQL 2008 R2 to SQL 2012 was virtually pain free. Our big job this year is to move all our server estate to AWS which will include standardising on SQL 2012, and next year exploiting the new features.
We are currently completing upgrade to SQL Server 2008 R2. There are no plans to upgrade to SQL Server 2012. I think we may start using it in 2 years the earliest.
Just finishing up on our upgrade to SQL 2008, but have one server running 2012 for testing and ad-hoc use.
As soon as the Budget allows, 2013, hopefully we can push the business case forward to this year.
Thanks for everyone who participated in this month’s question. The randomly selected winner is Pam Wampler. Be sure to enter the June Question of the month, as you might become next month’s winner.