| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Cathrine Wilhelmsen | BI Platform Architecture, Development Administration | Biml for Beginners: Generating SSIS packages with BimlScript |
| 09:00:00 | Andrey Zavadskiy | Enterprise Database Administration Deployment | Transaction Log Internals and Troubleshooting |
| 09:00:00 | Peter Larsson | Other | Rethink Your Data Model and Make It Super Fast |
| 10:15:00 | Bob Duffy | Application Database Development | When good SQL design goes bad |
| 10:15:00 | Dr. Subramani Paramasivam | Enterprise Database Administration Deployment | Life saver - Resource Governor for applications reporting |
| 10:15:00 | Joakim Nyström | Enterprise Database Administration Deployment | A Toolkit for Off-loading Data from Production |
| 11:20:00 | David Postlethwaite | Enterprise Database Administration Deployment | Taming the Beast – How a SQL DBA can keep Kerberos under control |
| 11:20:00 | Raoul Illyes | Enterprise Database Administration Deployment | SQL Automation, how to build a highly automated SQL Server environment |
| 11:20:00 | Håkan Winther | Application Database Development | How to kill SQL server performance |
| 11:20:00 | Mike Byrd | Application Database Development | SQL Server Foreign Keys – De-mystifying the Rest of the Story |
| 13:40:00 | Rob Volk | Enterprise Database Administration Deployment | Revenge: The SQL! - Director's Cut |
| 13:40:00 | Elvis Talic | BI Platform Architecture, Development Administration | Many to Many in SSAS: How To Implement It |
| 13:40:00 | Steinar Andersen | Enterprise Database Administration Deployment | SQL Server Magic Buttons: What are Trace Flags, and why should I care? |
| 14:55:00 | Rasmus Reinholdt | BI Platform Architecture, Development Administration | Building a meta-driven near realtime ETL solution with BIML and SSIS |
| 14:55:00 | Rodney Landrum | BI Platform Architecture, Development Administration | Analytics and the DBA – Using BI Power tools to visualize your SQL Infrastructure |
| 14:55:00 | John Martin | Enterprise Database Administration Deployment | SQL Server 2016 AlwaysOn Availability Groups - New Features Enhancements |
| 16:00:00 | David Williams | Enterprise Database Administration Deployment | SQL Server 2016 New Feaures (Not Query Store!) |
| 16:00:00 | David Söderlund | BI Platform Architecture, Development Administration | Using and improving Azure Machine Learning models with SSIS |
| 16:00:00 | Magnus Ahlkvist | Application Database Development | Eight hours of work in 20 minutes |
Event Date: 05-09-2015 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
In this session I will use the free BIDS Helper add-in to show you the basics of Biml and BimlScript, how to generate SSIS packages automatically from databases, how easy those packages can be changed, and how to move common code to separate files that can be included where needed. See why they say Biml allows you to complete in a day what once took more than a week!
This session is intended for SSIS developers who are not yet familiar with Biml.
Event Date: 05-09-2015 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
We examine the common issues such as full transaction log, how to get rid of multiple log files and shrink the log file, and solve the log fragmentation problem. Also we take a glance at new features of SQL Server 2014 for transaction log management.
Event Date: 05-09-2015 - Session time: 09:00:00 - Track: Other
Event Date: 05-09-2015 - Session time: 10:15:00 - Track: Application Database Development
In this humorous session I’ll be debating 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. •When you should NOT use stored procedures. •When we don’t need indexes. •When Clustered Tables are bad. •When Identity Columns should not be Primary Keys. •When we don’t care about fragmentation. •When good naming convention’s go bad. •Why Partitioning often makes your queries slower. •Why do ORMs really makes sense when they make all your parameters nvarchar (max)
Health Warning: These may not be the design tips you should be using on your production OLTP.
Event Date: 05-09-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
What does Resource Governor do? What is a resource Pool? Why any basic/intermediate users are given caution before implementing Resource Governor? What is this capable of doing in terms of allocating resources to the users, databases and applications? What are the methods to implement Resource Governor how to monitor the resource pools in terms of GUI T-SQL?
You can take away working scripts, functions, tools to make a Resource Governor work and manage them.
Event Date: 05-09-2015 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
SQL Server comes with many tools that, when properly used, can make your life a whole lot more easy; some of which are: SQLCMD scripting, the Change Tracking system, Transactional Replication and the MERGE command. In this session you will be presented to a simple toolkit that will utilize these tools to set up synchronization of your production data to an offline database in a way that is easy to configure and manage. The toolkit contains a very small number of T-SQL and SQLCMD scripts together with a “How to” instruction. Best of all – it#180;s available in Standard edition!
Event Date: 05-09-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment
What should be a straight forward and simple process can lead to all sorts of issues and trying to resolve them can turn into a nightmare. This talk looks at the principle of Kerberos, how it applies to SQL Server and what we need to do ensure it works
Event Date: 05-09-2015 - Session time: 11:20:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-09-2015 - Session time: 11:20:00 - Track: Application Database Development
This session is about how you can kill the SQL server Performance so that you can justify the budget for your new cool hardware, or to find out what is wrong with your SQL Server so you don't need to buy new expensive hardware and make you the hero of the day. During the session we will look at some common performance issues, tools to investigate whats the problem and how to solve it. Prepare for few Power Point slides and lots of code samples.
Event Date: 05-09-2015 - Session time: 11:20:00 - Track: Application Database Development
Event Date: 05-09-2015 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
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: 05-09-2015 - Session time: 13:40:00 - Track: BI Platform Architecture, Development Administration
In this session, you will learn step by step on how to implement many to many in SSAS. In addition, you will learn the benefits of using many to many, plus some real life examples of the implementation.
After this session, you will have better understanding of many to many in SSAS, plus you will be able to solve some of common business problems that arise daily.
Event Date: 05-09-2015 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment
In this session you will get a good overview of what Trace Flags can do for you, the risks and benefits, and how you should approach bringing them in to your production environment. Then of course there will be a deep dive in to some of the most useful and interesting ones. Since there is a lot more information to this subject than can be covered in one hour, there will be an extensive list of online resources included.
Event Date: 05-09-2015 - Session time: 14:55:00 - Track: BI Platform Architecture, Development Administration
Topics covered in the session
Event Date: 05-09-2015 - Session time: 14:55:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-09-2015 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-09-2015 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment
Event Date: 05-09-2015 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 05-09-2015 - Session time: 16:00:00 - Track: Application Database Development
The presentation also includes some reflections on how partitioning the table has changed how both T-SQL and Entity Framework code is being written, to take advantage of partition elimination.