LogParser is a free data application that anyone working with SQL Server should know about, come along and see how you could use it.
Well, I'm a DBA and one of my duties is to check that all SQL Server stuff are in the right place. It's a routine job, but, probably, the most important duty as DBA because it can help me to predict many important problems.
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.
Generalize your skills so you can specialize on SQL Server.
These two technologies can make a very big – and very bad – difference in how your SQL Server performs. Wouldn’t it be great if you could get the real, honest lowdown from a virtualization administrator, a SAN administrator, and a DBA? Wouldn’t it be even better if one person had done all three, and could give you the pros and cons of each point of view? That person is Brent Ozar, a Microsoft Certified Master who’s been there and done that.
Learn all about Optimistic Concurrency and how it works under the hood in this one hour session.
SQL Server upgrade is no easy job, as DBA must go through upgrade methodology with options and considerations. Take help of freely available Upgrade tools from Microsoft and plan your database upgrade with a coverage of
Pre-upgrade tasks, during upgrade and Post upgrade tasks.