sqlsathistory

Nr: 269

Back to Main list

SQLSaturday #269 - Exeter 2014

Start Time (24h) Speaker Track Title
00:00:00 n/a n/a Track 2 Session Details not available
00:00:00 Dave Ballantyne Track 1 Query Optimizer internals
00:00:00 David Postlethwaite Track 2 A real DBA don’t need a GUI -A Guided Tour of SQL Server Management Studio
00:00:00 David Williams Track 3 SQL Server 2014 New Features (not Hekaton!)
00:00:00 David Morrison Track 1 Query Plans Deep Dive
00:00:00 Emil Glownia Track 3 How to become a BI Developer?
00:00:00 Ewan Fairweather Track 2 SQL Server 2014 and Azure SQL DB - The Road Ahead
00:00:00 Hugo Kornelis Track 3 Powerful T-SQL Improvements that Reduce Query Complexity
00:00:00 Ian Meade Track 4 Dynamic code for efficient searching
00:00:00 James Skipwith Track 1 SQL 2014 In-Memory: Could you? Would you? Why the fudge should you?
00:00:00 Jen Stirrup Track 1 The Accidental Business Intelligence Project Manager
00:00:00 Kevin Chant Track 4 Delivering PowerView with SQL Server 2014 and SharePoint 2013
00:00:00 Kevan Riley Track 3 Uncovering the hidden gems in execution plans
00:00:00 Rob Sewell Track 2 PowerShell Box of Tricks
00:00:00 Neil Hambly Track 1 Effective Index Partitioning, Compression Strategy
00:00:00 Pieter Vanhove Track 2 1, 2, 3, … wait… 1, 2, 3, … many… SQL Servers
00:00:00 Peter Larsson Track 3 Remodel your old EAV design
00:00:00 Stacia Varga Track 1 Reduce, Reuse, Recycle: Automating Your BI Framework
00:00:00 Mladen Prajdić Track 1 SQL Impossible: Restoring/Undeleting a table
00:00:00 Satya Jayanty Track 4 Let's cook 'best SQL Server DBA practices'
00:00:00 Richard Munn Track 3 Policy-based what ? (Or how I learned to stop worrying and love PBM)
00:00:00 Stephanie Locke Track 3 An introduction to R
00:00:00 Stuart Moore Track 2 PowerShell for the curious SQL Server DBA
00:00:00 William Durkin Track 4 SQL Server Consolidation - Resistance is Futile
00:00:00 André Kamman Track 4 Automate your SSIS development with BIML
00:00:00 Allan Mitchell Track 4 Hadoop for the Microsoft Guy

SessionID: 12084

Session Details not available

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: n/a n/a

Title: Session Details not available

Abstract:

Session Details not available

SessionID: 12199

Query Optimizer internals

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Dave Ballantyne

Title: Query Optimizer internals

Abstract:

The query optimizer is at the heart of SQLServer. Without it SQLServer would be a vastly inferior product, queries would have to be manually tuned at each and every turn, and generally speaking, the optimizer protects us from the complexities and mechanics involved.

Much of the optimizer's internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags to gain further knowledge and insight into how your queries and data are processed to create a plan.

This session will be a deep dive into the optimizers' internals and not for the feint of heart.

SessionID: 12453

A real DBA don’t need a GUI -A Guided Tour of SQL Server Management Studio

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: David Postlethwaite

Title: A real DBA don’t need a GUI -A Guided Tour of SQL Server Management Studio

Abstract:

SQL Server Management Studio is at the heart of any SQL Server DBA or developer’s day. We take it for granted but rarely do we take a look at how we can customise or improve it to make our day to day work easier and more productive.

This presentation will show you how to use SSMS and will look at many of the hidden features and shortcuts that you had forgotten about or didn’t know were there. At the end of this session you will have learnt at least one new feature of SSMS that you can use to improve your productivity.

SessionID: 12806

SQL Server 2014 New Features (not Hekaton!)

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: David Williams

Title: SQL Server 2014 New Features (not Hekaton!)

Abstract:

SessionID: 12828

Query Plans Deep Dive

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: David Morrison

