This article is part of an Essential Guide, our editor-selected collection of our best articles, videos and other content on this topic. Explore more in this guide:
2. - Trends, perspectives and advice on enhancing SQL Server skills: Read more in this section
- Expert highlights Microsoft SQL Server trends
- Ways that application developers unwittingly hurt performance
- SQL Server certification: Is it worth it?
- SQL Server Parallel Data Warehouse: Get to know the client tools
- Three hot SQL Server technologies you need to know
Explore other sections in this guide:
- 1. - Basics and benefits of SQL Server training
- 3. - Essentials for DBAs in 2014
- 4. - SQL Server Glossary
There’s something Denny Cherry wishes you knew. Three things, actually.
SearchSQLServer.com caught up with the consultant and popular blogger on a June morning between the Orlando, Fla., and Amsterdam, Netherlands, TechEd conferences. We had a chance to ask him what he’d like you to know about SQL Server and pick his brain about the hottest SQL Server trends he encountered at Microsoft TechEd.
For more SQL Server tips by Denny Cherry
Securing SQL Server data in the cloud
SQL Server tips for high availability
- ) SQL Server 2012 is out. “I’m still getting a lot of questions about when SQL Server 2012 is coming out. It’s already been released,” Cherry said. Why the confusion? He speculates it’s because some of the other new releases, including Windows Server 2012 and Digital Studio 2012, are still in beta, leading to the incorrect assumption that SQL Server 2012 was in beta, too. But that’s not the case. The new database was released to manufacturing in March.
- ) New availability features are on the way. “AlwaysOn availability groups will help with high availability as well as applications scale out. You’ll be able to run SQL Server all at once, across different boxes and machines.”
- ) PC Windowing Functions are here. “These are a big win for SQL developers,” Cherry said. These features are a great way to do aggregations on data, and they allow you to examine data more easily than you otherwise could.
We also asked Denny Cherry to share with us what he believes the hottest trends for SQL Server are. Here are the top three trends he anticipates growing in this year and next.
- ) Data analytics and bringing business intelligence (BI) into companies. “That BI was so popular at TechEd just goes to show. This will not be going away any time soon,” Cherry said. Then he added, “People are going to have to learn [data analytics and BI] quickly.”
- ) High availability features. The desire for these kinds of features is only going to grow, according to Cherry. “Companies just can’t afford any kind of downtime anymore; their apps all need to be running 24/7.”
- ) Data growth. Companies are generating more and more data, and keeping it longer and longer. In the meantime, he said, tools that allow you to manage your “big data” will grow increasingly popular.