to search by track, speaker, or session category.
Sessions Found: 39
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator...
Automated tests in your database: tSQLt
tSQLt is a database unit testing framework for Microsoft SQL Server. tSQLt is ideal for the...
Azure Data Catalog – Turning Unused Assets into Usable Knowledge
Data is today’s currency. Azure Data Catalog (ADC) is a relatively unknown resource in the IT...
Azure Data Factory V2 /SSIS in Azure
Azure Data Factory (ADF) has done some mileage since it's beginning in 2015. It has evolved and is...
Back to the Future with Temporal Tables
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work,...
BI in Excel 2016: The value is in the Refresh
2 text transaction files, a pivoted excel budget file, 20 Power Queries, 6 dimensional tables, and...
Blue Collar SQL Tricks - Make Standard Edition Work for you.
You want Enterprise Edition of SQL Server? Not gonna happen! When we are limited by having just...
Columnstore Index Primer
Overview of Columnstore indexes introduced in SQL Server 2012 and its evolution through each...
Confidence: The fuel for action
Confidence is the fuel for action. How often have you thought about wanting to do something and...
Data Cleansing With SQL And R
On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and...
Data Landscape on Azure
There are many Data Platform offerings available on Azure and new ones are introduced regularly and...
DBA Checklists: Reliable, Repeatable, & Automated.
Now that SQL Server loves PowerShell and Microsoft loves open source, it is even easier to automate...
DBATools! The reason to finally start learning and using Powershell
Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008. In...
DevOps - Desired State Configuration
Desired State Configuration (DSC) is PowerShell add-on released with PowerShell 4.5 update and...
Educating yourself will make a SQL career more fulfilling
Do you want to turn your SQL knowledge into a possible career? This session will show you what...
Introduction to Object-Relational Mapping for DBAs
This talk introduces DBAs to Object-Relational Mapping (ORM) from the point of view of a software...
Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
Like parents having to break up a fight between battling siblings, SQL Server must do the same for...
Modernizing your legacy database integration points
Legacy corporate applications that are built in-house can quite often be tightly coupled together....
Much Ado About Hadoop
If you're interested in Hadoop but don't know where to begin, this session will give you an idea of...
New Era of Data Warehouse Design
Building and maintaining enterprise data warehouse is quite a daunting task; it takes months of...
Performance Tuning Fundamentals for SQL Server
Just a handful of configuration settings in SQL Server can mean the difference between an anguished...
Power BI for the Faint of Heart - Building an Interactive Report Step-by-Step!
You've heard about Power BI, and you've seen it, but you haven't yet rolled up your sleeves and got...
Power BI for the Faint of Heart - Understanding On-Prem, Hybrid and Pure Cloud Scenarios
Power BI v1. Started off in Excel. Today Power BI v2 has Excel capabilities, a free desktop app for...
Power BI: Roll up your sleeves, we're getting our hands dirty!
For years, Excel has been the tool of choice for business people around the world. In July 2015,...
R For the SQL Server Developer
R is the premiere language for data analysis. If the world of data science sounds fun and...
Remote Management of SQL Servers with PowerShell
Whether you've tried out PowerShell or not, make no mistake: PowerShell is here to stay. As a SQL...
Six Degrees of Sql Family? - An introduction to Graph Databases in SQL Server and CosmosDB
In this Session we will look at the theory and use of a Graph Database and its implementation in...
SQL Server Hands on Troubleshooting
How do you go about troubleshooting? How to fix issues that can happen in your environment? What...
SQL Server Internals - Cardinality Estimates
SQL Server uses cardinality estimates to decide on execution plan; how the data will be retrieved. ...
SQL Server Internals - Performance Troubleshooting Hands on Approach
Where do you look when you are having performance problems? What tools you have available? In...
Sessions Found: 39
Back to Top