Title: Query Plans Deep Dive

Abstract:

In this session we will take an in depth look at how query plans work. We will go under the covers and see what happens when you run that query.

We will also take a look at various operators, how they work, why they are chosen and how to avoid them being used in the wrong place / context,. Attendees of this session will walk away with a greater understanding of query plans and the operators, which will enable them to both better interpret their query plans and also write more efficient SQL code

SessionID: 13775

How to become a BI Developer?

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Emil Glownia

Title: How to become a BI Developer?

Abstract:

This is one of the most frequent questions I get from our website visitors (mainly as we provide BI Tutorials).

I have become a BI Developer and I would like to share my experience and thoughts (and get yours) during this session, which will include:

  1. We are not born BI Developers and anyone has a chance to become one!
  2. It is not easy but it is easier when you have a clear directions how to get there!
  3. Permanent vs. Contractor brief explanation of pros and cons!
  4. Money is important aspect so we will talk about salaries and contract rates!
  5. My journey to becoming a BI developer was not easy and I have started from not knowing English (in 2005) and any aspects of IT and I worked very hard (and Katie; my wife was my main success factor!) but I no longer want to be a BI Developer so last point is where to go next?

SessionID: 14014

SQL Server 2014 and Azure SQL DB - The Road Ahead

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Ewan Fairweather

Title: SQL Server 2014 and Azure SQL DB - The Road Ahead

Abstract:

Learn more about SQL Server 2014, the next major release of SQL Server and Azure SQL DB. SQL Server 2014 delivers higher performance on large volumes of data with our new In-Memory OLTP technology (formerly known as Project “Hekaton”), as well as greater availability through our hybrid disaster recovery and backup solutions. In this session we will walk through the improvements we have made in the product and explain how they address your needs for mission-critical performance and availability, faster insights on any data, and greater efficiency and flexibility.

SessionID: 15099

Powerful T-SQL Improvements that Reduce Query Complexity

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Hugo Kornelis

Title: Powerful T-SQL Improvements that Reduce Query Complexity

Abstract:

We’ve all dealt with them: nightmare queries, huge, twisted monsters that somehow work, despite being ugly and unmanageable. The time has come to tame these beasts, and the solution is available now, in SQL Server 2012.

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!

SessionID: 15296

Dynamic code for efficient searching

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Ian Meade

Title: Dynamic code for efficient searching

Abstract:

Illustrate how multipurpose queries can lead to issues with scalability and performance. Show a few alternatives that will work for smaller and simpler queries while highlighting their limitations for more complex queries. Then work through building a dynamic search query to resolve the identified performance issues. Touching on: • Testing. • Tuning each part of the query in isolation. • Plan cache re-use • Security – SQL injection attacks and authorisation / code signing. • Possibly, mentioning greater re-use and extendibility.

SessionID: 15544

SQL 2014 In-Memory: Could you? Would you? Why the fudge should you?

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: James Skipwith

Title: SQL 2014 In-Memory: Could you? Would you? Why the fudge should you?

Abstract:

SQL Server 2014 In-Memory OLTP Technology - AKA Hekaton - is here. Should you be getting excited? Will it prove to be the miracle turbo-boost for your databases that you are hoping for? In this session, three simple questions will be answered: Could you use it? How would you use it? And why would you want to use it? Tidy. So when your boss hears the buzz and wants everything converted ASAP, you'll know the score.

SessionID: 16393

The Accidental Business Intelligence Project Manager

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Jen Stirrup

Title: The Accidental Business Intelligence Project Manager

Abstract:

You’ve heard that Business Intelligence projects are prone to failure.

You’ve watched the Apprentice with Donald Trump and Lord Alan Sugar. You know that the Project Manager is usually the one gets fired. You know that a quick Bing search for ‘why do Business Intelligence projects fail?’ produces a search result of 25 million hits!

Despite all this… you’re now Business Intelligence Project Manager – now what do you do? In this session, Jen will provide a ‘sparks from the anvil’ series of steps and working practices in Business Intelligence Project Management. What about waterfall vs agile? What is a Gantt chart anyway?

