Sessions & Content

Tags
Content Type
Search
Conference
Apache Cassandra for the SQLServer DBA
A tour of Cassandra, a popular NoSQL DBMS
Creating complex labs from start to finish with Lability
Introduction on how to use the Powershell library Lability to create complex SQL Server based test labs.
Data Science For The DBA – Get Started Now
If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you an end-to-end Data Science project covering the core technologies in Microsoft Data + AI stack.
DevOPS for DBAs-Where is your magic wand?
DEVOPS - a buzzword in IT and how beneficial it is to include within your DBA activities
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers
Kick Start! SQL Server 2016/2017 Performance Tips and Tricks
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.
Run your DBA morning checklist with Policy Based Management
In this session you will learn how you can perform your DBA morning checklist with Policy Based Management to evaluate your servers and how I configured my setup.
The Microsoft Engineer's performance tuning toolbox
In this demo-only session, you will learn how Premier Field Engineers at Microsoft troubleshoot performance problems and what tool and scripts they use. We will take a look at tools and scripts like SQLDiag, SQLNexus, PAL, and BPCheck.
VLDBs: Lessons Learned
Maintaining very large databases (VLDBs) can involve a lot more creativity and bending of the rules than their smaller brethren. Attend this session to learn tips and tricks amassed from years of managing them.
Powershell community scripts for DBAs
We will take a look into my favourite Powershell scripts
SQL Server Internals and Configuration for R
Learn how to configure SQL Server 2016 for running R. The individual components and executables installed with R on SQL Server will be explored to understand the internal interactions and processes involved.
AD 2015. 2AM A Disaster just Began
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW?
An End-to-End Troubleshooting Checklist for SQL Server
Microsoft ships a multitude of tools to help detect, diagnose and resolve problems inside of SQL Server. But which is best to use and when? This session teaches attendees how to tackle the troubleshooting process to achieve repeated, optimal results.
BI DBA Performance Tuning
Understanding how SQL Server performance tuning works is not just a job for DBA's. It is important for BI professionals to understand as well
Daily problems with indexing and its-possible-solution
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution
Easy Performance Tuning: an Intro to Wait Statistics
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
Hadoop Primer for SQL Server DBA
Big Data is here to stay, no doubt about that. And Hadoop is THE framework for Big Data. But what is Hadoop? Is it a friend or foe for SQL Server DBA? Let’s explore what Hadoop is and how to make it work together with SQL Server.
Headache guaranteed: Deadlocking in SQL Server!
SQL Server needs its locking mechanism to provide the isolation aspect of transactions. As a side-affect your workload can run into deadlock situations - headache for you as a DBA is guaranteed!
ORM Tuning From A Database Perspective
Most ORM's tend to be very chatty and generate complex queries. In this session we will look at optimizing database access in ORM's. Using Nhibernate, LINQ &Entity Framework in the demos, we will examine how your ORM talks to the database and why.
Succeeding as a Remote Worker
With over 15 years of experience as a semi-remote Lead DBA for a medical system, running a consultancy firm, producing SQL Cruise events and balancing a personal life Tim Ford has a pocketful of tips to share in making "remote" work for you.
Understanding SQL Database Elastic Scale for the DBA
This session will look at SQL Database Elastic Scale through the important lens of the DBA, focusing on the critical aspects of database performance, maintenance, and management without adding unnecessary complexity.
Do's and don'ts of database corruption
In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.
Hadoop: Big Data or Big Deal?
Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
Integration Services (SSIS) for the DBA
In this session, you will learn what SSIS is, what components it consists of, and how to use the SSIS catalog to track the execution of packages and how to troubleshoot packages.
Monitoring Databases in a Virtual Environment
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
<<123>>