Nr: 372
SQLSaturday #372 - Exeter 2015
SessionID: 9211
The elephant in the room: Continuous Delivery for Databases
Event Date: 25-04-2015 - Session time: 00:00:00 - Track: Other
Speaker: Alex Yates
Title: The elephant in the room: Continuous Delivery for Databases
Abstract:
Let’s talk about constraints. What’s holding you back from achieving Continuous Delivery?
Databases.
If it’s painful, do it often... Your app is automatically integrated, tested and packaged for deployment in minutes. But what about databases?
Of course, databases come with complications and risks. We’ll talk about both the human and technical changes which are necessary to achieve a reliable, nimble, and automated database deployment process.
You’ll learn how to bring Dev and Ops closer together as well as customize established practices and existing toolsets to build a database deployment pipeline and speed up delivery while at the same time protecting the data (and your sanity).
There will be four example scenarios to choose from based on four different technology stacks - so for the demo you can vote on your favourite tooling!
By the end of the session, delegates will have learned that the elephant in the room is now: ‘Why aren’t we doing Continuous Delivery for d
SessionID: 13548
Analizing Text with SQL Server 2014 and R
Event Date: 25-04-2015 - Session time: 08:00:00 - Track: Track 01
Speaker: Dejan Sarka
Title: Analizing Text with SQL Server 2014 and R
Abstract:
Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. Free statistical package / language R is also useful for the text mining tasks. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with the tools mentioned.
SessionID: 13657
Practical advice on how to get started using source control, ssdt and ci
Event Date: 25-04-2015 - Session time: 08:00:00 - Track: Track 2
Speaker: Ed Elliott
Title: Practical advice on how to get started using source control, ssdt and ci
Abstract:
Being more agile sounds like the right thing to do, unit testing, source control even SSDT should help to make us Sql Developers more productive and happier but how do we actually do it?
This is a talk about how to start with an existing database and drag it kicking and screaming into source control.
We will cover what practical choices of IDE there are and how to use them to help, rather than hinder the development process.
In a nutshell, how do we become more agile on our Sql development!
SessionID: 22144
Run your DBA morning checklist with policy based management while sipping coffee
Event Date: 25-04-2015 - Session time: 08:00:00 - Track: Track 3
Speaker: Pieter Vanhove
Title: Run your DBA morning checklist with policy based management while sipping coffee
Abstract:
SessionID: 27041
You did WHAT to my transaction log?!
Event Date: 25-04-2015 - Session time: 08:00:00 - Track: Track 4
Speaker: Tony Davis
Title: You did WHAT to my transaction log?!
Abstract:
You won't believe what people will do to the transaction log when they get into trouble. The log is full! The application is experiencing strange errors! Do something! In this session, I will apply commonly suggested advice from internet search results and various forums, in search of a fast remedy for explosive log growth. How bad could it be?! Fortunately, once you understand what the transaction log looks like, how SQL Server uses it to guarantee database consistency, and the factors that can prevent reuse of log space, the dangers of 'quick fix' advice will become readily apparent, as will the right way to diagnose and fix a full log file. Note: no production servers will be harmed during this presentation.
SessionID: 36208
Loading Dimensions with SSIS
Event Date: 25-04-2015 - Session time: 08:00:00 - Track: Track 3
Speaker: Prathy Kamasani
Title: Loading Dimensions with SSIS
Abstract:
SessionID: 18786
Certification and IT Career - Self Case Study
Event Date: 25-04-2015 - Session time: 09:00:00 - Track: Track 3
Speaker: Tobias Koprowski
Title: Certification and IT Career - Self Case Study
Abstract:
SessionID: 18260
Introduction to Execution Plans
Event Date: 25-04-2015 - Session time: 09:25:00 - Track: Track 4
Speaker: Kevan Riley
Title: Introduction to Execution Plans
Abstract:
SessionID: 35931
Agile BI
Event Date: 25-04-2015 - Session time: 09:25:00 - Track: Track 01
Speaker: Stephanie Locke
Title: Agile BI
Abstract:
Agile methodologies are widely used in the dev world and are becoming increasingly adopted in the database world. But what about BI?
Covering the technology and process sides of enabling agile BI, this session is designed to give you practical tips to get things moving more quickly for you.
SessionID: 9324
Azure Data Factory - The New SSIS?
Event Date: 25-04-2015 - Session time: 09:25:00 - Track: Track 2
Speaker: Allan Mitchell
Title: Azure Data Factory - The New SSIS?
Abstract:
For a long time people have been asking where is SSIS for the cloud. Truth is it was never going to happen. Azure Data Factory has been designed from the ground up. It is designed for moving data at scale and with agility. Come to this session to learn about this new service and how it come provide value to your business processes
SessionID: 11237
Biml for Beginners: Generating SSIS packages with BimlScript
Event Date: 25-04-2015 - Session time: 10:45:00 - Track: Track 01
Speaker: Cathrine Wilhelmsen
Title: Biml for Beginners: Generating SSIS packages with BimlScript
Abstract:
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.
SessionID: 12847
Statistics, Estimation Plan Caching - The Big Three
Event Date: 25-04-2015 - Session time: 10:45:00 - Track: Track 4
Speaker: David Morrison
Title: Statistics, Estimation Plan Caching - The Big Three
Abstract:
In this session we will take an in depth look at statistics, how they are built, stored and used. We will go over why they are so important and what role they play in selecting a query plan. We will also take a look into estimation and how this affects query plan selection and how estimation and statistics tie together.
Also in this session we will take a look into plan caching, what it is, why it is done and how it can be both a help and a hindrance.
Using lots of demos and examples attendees will leave the session with a greater understanding of these three key areas and also the tools and techniques to work with and understand them in their own enviroments
SessionID: 15656
Database Partitioning - Part I
Event Date: 25-04-2015 - Session time: 10:45:00 - Track: Track 3
Speaker: James Skipwith
Title: Database Partitioning - Part I
Abstract:
In Session One: - Just what is database partitioning? - Do I even need it? - So what can be done in Standard edition? Knowledge is power and after these sessions those big tables won’t be so scary anymore. They can be tamed and will soon be purring like a kitten. It’s never all pain-free sailing partitioning large live tables but, armed with the correct knowledge, you can start planning and implementing your partitioning. Sweet.
SessionID: 21124
Making PowerShell useful for your team
Event Date: 25-04-2015 - Session time: 10:45:00 - Track: Track 2
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: 15657
Database Partitioning - Part II
Event Date: 25-04-2015 - Session time: 11:45:00 - Track: Track 3
Speaker: James Skipwith
Title: Database Partitioning - Part II
Abstract:
In Session Two: - And what can be done in Enterprise edition? - Is it useful for Data warehouses and SSAS Cubes? - And what’s new in SQL 2014? Knowledge is power and after these sessions those big tables won’t be so scary anymore. They can be tamed and will soon be purring like a kitten. It’s never all pain-free sailing partitioning large live tables but, armed with the correct knowledge, you can start planning and implementing your partitioning. Sweet.
SessionID: 23523
Event Date: 25-04-2015 - Session time: 11:45:00 - Track: Track 01
Speaker: Rasmus Reinholdt
Abstract:
Topics covered in the session
- BIML SSIS
- MDS
- System SPs (especially sp_depends)
- Near Real-time reporting, what it takes and how to do it.
SessionID: 26061
SharePoint Databases - What you need to know
Event Date: 25-04-2015 - Session time: 11:45:00 - Track: Track 2
Speaker: Al Eardley
Title: SharePoint Databases - What you need to know
Abstract:
An introduction to the different databases that SharePoint uses, with recommendations for High Availability, Disaster Recovery and configuration settings for SQL Server, including the constraints imposed in a single farm, a stretched farm between data centres and a separate DR farm.
SessionID: 34860
Top Down Tuning
Event Date: 25-04-2015 - Session time: 11:45:00 - Track: Track 4
Speaker: Richard Douglas
Title: Top Down Tuning
Abstract:
Lots of emphasis is placed upon fixing long running queries and reports, but what if you’re running third party applications, what then? In this session Richard Douglas will walk you through a number of options and procedures you should be following to allow your SQL Server to run more optimally. This is “Top Down Tuning” where the emphasis is placed on how you can make things better for all your users rather than SELECT TOP 3 Users FROM dbo.Company ORDER BY Importance DESC (That’s T-SQL for a selected few).
SessionID: 36485
The first step towards continuous integration for SQL Server
Event Date: 25-04-2015 - Session time: 13:05:00 - Track: Other
Speaker: Alex Yates
Title: The first step towards continuous integration for SQL Server
Abstract:
Continuous integration (CI) is a development practice that has become widely adopted for the application layer because it allows teams to detect problems quickly and locate errors more easily. By regularly integrating code into a shared repository and automatically verifying it you'll build confidence in your code.
But database CI continues to be a painful, manual process in many projects. Redgate supports developers through the first steps in setting up databases CI and in this session, I will show you:
-How easy it is to get your SQL Server database changes in source control using Redgate’s SQL Source Control.
-How to set up an automated build process for your databases using the DLM Automation Suite and Team City.
-How this process helps you spot and fix errors quicker.
-How to produce an artifact you can use for reliable, repeatable deployments in the future.
One lucky session attendee will also win a licence of SQL Source Control.
SessionID: 12092
Session Details not available
Event Date: 25-04-2015 - Session time: 14:00:00 - Track: Track 01
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 22712
SQL Server 2014 Features EVERYONE Can Use
Event Date: 25-04-2015 - Session time: 14:00:00 - Track: Track 4
Speaker: Lord Richard Douglas
Title: SQL Server 2014 Features EVERYONE Can Use
Abstract:
You love technology and have a passion to get things done, so when a new release of SQL Server comes out you’re ecstatic! Unfortunately your employer’s budget can’t stretch to the premium Enterprise edition and all the new sessions are showing Enterprise only features.
Don’t worry, in this session Richard Douglas will show you all the new features available in the Standard and Business Intelligence Editions that EVERYONE can benefit from.
After this session you will be able to outline why you need to upgrade to the latest edition of SQL Server as well as the benefits and how they can improve your business.
SessionID: 36185
Machine Learning without a PhD in statisitcs
Event Date: 25-04-2015 - Session time: 14:00:00 - Track: Other
Speaker: Andrew Fryer
Title: Machine Learning without a PhD in statisitcs
Abstract:
Machine learning is the science of making computers act without being unambiguously programmed. Machine learning (ML) is something that we use every day when we search and shop on the web and talk to our devices. Microsoft Azure ML is a fully-managed cloud service that enables data aware developers to efficiently embed predictive analytics into their applications, without a PhD in statistics helping organizations use massive data sets and bring all the benefits of the cloud to machine learning. So join Andrew for a practical insight into the fascinating world of Machine Learning, where you can be significantly different but never certain, deviation is normal, and you are amongst friends if you found the above quote funny.
SessionID: 24800
SQL Server and Application Security for Developers
Event Date: 25-04-2015 - Session time: 15:20:00 - Track: Track 3
Speaker: Mladen Prajdić
Title: SQL Server and Application Security for Developers
Abstract:
A lot of companies have a philosophy of "ship early with as many features as possible.” Security is an afterthought since it isn't fun to do and no one will attack them anyway. However, the dark side never sleeps, and security breaches have always happened, often leaving companies severely exposed or even bankrupt.
In this session we'll look at a few attack vectors that can be used against your company, and what you as a developer can and should do to protect against them. It will involve a good mix of security conscious SQL Server and application development, because you care about your work and nobody messes with you.
SessionID: 26101
SSRS Inception: Reporting on Reporting services.
Event Date: 25-04-2015 - Session time: 15:20:00 - Track: Track 01
Speaker: Terry McCann
Title: SSRS Inception: Reporting on Reporting services.
Abstract:
Wouldn't it be great if you could see who is viewing a report, in what format and how often, all inside your current SSRS environment? With this data wouldn't it then be even better if we could automate a process to email the owner of that report to say "HA! I told you no one looked at this report!". In this session we will look at how we can do all of this and more by mining the SSRS DB.
SessionID: 28218
Stories from the Trenches: Upgrading SQL with Minimal Downtime
Event Date: 25-04-2015 - Session time: 15:20:00 - Track: Track 2
Speaker: William Durkin
Title: Stories from the Trenches: Upgrading SQL with Minimal Downtime
Abstract:
SQL Server has come a long way in the last few years, with Microsoft investing heavily in High Availability features. This session will show you how to use these features to enable you to safely upgrade a SQL Server, while ensuring you have a return path if things should go wrong. You will leave the session knowing what features you can use to upgrade either the OS, Hardware or SQL Server version while keeping your maintenance window to a minimum. The session will apply to Standard Edition as well as Enterprise Edition, so doesn't only apply to "High Rollers"!
SessionID: 9467
Event Date: 25-04-2015 - Session time: 15:20:00 - Track: Track 4
Speaker: André Kamman
Abstract:
SessionID: 10571
When good SQL design goes bad
Event Date: 25-04-2015 - Session time: 16:20:00 - Track: Track 2
Speaker: Bob Duffy
Title: When good SQL design goes bad
Abstract:
Take what you’ve learned about SQL Server and turn it upside down.
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.
SessionID: 17283
Microsoft SQL Server AlwaysOn in a Multi-Site world
Event Date: 25-04-2015 - Session time: 16:20:00 - Track: Track 3
Speaker: John Martin
Title: Microsoft SQL Server AlwaysOn in a Multi-Site world
Abstract:
Covering things like Asymmetric storage configurations, DNS considerations and the advances in clustering. By the end of this session, you will be in a position to confidently start building out multi-site Highly Available and ef
SessionID: 21386
Event Date: 25-04-2015 - Session time: 16:20:00 - Track: Track 4
Speaker: Neil Hambly
Abstract:
Come learn about the native tools at our disposal for performing these important load tests and how we can identify when performance levels begin to drop. Using demos of these native tools – including Distributed Replay Utility (DRU), Database Tuning Adviser (DTA), Perfmon, Extended Events, and Profiler – we’ll see how to plan and perform a load test project, gain an understanding of SQL Server’s performance under varying load scenarios, and discover which tell-tale indicators can help alert us to performance degradation.
SessionID: 21598
Event Date: 25-04-2015 - Session time: 16:20:00 - Track: Other
Speaker: Oz Locke
Abstract:
You’ve gotten your head around SSRS — how to set up datasets, how to make tables and charts, how to add parameters — and know you’re looking for more. This sessions will add to what you already know and teach you some nifty things you may have thought you couldn’t do.
Among the topics covered will be mastering export formats, creating user driven branding, making the most of parameters and using your reports’ metadata to control how they behave.