to search by track, speaker, or session category.
Sessions Found: 143
3 Ways for Getting Data from SharePoint : SSIS, Excel and Access
Need to report on some data from SharePoint? We will look at three different techniques to pull...
5 Minute No Sweat SQL Security Audits
Security audits such as PCI, STIG, or HIPAA, are important and can be complicated. Depending on the...
A Beginner's Guide To Plan Guides
Even with the increased simplicity of plan forcing using Query Data Store in SQL Server 2016 and...
A Deep Dive into Latches
This topic sounds scary, but it’s not. Regardless of whether you have a small database with only a...
A Guide to Azure SQL Database
Have you been wondering what Azure SQL Database is and what it means for you as a production DBA?...
A Tour of R in the Microsoft Ecosystem
Over the past few years R has been popping up in several areas within the Microsoft ecosystem. It...
Alexa, Talk to Me
Learn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa. In this...
An Introduction to Azure SQL Managed Instances
Microsoft has recently expanded the Platform as a Service (PaaS) offering for SQL Server to include...
An introduction to the magical world of BIML!
Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are...
Analysis Services for the Absolute Beginner
Publications across the globe have called data “the new oil.” However, the value of oil is in what...
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator...
Applying Forensic Accounting Techniques Using SQL And R
Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal...
Approaching Zero: Minimizing Downtime During Deployments
Negotiating a downtime for a release can be difficult in this modern, 24x7 world. When downtime...
Automate your SQL Server installs and configurations using Powershell Desired State Configuration
Database administrators are being tasked with managing a large number of SQL Server instances. ...
Azure Analysis Services: Purpose, Migration, Benefits, and Tools
This presentation will briefly go over the history of OLAP and Microsoft's contribution to the...
Bare Naked Skinny on SQL Server
Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold...
Become the Most Valuable Player: Soft Skills for the Hard Market
Whether you are just starting a career, advancing into senior leadership, or trying to woo a...
BITRACKS:Populating a Data Warehouse with SSIS and Biml Patterns
This session will demonstrate how to leverage Biml Patterns, along with SQL Server Metadata, to...
Branding Yourself for a Dream Job
Everyone wants a great job that they enjoy, but few of us know how to take charge of our career....
Build a White/Blacklist Bouncer. Who Gets into Your SQL Club?
Are too many systems hitting your SQL Servers? Do you know who they all are? Are you under...
Building Your Yellow Brick Road: Directing Your Path to a Successful Career
For most of us, our career in technology was and is the result of our combined education,...
Choose Your Own Adventure: Performance Tuning
Life is all about choices, and when it comes to SQL Server it is no different. If you don't have a...
Choosing the Right Microsoft Data Science Platform
So you've done traditional BI for some time, but now you and your company know it's time to dig...
Choosing Your Cloud Data Platform--SQL DB, Managed Instance or Something Else?
There are a lot of options for cloud databases out there from Microsoft and other vendors. In this...
Code Like a Pirate ... Intro to R and Data Science Tools in MS
R is the most popular statistics language used today. It is one of the most useful tools in the...
Code Like a Snake Charmer - Intro to Python!
Python is the one of the most popular programming languages used today and one of the most useful...
Collecting Performance Metrics
Have you ever had a manager standing over your shoulder, wanting to know why a server is running...
Common SQL Server Mistakes and How to Avoid Them
Making mistakes is human nature, avoiding them comes from experience and shared wisdom from others....
Considerations for Enterprise Power BI Deployments
This sessions will cover the various ways a Self-Service solution, such as Power BI, can be...
Continuous Learning for the Modern Age
You have read this far, great! I already know this session is for you. How do I know? It is...
Sessions Found: 143
Back to Top