Event Date: 18-06-2016 - Session time: 08:30:00 - Track: DEVOPS
In this presentation we will have wall to wall demos on creating, configuring, connecting, using, securing, monitoring, uploading, scheduling and syncing your SQL Azure database.
We will specifically cover
•Linked Servers •Mobile App WebJobs •Azure Automation •Monitoring and Alerts •Firewall Rules •Dynamic Data Masking •Always Encrypted •Stretch Tables •DACPACs and BACPACs
By the end of this sessions you will some way to becoming an Azure Jedi
Event Date: 18-06-2016 - Session time: 08:30:00 - Track: DBA
Event Date: 18-06-2016 - Session time: 08:30:00 - Track: BI
If you apply Microsofts strategy Cloud First Mobile First to Microsoft BI you may wonder where you find the right direction on Mobile BI in this strategy. In the last years the mobile part was somehow in the fog. This session will jump into the jungle of different approaches and will deliver a clear and understandable Matrix, when you should use what and how it may or may not meet your expectations. We will review the different toolsets under Self-Service and Corporate BI Standards and of course we also check the mobile device shop to see, which offering fits best on the Hardware available.
Event Date: 18-06-2016 - Session time: 09:40:00 - Track: BI
We'll take a high level look at the available Azure services, discussing what their capabilities are and how they fit together. Covering Azure Data Factory, Data Lake, Table Storage, Blob Storage, U-SQL, HDInsight, SQL Data Warehouse, Machine Learning, Power BI, Event Hub, Stream Analytics and more.
Event Date: 18-06-2016 - Session time: 09:40:00 - Track: DBA
In this presentation, I'll cover the reasons companies migrate, the ways SQL migrations are usually performed, and the considerations that must be made when performing a migration.
Then I'll show you how to use the PowerShell dbatools module to simplify your SQL Server migrations. dbatools makes migrating databases, logins, linked servers, credentials, jobs, database mail, and other essential SQL components extremely easy.
Event Date: 18-06-2016 - Session time: 09:40:00 - Track: DEVOPS
Event Date: 18-06-2016 - Session time: 10:50:00 - Track: DBA
A working knowledge of Dynamic Management Objects, indexing internals, and eagerness to experiment with metadata is a prerequisite!
Event Date: 18-06-2016 - Session time: 10:50:00 - Track: BI
Event Date: 18-06-2016 - Session time: 10:50:00 - Track: DEVOPS
You will therefore be taken through the concept of in-memory tables and what to be aware of when considering converting your database tables and code to In-Memory tables and through a life migration demo be given all the tips and tricks I picked up while doing so. After attending this session, you will be able to leverage on the new concepts and work your way around its current limitations to gain enormous speed increase and a lock-free environment.
Event Date: 18-06-2016 - Session time: 12:40:00 - Track: DBA
In SQL Server 2005, two optimistic concurrency mechanisms were introduced and touted as the solution to all our problems. Now in SQL Server 2012, 2014 and 2016 even more have followed, but many challenges and problems still remain. Let’s take a long look into the world of SQL Server concurrency and investigate Pessimistic and Optimistic isolation understanding how they work, when you should use them, and more importantly when they can go very wrong. Don't be staring down the wrong end of SQL Server's two Smoking Barrels and join me for this revealing and thought provoking presentation.
Event Date: 18-06-2016 - Session time: 12:40:00 - Track: BI
Event Date: 18-06-2016 - Session time: 12:40:00 - Track: DEVOPS
Crash recovery is hard to get right; as evidence ten-year gap between the release of commercial database products, System R and DB2 and the development of a working crash recovery algorithm. Even after it was invented, another five years passed before the algorithm was proven correct. Modern day Database owners and administrators have to navigate trough a horde of backup methodologies and false promises in order to preserve data. In this lecture we will cover many of the modern day database data protection technologies, and there pros and cons.
Event Date: 18-06-2016 - Session time: 13:50:00 - Track: DEVOPS
Event Date: 18-06-2016 - Session time: 13:50:00 - Track: BI
It is time to bring the Don't Repeat Yourself (DRY) software engineering principle to SSIS projects. First learn how to use Biml and BimlScript to generate SSIS packages from database metadata and implement changes in all packages with just a few clicks. Then take the DRY principle one step further and learn how to update all packages in multiple projects by separating and reusing common code.
Speed up your SSIS development by using Biml and BimlScript, and see how you can complete in a day what once took more than a week!
Event Date: 18-06-2016 - Session time: 13:50:00 - Track: DBA
In this session we’ll take a look at what the QueryStore is and how it works, before diving into a scenario where overall performance suddenly degraded, and we’ll see why QueryStore is the best new feature in SQL Server 2016, bar none.
Event Date: 18-06-2016 - Session time: 15:00:00 - Track: DEVOPS
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
Event Date: 18-06-2016 - Session time: 15:00:00 - Track: DBA
You create a vm in Azure and size it to match your local system and move your database into it. This might not be the most cost effective way though and also, you still have to do all the database maintenance yourself. In this session we will investigate how we could use more of the cloud features like SQL Database, Redis Cache, Search, etc. in order to truly scale our system. And we'll see if this increases or lowers the total cost of ownership. This excercise is about an OLTP system but we will also look at how it affects loading our DWH from this new setup.
Event Date: 18-06-2016 - Session time: 15:00:00 - Track: BI