Jen will give you some ideas and insights that will help you set your BI project right: assess priorities, avoid conflict, empower the BI team and deliver the Business Intelligence project successfully!

SessionID: 18135

Delivering PowerView with SQL Server 2014 and SharePoint 2013

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Kevin Chant

Title: Delivering PowerView with SQL Server 2014 and SharePoint 2013

Abstract:

In this session I will explain what PowerView is and the benefits it can bring to your business; followed by an overview of how you can deliver it to your business using SQL Server 2014 and SharePoint 2013.

SessionID: 18258

Uncovering the hidden gems in execution plans

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Kevan Riley

Title: Uncovering the hidden gems in execution plans

Abstract:

We all know that the execution plan is central to understanding query performance, but the way we view the execution plan hides lots of good, useful information from us. The plan is an XML document and knowing what attributes to look for can give you a better window onto your query's performance. In this session Kevan will cover the attributes that he looks for, what they mean and what actions to take. We may even get a sneak peak of what's to come in SQL 2014 too.

SessionID: 21123

PowerShell Box of Tricks

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Rob Sewell

Title: PowerShell Box of Tricks

Abstract:

The life of a SQL Server DBA is a busy one. A fount of all knowledge, the SQL Server DBA is often interrupted with small questions and routine tasks. This session will show you some functions that you can use to save time spent on this and hopefully inspire SQL DBAs to explore PowerShell further by showing how easy it is to explore SQL Server properties with it.

SessionID: 21379

Effective Index Partitioning, Compression Strategy

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Neil Hambly

Title: Effective Index Partitioning, Compression Strategy

Abstract:

We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server.

When Indexing also combines 2 of the Enterprise features: Partitioning Compression, we can often see substantial gains.

Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.

Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.

SessionID: 22139

1, 2, 3, … wait… 1, 2, 3, … many… SQL Servers

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Pieter Vanhove

Title: 1, 2, 3, … wait… 1, 2, 3, … many… SQL Servers

Abstract:

Quote: “A good DBA is a lazy DBA”. When you have to manage a few SQL Servers, it’s not that hard to be a lazy DBA and to automate your day to day activities. But when you have to manage over 100 instances, it can become a tough job. Just imagine how you will deploy a new maintenance job on all your instances? Are you going to connect to each server one by one? Not really… Microsoft provides an enhanced set of multi-server management tools. The purpose of this sessions is to point out which SQL Server tools you can use for multi-server management. The session is bulk loaded with demos and it will give you a good idea what features can be helpful in your environment.

SessionID: 22172

Remodel your old EAV design

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Peter Larsson

Title: Remodel your old EAV design

Abstract:

Sometimes you really need an EAV model. In most cases they are ugly and slow.

After this session you will have gained new insights how to turn your old, slow, EAV model into a slim superfast model.

There will be real life examples from a recent project. With the techniques displayed in the presentation, I cut the execution time down from 134 days down to 0.5 seconds and cut the storage need from 550GB to 45GB.

SessionID: 24651

Reduce, Reuse, Recycle: Automating Your BI Framework

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Stacia Varga

Title: Reduce, Reuse, Recycle: Automating Your BI Framework

Abstract:

Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, SSIS packages, and SSAS multidimensional or tabular models that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.

SessionID: 24782

SQL Impossible: Restoring/Undeleting a table

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 1

Speaker: Mladen Prajdić

Title: SQL Impossible: Restoring/Undeleting a table

Abstract:

Yes, you read the title right.

No, it's not about the usual "one table per partition" and "restore full backup then copy the data over" methods. No, there are no 3rd party tools involved. Just you and your SQL Server.

Yes, it's crazy. No, it's not for production purposes. And yes, that's why it's so much fun. Prepare to dive into the world of data pages, log records, deletes, truncates and backups and how it all works together to get your table back from the endless void.

Want to know more? Come and see!

SessionID: 25014

Let's cook 'best SQL Server DBA practices'

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Satya Jayanty

Title: Let's cook 'best SQL Server DBA practices'

Abstract:

