A fun session showing some amazing things you can do with Power BI
This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance.
This session introduces SQL Server 2012 and 2014 text mining capabilities.
Azure stream analytics is a new Azure service for analyzing streaming data.
Azure Data Factory is a managed service for extracting, transforming and processing data, with ability to define pipelines and data driven workflows. in this session you will learn differences between this tools and SSIS with demos
Azure Machine Learning is a fully managed cloud service for predictive analytics.
In this 1hour session, we will run through;
ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.
Sometimes don't want our data in the cloud, but that doesn't mean we can't use the cloud at all.
A SSAS MDX Deep Dive session covering the implementation of a business requirement to identify rogue behaviour over time and within SCD organisation groups.
A journey from dev to production. This talk covers best practices for developing and deploying Visual Studio Database Projects targeting multiple environments. We will cover using composite projects, pre and post deployment scripts and other optionst
The session starts with a brief overview of the operator and it
Everyone wants a dream job that they enjoy going to each week. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself in today's competitive world.
Alberto will show you some common techniques to use when building a budget model with Power Pivot and Power Query, including previous year allocation, multiple-step budgeting with linked back tables, handling of budget on non-existing products
Learn how to write Powershell that will use Remoting to run scripts parallel on any number of servers. We'll talk about remoting, background jobs and how to collect and report on the results
This all demo session build around a real life case study from one of the largest organizations in the world. will take you through a case of how to build a completely meta-driven SSIS solution relaying on BIML and MDS to do the hard-work for you.
See how to use Power Query to build a detail-level reporting solution
The Azure CAT team has successfully architected, designed and built hundreds of cloud projects. In this session we will share the learnings on how to design a cloud application to scale to handle large, complex workloads.
When loading a large amount of data, e.g. into your data warehouse, you want the data inserted into the table as fast as possible. You know you have to use bulk load, but what do you need to do to ensure that data is loaded as fast as possible?
Come to this session to find out what is involved and what we learned from migrating 700+ servers into Microsoft Azure.
In this session you'll learn how to analyze execution plans efficiently, how to track the real bottleneck quickly, and how to avoid some common mistakes that will save you a lot of time and frustration…
Continuous Integration for Reporting Services
You're hearing a lot about the new features in SQL Server, but you're not hearing a lot about the drawbacks. Ever wonder why? Join Brent Ozar, the guy behind DBAreactions.com, for a sarcastic, funny look at SQL Server 2014's "features" and bugs.
Multi Site Tier 1 HA solution: 5 parts (1 Windows Cluster, 2 lots of cluster storage, 3 SQL FCI’s & 4 AG’s)
This session will demonstrate query performance issues a dba is confronted with every day. The demos will handle these scenarios and it's solution
The new SQL Server 2014 CE is one of the biggest changes
Let's see what's changed, How to debug it, walk through the density calculations,
combined Filter and key Scenario’s and see how this impacts your performance
This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBA’s in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.
Does the concept of analytics make you nervous? Are you being asked to do more advanced analysis with existing tools? Come learn how to take your predictive capabilities to the next level with new azure technologies.
Data warehouse designers often ignore the specific needs of an OLAP database. In this session, John will outline the best ways to optimise your relational database to support your multidimensional OLAP cubes
In this session, you’ll learn about SQL Server stored procedures: what they are, when and why you'd use them, and how you would develop a solution with one. We’ll walk through examples to explore the process of solution building in SQL Server.
The Power BI Preview service offers developers a rich API service for anyone to interact with Power BI programmatically and create applications for Power BI. In this session we will introduce you to the Power BI developer story
One of the most important aspects of maintaining uptime with both availability groups and clustered instances of SQL Server is dealing with quorum. This session will cover multiple versions of Windows on how to approach, configure, and manage quorum.
This session will look at providing cost effective DR capability with Azure.
You're a DBA who's struggled with Perfmon metrics and Profiler. You're facing a sea of confusing numbers, and you don't know where to focus first. Microsoft Certified Master Brent Ozar will give you a friendly introduction to wait statistics.
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.
EventStore is an event streaming database specialising in delivering CQRS, but capable of being a general repository for notifications. Get the skinny on how it works, the architecture and where you might use it.
The attendees will get a overview of the possibilities with Excel Services 2013 in a Business Intelligence perspective.
(1) Overview of the publish options
(2) How to control the layout
(3) Tips & Trick from real world examples
Extended Events are replacing the old SQL Trace & Profiler, and there are many good reasons for that. In this session I want to demonstrate to you some of the best features and possibilities of this Tracing Framework.
What's your data visualization vegetables, and what's your candy? This session will look at data visualization theory and practice.
Many triggers are inefficient and violate best practices, but it doesn't have to be this way.
Join this session and learn how to improve your triggers and keep them off the list of potential scapegoats for your SQL Server performance woes.
This session present key tools, methodology and approach for troubleshooting SQL Server. Performance and availability of the database engine has a direct impact on user experience of applications.
tSQLt is a testing framework that is designed to help you write repeatable, isolated tests against your database code. In this session we will briefly examine the goals of testing, and introduce tSQLt with a variety of demonstrations.
Come to this session if you want to find out about Microsoft's Document storage option in the cloud. You will leave understanding what it is, why it exists and how to get started.
Need to search your data efficiently whilst in the cloud? This session introduces you to MSFT's highly scalable search solution in Azure
If you work with an amazing visualisation plugin NodeXL you might have asked yourself the question - how do I get my custom data for getting those great visualisation for analysis.
This session will show you a couple of ways of how to get it done.
Big Data is here to stay, no doubt about that. And Hadoop is THE framework for Big Data. But what is Hadoop? Is it a friend or foe for SQL Server DBA? Let’s explore what Hadoop is and how to make it work together with SQL Server.
For long Hadoop and MapReduce were linked together. With the release of YARN, Hortonworks, Microsofts Hadoop partner, launched the Stinger initiative to speedup Hive a 100x. But wat is it? In this session I will show you.
SQL Server needs its locking mechanism to provide the isolation aspect of
transactions. As a side-affect your workload can run into deadlock situations -
headache for you as a DBA is guaranteed!
We’ll be looking into the pros and cons of moving SQL Servers into a virtual server environment. Specifically we’ll be looking into when it’s a good idea and when it’s probably not a good idea. Like all problems in the database world there are no h
Why can't DBAs seem to trust automation for the Database? Here's how to overcome that mistrust and conquer database automation.
In this session we'll dig into the internal structures of indexes. We will explore the differences between clustered and non-clustered indexes, what's laid out within each page of the indexes.
Microsoft has totally reimagined the Power BI platform and user experience for BI professionals, developers and business users. Please join me to further explore all these great changes and enjoy a fun demo-intensive session.
You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell. We’ll work on SQL Server with Powershell, and learn some cool techniques. Come see this all-demo, hands-on session!
In this talk, I will share my experience in creating and running Azure SQL Database, a large cloud scale service powered by SQL Server technologies.
This session is your opportunity to ask the people who know, the questions you want to ask. This is an opportunity you cannot afford to miss.
One of the crawl, walk then run onramps to the cloud would be to exploit Hybrid computing. Microsoft SQL Server gives you this on ramp as it continues to extend the value to your on premise environment with features that let you extend to the cloud
DBAs are always asked to perform tasks against dozens of objects and the requests never come in the format we need them. Learn how to make regular expressions parse through the requests for you to get your day back and become a star in your office.
Where is the MSFT data platform now and where is it going
SQL server 2014 is one of their measure releases. Where Microsoft has done a superb job. There are so many enhancement we have in SQL Server 2014. In my session I will show you my top 5 features.
Transactions are critical when multiple changes need to be made entirely or not at all, but it’s rare to see transactions used at all in most production code. In this introductory session, we'll look at what transactions are and how they're used
Ever wondered if you can optimize your sql projects so you don't have to do unnecessary work? Take a look at how I've optimized SSDT Deployments by use case.
Most ORM's tend to be very chatty and generate complex queries. In this session we will look at optimizing database access in ORM's. Using Nhibernate, LINQ &Entity Framework in the demos, we will examine how your ORM talks to the database and why.
Learn how to use the Power BI tools to help you analyse, specify and test the concepts and requirements of your next data Warehouse project.
Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources.
SAP HANA is ubiquitous nowadays and its market share is growing steadily. But being foremost a backend technology opens the trail for other frontend tools like Office 365 &Power BI. How to combine these two technologies will be shown in the session.
Come to learn how to implement solutions to prevent undesirable settings creeping in your SQL Server environment. To accomplish this, we will look Policy Based Management with Central Management Servers, SQL Server Audits and DDL Triggers.
This session will show you how the query optimizer has been updated to work with the new SQL Server 2014 features and to provide better performance to existing ones. Topics include Hekaton, the new cardinality estimator and incremental statistics.
In this session we'll explain what the SQL Execution plan is, how the SQL Server generates it, and how to read the output.
In this session you will learn about common MDM scenarios, and get Real Life examples on how to handle these Scenarios by building a MDM Architecture using SQL Server and Master Data Services.
Your relational Data Warehouse is suffering from performance problems. In this session we will take a look at some of the most common performance problems that tend to occur in a relational data warehouse.
RMan and Reporting Girl join forces to fight the crimes in data visualization.
By building a common ground (based on the IBCS standards) they improve their weapons (R and SSRS) that help them in their fight.
Setting up SharePoint BI applications and services to work in an enterprise environment
A look at the basics of CLR integration with SQL Server, focusing on the nuts and bolts of CLR objects, followed by some practical examples.
Hekaton is the Greek word for 100 - the goal of In-Memory OLTP in SQL Server 2014 is to
improve query performance up to 100 times. In this session we will look under
the cover of Hekaton and the Multi Version Concurrency Control (MVCC)
Flash storage is a game changer for virtually every app in which it is used. Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head.
Working on full abstract...i'll update this week.
In SQL Server 2014, there have been many changes aimed at giving a more accurate number of rows, and therefore better plans. This session will be a look at these changes, comparing and contrasting with SQL2012/2008 to see how they help.
In this session, we will share some of the hard lessons learned from the first large deployments in Analysis Services Tabular.
In this session, we show how SSIS and HDInsight can work together, as well as how Hadoop jobs can be executed and how data can be transferred with SSIS between HDInsight, SQL Server, and other sources or destinations.
Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail!
With over 15 years of experience as a semi-remote Lead DBA for a medical system, running a consultancy firm, producing SQL Cruise events and balancing a personal life Tim Ford has a pocketful of tips to share in making "remote" work for you.
This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.
Learn how to assess query performance, ensure consistent and reliable query tuning, and avoid ten all-too-common performance killers in SELECT statements running on Microsoft SQL Server.
Exposing the lighter side of Business Intelligence. If you've never been to a Power Hour session before then you will definitely shouldn't miss this one.
Microsoft has a famous whitepaper called "The Data Loading Performance Guide".
On this session, we will turn the whitepaper into a presentation and see a few advanced ways to boost your data loading processes.
The Microsoft SQL Server comes with many features to take a look behind the scenes of the powerful engines. This session will explain how to use the power of these tools to write your own monitoring and diagnostics environment in Powershell and C#.
Gain insights into what is behind the media storm surrounding the Economic Crisis, by diving into publically available data using PowerBI . Learn how the use of analytical tools can empower us by answering the questions we need to ask.
The world of data is changing rapidly. Come learn what this means for your role as a data professional and what you can do to make sure you stay at the front of your field.
In this session we'll take two queries, a read and a write one, and look at the whole trip from the client through the server and back to the client. On this journey we'll try to identify where things might go wrong.
Microsof IT's Cloud strategy involves migrating hundreds of applications to Azure. The scale on which it is being done may be unprecedented. Lessons Learned are numerous. This session exposes the most important—& painful—ones.
As data warehouse developers we deliver data to business users... but we don't deliver data as fast as we want. There are many things you can do to increase your own productivity and become a more efficient data warehouse developer.
New IT leaders are rarely trained in the soft skills needed to be successful when put in charge. This one-hour session will explore the ten most frequent and challenging mistakes that new IT leaders make, as well as discuss methods for combating thos
Learn how to write T-SQL more clearly so that it performs better.
Power BI is the Self-Service BI offering of Microsoft to all Information Workers out there, but hey: Is there anything for developers? We will have a look.
An overview of Unit Testing using the open source tSQLt framework, demonstrating how it can increase confidence in your code, save you time and help prevent bugs from being introduced in the future.
Over the years I've tried various ways to look at output from SQL Server for performance tuning reasons. We will look at virtual_file_stats, waitstats, the buffer cache etc. and we will visualize them in various ways
Indexing internals and how it impacts query performance.
In this humorous session I’ll be contesting many of the so called "best practices" in SQL Server and demonstrating counter arguments. Come along to see how so called "pillars" of design are starting to break down.
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
This session will look at SQOOP, PIG and HIVE. Three tools which are essential in your Big Data Toolbox. We'll look at what they do, how they do it and why you would want to use them
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