Nr: 460
SQLSaturday #460 - Slovenia 2015
SessionID: 38432
Daily problems with indexing and its - possible - solution
Event Date: 12-12-2015 - Session time: 09:00:00 - Track: DBA
Speaker: Uwe Ricken
Title: Daily problems with indexing and its - possible - solution
Abstract:
Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!
- Why performance degradation in spite of maintenance jobs?
- just one more database in the result set and the query runs really bad - why?
- usage of literals is completely different from the usage of variables - why?
- identical data types but the query runs in part perfect and in part bad...
- your execution plan shows an INDEX SEEK - but the table will be scanned!
- you get a query from the business which performs really bad but when you test it it runs pretty cool - why?
SessionID: 38548
Beginners Guide to MDX
Event Date: 12-12-2015 - Session time: 09:00:00 - Track: BI
Speaker: Alex Whittles
Title: Beginners Guide to MDX
Abstract:
Give your queries a multidimensional makeover. 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.
MDX can seem a very daunting language, but when it's broken down into the basics it's easier than you think.
We'll start at the beginning, so you need no previous MDX experience, but it does help to have some experience with cubes. If you already write MDX but struggle with the syntax, then you need to attend this session!
We'll walk through the difference between a member, measure, tuple, set and dimension. Well describe how to decipher a [] from a {} or a (), and we'll look at some of the awesome power that MDX can provide to our reporting.
SessionID: 40414
Real Time Power BI - API, Hubs and Streams
Event Date: 12-12-2015 - Session time: 09:00:00 - Track: BI/DEV
Speaker: Davide Mauri
Title: Real Time Power BI - API, Hubs and Streams
Abstract:
Power BI - I bet you already know what it is - also offers a nice API set that allows you to program it directly from you application so that you can push data directly to Power BI Dashboards and have them updated in real time. Or, even better, you can create a little bit more complex solution that will live in the cloud and uses Azure Event Hubs to ingest data, Stream Analytics to do some streaming query and finally Power BI to visualize it. And you can even put Azure DW in the game (and probably you should)
In this session we'll all this stuff, how it works together and how it can help us to create a very cool and useful Cloud Modern BI solution.
SessionID: 40858
0x010D88DDB7DFE19AAD36D - Always Encrypted in SQL Server 2016
Event Date: 12-12-2015 - Session time: 09:00:00 - Track: DEV
Speaker: Regis Baccaro
Title: 0x010D88DDB7DFE19AAD36D - Always Encrypted in SQL Server 2016
Abstract:
At the end of this session you will know about the Driver Process of Always Encrypted, how to set it up and how to deploy it and maintain it in on-premises, hybrids and cloud solutions.
SessionID: 40886
Automatic sharding in SQL - Reality or Myth?
Event Date: 12-12-2015 - Session time: 09:00:00 - Track: DBA/DEV
Speaker: Gregor Spagnolo
Title: Automatic sharding in SQL - Reality or Myth?
Abstract:
Have you ever started developing a product and found out that none of the available databases aren’t suitable for your use case?
What was your next step? In our case we were crazy enough to create our own database engine. In this session I will present our problem and what led us to the creation of new database engine. We will have a quick overview of how database engine is working and why it is the most suitable database for our case. Maybe you will find out that it may suit also for your needs. A closer look will also explain how our database engine handles automatic shading.
SessionID: 38439
Event Date: 12-12-2015 - Session time: 10:15:00 - Track: DBA
Speaker: Miroslav Dimitrov
Abstract:
SessionID: 38617
Micro ORM - a petite beauty or a poison in a small flask?
Event Date: 12-12-2015 - Session time: 10:15:00 - Track: DEV
Speaker: Dejan Dular
Title: Micro ORM - a petite beauty or a poison in a small flask?
Abstract:
For developers with good knowledge of SQL using a micro ORM seems like an obvious choice. But is it? In the session we will discover the features of the micro ORM called Dapper and how can it simplify your way of communicating with the database. Then we will compare it to the Entity Framework and analyze when you should use one or the other - or neither. But wait! There is more! At the end you will see how easy it is to write a Dapper extension where the classes in your code will magically receive super SQL querying powers.
SessionID: 41137
Microsoft Azure Machine Learning Algorithms
Event Date: 12-12-2015 - Session time: 10:15:00 - Track: BI
Speaker: Tomaž Kaštrun
Title: Microsoft Azure Machine Learning Algorithms
Abstract:
Focus of this session will be explanation of algorithms available for predictive analytics in Azure Machine Learning service. Algorithms will be grouped by learning style (Supervised, semi-supervised and unsupervised) and will take a look into 1) regression algorithms, 2) Regularization algorithms, 3) Decision trees algorithms, 4) Naive Bayes algorithms, 5) Dimension reduction algorithms, 6) Associated learning (not Kernel) Algorithms and 7) Clustering algorithms. With theory explained we will look into data samples and later examples in ML for these algorithms.
Within this session we will explore, which algorithm is used and useful for what kind of empirical problem and which is suitable for particular data-set.
SessionID: 41162
What's new in SQL Server 2016 for BI Developer
Event Date: 12-12-2015 - Session time: 10:15:00 - Track: BI/DEV
Speaker: Prathy Kamasani
Title: What's new in SQL Server 2016 for BI Developer
Abstract:
Finally, the wait is almost over. After few years of silence, Microsoft has finally made exciting announcements about SQL Server on premises enhancements.
In this session, I will cover top new features in SQL Server 2016 from a BI professional perspective. You will get an up to date overview of key improvements of MDS, SSIS, SSRS and SSAS
SessionID: 41164
SQL Server Security In An Insecure World
Event Date: 12-12-2015 - Session time: 10:15:00 - Track: DBA/DEV
Speaker: Gianluca Sartori
Title: SQL Server Security In An Insecure World
Abstract:
One of your first responsibilities of a SQL Server DBA is to safeguard the data and protect it from unauthorized access.
Over and over we hear about hacker attacks and data leaks: if you don't want to be the next Sony, you have to take action and activate all the available protection measures.
In this session you'll learn how attackers take advantage of weaknesses in your infrastructure and how to secure it using SQL Server security features and best practices.
SessionID: 38413
Easy ETL with Biml
Event Date: 12-12-2015 - Session time: 11:30:00 - Track: BI/DEV
Speaker: Marcin Szeliga
Title: Easy ETL with Biml
Abstract:
Can ETL be fun? Unfortunately, very often creation of ETL layer is time-consuming, tedious, error-prone task. What’s more, any change in requirement needs most of the work to be redone. In our session we’ll present new approach to creating BI solutions using Biml language and Mist programming environment. They greatly simplify the process, allowing for amazing flexibility, and make the ETL work more pleasant. We will show real examples of how Biml and C# generates hundreds of usable SSIS packages in just couple of minutes. We will also cover integration of ETL with TFS and CI for ETL. Everything with 100% compatibility with unmodified SQL Server. Join us and see how BI just became fun again
SessionID: 38445
Temporal Tables in SQL Server 2016
Event Date: 12-12-2015 - Session time: 11:30:00 - Track: DEV
Speaker: Miloš Radivojević
Title: Temporal Tables in SQL Server 2016
Abstract:
Temporal tables are defined in the SQL 2011 standard and now transactional (system-versioned) temporary tables are included in Azure SQL Database and SQL Server 2016 CTP2.
In this session we'll explain why we need them, how system-time tables work and demonstraint how to design and implement solutions for common use cases that involve temporal tables...
SessionID: 38469
SQL Server 2016 AlwaysOn Availability Groups - New Features Enhancements
Event Date: 12-12-2015 - Session time: 11:30:00 - Track: DBA
Speaker: John Martin
Title: SQL Server 2016 AlwaysOn Availability Groups - New Features Enhancements
Abstract:
SessionID: 39132
Databases on mobile devices
Event Date: 12-12-2015 - Session time: 11:30:00 - Track: DEV
Speaker: Catalin Gheorghiu
Title: Databases on mobile devices
Abstract:
You are a Windows Phone developer or just a mobile developer and you need a database locally, on the device, a database, what are your options? And really how do you sync you data with the big database? What you can do, what you cannot do, and how? How cloud is changing this story? These are a few of the questions this presentation will try to answer, the focus be on Windows Phone (the easiest to demo, but not ignoring the “others”). The actual industrial devices will be also covered.
And of course all with as much demoes and code as possible.
SessionID: 40474
Anatomy of the DAX Query Plan
Event Date: 12-12-2015 - Session time: 11:30:00 - Track: BI
Speaker: Stacia Varga
Title: Anatomy of the DAX Query Plan
Abstract:
SessionID: 40799
Effective Index Partitioning, Compression Strategy
Event Date: 12-12-2015 - Session time: 13:30:00 - Track: DBA/DEV
Speaker: Neil Hambly
Title: Effective Index Partitioning, Compression Strategy
Abstract:
When Indexing also combines 2 of the Enterprise features: Partitioning Compression, we can often see substantial gains.
Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.
Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
SessionID: 41115
SQL Server 2016 Query Store
Event Date: 12-12-2015 - Session time: 13:30:00 - Track: DBA
Speaker: Sergio Govoni
Title: SQL Server 2016 Query Store
Abstract:
SessionID: 41167
Event Date: 12-12-2015 - Session time: 13:30:00 - Track: DEV
Speaker: André Kamman
Abstract:
SessionID: 41176
Building mobile BI dashboards with Datazen
Event Date: 12-12-2015 - Session time: 13:30:00 - Track: BI
Speaker: Zoltán Horváth
Title: Building mobile BI dashboards with Datazen
Abstract:
Datazen enables you to deliver mobile solutions rapidly: it allows you to develop KPIs and dashboards targeted for mobile devices like tablets and phones in a quick and easy way. The dashboards render in native applications for all flavors of phone or tablet operating systems, but also can be viewed in browsers and/or embedded into applications.
Join this session to see how simple it is to build a Datazen dashboard and publish it to the Datazen server. During the demo, you'll be able to follow how the dashboards change - on your own device!
SessionID: 43006
Ask the Expert Panel - Your Questions, Our Answers, and Fun
Event Date: 12-12-2015 - Session time: 13:30:00 - Track: BI/DEV
Speaker: Mladen Prajdić
Title: Ask the Expert Panel - Your Questions, Our Answers, and Fun
Abstract:
Questions will be answered, debates will be had, general awesomenest will ensue.
This is a popular interactive session format on many conferences.
With you attending we can make it really great. Don't miss out.
SessionID: 38419
Database Administration for the non-DBA
Event Date: 12-12-2015 - Session time: 14:45:00 - Track: DBA/DEV
Speaker: Denny Cherry
Title: Database Administration for the non-DBA
Abstract:
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. During this session we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels and indexing.
While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to better know what to look for.
SessionID: 38536
You don't need Enterprise Edition to do that!
Event Date: 12-12-2015 - Session time: 14:45:00 - Track: DBA
Speaker: William Durkin
Title: You don't need Enterprise Edition to do that!
Abstract:
The most coveted features of SQL Server are made available in Enterprise Edition and are sometimes released into Standard Edition a few years later. This often leaves a vast group of users who "window shop" the latest and greatest features and return to the office wishing they never saw those features presented. This session will show you how you can achieve the same, or at least a similar, outcome to some of those features without having to fork out for Enterprise Edition licenses or breaking any license agreements. You will leave the session with a set of solution concepts covering Partitioning, Data Compression and High Availability that you can build upon or extend and maybe save you and your company a nice pile of cash.
SessionID: 40242
Stream Analytics on premise and on the Cloud with SQL
Event Date: 12-12-2015 - Session time: 14:45:00 - Track: BI/DEV
Speaker: Marco Parenzan
Title: Stream Analytics on premise and on the Cloud with SQL
Abstract:
SessionID: 40637
The Ticking Timebombs in Your Databases
Event Date: 12-12-2015 - Session time: 14:45:00 - Track: DEV
Speaker: Karen Lopez
Title: The Ticking Timebombs in Your Databases
Abstract:
You've worked hard to build the best systems you can, and then one night you get called in to resolve a production incident. As you peer into your database, you see it: something so bad it sends shivers down your spine. How did that get in there? Who did that? Why? And how do you fix it?
In this session, we look at the workarounds, technical debt and clever designs that can cause you grief when you least expect it. We will also include perfectly fine features that can haunt you later. We will discuss how these things happen and give you tools to identify the ones that cause the most pain.
Join us: you'll keep your job, have happier users and get more rest.
SessionID: 40644
Shiny: dashboards in R
Event Date: 12-12-2015 - Session time: 14:45:00 - Track: BI
Speaker: Stephanie Locke
Title: Shiny: dashboards in R
Abstract:
SessionID: 38767
T-SQL : Bad Habits Best Practices
Event Date: 12-12-2015 - Session time: 16:00:00 - Track: DEV
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits Best Practices
Abstract:
Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
SessionID: 38926
Continuous Integration and the Data Warehouse
Event Date: 12-12-2015 - Session time: 16:00:00 - Track: BI/DEV
Speaker: John Tunnicliffe
Title: Continuous Integration and the Data Warehouse
Abstract:
- Automating your build and deployments with SQL Server Data Tools
- Auto-code generation within SSDT using T4 templates and DacFx
- Harnessing the power of BIML
- Automated Integration and Regression testing of your Data Warehouse
- Deploying and on-going management of OLAP databases using the SSAS Partition Manager
SessionID: 39164
Making PowerShell useful for your team
Event Date: 12-12-2015 - Session time: 16:00:00 - Track: DBA/DEV
Speaker: Rob Sewell
Title: Making PowerShell useful for your team
Abstract:
Making PowerShell useful for your team
You have heard about PowerShell and may be spent a little bit of time exploring some of the ways in which it will benefit you at work. You want to be able to perform tasks more specific to your organisation and need to share them with your team.
I will show you how you can achieve this by demonstrating
An easy way to learn the syntax
How to explore SQL Server with Powershell
How to turn your one off scripts into shareable functions
How to ensure that your team can easily and quickly make use of and contribute to PowerShell solutions
Where else to go for help
SessionID: 40340
Business Analytics 101: Agile Analytics using Azure Machine Learning
Event Date: 12-12-2015 - Session time: 16:00:00 - Track: BI
Speaker: Jen Stirrup
Title: Business Analytics 101: Agile Analytics using Azure Machine Learning
Abstract:
How does this change in landscape affect businesses? Are you new to the world of business analytics? Are you taking over an existing analytics program, or starting one from scratch? This session will help you to understand how to craft a strategy, provision the right business analytical capabilities, and move towards actionable results. We’ll identify common pitfalls to avoid as you start or reinvigorate your business analytics program. In particular, we’ll explore how companies are using self-service and data discovery techniques to deliver more agile analytics using Azure Machine Learning.
SessionID: 41205
Event Date: 12-12-2015 - Session time: 16:00:00 - Track: DBA
Speaker: Joseph D'Antoni
Abstract:
• Optimizing TempDB in an Azure VM
• Reducing latency between application VMs and database VMs
• Right sizing Azure VMs for performance and cost
• Striping I/O across devices in Azure VMs
• Performance Tuning in Azure DB
You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.