May 7, 2013 at 7:35 am
I'm asking this question for two reasons:
1. I'm just plain curious.
2. I'm hoping this will help me make the business case for an upgrade from SQL 2008.
Question: Regarding SSIS, SSRS, and SSAS what are you favorite new features you have enjoyed the most or found the most helpful in SQL Server 2012 that you consider worthy to have over SQL Server 2008?
Thank You all in advanced.
JamesNT
May 7, 2013 at 7:46 am
Using google with your exact subject returned this as the top hit.
http://msdn.microsoft.com/en-us/library/bb500435.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 7, 2013 at 8:05 am
Sean,
Thanks for the article. But I'm asking for YOUR opinion on what has helped YOU the most.
JamesNT
May 7, 2013 at 8:36 am
It very much depends on your business, but I can give you a few things I've seen people use.
1. AlwaysOn Availability Groups - Get some HA and offload reporting in a scale out way to other servers. Not cheap, but it can work.
2. Window functions - Can dramatically speed up some queries, but also reduce development time if you use these.
May 8, 2013 at 5:46 am
All the enhancements around extended events are pretty excellent. I'm also enamored of the distributed replay mechanism (although I wish it worked with extended events too). Availability Groups are extremely awesome. Mirroring finally done right.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 8, 2013 at 8:55 am
AlwaysOn Avail Groups is a great feature, but I am looking forward to a day when it will be possible to sync logins, linked servers, operators, jobs, sp_configure settings and other "server" settings between replicas without having to rely on home-grown solutions.
We are not there yet...
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]
May 13, 2013 at 12:00 pm
Thank you all for you input.
JamesNT
May 14, 2013 at 3:35 am
Steve Jones - SSC Editor (5/7/2013)
It very much depends on your business, but I can give you a few things I've seen people use.1. AlwaysOn Availability Groups - Get some HA and offload reporting in a scale out way to other servers. Not cheap, but it can work.
2. Window functions - Can dramatically speed up some queries, but also reduce development time if you use these.
From my business perspective:
1. Upgraded SSIS. Easier development and deployment. Much more mature product now.
2. Power View. Definately. One of the more "sexy" things you can show management for persuading them to buy SQL Server 2012.
3. Columnstore indexes. Huge performance improvements in data warehouse scenarios.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply