Database Administration (DBA) Sessions
Index Impact Workload Analysis (Level 300)
Should you add an additional index or modify some existing ones? Does it make sense to drop unused indexes to improve workload performance? You have indexing questions, but finding the correct answers is difficult. In this session, you will learn a proven approach for identifying whether an index change helped or hindered performance. We will take a real SQL Server OLTP workload, establish a baseline against it, and use that baseline along with some tools to determine whether index changes should be applied to our production databases or not. After attending this session, you will be able to easily apply the same techniques to your production environment.
Flash vs. Disk vs. SSD (Level 300)
This session kicks off with a review of the differences between flash, spinning disk, and solid state drives. We will then examine the pros and cons of each kind of disk, finishing with when you want to use each kind of disk in your SQL Server database servers.
Load Testing with SQL Server Tools (Level 300)
It’s often difficult to know how your SQL Servers will perform under different loads. By performing load testing, you can gain key insights, perform modifications to existing configurations, and understand the impact on performance levels.
Come learn about the native tools at your disposal for performing these important load tests and how you can identify when performance levels begin to drop. Through demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – you will see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert you to performance degradation.
Microsoft SQL Server In-Memory OLTP Deep Dive (Level 400)
Come learn how In-Memory OLTP is integrated into SQL Server and about the architectural pillars of memory optimization, concurrency, and native compilation. In this session, we will look at how in-memory tables and stored procedures are natively compiled and how ACID is achieved without locking and latching. We will also look at memory provisioning, high availability, and the overall manageability and supportability of In-Memory OLTP.
Reading Query Plans (Level 300)
T-SQL is a declarative language. We tell SQL Server what needs to be done, not how to do it. That’s where query plans come in: They tell us how SQL Server executed our queries. And that can be very interesting. This session, based on real-world scenarios, will look at common operators, check whether they were good or bad, and examine the situations in which they were bad. You will also see how to change the plan by using indexes, statistics, and hints.
SQL as a Service (in the Private Cloud) (Level 300)
This session will share the lessons learned in the private cloud from a customer case. We will look at private cloud from the perspective of middleware as a service (for instance, SQL Server, SharePoint, etc.) and not infrastructure as a service. You will learn different implementation strategies for SQL Server high availability options and the pros and cons of each. You will also gain an understanding of the basics of System Center Virtual Machine Manager and learn how to use Service Templates to deploy and service a database application. If you plan to work on SQL Server in the private cloud, including re-usable VM deployments of SQL Server, this session is for you.
“SQL Attack(ed)” – SQL Server Under Attack (Level 300)
Although SQL Server is considered "secure by default," one of the most successfully attacked targets is the data that resides in SQL Server. Most exploited weaknesses are due to misconfiguration or weak coding practices. In this purely demo-based security session, you will see several real-life attack scenarios on different layers. Due to special request, this includes some special SQL Injection types. You will also see how an evaluation-of-privileges attack is possible because of a not-uncommon configuration, as well as an “insider-exploit” with a database root kit. Note: There will be no instructions on how to attack a system, but rather this session will highlight common weaknesses – with (almost) no slides and demos, demos, demos.
SQL Server AlwaysOn Readable Secondaries (Level 300)
Jacky van Hogen
Come learn how to configure one or more readable secondaries for SQL Server 2012 using AlwaysOn and see the (unexpected) impact of this configuration on the primary instance.
The Day After Tomorrow: Why You Need to Baseline (Level 200)
Ensuring peak SQL Server performance isn’t always easy and requires a lot of work on the part of the DBA. To maintain the best possible performance, you need to make sure you’re monitoring the right things. But how do you know if the performance numbers you’re seeing are good or bad? Baseline comparisons can help, and this session will show you how to get the most from them. You will learn what a baseline is, why and when you need to take one, and how to create one using native Windows and SQL Server tools.
Why Is SQL Server Slow Right Now? (Level 300)
You need a fast, easy way to troubleshoot temporary slowdowns on SQL Server 2005, 2008, and 2012. Before you open Task Manager or run sp_who2, join this session for a simple script to rapidly identify common culprits such as blocking queries, long-running jobs, and CPU spikes. You've used sp_Blitz to find out general problems with the SQL Server and you know it's not perfect, but why is it unusually slow RIGHT NOW? Let's tackle it together. When you get back to the office, you'll have:
• An easy-to-use script to find bottlenecks fast
• Instructions on how to let anybody run it without being SA
• Fewer help desk tickets and phone calls pestering you