In this purely demo-based session, I will show several real-life attacks, from mere reading up to disrupting service availability via various types of manual and automated SQL Injection, including a broadly unknown elevation of privileges attack.
Error handling in T-SQL stored procedures
In this intensive one hour session, learn how to analyse and visualise your data using the Data Analysts Toolkit - Microsoft Power BI complemented with R
This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional
Manage Reports, Users/Security, Subscriptions, Report history, Snapshot.
In this session we'll look at the common causes of bad execution plans and examine options for resolving the problem, short term and long term.
Impress the boss and your colleagues by delivering Dashboards, KPIS, maps and Scorecards wrapped in a tablet-ready interface with SSRS
Everyone wants a job they enjoy and look forward to working at each day. This session will present practical techniques for improving your brand and giving you the chance to interview for the job you want.
Learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. Learn how to set up a monitoring solution to capture data and diagnose slow queries.
Information Workers and Data Analysts do “myth busting" on corporate performance and forecasts on regular basis. This session uncovers ways to take advantage of Power BI as Software as a Service (SaaS) for a "myth busting" lab you can try at home!
Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window
Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.
Attend this session and understand how, why, and when SQL Server uses statistics and how this new feature will help improve performance.
A deep dive into batch mode scalability with column store index and SQL 2014.
Continuous delivery is an approach that enables new functionality to be delivered as needed. This session will cover how this approach can be applied to data warehouses to enable faster time to value for the consumers of the data.
Building software is hard, and we often find that fixing bugs is expensive if they are not caught early. Continuous Integration (CI) has proven to be a valuable technique in improving software quality and this session demonstrates CI for databases.
In this session we describe how to instrument a new or existing solution, and create a Telemetry system that will delight your customers, run your application efficiently and reduce your COGs.
Everyone knew how to keep data safe and secure, right up until Edward Snowden revealed this error. Learn how to keep the data secure, by identifying and quantifying the risks. Take away practical tips and advice to apply immediately.
Let's debate database design issues: NULLs, surrogate keys, datatypes, RI and more
Learn ready-to-use DAX patterns improving development speed of Power Pivot solutions. Good also for SSAS Tabular developers.
This session targets SSAS developers that are already dealing with complex security solutions on a regular basis and want to get more insights on what actually happens inside SSAS when the different kinds of security are applied to their model.
Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.
This session shows how you can use SQL Server 2014’s features to meet your solution’s non-functional requirements and ensure operational success.
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
In this session we'll look at the things you should and shouldn't be doing now, to protect yourself and your data against the risk of corruption and thing you should and shouldn't do should the database ever become corrupt.
We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning & Compression
Learn how to identify
Join me for an hour of playing with different ETL patterns by using Clustered Columnstore Indexes.
Using different Hardware might lead you to different conclusions,
and the size of the workload is always the paramount of your performance.
In this session I want to demonstrate to you some of the coolest features and possibilities of this Tracing Framework. You will never want to see Profiler again.
Microsoft is moving to the cloud and SQL Server 2014 is the first release with features designed specifically to extend your datacentre into the cloud.
In that session we will discuss about Data Governance around Power BI and on-prem platforms
How to avoid dataset-hell ? What are the best practices for sharing queries ? Who is the famous Data Steward ?
Learn where to start reading execution plans and how to interpret them in order to understand how to tune poorly performing queries.
Hadoop (Big Data) vs SQL Server. A view from a SQL Server DBA / Developer
How does SQL Server build results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be SQL Server. This session is for people who are comfortable writing queries, but not with indexes, statistics, and sargability.
You don't buy a lot of servers, but you're about to deploy SQL Server, and you only get one chance to make it right. Brent Ozar will boil down everything you need to know into just a few simple decisions including SQL Edition, sockets, and RAM.
It's time to take your ad-hoc Powershell scripts turn them into your very own module. And while we're at it we will add proper error handling, parameterization & pipeline support. I will also demonstrate how to build help, force and whatif support.
In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.
In this session, you will learn what SSIS is and which components it consist of, how to use the SSIS catalog to track the execution of the package and how to troubleshoot packages.
R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about.
You have tuned your SQL server to it's limits, you have maxed the RAM on your server, and still your data warehouse is too slow. Is a Parallel Data Warehouse the next step?
So you are a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it. I've got some of the answers here in this session for you.
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so no previous experience necessary.
Come to this session to learn about the next wave of Microsoft’s analytic capabilities. Big data opens up great possibilities but do you have the right skills as a data scientist? Learn what Microsoft is doing in the analytics space
In one hour we will take a sample ecommerce application and database, show tools available for both schema and data migration and the demo performance, scalability and monitoring impacts.
In-memory OLTP is probably one of the most radical technologies to hit SQL Server in a long time. It has become the topic of endless discussions, debates, and the unavoidable myths. In this session we will cover the actual pains that drove the design
This session will help DBAs to understand what changes they need to make in their performance and monitoring practices for virtualized database servers.
Once you've decided to move to Azure with any of your databases, you're going to need to know how they're performing, this session shows you.
You don’t have to be an analysis services guru to gain a better understanding of how to analyse, configure and optimise cube processing.
Alberto will start with a simple query and he will perform on stage all the necessary steps to optimize it, showing you the tools ant the techniques used to identify the bottleneck and to fix the performance issues
Because there are always at least two sides of the performance coin, in this session aimed at .Net and SQL developers, we'll dive into the workings of the .Net SqlClient and give you insight into way more than just SqlCommand.ExecuteReader()
Writing efficient queries with temporal predicates is finally not a problem anymore.