to search by track, speaker, or session category.
Sessions Found: 25
A Database Designer's Favorite Features in SQL Server: Security, Privacy, and More
With the perfect storm of new compliance legislation and greater coverage of data breaches, data...
Analysis Services is in Azure? Seriously!? Let's build a model!
Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in...
Building measures in Power BI (and SQL Server Analysis Services tabular models)
In this sessions, we will create measures using the DAX language to support more sophisticated data...
Continuously deploying SQL code using Powershell
Discover a way of deploying your SQL code in a reliable and repeatable manner by using Powershell...
Database Corruption - Advanced Recovery Techniques
Being able to monitor, diagnose and recover from Database Corruption is a critical skill for any...
DBA Checklists: Reliable, Repeatable, & Automated.
Now that SQL Server loves PowerShell and Microsoft loves open source, it is even easier to automate...
dbatools 1.0 - Updated and ready for Production use.
The open source DBA Tools module from DBATools.IO was first released to PowerShell gallery on May...
Get Your Optimizer to Give up All Its Secrets
You know that execution plans can provide you with vital information to tune a query, but just how...
GITHB 101 - An introduction to using Github and Git for Source Control and Open Source Projects
In the last few years the requirement to understand and use distributed Source control systems has...
Introduction to Azure AI - The Art of the possible
According to the Economist magazine, data is the world’s most valuable resource. So, it makes...
Introduction to Power BI
This sessions will provide an introduction to Power BI Desktop and the Power BI Service. With...
Maximizing SQL Server Management Studio for Developers and DBAs
Whether you're a developer or a DBA, you likely use SSMS (SQL Server Management Studio) a lot. ...
Remember Back When? Temporal Tables in SQL Server 2016 and 2017
SQL Server 2016 and 2017 come with their own version of a Wayback Machine: temporal tables. With...
Special Agent Jenkins
SQL Server Agent is a powerful tool to configure scheduled tasks for your SQL Server. However, once...
The Amazing Utility of ROW_NUMBER()
When it was introduced way back in SQL Server 2005, the lowly ROW_NUMBER() function at first seemed...
The Tricky Part of Doing Tricky Things in your Database
We've mastered the basics of basic database design patterns, but what happens when you or a...
The wonders of modern SQL Server administration
Ever been tired of doing the same action over and over again? Chaining together RESTORE DATABASE...
Visualize Your Transaction Log
The SQL transaction log can be a mystery to many DBAs. We live in the age of visualizations, so...
Weird stuff I saw ... while supporting a Java team
After spending more than a decade completely devoted to the Microsoft stack, I did some time...
Weird Stuff I Saw While ... Working With Heaps
We've all been told at some point that heaps are usually bad for select, update, and delete...
Who's Pissing in Your Data Lake?
The new data terms of Data Lake, Data Reservoir, and Data Swamp have left me with more questions...
Why do I need Analysis Services?
Do you have or are you developing a BI roadmap without Analysis Services? Do you write a lot of...
Why is my DBA So Grumpy ... When I Use NOLOCK and Other Query Hints.
Most of us have heard that using the NOLOCK hint is not recommended. But why is this? What is it...
Why Should I Care About ... Partitioned Views?
Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views...
Why should I care about ... the plan cache?
SQL Server is a huge product, with many different places a DBA can go to look for information on...
Sessions Found: 25
Back to Top