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.
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.
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.