Nr: 194
SQLSaturday #194 - Exeter 2013
SessionID: 11573
Advanced SQL Server 2012 HA and DR Architectures
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Christian Bolton
Title: Advanced SQL Server 2012 HA and DR Architectures
Abstract:
In this session I'll cover advanced HA and DR architectures for SQL Server 2012 that also enable you to scale-out certain workloads. This will include design patterns and configuration best practices for Availability Groups (AG) and Failover Cluster Instances (FCI) across different sites as well AG replicas between FCIs.
SessionID: 12061
Session Details not available
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: n/a n/a
Title: Session Details not available
Abstract:
Session Details not available
SessionID: 12202
Estimation, Statistics and “Oh My!”
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Dave Ballantyne
Title: Estimation, Statistics and “Oh My!”
Abstract:
At the heart of SQL Server is the cost based optimizer. Stop and think about that a minute, it attempts to give the “best plan” based on the cost of the work undertaken. How does it know the cost of the work before its done the work ? This isn’t a conundrum, it doesn’t. It estimates! How does it estimate ? That is statistics.
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong and how you can have influence over these choices.
SessionID: 12316
"I'm sure my procedure does what it should!"
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Dave Green
Title: "I'm sure my procedure does what it should!"
Abstract:
Or, using unit tests to produce better quality code and do less (re)work!
In this brisk session we will discuss some of the reasons to unit test your procedures as well as which tests are and are not appropriate as unit tests. We will look at how to use the open source tSQLt framework to achieve repeatable unit tests, including Test Driven Development approaches and writing tests for existing stored procedures; in short everything you need to begin writing unit tests for the stored procedures in your databases.
SessionID: 12821
Myth Busters! Busting Common TSQL Myths
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: David Morrison
Title: Myth Busters! Busting Common TSQL Myths
Abstract:
In this session we will take a look at, and hopefully bust, my list of common myths and misconceptions I see and hear about on a daily basis.
We will look at areas such as Indexing / SARGability, joins sub queries, nested views, query plans and a host of other myths. Using lots of a demos and examples attendees will walk away with a better understanding of the best ways to use TSQL and hopefully bust at least one myth or misconception that they have
SessionID: 15301
A temporary fix for a short term problem
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Ian Meade
Title: A temporary fix for a short term problem
Abstract:
Finding the best way to implement complex logic in TSQL can be more challenging then you’d expect. Often, the developer just makes the query bigger and more complex but this is not always ideal. We’ll look at how and when you should split larger queries into smaller chunks. We’ll explore the implication of larger queries, using temporary tables, table variables, functions and view, derived tables and sub queries and CTEs.
SessionID: 15540
Professional PowerShell
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: James Boother
Title: Professional PowerShell
Abstract:
PowerShell has evolved (again). PowerShell v3 released earlier this year comes with:
• new cmdlets,
• enhancements to familiar cmdlets,
• better help system,
• workflow,
• PowerShell Web Access
• + Lots more
This is an opportunity for you to see the important new features first hand.
SessionID: 15658
Declarative database development with SSDT
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jamie Thomson
Title: Declarative database development with SSDT
Abstract:
SessionID: 17170
SQL Sever, the DBA Compliance
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: John Martin
Title: SQL Sever, the DBA Compliance
Abstract:
Compliance is something that we are all having to deal with and this is only going to increase with heightened privacy concerns and due diligence requirements in business. This session will cover three of the main areas that you are likely to have to deal with; Payment Card Industry - Data Security Standard (PCI-DSS), Sarbanes Oxley Act (SOX) and the UK Data Protection Act 1998 (DPA). I will look at what these standards are for and how they sometimes conflict.
Information Heavy and Demo Light, this session will help you identify what you need to keep an eye on and I will show a couple of options on how to monitor who is doing what with your data.
SessionID: 17337
Tracking server activity without slowing it down
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jonathan Allen
Title: Tracking server activity without slowing it down
Abstract:
All SQL Server DBAs should know how Service Broker and Event Notifications work so that they can implement this very simple feature to make sure they are aware of events happening on their servers.
Event Notifications is a very light-weight, asynchronous mechanism for identifying events and taking actions. In this session we will create sessions to monitor for and act on DDL changes, file size changes, index and statistics changes, security changes and more. Attendees will gain an understanding of how they can monitor many servers and stay in control.
SessionID: 17603
Thinking Big Understanding PDW
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: James Rowland-Jones
Title: Thinking Big Understanding PDW
Abstract:
We will visit the architectural components of PDW and look at some of the new features available in V2. We will also dive into some of the lessons learned developing systems for PDW in the field.
You will leave this session understanding why you should be thinking about PDW for your data warehouse and how you can accelerate the delivery of your PDW project.
SessionID: 18705
Welcome to the Licensing Nightmare
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Tobias 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: 19551
READPAST Furious-Transactions,LockingIsolation
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mark Broadbent
Title: READPAST Furious-Transactions,LockingIsolation
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: 19681
Cloudbursting - Amazon RDS for SQL Vs SQL Azure
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Mark Pryce-Maher
Title: Cloudbursting - Amazon RDS for SQL Vs SQL Azure
Abstract:
We all know about the low startup costs of using cloud based SQL Servers, but what are the (hidden) costs and benefits?
In this session, we will run thought the supported feature sets of each and how they stack up against one another.
Does one perform better than the other? Are they better for different work loads?
If the demo gods are with us, will can see they both in action and you can see for yourself!
SessionID: 20022
An Introduction to SQL Server Virtualisation
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Gethyn Ellis
Title: An Introduction to SQL Server Virtualisation
Abstract:
SessionID: 21037
Table Indexing for the .NET Developer
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Denny Cherry
Title: Table Indexing for the .NET Developer
Abstract:
In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2012 databases. We will also be looking into the new indexing features that are available in SQL Server 2012 (and SQL Server 2005-2008) and how you the .NET developer can make the best use of them to get your code running its best.
SessionID: 21331
Why are we Waiting..
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Neil Hambly
Title: Why are we Waiting..
Abstract:
An in-depth session examining "Waits" happening in your SQL Servers, using the well-known "Waits Queues" methodology.
With particular focus in the session on understanding and interpreting the information found the (DMV) sys.dm_os_wait_stats,
Taking note of which “Waits “with the highest counts or excessive wait times, as well as those which “Waits” can be safely ignored,
We can discover those "performance hurdles" and ways to overcome or remove them, restoring your SQL Servers performance levels.
By using established methodologies like “Waits Queues”, we can systematically identify and remove performance
Previous Presented @ SQLBits 8 9 in UK @ SQLPASS Summit 2011 (310 Attendees) SQLDay
And @ several UK User Groups
SessionID: 22117
XML: The Marmite of SQL Server
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Phil Quinn
Title: XML: The Marmite of SQL Server
Abstract:
SessionID: 22686
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Lord Richard Douglas
Abstract:
You’ll learn simple tricks to write better code, scripts, and tables. Plus, you’ll gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.
Plus, you’ll learn how to take corrective action when:
•The optimizer isn’t using all available processors
•The database engine fails to report all the resources a query has used
•The optimizer uses the wrong plan
•Database tables cause memory issues
SessionID: 22815
Power View and the Cube
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Regis Baccaro
Title: Power View and the Cube
Abstract:
Now that Power View users can connect to multidimensional BI Semantic Model (cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models.
The session we'll present
- An understanding of the Multidimensional Model Objects in Power View
- How to create a Shared Report Data Source Connection to a Multidimensional Model
- How to create a Power View Report with a Multidimensional Model Data Source
- An visual exploration of a Multidimensional Model by using Power View
SessionID: 24763
SQL Injection from website to SQL Server
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mladen Prajdić
Title: SQL Injection from website to SQL Server
Abstract:
SQL Injection is still one of the biggest reasons various websites and applications get hacked.
The solution as everyone tells us is simple. Use SQL parameters. But is that enough?
In this session we'll look at how would an attacker go about using SQL Injection to gain access to your database, see its schema and data, take over the server, upload files and do various other mischief on your domain.
SessionID: 27391
Quantifying the cost of Compression
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Thomas Kejser
Title: Quantifying the cost of Compression
Abstract:
A DBA running SQL Server 2008 or above will often need to understand if it is worth trading CPU cycles for I/O by enabling row or page compression. The benefits can be significant, but does the cost in core licensing offset the storage capacity saved? Often, comparing the workload before and after compression isn't an option. How then can you make an educated guess about the cost of compressing tables and indexes? In this session, we will use Grade of the Steel type workloads to quantify the CPU cost of enabling different types of compression. Using CPU profiling, we will try to quantify the cost of this feature.
SessionID: 28204
Database Replication - What, How and Why
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: William Durkin
Title: Database Replication - What, How and Why
Abstract:
Database replication doesn't get much attention, especially now that the AlwaysOn features have been released into the wild.
However, replication offers another way to make data available on multiple servers/locations that steps outside of "normal" HA/DR scenarios.
This session will explain what database replication is, what the different parts are that make up the replication architecture and when/why you would use replication.
The content will be valid for all versions of SQL Server from 2005 onward,
SessionID: 34575
ETL Shootout, SSIS vs Powershell
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: André Kamman
Title: ETL Shootout, SSIS vs Powershell
Abstract:
But I keep running into weird requests that were just easier to fix with Powershell.
I'll show you why some things are not easy in SSIS.
I'll also discuss how you can work around a lot of that instead of switching to Powershell like I did.
This session will be around 70% "why is this hard in SSIS and can you work around it?" and 30% "Look how cool Powershell is"
SessionID: 34630
Star Schema database primer
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Eric Lawson
Title: Star Schema database primer
Abstract:
A session covering the the core principles of the star schema database model, as required for decision support solutions and as the bedrock for Analysis Services cubes and the new Tabular model.
In this session we cover
-technical comparison of databases
-features of the star schema database
-where do you get one
-how do you best exploit it
-next steps
SessionID: 9214
MDX 101
Event Date: 09-03-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Alex Whittles
Title: MDX 101
Abstract:
Give your queries a multidimensional makeover.
In this session we'll look at the structure and basics of MDX, the MultiDimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so you need no previous MDX experience!