Event Date: 23-07-2016 - Session time: 09:45:00 - Track: Business Intelligence
Event Date: 23-07-2016 - Session time: 09:45:00 - Track: Database Development
Then you should look at database testing but what is database testing? What are unit tests? Integration tests? Acceptance tests? How do you get started and keep going with automated testing?
In this session we will answer these questions and give examples of how to test database code and some of the challenges you will face along the way.
Whether you are completly new to developer testing or have been been "a mocking and asserting" in c# or java for years this session will get you started writing tests for your database code.
Event Date: 23-07-2016 - Session time: 09:45:00 - Track: Database Engine
Event Date: 23-07-2016 - Session time: 09:45:00 - Track: PowerShell
We will cover Functions, Aliases, Help Topics, Modules, Cmdlets, Objects, Methods and Properties and how understanding these different aspects makes your time in PowerShell much simpler to get to grips with and can really help you adopt the language in a much more efficient way going forward.
This session should leave you with a greater understanding of the PowerShell Language and give you the ability to go and discover more of the language and how it works.
Event Date: 23-07-2016 - Session time: 09:45:00 - Track: Azure
Event Date: 23-07-2016 - Session time: 11:05:00 - Track: Business Intelligence
Session objectives: #183; Enable OLAP and tabular analytics against SQL DW #183; Provide technical configuration to get the best from SSAS when connecting to SQL DW #183; Recommendations for process and approach #183; Optimize OLAP and SQL DW for performance
Event Date: 23-07-2016 - Session time: 11:05:00 - Track: PowerShell
The 6 P's are usually Proper Prior Preparation Prevents Poor Performance. The Powershell profile is a powerful tool that can provide a perfect Powershell scripting environment. It runs on start up preparing your editor for the purposes and processes that you intend to produce If you use Powershell you should be making use of your profile and in this beginners session I will show you how you can start making your Powershell environment work even better for you
Event Date: 23-07-2016 - Session time: 11:05:00 - Track: Database Engine
Event Date: 23-07-2016 - Session time: 11:05:00 - Track: Database Development
New T-SQL functions offer out-of-the-box solutions for many problems that previously required complex workarounds. Paging, Running totals, Moving aggregates, YTD, and much more comes at the power of your fingertips in SQL Server 2012. The only thing you need to do is learn the syntax. And that is exactly what this session is all about: a thorough description and explanation of the syntax, and loads of demos to demonstrate how you can use all these new features. Attend this session to boldly take SQL Server where it has never gone before!
Event Date: 23-07-2016 - Session time: 11:05:00 - Track: Azure
IoT solutions very often are not a one way street. Having devices send their data to the cloud is great but often you need the cloud to talk back to your device.
OK so our data is in the cloud but now what? What do we do with it? What can we do with it?
This session is going to show you how to solve all of these things. It is going to be heavy on demos and will build the solution in stages so nobody gets lost. We'll use a mixture of technologies all of which are available in Azure.
Come to the session to learn more.
Event Date: 23-07-2016 - Session time: 12:45:00 - Track: Business Intelligence
Event Date: 23-07-2016 - Session time: 12:45:00 - Track: Database Development
Event Date: 23-07-2016 - Session time: 12:45:00 - Track: Azure
Event Date: 23-07-2016 - Session time: 12:45:00 - Track: Database Development
With the rise of Cloud, with hosted virtual machines and Azure SQL DB, adding to the mix of on-premises physical and virtual machines, having one tool that can give you this single view is vital.
Monitoring enables you to understand where you have pain points and allows you to make the most out of these disparate systems. With SQL Sentry tools we can monitor every type of SQL Server wherever it resides; AWS Virtual Machines, Azure SQL DB, in your Datacenter, or hosted in Rackspace.
Join us as we help you understand what, and how SQL Sentry can help you get the most from your SQL Server Data Platform, wherever it is.
Event Date: 23-07-2016 - Session time: 13:30:00 - Track: Database Engine
In this session we'll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We'll start by gaining access to a SQL Server (using some creative ways of making man-in-the-middle attacks, and other ways), escalating priviledges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), and more. Most importantly, we'll also cover recommendations on how to avoid these attacks. This is a demo-driven session, suited for DBAs, developers and security consultants (Jedi level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Event Date: 23-07-2016 - Session time: 13:30:00 - Track: PowerShell
I have written Powershell scripts to deploy and manage them across multiple servers. While building this I had to use more Powershell tips and tricks then I thought I would need. I would like to share these lessons learned with you. Do you like Powershell and Ola Hallengrens scripts? Then do not miss this session
Event Date: 23-07-2016 - Session time: 13:30:00 - Track: Azure
When and why to choose a Big Data solution, how the technologies fit together, why choose one over the other.
Event Date: 23-07-2016 - Session time: 13:30:00 - Track: Business Intelligence
You will learn: •To identify the different error handling methods in control flow, data flow, and script tasks •Be able to utilize event handlers to proactively handle errors •Be able to redirect data error and proactively handle data flow errors •Be able to identify error descriptions and log error details
Event Date: 23-07-2016 - Session time: 13:30:00 - Track: Database Development
However, you still haven’t written as many automated tests as you know you should and you aren’t convinced you’re going about it the right way. You haven’t really looked at the build functionality in VSTS yet or gotten to grips with build servers like TeamCity or Jenkins, and even if you have you aren’t sure how the process should work for SQL Server builds and tests.
In this session I’ll explain how to use tSQLt to build a suite of automated tests to give you confidence in the quality of your code. Then I’ll talk through various ways to automate your database builds and run those tests on some schedule or trigger. I’ll also discuss the pros and cons of various different approaches so that you can understand
Event Date: 23-07-2016 - Session time: 14:45:00 - Track: Database Engine
These new features have the potential to really improve application security, especially in compliance scenarios. Pushing the security restrictions down into the database layer has many benefits, notably only the data needed leaves the database. But there are a number of gotchas that you need to be aware of that can really mess up performance if you get them wrong.
In this session we will look at how you can get the most out of these features and retain the performance of your system.
Event Date: 23-07-2016 - Session time: 14:45:00 - Track: Azure
Event Date: 23-07-2016 - Session time: 14:45:00 - Track: Database Development
We will cover:
If you write, debug or modify SQL Server database code and haven't yet started using SSDT full time then this session will help you get started and be productive quickly.
Event Date: 23-07-2016 - Session time: 14:45:00 - Track: PowerShell
This is a session where there will be chance to follow along (if you bring your own laptop) and learn in real time from the co-ordinator of the UK PowerShell User Groups - however you will also be lead to further community resources if you require further time after the session to get this built into your current day to day workflow.
As this session will be focused towards SQL Professionals we will take a look at SQL Specifics that can be used within PowerShell Scripts Unit Testing.
Event Date: 23-07-2016 - Session time: 14:45:00 - Track: Business Intelligence
Event Date: 23-07-2016 - Session time: 16:00:00 - Track: Database Development
You now have answers to these questions and thanks to Microsoft for integrating R Revolution within new SQL Server 2016. We all now have the opportunity to use R packages and see the results within SQL 2016.
In this session, you will definitely take away a breakthrough concept of Advanced R Analytics within SQL 2016 and get ready to kick your creative horse, and go beyond your imagination on how you can build advanced analytics and impress your employers/customers.
Event Date: 23-07-2016 - Session time: 16:00:00 - Track: Business Intelligence
Wait a second. Yes it is has never been easier to add the “wow” factor to presentations based on data. However there are still techniques, tricks and traps that you need to know if you are going to leave your audience impressed with your insights rather than drowning in your data. This session takes you through the use and limitations of all the visualizations that come out-of-the-box with Power BI, as well as a quick tour of many of the custom visuals that are now available. You will see which type of delivery is best suited to which kind of data. You will also learn how best to structure and adapt the Power BI data model so that it can feed into the different visualizations for maximum effect.
Event Date: 23-07-2016 - Session time: 16:00:00 - Track: Database Engine
Event Date: 23-07-2016 - Session time: 16:00:00 - Track: PowerShell
Most DBAs are probably using unattended installs followed by a bunch of post configuration scripts make sure our SQL Server instances are production ready. We will take a look at how Powershell DSC works, and how this can be used by DBAs to install, configure and manage SQL Servers. We will try to answer questions like:
How does Powershell DSC work How would a DBA use Powershell DSC Are the resources to manage SQL Server mature enough
After this session you are better equiped to decide if Powershell DSC is useful for you, now or in the near future.
Event Date: 23-07-2016 - Session time: 16:00:00 - Track: Database Development
Do you believe the people who claim that these statements are myths? Or do you prefer to form your own opinion? If you take database design seriously, you cannot afford to miss this session. You will get a clear and easy to understand overview of all the higher Normal Forms: what they are, how to check if they are met, and what consequences their violations can have. This will arm you with the knowledge to reject the myths about higher Normal Forms. But, more important: it will make you a better designer!