| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:10:00 | Niels Berglund | Application Database Development | Real World Error Handling in SQL Server |
| 09:10:00 | Sean Cremer | Professional Development | Dynamic Management Views and Functions - a Practical Overview |
| 09:10:00 | Peter Willmot | Application Database Development | Designing and Building SQL Database Apps for IoT Scenarios |
| 10:10:00 | Gary Hope | Analytics and Visualization | Microsoft Steam Analytics and Real-Time Data Visualisation |
| 10:10:00 | Arnie Rowland | Application Database Development | RC, SI, and RCSI, Oh My! –We're off to see the Wizard -to understand how it all works. |
| 10:10:00 | Gail Shaw | Enterprise Database Administration Deployment | All about Execution Plans |
| 11:10:00 | Steve Simon | Analytics and Visualization | Business Analytics with SQL Server Power Map:Everything you want to know but were afraid to ask |
| 11:10:00 | Clinton van Blommestein | Application Database Development | tSQLt - Database Unit Testing |
| 13:00:00 | Steve Simon | Advanced Analysis Techniques | Efficient and Effective coding of Stored Procedures |
| 13:00:00 | Gail Shaw | Enterprise Database Administration Deployment | Backups? What backups? |
| 13:00:00 | Michael Johnson | BI Platform Architecture, Development Administration | Automating your data-warehouse development with BIML |
| 14:00:00 | Gary Hope | Advanced Analysis Techniques | Microsoft Machine Learning Overview |
| 14:00:00 | Gail Shaw | Enterprise Database Administration Deployment | Lies, Damned Lies And Statistics |
| 14:00:00 | Niels Berglund | Application Database Development | What's New for SQL Developers in SQL Server 2016 |
| 15:00:00 | Steve Simon | Information Delivery | SQL Server Reporting Services 2014 on Steroids!! |
| 15:00:00 | Trevor Makoni | Application Database Development | Dynamic SQL, not so scary? |
| 15:00:00 | Arnie Rowland | Strategy and Architecture | Query Performance QA |
Event Date: 19-09-2015 - Session time: 09:10:00 - Track: Application Database Development
However, in the "real world" it may not be so straight forward as just using this new error handling. As we at Derivco have seen there are quite a few "gotchas" when it comes to how to handle errors. In this session we will take a look and see what issues we have to be aware of, in order not to be bitten by our error handling.
Event Date: 19-09-2015 - Session time: 09:10:00 - Track: Professional Development
This session will cover the more commonly used Dynamic Management Views and introduce the new ones that will be coming in 2016.
Event Date: 19-09-2015 - Session time: 09:10:00 - Track: Application Database Development
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Analytics and Visualization
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Application Database Development
Event Date: 19-09-2015 - Session time: 10:10:00 - Track: Enterprise Database Administration Deployment
This full day session focuses on the execution plan. We'll look at the compile process, how and why plans are stored in cache and how they are removed.
We’ll spend time exploring the key differences between actual and estimated plans, and why those descriptions are more than a little misleading. We’ll also show you assorted methods to obtain a query's execution plan and what the differences and tradeoffs of each are.
We'll look at where to find useful information in execution plans, what the common operators are and how to decipher the sometimes cryptic messages the plans are sending to you. We'll also debunk some myths surrounding query operators and execution plans, and we'll show how you can use the execution plan to identify performance issues and other query problems.
Event Date: 19-09-2015 - Session time: 11:10:00 - Track: Analytics and Visualization
In the hands-on presentation we shall be constructing a few simple analytic reports (from background financial data). More importantly we shall see how our conclusions help us target new prospective business opportunities.
Event Date: 19-09-2015 - Session time: 11:10:00 - Track: Application Database Development
Or you are that lucky person that has to make changes to business critical code, where a mistake can put you on a fist name basis with the CEO.
Sure, we have testing departments that will check our code, and some of us have to test our code ourselves. But you might still end up lying awake at night wondering about that edge case scenario.
Testing takes time, and database tables have foreign keys and constraints and all sorts of other things that make it hard to get the system into a specific state. Then you change your code and have to do it all over again.
tSQLt allows you to prepare your database for a test, and once the test is run the database is set back like nothing happened. All that remains is whether your test succeeded.
We will go through setting up the framework, how to write tests and run them - either manually or as part of your build process
Event Date: 19-09-2015 - Session time: 13:00:00 - Track: Advanced Analysis Techniques
In this hands-on presentation, we shall be looking at best practices with regards to creating and tuning stored procedures. We shall also be discussing parameter sniffing and other gotcha’s that affect us in our daily lives.
Event Date: 19-09-2015 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
In this introductory session, we’ll look at backups, backups and more backups (because there’s no such thing as too many backups)
We’ll look at full backups, what they are and how often they should be run. We’ll look at differential backups, how they fit into backup strategies and the pitfalls you may encounter when using them. We’ll look at transaction log backups, at why they are an essential part of the backup strategy for important databases and at what happens when transaction log backups go wrong.
Event Date: 19-09-2015 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 19-09-2015 - Session time: 14:00:00 - Track: Advanced Analysis Techniques
Event Date: 19-09-2015 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment
In this session well take a look at what statistics are and why SQL keeps them; at how SQL maintains them and under what circumstances that maintenance is insufficient; and well look at the problems that result when they are inaccurate.
Finally we'll cover some suggestions and options around maintenance of statistics when the automatic maintenance is not sufficient.
Event Date: 19-09-2015 - Session time: 14:00:00 - Track: Application Database Development
Things we will look at is: improvements to In-Memory OLTP (the "artist" formerly known as Hekaton), Operational Analysis - how to combine OLTP processes together with the ability to analyse the data at the same time, new JSON support and other odd and "sundry" things
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: Information Delivery
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: Application Database Development
I will be looking at the specific example of an application runtime need to import all or a subset of database objects tables, views, functions, procedures, triggers from one database to another.
I will also look at how to store the result of a SQL select into a .NET Data Table object and then to XML and then the reverse of picking up the XML and then recreating the dataset back to SQL.
Event Date: 19-09-2015 - Session time: 15:00:00 - Track: Strategy and Architecture
Or perhaps better understand why sometimes it just doesn't seem to work the way you hope? Maybe you have questions about specific queries in your environment?
Bring your questions and desire for knowledge to this free flowing QA Session and let one of the top SQL Server Query Performance Specialists offer suggestions and advice.
No Powerpoint. No 'canned' demos. Just a conversation about your 'real world' problems and how you might go about improving performance. Don't miss this opportunity.