IT/Dev Connections 2015 Online Session Recordings
The SQL Server Package
Join the best SQL experts in the industry for this training package which features the best SQL sessions of IT/Dev Connections 2015. With the hottest topics including internals, architecture, DBA, and Power BI you'll leave with a comprehensive understanding of the lastest on SQL Server. Order this package today!
Benchmarking Your SQL Server Environment
Presented by Ben DeBow and David Klee
What do you do when a user reports that “the database is slow again”? Do you run the user's queries to see how the database is working? How do you try to track down the issues your users report? Wouldn’t you like to quickly whip out some performance numbers and review the platform to see if anything is amiss? This informative session will show you how to eliminate the subjectivity in the performance of your mission-critical SQL Server systems and replace it with objective performance metrics. Benchmarks and baselines can help you quickly find any performance anomalies in the environment, plus help you project performance and capacity into the future. Tools, techniques, and scripts will be shared and demonstrated.
Hacking Into SQL Server Instances for Fun and Profit
Presented by Argenis Fernandez
In this session we'll explore several methods of hacking into SQL Server instances. Some methods assume you have Windows Administrator privileges on the box; others only require access to your physical network. We'll cover SQL injection, memory dumps, man-in-the-middle, pass-the-hash, and other attack vectors. Armed with this knowledge, you should be able to go back to your job and make a difference in your network security.
SQL Server Internals and Architecture
Presented by Kevin Kline
Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:
• What are the various areas of memory inside SQL Server?
• How are queries handled behind the scenes?
• What does SQL Server do with procedural code, such as functions, procedures, and triggers? • What happens during checkpoints? Lazy writes?
• How are I/O operations handled with regard to transaction logs and the database?
• What happens when transaction logs grow or shrink, or the database grows or shrinks?
This fast-paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information. So put on your silly hat, because we cover all these topics and more at high speed and with tongue planted firmly in cheek!"
The Efficient DBA: Automating Your Job
Presented by Jes Borland
As an operational DBA, you have many tasks to perform. You need to ensure that your databases are backed up, consistency checks are run, and performance baselines are created and monitored. How do you accomplish these tasks and still have time to help developers and end users with performance, perform upgrades and migrations, and continuously learn? Automation! In this session we'll walk through real-life examples of using tools such as maintenance plans, SQL Server Agent jobs running custom scripts, and PowerShell to automate common tasks and make you the most efficient DBA you can be.
Top 10 DBA Mistakes in SQL Server
Presented by Kevin Kline
Microsoft SQL Server is easier to administrate than any other relational database on the market. But “easier than everything else” doesn’t mean it’s easy. And it doesn’t mean that database administration on SQL Server is problem-free. Because many of us fall into the role of database administrator without professional training, we end up encountering issues that others solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again?
Diving Deeper into the Power BI Platform
Presented by Jen Underwood
In this session, we will walk through the Power BI platform components from a BI professional perspective. In addition to reviewing Power BI tools, we will also cover logical and technical architecture, data connectivity, data transfer, security and hybrid solution design patterns. Topics covered include:
• Solution architecture
• Governed self-service BI
• Configuring data sources
• Loading and preparing data
• Authoring reports and dashboards
• Using the native mobile BI apps
• Building real-time dashboards
• Integrating Power BI