Nr: 162
SQLSaturday #162 - Cambridge 2012
SessionID: 10540
SQL 2012 Always On-Deep Dive
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Bob Duffy
Title: SQL 2012 Always On-Deep Dive
Abstract:
Always On offers a huge leap forward in terms of high availability. This sessions is a demo based introduction to the high availability changes in Denali emphasising key features and benefits. During the demonstration we will show how to seamlessly upgrade a database from SQL 2005+ to Denali with ZERO down time and then use the Always on features to simplify reporting, availability and disaster recovery. This session will be useful for anyone who is working in a high availability environment or currently using replication to provide reporting and looking for a neater solution.
SessionID: 10997
SQL Internal Storage
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Bruno Basto
Title: SQL Internal Storage
Abstract:
SessionID: 11098
Windows Azure from a Data Perspective
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Buck Woody
Title: Windows Azure from a Data Perspective
Abstract:
SessionID: 11470
Intro to Tabular Model in Analysis Services 2012
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Chris Webb
Title: Intro to Tabular Model in Analysis Services 2012
Abstract:
SessionID: 12067
Session Details not available
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 12069
Session Details not available
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4 (special)
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 12210
What's new in SQL Server 2012 - TSQL
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Dave Ballantyne
Title: What's new in SQL Server 2012 - TSQL
Abstract:
With the release of SQL Server 2012, the T-SQL language has been extended further to enable greater productivity and more optimal queries.
Following the ANSI SQL standard support has been included for PAGING and SEQUENCES. Many cumbersome sub-queries will be banished by the clutch of new analytic functions, but perhaps the biggest is the window framing extensions. These now allow a true sliding window of data to process such common problems as rolling balances.
This will be a high-level look session, but will be diving a bit deeper to highlight some caveats as we go as its not all plain sailing.
SessionID: 12819
Query Plan Operators Deep Dive
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: David Morrison
Title: Query Plan Operators Deep Dive
Abstract:
In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen.
We will look at the good and bad aspects of each and why sometimes they aren't the right tool for the job.
Using lots of examples we'll investigate the usage and impact they have on your SQL Server.
Hopefully you'll walk away from this session with the knowledge which will give you a deeper understanding of your query plans
SessionID: 13596
The Magic of SQL Server 2012 BI in SharePoint
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Duncan Sutcliffe
Title: The Magic of SQL Server 2012 BI in SharePoint
Abstract:
Although this session is mildly technical, it is easy to grasp and uses 100% demos.
SessionID: 15039
Make Your Queries Fly With Columnstore Indexes
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Hugo Kornelis
Title: Make Your Queries Fly With Columnstore Indexes
Abstract:
Often touted as a “BI” feature, in reality columnstore indexes can benefit any workload that involves some sort of reporting on large tables. In this session, we’ll first discuss how columnstore indexes work. Once past the basics, we’ll dive in and get dirty, looking at how to rewrite existing queries and change database designs to get the most out of this new index type.
If you are running SQL Server 2012, you can add a columnstore index to your large tables and gain maybe 4x performance – or you can attend this session and make things really fly.
SessionID: 15403
Inheriting a database for Developers
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Niko Neugebauer
Title: Inheriting a database for Developers
Abstract:
There are very few applications which are being developed from zero, the most are apps are simply inherited from previous development teams.
This session serves to show some easy implementable practices to follow after inheriting a database. Those practices allow to check some if the database design was done in regards to the actual data, or if while implementing some of the constraints and checks some tables were left behind. :)
The practices shown in this session will allow to check the database design and identify some of the possible performance degradations.
SessionID: 15539
Troubleshooting SQL Server with PowerShell
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: James Boother
Title: Troubleshooting SQL Server with PowerShell
Abstract:
TBD
SessionID: 16559
Mobile Business Intelligence for Everyone, Now!
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Jen Stirrup
Title: Mobile Business Intelligence for Everyone, Now!
Abstract:
Microsoft has made serious commitments to mobile Business Intelligence, announced at SQLPass Summit 2011. What is the roadmap? What's available right now, and how can it be implemented at your organisation?
Come to this session to learn about mobilising Business Intelligence using Sharepoint, Reporting Services, SQL Azure, Excel Services and Power Pivot. Yes, it is possible to have mobile Business Intelligence in your organisation, and come to this session in order to learn how!
SessionID: 19515
Red Gate followed by Lightning Talks
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Mark Broadbent
Title: Red Gate followed by Lightning Talks
Abstract:
In this session you will first get wowed by Red Gate by a 30 minute session of 'How to Slash Your Storage Costs with SQL Storage Compress' and if that wasn't enough you will then be dazzled by several 5 minute lightning talks from a selection for SQL Experts and first timers! Join us for a non-stop ride of SQL goodness in 5 minute chunks. Who will win the showdown ...Professional software company Redgate or the motley selection of lightning speakers! Join us and find out!
SessionID: 19541
READPAST Furious-Transactions.Locking.Isolation.
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4 (special)
Speaker: Mark Broadbent
Title: READPAST Furious-Transactions.Locking.Isolation.
Abstract:
Do you really understand SQL Servers’ Concurrency behaviour?
Are you sure that Transactions are an ALL or NOTHING operation?
Do you believe Read operations cannot start a Transaction?
Do you really know if READ_UNCOMMITTED is safe for reporting?
Is being Optimistic really better than being Pessimistic?
Can SQL Server 2012 be the solution to all our problems or our worst nightmare?
I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to all these questions and more and make you wish you had known all of this sooner.
SessionID: 19600
Optimizing Storage and Performance Using Page and
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Mark S. Rasmussen
Title: Optimizing Storage and Performance Using Page and
Abstract:
Since SQL Server 2005, we've been able to use the vardecimal data type to store decimals efficiently. With SQL Server 2008 came row and page compression, resulting in much better options for compressing our data. However, neither row nor page compression are panaceas! In this session I'll walk you through the internals of row and page compression, and based on that knowledge, enable you to better evaluate when to use which type of compression, if compression should be used at all. Once used, how do we determine its effectiveness? What are the pitfalls? I'll give you a full tool belt of knowledge to bring home and put to use on your databases.
SessionID: 19683
Creating SSMS 2012 Add-ins for Crash Test Dummies
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4 (special)
Speaker: Mark Pryce-Maher
Title: Creating SSMS 2012 Add-ins for Crash Test Dummies
Abstract:
In this session we will run through the history of SQL Server Management Studio Add-ins, then goto through the step by step process of creating an Add-in for SQL Server Management Studio 2012.
We will look at some of the cool things you can do and break.
This session is for people who have some C# knownledge and want to extend SQL Server Management Studio.
SessionID: 19782
Partitioning Design for Performance and Maintainab
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4 (special)
Speaker: Martin Cairns
Title: Partitioning Design for Performance and Maintainab
Abstract:
Partitioning your data allows a whole host of benefits to the performance and maintainability of your databases but still seems to be a dark art known only to a few people. With every release of SQL Server more features become available to help solve various problems and a lot of them require that your database has been partitioned for that feature to be used effectively. The most recent feature requiring partitioning is Column Store indexes, without partitioning you would be required to drop them before modifying any data in the base table and then recreating them from scratch.
SessionID: 21340
Extended Events – New Age of Profiling
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Neil Hambly
Title: Extended Events – New Age of Profiling
Abstract:
Extended Events is the replacement for profiler in many respects, and will be the choice of capturing data from within SQL Server now and in future editions, so we need to understand the differences it has to profiler "old guard" and why we should be using this new feature for this purposeI'll take you on a Guided tour of the key aspects, and show you simply how in just minutes you can up and running and capturing data using this new method and how to analyze it effectivelyFollow me to the "new age" of understanding your systems activity
SessionID: 21898
I work with SQL why should I care about SharePoint
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4 (special)
Speaker: Peter Baddeley
Title: I work with SQL why should I care about SharePoint
Abstract:
SessionID: 22116
XML: The Marmite of SQL Server
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4 (special)
Speaker: Phil Quinn
Title: XML: The Marmite of SQL Server
Abstract:
SessionID: 23301
Tame Your Unruly Data...With Constraints!
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Rob Volk
Title: Tame Your Unruly Data...With Constraints!
Abstract:
Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!
SessionID: 26952
2 AM. A Disaster just began...
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Tobiasz Koprowski
Title: 2 AM. A Disaster just began...
Abstract:
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I'll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I'll show You how to be BEST prepared.
SessionID: 26955
Welcome to the Licensing Nightmare
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 4 (special)
Speaker: Tobiasz Koprowski
Title: Welcome to the Licensing Nightmare
Abstract:
Are You remember "Sliders"? In my opinion Licensing World is similar to this series. How many time You tried to understand licensing? How many times You heard different opinions about same question? I'm sure, that You know what is CPU, CORE, SOCKET. Are You familiar with Processor / User / Device? And CAL / SAL/ SA too? Are You use SPLA program or just OEM or MOLP? Physical Instance, Virtual Instance, 90 Days, EULA, SPUR, LAR, Multiplexing, 5 Dollars (not 5 Cents)... It's not all the possibilities, if we are talking about licenses. Let's talk about it, from the Licensing Point of View
SessionID: 27075
Improving DB Development with SQL Source Control
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Red Gate
Title: Improving DB Development with SQL Source Control
Abstract:
Keeping track of database versions, deployment scripts, and any number of ad hoc database changes is a pain. In this session, you’ll see how to manage database changes easily using source control within SQL Server Management Studio. Source controlling databases is faster than you think with SQL Source Control; you can track who made database changes, what they changed, when, and why.
SessionID: 8919
T-SQL : Bad Habits and Best Practices
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits and Best Practices
Abstract:
In this session we will go over several bad habits that are quite
pervasive in the SQL Server community, and show with demos and samples why
these habits can be bad.
We'll also illustrate some good habits that are less common and why they
should be adopted.
The goal is to have every user in the room walk away with immediately
actionable knowledge to improve their existing stored procedures, raise
their overall T-SQL skill, and change the way they think about writing
code.
SessionID: 9216
Merge-tastic: a better way of loading dimensions
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Alex Whittles
Title: Merge-tastic: a better way of loading dimensions
Abstract:
SessionID: 9304
SQL Server 2012 SSIS Change Data Capture
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Allan Mitchell
Title: SQL Server 2012 SSIS Change Data Capture
Abstract:
We are storing more and more data FACT
We have less time to move data around our environment FACT
Businesses want close to real-time analytics FACT.
We therefore need to plan our data movement strategy better. In this session I will show you the improvements to CDC being made in SQL Server 2012 and suggest why this is something you will want to know.
SessionID: 9462
Practical PoSh – Design and build larger scripts
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: André Kamman
Title: Practical PoSh – Design and build larger scripts
Abstract:
SessionID: 9528
Designing an SSIS Framework
Event Date: 08-09-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Andy Leonard
Title: Designing an SSIS Framework
Abstract: