to search by track, speaker, or session category.
Sessions Found: 101
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 Masters Passport to Extended Events
"As is commonly the case, all good things come to an end. And now is as good a time as any for the...
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...
Automated SQL Server installation and configuration using PowerShell
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server...
Azure Machine Learning I : Machine Learning and Predictive Analytics with AML Studio
Windows Azure Machine Learning and Data Analytics platform offers a streamlined experience, from...
Azure Machine Learning II : Machine Learning and Predictive Analytics with R and Visual Studio
What if you have the power to predict the future? Predictive analytics enables uncovering...
Big data architectures and the data lake
With so many new technologies it can get confusing on the best approach to building a big data...
Choosing Sides in the ETL vs ELT Debate
The debate regarding the relative merits of extract transform load (ETL) and extract load transform...
Choosing technologies for a big data solution in the cloud
Has your company been building data warehouses for years using SQL Server? And are you now tasked...
Cloudy with a Chance of Data
The ""Cloud" is here. With it, there are many options for storing and processing data. What does...
Collecting and Analyzing File & Wait Statistics
Is your SQL Server instance running at its peak performance level? Probably not but the real...
Collecting Performance Metrics
Have you ever had a manager standing over your shoulder, wanting to know why a server is running...
Connection to SQL Server. Problems. Troubleshooting. Solutions.
It is very frustrating when users complain about inability to connect to SQL Server while SQL...
Controlling Competing Workloads with SQL Server Resource Governor
With heavily consolidated instances and competing workloads, the Enterprise only Resource Governor...
Crazy Things Developers Do
Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be...
Data Cleansing With SQL And R
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and...
Data Hoarding (Buried Alive): Better Data Modeling and Management When Using Power BI
Microsoft’s Power BI service has allowed end users and business analysts to exercise their...
Data Protection & Privacy in the World of Database DevOps
Ensuring the ongoing protection of personally identifiable information is mandatory in today's...
Data Types Do Matter
They're just numbers, right? A date's a date. It's just string data, who cares? I can't tell you...
Data Visualization: How to truly tell a great story!
We have more information available to us today than ever before. So much so that we run the risk of...
Deeper Into Azure Machine Learning
Azure Machine Learning enables far more than supervised 2-class classifications and continuous...
Deploy AlwaysOn on Google Cloud in Real Life
We will discuss all details of deploying SQL Server 2016 AlwasyOn on Google Cloud in real life. ...
Enabling Familiar, Powerful Business Intelligence
This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use,...
Environmental SQL Server Troubleshooting
When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and...
Excel with DAX
DAX is the new formula language (builds upon Excel's) supporting PowerPivot and Analysis Services...
Exploring Execution Plans
Getting started reading execution plans is very straight forward. The real issue is understanding...
Extended Events - Better than Profiler
Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant...
Extending DevOps To SQL Server
Most organizations are under pressure to speed up the software delivery cycle, whether that’s to...
Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using...
From Analyst BI Day to Developer BI Night
You are a data analyst by trade. Your SQL skills are likely used to write research queries, do...
Sessions Found: 101
Back to Top