to search by track, speaker, or session category.
Sessions Found: 109
"Full Text indexing!" or..."What is that service I never turn on?"
If you've ever wondered what that other service is in your configuration manager then this is the...
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...
45 Minutes to Your First SSAS Tabular Model
Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or...
Accelerating Development and Testing Using Data Virtualization
Constraining everything in development and testing is database size. Storage is a bottleneck, and...
Alexa, Talk to Me
Learn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa. In this...
An (Advanced) Introduction to Dax
Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be...
Analysis Services for the Absolute Beginner
Publications across the globe have called “data the new oil.” However, the value of oil is what...
Applying Forensic Accounting Techniques Using SQL And R
Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal...
In this daylong session, we’ll review all the various infrastructure components that make up the...
Azure Managed Instances—Your Bridge to the Cloud
Many organizations would like to take advantage of the benefits of using a platform as a service...
Back(up) to Basics
Most DBAs know how to use Management Studio to backup and restore a database. That may work some of...
Best Practices Explained. Reasons Why We Do Thing The Way We Do.
Ever used a NOLOCK hint, only to find that nothing broke the next day? Odds are most folks reading...
Building REST API using SQL Server JSON functions
SQL Server 2016 and Azure SQL Databases both contain JSON features that allow data to be accessed...
Building the HASSP: Putting SQL Server In Space
In today's world, technology is a pervasive part of our lives. We have "smart" appliances...
Cloudy With No Chance of Downtime: High Availability using Azure
With the advent of cloud-based data platforms, there are a multitude of options to consider when...
Cross Tabs & Pivots - Much More Than Just Converting Rows to Columns
This session covers and compares the PIVOT operator to an ancient but very high performance...
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 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...
Database Continuous Delivery & Your Salvation!
Continuous Integration & Delivery isn’t a new concept. Application Developers have been doing it...
DBAs vs. Developers: JSON in SQL Server 2016
The war between DBAs and developers has been raging since the dawn of relational databases. One...
Decoding the Cardinality Estimator to Speed Up Queries
The cardinality estimator in SQL Server is a massively complex piece of software that is...
Developing ASP.NET Core 2.0 Web APIs for your Web and Mobile Apps
ASP.NET Core 2.0 is a cross-platform web framework that can be deployed to Windows, macOS, Linux or...
Don't just code it—Generate It
Code Generators are all the rage—BIML, JS frameworks, .NET scaffolding, even the humble templates...
Emergency! Are You Ready for Disaster to Strike?
Most of the time pilots are learning to fly, they're actually learning how to recover from...
Essential Linux for the SQL Server DBA
Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for...
Ethics, Morals, and Laws for the DBA 101
Ethics, Morals, and Laws each govern one aspect of our behavior as people and DBAs. They govern...
Execution Plans 101
Do you have a query that you want to tune, but don't know where to start? Execution plans can be a...
Extended Events: What are they and How do I use them
Since Extended Events are replacing Profiler, every DBA should know what they are and how to use...
Four Rules For Columnstore Query Performance
You've read all the Books Online articles about Columnstore indexes for data warehouses, but...
Getting Started with Azure: A New Adventure for SQL DBAs
Microsoft Azure is no longer a technology that should be learned by some. It has become a...
Sessions Found: 109
Back to Top