It's 2AM and Disaster just began... In this session I want to discuss about best practices for surviving disaster, based on my experience in few years in data center. I presented this session as Lightning Talks in Liverpool. Now is the time for full
In this session we shall demonstrate configuration, installation and administration of SQL Server 2012 on Server 2008R2 Core. We shall discuss Command line and PowerShell configuration, Installation of SQL, Remote Administration and Clustering.
Microsoft SQL Server is one of the easiest database to setup and administrate. But that doesn't mean it's problem free. Find out the most common DBA mistakes on SQL Server so that you can make sure not to make them!
LogParser is a free data application that anyone working with SQL Server should know about, come along and see how you could use it.
I'll explain how to manage a large environment of 400+ instances in such a way that it's also useful if you have only 5 instances. Expect 50% processes and war stories and 50% demos and scripts (lots of PowerShell of course, but not everything)
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.
Tools and utilities are very useful for any data platform deployment, management, and administration. This session demonstrates native tools and techniques along with world class third party tools from IDERA that can make your long days shorter and m
PowerPivot can be a great troubleshooting / performance tuning tool for a dba besides just loading all the data in a database and start querying. I'll show the pro's and cons of PowerPivot while trying work with waitstats, profiler data etc.
Brad McGehee, Red Gate's Director of DBA Education, will share his experience of monitoring SQLServerCentral's DB performance what he found, how he did it using SQL Monitor, and how they were fixed. Following that Brian Harris will demo SQL Monitor.
In this session I’ll show you how to maintain security and development rigour whilst allowing the developers to use ORM tools.
Dan Cardno, Idera's Senior Sales Engineer, will focus on the suite of SQL Performance solutions offered by Idera and how they can help anyone tasked with the responsibility of administering SQL server databases.
I had to import and process 100+ files for my latest project and wondered if there was a way to generate SSIS packages based on a repository table containing the rules. As it turns out, this can be done but the programming model is a bit awkward.
The samples that you can find online are not allways functional and debugging is difficult. I did get it to work though and will show you how I did it and what problems I ran into.
After this session you will know how to generate packages that contain sources, destinations, cached lookups, derived columns, conditional splits, sorts, union all, etc.
This session is not about the script component inside SSIS but about generating SSIS packages and programmatically reading and changing properties of existing packages.This session should also be usefull if you're not a full blown developer but more of a DBA type. I'm a DBA and I got through this :-)
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.
A typical day of DBA and new features of SQL Server 2008 can help - save a minute.
Learn all about Optimistic Concurrency and how it works under the hood in this one hour session.
In this session we will cover 3 new enhancements to the Database Engine. Application and Multi-Server Management introduces new capabilities for managing, monitoring and exploiting your SQL Server Infrastructure through the new SQL Server Control Point and enhancements to SSMS and Policy Based Management and Data-tier application packages. SQL Connection Plans allow you to logically refer to an application in connection strings rather than servers making migration of database applications across your SQL Server infrastructure much easier. Unicode compression in R2 enhances the native data compression capabilities introduced in SQL 2008 for Unicode data using SCSU (Simple Compression Scheme for Unicode Data)
Database availability is important to every DBA and selecting the right solution to satisfy availability requirements can be a difficult choice. Attendees will be presented with an overview of each technology and complementary technologies enabling them to make better choices of availability solution.
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.