Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2012 New Features Expand / Collapse
Author
Message
Posted Tuesday, May 7, 2013 7:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 6:53 PM
Points: 19, Visits: 89
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
Post #1450137
Posted Tuesday, May 7, 2013 7:46 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:47 AM
Points: 13,110, Visits: 11,940
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1450146
Posted Tuesday, May 7, 2013 8:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 6:53 PM
Points: 19, Visits: 89
Sean,

Thanks for the article. But I'm asking for YOUR opinion on what has helped YOU the most.

JamesNT
Post #1450157
Posted Tuesday, May 7, 2013 8:36 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:24 AM
Points: 33,088, Visits: 15,197
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1450190
Posted Wednesday, May 8, 2013 5:46 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 11:13 AM
Points: 15,527, Visits: 27,909
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1450509
Posted Wednesday, May 8, 2013 8:55 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 8:53 AM
Points: 1,861, Visits: 3,599
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...


__________________________________________________________________________________

Turbocharge Your Database Maintenance With Service Broker: Part 2
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1450627
Posted Monday, May 13, 2013 12:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 6:53 PM
Points: 19, Visits: 89
Thank you all for you input.

JamesNT
Post #1452256
Posted Tuesday, May 14, 2013 3:35 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:32 AM
Points: 13,310, Visits: 10,175
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1452454
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse