Today Quentin Clark announced SQL Server 2014 CTP2 is now available. It’s both available for public download and it’s the final CTP before going RTM.
Now, I don’t know about the rest of you but my favorite feature of 2014 so far is Hekaton. I’ve been a prod DBA for many years and speeding up OLTP is a big love of mine. So anyway, we got a really nice demo of Hekaton and columnstore and how they can update app data in a fraction of the time they could before.
You can also now backup sql DBs to azure storage. Of course, I doubt it really has to be azure, because the backup flag is ‘to URL’ instead of ‘to DISK’, so I would imagine it’s any internet addr. I haven’t verified that though.
They also introduce managed backups where they’ll backup the DB once they’ve determined that it’s changed enough. This can be helpful for small shops who don’t want to have to think about backups, and who don’t have highly changing data.
As well, SQL finally can encrypt backups and they do it in all versions.
There’s also a feature pack you can download for SQL2K8 that lets you backup those DBs to azure as well.
The best database career advice you’ve never heard!
Become a DBA. Become a BETTER DBA. Use the Roadmap.
The DBA Roadmap Seminar is 7 MP3 tracks (over 5 hours!) of insider guidance on your database career. We'll teach you how and what to study as a DBA, weigh in on controversial resume debates, teach you to recognize a worthy recruiter, and discuss the new professionalism of interviews. Also some bonus materials, PDF companion guides, and really spiffy intro music!
Once your $99 PayPal payment is submitted, you'll get the download link in e-mail! (Download is a 370Mb ZIP file.)
Visit www.DBARoadmap.com for info, forums, and more!
TagsArchitecture blunders Camtasia Career Coding Standards CPU data generator DBA Development disaster firewall Idiots Inside SQL Server Interview ITBookworm Jobs Kalen Delaney Katmai Ken Henderson LiteSpeed MidnightDBA PASS Summit 2011 Pinnacle politics Powershell Powershell Hero Query techniques Red-Gate reporting restore SQL Express 1433 SCM SQL Server SQLServerDVD.com SSIS SSRS Training troubleshooting TSQL Tuesday tuning Tutorials Video post videos Yukon
Interview: Kalen Delaney!
Need help? Got an emergency? Write us at Support@MidnightDBA.com!
We can schedule time to help with your backup/restore issues, high availability and disaster recovery setup, performance problems, and a great deal more. Very often, we're even available on the moment for downtime issues and emergencies.
- Guest Review: Microsoft Wireless Sculpt Ergonomic Keyboard
- Quick Review: Anker Vertical Ergonomic Optical USB Wired Mouse
- Reading: Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan
- Repost: “Problems with my new book” by Grant Fritchey
- Announcing SQL Server 2012 Query Performance Tuning by Grant Fritchey