In this session we will go through the topics of performance, scalability and availbility - the 3 core topics that every DBA needs to know. Performance is at the core and required for every database application (small or mission-critical). In this talk we will go through the concepts, tools and procedures that will help you in monitoring and start fine-tuning the performance or find the root-cause on your data platform. The subject covered here is excerpted from my book "Microsoft SQL Server 2008 R2 Administration cookbook" and "SQL Server 2012 Cube Security How-to". This will also be an ideal beginning for any IT person who is willing step-into DBA world.

SessionID: 25072

Policy-based what ? (Or how I learned to stop worrying and love PBM)

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Richard Munn

Title: Policy-based what ? (Or how I learned to stop worrying and love PBM)

Abstract:

Beginning with SQL Server 2008, Policy-based Management was added to the DBAs toolkit to ease administration, but it only goes so far. This session will cover the principles of PBM, and we'll take a look at how we can make it work for us, as opposed to just telling us something is not right. We'll cover PBM and it's insides, Alerts, Operators, Scheduled Jobs, and demo a real-world use when setting up databases.

SessionID: 25269

An introduction to R

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 3

Speaker: Stephanie Locke

Title: An introduction to R

Abstract:

R, the statistical programming language, is another open-source program making inroads into the Microsoft world. This session will show you how to get data into R directly from SQL Server, perform different forms of analysis, and output to various formats.

SessionID: 25824

PowerShell for the curious SQL Server DBA

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 2

Speaker: Stuart Moore

Title: PowerShell for the curious SQL Server DBA

Abstract:

As a SQL Server DBA you've probably noticed more and more talk of PowerShell over the last few years. You might have never used it, or perhaps you've even downloaded a few scripts to use, or started reading a tutorial, but aren't really sure what it can do for you?

Then this session is for you. Trying something new for SQL Saturday Exter 2014, this "session" is in fact 2 sessions long (don't worry, you'll still get a break for coffee half way through).

By the end of them you should have a better understanding of what PowerShell is, and how it can be used with SQL Server, so you can start writing your own scripts or have a better understanding of how a script you've downloaded works

Session 1 will be a easy high level introduction

SessionID: 28201

SQL Server Consolidation - Resistance is Futile

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: William Durkin

Title: SQL Server Consolidation - Resistance is Futile

Abstract:

The IT world is currently in cost-saving mode - cutbacks are all over the place and then Microsoft pushes out SQL Server price hikes.

In this session we will discuss how consolidating SQL Server can reduce overall costs and increase efficiency. We will cover the reasons for consolidation along with the advantages and the disadvantages of consolidating SQL Servers. We will also take a look at some of the tools that can assist with a consolidation project and some pitfalls that I have experienced on previous consolidation projects.

SessionID: 34557

Automate your SSIS development with BIML

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: André Kamman

Title: Automate your SSIS development with BIML

Abstract:

Ever tried to import a file with the Import/Export wizard?

Or created a bunch of SSIS packages to process a data warehouse load? Then you know how much work it is to specify the metadata correctly just to create a package that actually works. Wouldn't it be cool if you had a descriptive language which looks at your metadata and just created the packages for you? This is what BIML is all about. In this session I explain what BIML is, how it works and I'll show you how you can generate your packages and quickly respond to changes. You can expect a demo rich session with lots of notes from the field and practical examples. This is not just for BI developers, DBA's or SQL dev's who need to import or export data occasionally will learn some quick and easy tricks as well.

SessionID: 9295

Hadoop for the Microsoft Guy

Back to calendar

Event Date: 22-03-2014 - Session time: 00:00:00 - Track: Track 4

Speaker: Allan Mitchell

Title: Hadoop for the Microsoft Guy

Abstract:

Microsoft have released a distribution of Hadoop targeted at making big data accessible to everyone. Hadoop is different to SQL Server. Not necessarily better, just different. It is a tool for a job. if you have only ever worked with an RDBMS such as SQL Server then Hadoop is going to play with your mind a little and you are going to need to rethink a few things.

This session is going to take Hadoop and break it apart. I will also look at some of the tooling Hive and Pig. Keep an open mind and let me show you that Hadoop has lots to offer.

This site is open source. Improve this page.