In this session, you'll gain invaluable guidance for optimizing your backup strategies. Using trace flags the session will cover how SQL Server manages its own backup options and how you can tune them to meet your SLAs.
So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it. I've got some of the answers here in this session for you.
Has your SQL Server or Databases been taken over by a malevolent force?
Worry not, for we shall open the pages of The Necronomicon, SQL Server Book of the Dead, and through its Ancient scripture and verse resurrect them back to life.
This session will focus on 5 great hybrid cloud features available in SQL Server 2014 that show how you can use these features to lower your TCO and leverage the cloud to provide new disaster recovery and backup solutions.
Organizations risk being overwhelmed by data. How can you effectively provide a “single version of the truth”, while unlocking the key trends and insights that will allow your business to succeed? Come to this session to find out how.
In this session, I will demonstrate, step-by-step, the entire process of restoring all of the system and user databases from a damaged instance to a new instance.
If you’ve only ever chosen to use Microsoft database products then there’s a chance you might hide a curiosity deep down about the Oracle database platform; or like me a few years ago be told that your next big production system will use it and now’s the time to upskill. This session introduces some key concepts and differences about the Oracle database platform to people like myself who are used to the UI-heavy Windows-based database world and hopefully make you curious enough to want to at least give it a try when you get back home.
Increase the "out of the box" performance and throughput of SQL Server.
The new compression features built into the Enterprise Edition of SQL Server 2008 should use less disk space and, perhaps even more important, speed up your system because of reduced disk IO.
In this session we will :
Take a look behind the scenes to see how it works.
Investigate what commands / tools we can use to set it up and maintain it.
Look into some examples of my own day to day experience that I collected so far.
I aim to give an overview of both data compression and backup compression AND some Lessons Learned.