to search by track, speaker, or session category.
Sessions Found: 61
"There Be Whales Here!" -- Big Data in SQL Server
Due to varying definitions of Big Data which confuse data volume and data organization, the common...
3 Keys to Successful Consulting
Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to...
A Developer's Guide To A Neglected Database
You've just landed a new job or a new task. You are charged to maintain and improve a...
Advanced Power BI Modeling Techniques
Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex...
Are all RDBMS systems created equally?
We all love SQL Server but is it really so much different than Postgres, Oracle or Mysql? I've...
Availability Groups: What They’re Not Telling You
SQL Server 2012 brought to life a new form of high availability and disaster recovery in the form...
Azure AD authentication methods for SQL Azure
Deploying to SQL Azure? What are the best ways to login/authenticate to SQL Azure? Learn about...
Azure Machine Learning 101
There are several ways to create a machine learning model. You can use R or Python or even other...
Beginning Admin: The Care and Feeding of SQL Server
Design and development may be exciting, but database administration is absolutely critical (and,...
Beginning Powershell for DBAs 1.0
The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an...
If you work with SQL Server at all, you need to know Transact-SQL, the SQL Server programming...
Big Data Clusters for the Absolute Beginner
Are you a DBA or data professional working with out-dated technology or feel your skills are...
Clustered, Non-Clustered and Covering Indexes Oh My!
So you have a brand new table with lots of data and when you do a query it takes forever to return....
Complete Database Migration with PowerShell
With SQL 2008 going out of support this year, there is a greater need to migrate to a more recent...
DBAs Working Smarter NOT Harder with PowerShell
Do you have extra time in your day to do extra things or to make things better? Feel overworked...
Discover the Hidden Mysteries of Common Table Expressions
Although they have been around since SQL Server 2005, Common Table Expressions (CTEs) have been a...
Dynamic SQL: When, Why, and How to Use It
You're comfortable writing T-SQL, and you've built a lot of stored procedures that have a bunch of...
Effortless Backups with Minion Backup
Minion Backup is a stand-alone backup solution that can be deployed on any number of servers, for...
Everything You Need to Know About Indexes!
The attendee will learn all about the various index structures, how or when to use them and why....
Faster Transactions: Query Tuning for Data Manipulation
Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query...
How to Be an MVP (in Life and a Microsoft MVP)
Many times we look at the success of others and think it is beyond us. In this session, 12 time...
Improving concurrency with Read Committed Snapshot Isolation
At some point or another, every DBA has to deal with concurrency issues. Read Committed Snapshot...
Inside the DBAtools PowerShell Module
There has been a movement towards PowerShell in the SQL Server Community lately. With so much out...
Inside the Query Store. What Knowledge can You Gain?
The Query Store houses valuable information on performance of your queries, as well as gives you...
Introduction to SQL Server Graph DB
Have you heard about all the hot new features in SQL Server 2017? One of the game-changing features...
Introduction to T-SQL Windowing Functions
T-SQL windowing functions can simplify many complex queries. They are the best thing that has...
It's NOT About The Cookie
Do you trust the numbers or ‘go with your gut?’ When there’s a discrepancy between your gut feeling...
It's Not Your Fault, It's the SQL Server Default
When you see those little green checkmarks, then you know your new SQL Server instance is ready to...
Loading SQL Server Data with Powershell
Powershell has become the defacto standard for scripting Microsoft products. However, putting data...
Make Database Documentation your Minion
Most IT folks aren’t a fan of writing documentation. We are far more interested in creating...
Sessions Found: 61
Back to Top