Toggle navigation
FAQ
Venue & Travel
Sponsors
Sessions
Training Days
Wednesday
Thursday
Friday
Saturday
Login
It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript,
click here for a page that doesn't require javascript
.
Home
Sessions & Content
Sessions & Content
Tags
AlwaysOn
(3)
Analytics
(17)
APS
(2)
Azure
(47)
backup
(5)
BI
(46)
CDC
(2)
data mining
(3)
Data Quality Services
(2)
data warehousing
(28)
DAX
(30)
DBA
(20)
dimensions
(17)
ETL
(13)
high availability
(13)
katmai
(2)
master data
(7)
memory
(14)
mirroring
(3)
partitioning
(9)
performance
(139)
Power BI
(17)
Power Pivot
(12)
Power Query
(2)
PowerShell
(16)
profiler
(7)
R
(10)
security
(18)
SharePoint
(6)
spatial
(8)
SQL Data Warehouse
(4)
SSAS
(58)
SSDT
(12)
SSIS
(31)
SSRS
(23)
StreamInsight
(3)
virtualization
(7)
Content Type
Slide Deck
442
Search
Conference
SQLBits I
16
SQLBits II
6
SQLBits III
9
SQLBits IV
15
SQLBits V
31
SQLBits VI
16
SQLBits VII
35
SQLBits VIII
39
SQLBits IX
42
SQLBits X
41
SQLBits XI
24
SQLBits XII
53
SQLBits XIV
2
SQLBits XV
48
SQLBits XVI
3
SQLBits XVII
62
"Start Small and Grow Big" with Power BI and Azure AS
In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then evolve it into a fully scalable Azure BI solution.
50 ways to show your data
„A picture is worth a thousand words“ - compelling visualizations beyond the usual bar, line or scatter plots, produced with the help of the ggplot2 package and friends.
60 Reporting Tips in 60 Minutes
This is a session for the all of you with short attention spans (like me!) In this session, we will rapid fire tip after tip to help you be a better report author. We'll use the popular Microsoft tools, SSRS and Power BI.
Administrating SSRS without boring web based clicks
Automate SSRS management using Microsoft's PowerShell module
Advanced-On-Prem SSRS 2017 For Non-Ad Users
There has always been a challenge of publishing an on-prem developed reports to external clients (non-AD users). Is this achievable with the latest SQL Server 2017 with RLS enabled?
An introduction to HDInsight
Are you still asking yourself, what is big data? What is HDInsight and how can I benefit from it? which type of HDInsight Cluster should I use? come to this session and find an answer
An Introduction to Machine Learning
Learn how to build an Azure Machine Learning model, how to use, integrate and consume the model within other applications, and learn the basic principles and statistics concepts available in the different ML algorithms.
An introduction to SQL Server for data scientists
A little bit of knowledge about how SQL Server works can go a long way towards making large data engineering queries run faster.
Analyzing real-time data using Azure Streaming Analytics.
Businesses today require real-time information to make better-informed decisions, this requires a new set of tools. In this session you will learn about Azure Stream analytics and how it can help address real-time data scenarios
Apache Cassandra for the SQLServer DBA
A tour of Cassandra, a popular NoSQL DBMS
Azure and SQL Server: Getting the best out of the cloud
SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds, reducing operational costs.
Azure Data Catalog Adoption Patterns and Best Practices
Get the most from Data Catalog with patterns and practices.
Azure SQL Data Warehouse Optimizing and Maintaining
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance.
Boosting SSAS productivity with Tabular Editor
Tabular Editor is an open source offline editor experience for SSAS Tabular, which offers lots of features in a simple UI that can vastly improve your productivity when developing Tabular Models at compatibility level 1200+
Breathe Life Back into your MS SQL Server Systems And Cloud Apps With a Much Needed Parallelism Boost
Mike Prince, Senior Technical Consultant and Independent User of MaxParallel™ reveals how it worked for Ultima Business Solutions and details the levels of performance enhancements they now achieve.
Chatbots for Dummies
Learn how to build, debug and deploy a chatbot using the Azure Bot Service and the Microsoft Bot Framework.
Data Science For The DBA – Get Started Now
If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you an end-to-end Data Science project covering the core technologies in Microsoft Data + AI stack.
DAX Best Practices
Best bractices in DAX formulas from real world experience.
Dont cross the streams, a closer look at Stream Analytics
This session takes a closer look at Azure Stream Analytics, and how you can make it work in your Projects.
DWH and Microsoft BI in an Online Games Company
How does Big Data with Hadoop, Cloud Computing in Azure, Self Service BI and “classic” BI with SQL 2016 interact with each other to build a modern enterprise BI architecture at InnoGames? Watch my talk and you will know!
Efficiency Tips and Tricks for Multi-Platform Data Client DBAs
Real-world scenarios and stories of a DBA who has to deal with different database platforms and their constant battle with efficiency. This session will offer neat solutions, demos, and tools to make your job more pleasant.
Evaluating Models: Get Ready to ROC
Introducing the ROC curve and its use in Azure ML.
Extending Power BI With Your Own Custom Visual
Microsoft Power BI supports custom visuals from the Office Store (store.office.com). In this session I will demonstrate what is needed for starting building your own.
How to Architect Azure for Insights & Analytics
Selecting the right PaaS components in Azure
Hybrid Data Solutions-how to have you cake and eat it!
We live in a cloud first World, but many organisation still run largely on-premise. This session covers how these organisations can begin their journey and leverage Azure data services.
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers
Inside the classic machine learning algorithms
Algorithms like Neural Nets, Deep Learning, SVM and KNN are dominating the Machine Learning world. You don’t need to know the maths behind them but you do need to know how they work in order to use them effectively. This talk will explain just that.
Introduction to Graph Processing with SQL Server 2017
Hierarchies and graphs are the bread and butter of most business applications. SQL Server 2017 comes now with a different approach: Graph Database. You will learn best practices, have fun and will leave with handy scripts.
Introduction to partitioning
Session will be aimed at Database Administrators\Developers who have not previously implemented partitioning within an OLTP database and is designed to give a overview into the concepts and implementation.
Introduction to Pester-TDD for PowerShell
Start from nothing and use Test Driven Development to write a PowerShell function that uses the Microsoft Cognitive Services API to analyse pictures. I will take you on a journey from nothing to a complete function
Kick Start! SQL Server 2016/2017 Performance Tips and Tricks
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. In this session we will discuss newly introduced SQL Server 2016 / 2017 features for performance.
Kicking & Screaming: Replacing Profiler with Extended Events
Extended Events was released with SQL Server 2008, and almost 10 years later, many data professionals are still clinging to Profiler. It's time to move forward, and in this session I'll show you how.
Managing Always On Availability Groups with Powershell
Combining Always ON Availability Groups and Powershell will make your life easier
Parallel Database Maintenance with 24/7 Systems and Huge DBs
Session deals with the database maintenance problems (like defragmentation) in situation of 24/7 system. As we walk through the basic maintenance we keep in mind that our database is big and it takes a lot of time to do the proper maintenance.
Performance Monitoring Using Extended Events, DMVs & Query S
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Pitch Perfect-Presenting Ideas That Win Executive Support
You want to make your IT organization better, new software or hardware, new team process, or other significant change? Is you organization’s management are prone to saying ‘No’ to things like this in the past. How do you move forward successfully?
Power BI deployment strategy for publishing and maintenance
It takes minutes to create and share Power BI reports and users who has relevant Power BI access can do many things in the PBI service. In this session, Prathy will show how having a deployment strategy helps maintaining Power BI service.
Preparing your business for data science
So you're thinking about doing implementing data science project in your business? If you fail to plan, you plan to fail, so come to this session to help you construct your data science plan to help you succeed!
Query Execution: Expectation-Reality
Sometimes this happens. What you expect not always what you received. In this session, we will look at a bunch of such situations.
Revenge: The SQL!
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
Row Level Security-A real world example
Row Level Security based on related tables
Scalable deep learning model training with Azure Batch AI
Deep learning is an essential component of an analytical toolbox. There are considerable challenges in training deep learning models and this presentation explores how to overcome these using Microsoft’s scalable ML offering, Azure Batch AI.
Securing your Data is Easier than ever with Azure SQL DB
Securing your Data is Easier than ever with Azure SQL Database: A Walk Around the Security Toolset. This will be a demo-heavy overview of the latest security capabilities available, including the newest intelligent data protection features.
Simplifying XEvents Management with dbatools
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Solving ETL bottlenecks with SSIS Scale Out
Do you have large-scale SSIS platforms which experience bottlenecks due to the number of packages or volumes of data that need to be processed? Yes! Then you need to explore SSIS scale out.
SQL Intelligence excels your tuning and security expertise
Azure SQL Database built-in intelligence features will help you improve performance and security of your database and dramatically reduce the overhead of managing thousands of databases.
SQL Operations Studio: the state of the art and future
Microsoft SQL Operations Studio is a new light-weight, free and multi-os tools for SQL Server, Azure SQLDB and DW running anywhere.
SQL Server Infernals – A Beginner’s Guide to Worst Practices
When you're in a rush, following best practices is a luxury you may not be able to afford. What about just avoiding worst practices instead? Join me for this session and learn from my mistakes!
SQL Storage Fundamentals for Azure IaaS
SQL disk configuration and planning can really hurt you if you get it wrong in azure. There is a lot more to getting SQL right on Azure VMs than next-next-next.
SSAS Tabular Toolbelt: 6 tools that make your work easier
In this session, I'm going to show you six amazing tools that must be in your developer/consultant toolbelt. These tools help you develop, manage, monitor and optimize your Tabular model, in other words, it makes your day to day job easier.
Tabular Automation With TMSL and PowerShell
This session will explore the Tabular Model Scripting Language (TMSL); how TMSL can be used with PowerShell to automate the creation and deployment of an Analysis Services Tabular Model.
Tame Your Unruly Data...With Constraints!
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
Temporal Data in SQL Server
Use temporal support in SQL Server and add what is missing out of the box.
Text Analytics Of A Banks Public Reports
Text analysis of financial documents using R & Power BI.
The Pathway to the cloud using Azure SQL Managed Instances
If you have 100's SQL Servers, some legacy applications, running on older versions and no cloud subscription? Then the path is to cloud very different from a single click. We focus on the key steps needed for a cloud SQL data migration.
T-SQL Window Function Deep Dive
Solve complex problems with T-SQL window functions.
tSQLt Tests: Unit Test Your SQL Server Code and Sleep Better
You are responsible for writing or deploying SQL Server code, and want to avoid unleashing catastrophe in your databases. In this session you will learn how to install and use the tSQLt testing framework to run automated repeatable tests.
Uncovering Duplicate, Redundant, & Missing Indexes
Ensure your indexes are achieving their fullest potential!
What is the Azure SQL Datawarehouse?
In this session we will discuss about the Azure SQLDW and how we can use it to help on our day to day.
What Power BI users need to know about R
Learn the basic knowledge to use the R language in Power BI as source, transformation or visualization
What’s New with SSIS in ADFv2
See the latest features of SSIS in ADFv2, e.g. ARM VNet, Enterprise Edition, Custom Setup Interface, Execute SSIS Package Activity, etc.
Whats New in Azure Analysis Services
This session will reveal what's new for Azure Analysis Services in the areas of performance, scalability, advanced calculations, model management, and monitoring.
Building a Performance Monitoring System Using XEvents
In this session you will learn how to use Extended Events and Dynamic Management Views (DMVs) to build a performance-monitoring system for your database environment.
Near real-time IoT Analytics of Pumping Stations in PowerBI
An IoT analytics solution addressing real-life issues with SCADA data from a network of 600 Waste Water Treatment Plants and 100s of Pumping Stations. An end-to-end solution with Azure Data Warehouse, Azure Data Factory, Azure Analysis Services and PowerBI
Operational Machine Learning: MS Tech for Data Science
Discover the Microsoft technologies that enable end-to-end data science, including SQL Server and Azure PaaS Services, along with practical scenarios and demos.
A Beginner’s Guide to Cloud Computing and SQL Azure
This talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages along with what Microsoft Azure has to offer.
Advanced MDX Tips And Tricks
Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
Advanced Topics for Azure SQL Data Warehouse
This session covers the more advanced aspects of development for Azure SQL Data Warehouse. Areas such as data movement, workload concurrency and resource management will all be covered during this intense 60 minute session.
AlwaysOn Availability Group Troubleshooting Ninja
If you use AlwaysOn Availability Groups, then come learn about the new enhancements shipped with SQL Server 2012 SP3 and above which allows you to troubleshoot failovers in your AG and understand reasons for latency.
Analytics Master Class-more exotic patterns in data
Analytics is all about having a good set of analytical tools. Last year at Sqlbits I outlined 4 such tools, this session will expand on that set. We’ll cover Dark Data, Probability calculations, RFI
Automate Your ETL with SSIS and PowerShell
ETL Development takes time. Allen will show how PowerShell and BIML combine to make the development process seamless, consistent and reduces costly development time dramatically.
Azure Data Factory vs SSIS
Azure Data Factory and SSIS are both data movement tools, but built for different purposes. In this session you will learn pros and cons of using each technology, and best practices of using each in real world scenarios.
Azure DocumentDB: Advanced Features for Large-Scale Apps
Let's talk about how you can get the most out of Azure DocumentDB. In this session we will dive deep in to the mechanics of DocumentDB and explain the various levers available to tune performance.
Azure SQL Database Security - Microsoft product team
Join me for an overview of how Azure SQL DB customers can simply secure their data using our most advanced features to-date including Always Encrypted, Transparent Data Encryption, Dynamic Data Masking and SQL Threat Detection.
Biml for Beginners: Speed up your SSIS development
SSIS is a powerful tool for extracting, transforming and loading data, but creating and maintaining a large number of SSIS packages can be both tedious and time-consuming. Learn how to speed up your SSIS development by using Biml and BimlScript.
Cardinality Estimates in Microsoft SQL Server
Attend this session and understand how, why, and when SQL Server uses statistics and how the new CE will help improve performance.
Continuous Integration and the Data Warehouse
Continuous Integration is not normally associated with data warehouse projects due to the perceived complexity of implementation. John will be showing how modern tools make it simple to apply Continuous Integration techniques to data warehouse projects
Cortana Intelligence Suite – from a guy on the team
Buck Woody will lead you around the Cortana Intelligence Suite showing you how to create intelligent actions from data.
Cut the R learning curve
There's base R, modern R, the Hadleyverse, R in SQL, and more - understanding where to begin can be an exercise in frustration and cost you valuable time. This session takes you through the R you need to be productive quickly.
Data Modelling For Beginners
In this session we will talk through the process of gathering user requirements to provide a good starting point for your data model. We will use the Sun Modelling technique to aid us in this.
Debugging made easier using Extended events
Learn how enhancements in Extended Events can help in easing the troubleshooting for common scenarios that you face in your daily SQL Server life.
Dynamic Search Conditions
This session looks at the two main techniques to efficiently implement searches where users can select between a large set of search conditions
Enhancements that will make your SQL engine roar #1
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Enhancements that will make your SQL engine roar #2
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
Essential Architecture for Bi in a Virtual Environment
Virtualization has had a major impact on computing. While data professionals have adjusted to this for database servers, many BI workloads have moved there as well. Learn about the impact of virtualization on BI.
Excel and Power BI-Better Together
These two Microsoft analytic platforms share lots of technologies and users can import and model data in any one of the environments and use the results across both.
Handling Relationships in DAX
Tabular offers only one-to-many relationships on a single column: it seems poor when compared with Multidimensional. However, with DAX, you can handle any relationship. We analyze and solve scenarios with calculated, virtual and complex many-to-many.
How to start with In-Memory OLTP?
In this session, we will introduce a step-by-step approach to adopting the technology, aimed at beginners who are interested in how it can fit into their own environments.
Introducing the SQL Server 2016 Query Store
In this session we will take a deep dive into one of the, in my opinion, most exciting new feature in SQL Server 2016, the Query Store. Learn all about the inner workings of the query store and how it can help you analyse query performance!
Lock, Block and Two Smoking Barrels
Enter the world of SQL Server concurrency to experience the age old problem of Locking, Blocking and Deadlocking. Let's investigate pessimistic isolation and whether optimistic concurrency could be the answer to all our problems or the last resort.
Locking and Blocking
Locking and blocking is SQL Server’s default method of managing concurrency in a multi-user environment. In this session we’ll look at the three main aspects of locking, including when locks cause blocking and also examine ways to minimize blocking.
Machine Learning demystified: ask the right questions
In this session, we are going to look at a typical machine learning process and how to apply it to real world data. We are going to use Azure Machine Learning to transform data and ideas into models that are production ready in minutes.
Modeling Data in a Document-Oriented NoSQL Database
In this talk, you will get an overview on what to think about when storing data in a document database.
New T-SQL capabilities in SQL Server 2016 & Azure
Discover the ins and outs of some of the newest capabilities of our favorite data language. From JSON to COMPRESS/DECOMPRESS, from SESSION_CONTEXT() to DATEDIFF_BIG(), and new query hints.
Optomizing SQL Server Performance in a Virtual Enviroment
In this session we'll look over some of the things which you should be looking at within your virtual environment to ensure that you are getting the performance out of it that you should be.
Permy, Contractor or Freelance?
What are the pros, cons and gotchas of being a permy vs contractor or freelance consultant? We’ll look at what you need to think about from a logistics, financial planning, tax, marketing, career and skills development perspective.
Recovery Models Made SIMPLE
This session looks inside the transaction log to see exactly what is logged for minimally logged operations in each of the recovery models. We also look at other factors in our SQL Server operations that affect what is actually written to the log.
Responding to Extended Events in near real-time
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems.
Running Totals
This session covers practical applications of running total computations.
SQL Server 2016 Hero Features in a Customer Scenario
This sessions covers the SQL Server 2016 Hero Features and you will see a real customer scenario demo showcasing the Full Lifecycle of Financial Data.
<<
1
2
3
4
5
>>