Nr: 235
SQLSaturday #235 - New York City 2013
SessionID: 10111
The Transaction Log and How It Affects HA/DR
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Edwin Sarmiento
Title: The Transaction Log and How It Affects HA/DR
Abstract:
When choosing the appropriate SQL Server HA/DR solutions, it is important to understand the SQL Server Transaction Log as it affects any solution you choose. In this session, we will look at transaction log basics, how logging and recovery works and how it affects all of the HA/DR solutions available in SQL Server. You'll be surprised to know that the transaction log is the most important part of your database.
SessionID: 10182
Surviving Your Peak Database Load
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Ben DeBow
Title: Surviving Your Peak Database Load
Abstract:
SessionID: 11254
“Indexing” Encrypted Data
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Chris Bell
Title: “Indexing” Encrypted Data
Abstract:
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
SessionID: 12383
Deploying Highly Available SQL Servers in the Amazon EC2 Cloud
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: David Bermingham
Title: Deploying Highly Available SQL Servers in the Amazon EC2 Cloud
Abstract:
SessionID: 12541
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: David Klee
Abstract:
SessionID: 12884
SSIS templates, configurations and variables, oh my
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Daniel Bowlin
Title: SSIS templates, configurations and variables, oh my
Abstract:
SessionID: 12960
Dealing With Errors in SSIS 2012
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: David Dye
Title: Dealing With Errors in SSIS 2012
Abstract:
This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
SessionID: 13357
How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise Edition
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Carl Berglund
Title: How to Create a Self-Managed SQL Server Utility without SQL Server Enterprise Edition
Abstract:
Learn how to make your next SQL Server deployment or tech refresh the basis of a consolidated, elastic, self-managed SQL Server utility. This session will help you understand how to build a highly available SQL Server farm to maximize flexibility and agility while avoiding the traps that force you to SQL Server Enterprise Edition.Are you currently dealing with…• Standards that force the most expensive software stack? • High licensing and yearly subscription costs associated with vendor lock-in?• Multiple deployment models that increase project complexity and dependencies while reducing your flexibility and agility? Wouldn’t you like to...• Reduce the cost of both SQL Server licensing and infrastructure?• Have a single operational model that solves all deployment requirements?• Deploy the edition of SQL server that best solves the business problem without being forced to Enterprise Edition?
SessionID: 13837
Query Optimization Crash Course
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Edward Pollack
Title: Query Optimization Crash Course
Abstract:
Do you have users complaining that applications are running "too slow"? Do your DB traces look like a short story written by monkeys at typewriters?
This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We'll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!
SessionID: 14515
SQL Server 2012 AlwaysOn Availability Groups
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: George Walters
Title: SQL Server 2012 AlwaysOn Availability Groups
Abstract:
The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.
SessionID: 14976
Merge Replicaton Internals
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Hilary Cotter
Title: Merge Replicaton Internals
Abstract:
Merge Replication allows you to replicate data bi-directionally. It is designed for occasionally connected data islands which need to aggreate data centrally, and vice versa. This session covers merge replication internals, conflicts, resolvers including the business logic and stored procedure resolver, dynamic and static filtering and how to handle identity ranges.
SessionID: 15523
How to Build a Centralized Database Monitoring Solution – Never Miss a Backup
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: John Abrams
Title: How to Build a Centralized Database Monitoring Solution – Never Miss a Backup
Abstract:
As every DBA knows, the one question you want to be able to answer affirmatively is “Can you recover that data?”
Monitoring is critical, but monitoring methods can be imperfect. Traditional methods are difficult to set up and maintain across your entire environment, resulting in incomplete monitoring and missed alerts, so that it’s difficult to be sure of your answer to that all important question.
This presentation will:
• Show you how to implement a better way to monitor your database environment that is more efficient, easier to maintain, and guarantees that you never miss an alert.
• Share the methodology, framework, and key syntax, so that you are certain the databases you are responsible for are always up, always backed up, and never run out of disk/file space.
So that your answer to that all important question is always YES!
SessionID: 16196
Into the Blue: Extending AlwaysOn Availability Groups
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Joseph D'Antoni
Title: Into the Blue: Extending AlwaysOn Availability Groups
Abstract:
For many organizations, having a second data center or co-location center doesn’t make sense, financially or logistically. Typically, this would limit options for building out a disaster recovery (DR) solution. However, now with Windows Azure virtual machines and SQL Server AlwaysOn Availability Groups, you can connect your on-premise solution to a real-time secondary replica, providing read scalability and a solid DR solution.
This session will demonstrate how to extend an Availability Group into Windows Azure, discussing the pros and cons as well as the cost of the solution. You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs and benefits of building a DR solution within Windows Azure, and how Azure-based backup and recovery can work.
SessionID: 16302
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Jeffrey Garbus
Abstract:
Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
SessionID: 17049
How to audit and prevent unwanted user actions.
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: John Miner
Title: How to audit and prevent unwanted user actions.
Abstract:
Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation,
there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.
Coverage:
1 – Granting correct user access is vital.
2 – DML triggers to keep a DATA audit trail.
3 – DDL triggers to keep a SCHEMA audit trail.
4 – Preventing unwanted DATA modifications.
5 – Preventing unwanted SCHEMA changes.
6 – Preventing table TRUNCATIONS.
7 – LOGIN triggers to control who, what, and when.
8 – Change data capture (CDC) an alternative to triggers.
SessionID: 17890
Windows Azure SQL Database Design: Silver Lining and Dark Side
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Karen Lopez
Title: Windows Azure SQL Database Design: Silver Lining and Dark Side
Abstract:
Data modelers and designers need to understand the logical, physical, and technical differences in designing for Windows Azure SQL Databases (WASDs) and traditional on-premise SQL Server databases. In this session, we'll review the concepts that still work in both and the features that need to be tailored to each target environment.
You’ll see demonstrations of the database design processes and gain best practices for model-driven development for each environment, including tool support. The session will feature a demonstration of a complete life cycle roundtrip – data model to database and back to data model – and tips and tricks for creating and maintaining WASD database designs. We’ll finish up with 10 tips for designing databases for both WASD and SQL Server.
SessionID: 18193
SQL Server Internals and Architecture
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Kline
Title: SQL Server Internals and Architecture
Abstract:
What’s different about 32- and 64-bit systems?
What are the various areas of memory inside of SQL Server?
How are queries handled behind the scenes?
What does SQL Server do with procedural code, like functions, procedures, and triggers?
What happens during checkpoints? Lazywrites?
How are IOs handled with regards to transaction logs and database?
What happens when transaction logs and databases grow or shrinks?
SessionID: 18255
SQL Server Sudoku Solver using Transact-SQL
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Kevin Feit
Title: SQL Server Sudoku Solver using Transact-SQL
Abstract:
This session will provide an introduction to Transact-SQL using a stored procedure to solve a Sudoku puzzle as an example. Language elements covered will include use of variables, conditional logic, looping, and recursion.
SessionID: 18271
SSAS Tabular 2012 vs SSAS Multidimensional OLAP
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Goff
Title: SSAS Tabular 2012 vs SSAS Multidimensional OLAP
Abstract:
In this presentation, I'll compare the new Tabular Model in SSAS 2012 with the more "traditional" multidimensional OLAP in SSAS. I'll show which of the 2 approaches works better in specific scenarios, and why you'd want to use one method over the other for certain applications. If you are trying to decide which approach to use, or if you are an experienced OLAP developer who wants to know the pros and cons of moving to the Tabular Model, this presenation is for you!
SessionID: 18408
Indexes: The Basics
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Kathi Kellenberger
Title: Indexes: The Basics
Abstract:
SessionID: 19041
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Leonard Lobel
Abstract:
SessionID: 19751
The 10 Commandments of ETL
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Martin Schoombee
Title: The 10 Commandments of ETL
Abstract:
In this session I will share the 10 basic principles I follow when developing ETL processes, and also show how the different choices can affect performance. Following these simple guidelines have resulted in many successful projects and happy customers. I'm sure it will work for you too!!
SessionID: 19882
Automating in the Cloud
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Matt Velic
Title: Automating in the Cloud
Abstract:
We've heard all the awesome Cloud deployment stories, but DBAs can use the Cloud too! Looking for a way to test your backups? Need to find an offsite location as a part of a DR plan? What about defining your backup retention scheme? You can handle these common administration problems by utilizing Cloud services in combination with PowerShell automation. In this session, we'll review the basic Cloud architecture of both Azure and Amazon, as well as some specifics as to the components of the solution.
SessionID: 20235
Virtualizing SQL 2012: Doing It Right
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Michael Corey
Title: Virtualizing SQL 2012: Doing It Right
Abstract:
SessionID: 20533
Recovery and Backup for Beginners
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Mike Hillwig
Title: Recovery and Backup for Beginners
Abstract:
We all know that backups are important. But are we building a backup strategy that can recover in a manner that meets business needs? All too often, we plan a backup strategy without a recovery strategy.
In this session, veteran DBA Mike Hillwig will start with understanding the recovery strategy and work toward implementing the right backups to meet that recovery strategy. He'll also set the record straight around some very common myths around database recovery and backups.
SessionID: 21585
Indexing your Data Warehouse
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Troy Gallant
Title: Indexing your Data Warehouse
Abstract:
SessionID: 21788
ETL not ELT! Common mistakes and misconceptions about SSIS
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Paul Rizza
Title: ETL not ELT! Common mistakes and misconceptions about SSIS
Abstract:
SessionID: 23545
HealthySQL
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Robert Pearl
Title: HealthySQL
Abstract:
Session Level: Beginner
Robert Pearl
Speaker photo Robert Pearl, President of Pearl Knowledge Solutions, Inc., SQL MVP/SME, solutions-oriented Senior DBA with 12+ years of experience. He's a SQLCommunity/SQLSaturday evangelist/promoter and maintains his regular b
SessionID: 23900
Biml for Fun and Profit with SSIS
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Samuel Vanga
Title: Biml for Fun and Profit with SSIS
Abstract:
SessionID: 24019
New version: Get-PowerShell | Get-SQLServer
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: SB Chatterjee
Title: New version: Get-PowerShell | Get-SQLServer
Abstract:
SessionID: 24666
Using Power View Hadoop to Unlock Hidden Markets
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Stacia Varga
Title: Using Power View Hadoop to Unlock Hidden Markets
Abstract:
A practical way to derive business value from big data is to micro-target customers, but where do you begin? In this session, we examine real data from one of the nation's largest cable TV providers and combine it with data from the 2010 census and other data sources. Then we walk through a demonstration of how to use Hadoop and the Microsoft BI stack with this integrated data to develop powerful analytics quickly and easily. We demystify the process of working with big data by showing you first how to gather and load the data into Hadoop, and then how to extract a subset of that data and apply data visualization to reveal insightful patterns that you can use to connect more effectively with customers. Co-presented with Joey D'Antoni
SessionID: 25140
Database Design: Size DOES Matter
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Thomas LaRock
Title: Database Design: Size DOES Matter
Abstract:
SessionID: 25323
Alright,WHY is the server REALLY running so slow!
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Steve Simon
Title: Alright,WHY is the server REALLY running so slow!
Abstract:
SessionID: 25772
Building BI Solutions with Excel 2013
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Steve Hughes
Title: Building BI Solutions with Excel 2013
Abstract:
If you have not experienced building BI solutions with Excel 2010, be amazed at what you can do in Excel 2013. In this session we will use PowerPivot, Power View, Quick Explorer, and other great features in Excel to build an Excel 2013 BI solution. Microsoft has went "all-in" with Excel as their primary BI client. If you want to get a first hand look at using it more fully, you will be amazed. I know I was.
SessionID: 26090
Upgrading to SQL Server 2012 with limited downtime
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Ted Krueger
Title: Upgrading to SQL Server 2012 with limited downtime
Abstract:
I don’t and that is why we’re going to look at methods to upgrade or migrate SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2 up to SQL Server 2012 with as little downtime as possible - minutes. In this session, we’ll see how mirroring, log shipping and even replication, can make us look like DBA Rock stars at upgrade time.
SessionID: 26112
SQL Server Storage Engine under the hood
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Thomas Grohser
Title: SQL Server Storage Engine under the hood
Abstract:
How is SQL Server really accessing the data and log files on the disk? What's done asynchronous and what's synchronous and what impact does that have on our queries and DML statements.
Which impact have features like database mirroring and replication, what's different when SQL Server is starting up.
Which I/O Subsystems (including SSD) are best for which type of data and what's the impact if you choose a different one. Which files can be placed on the same volume and which should not.
SessionID: 26195
Common TSQL Mistakes
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 26820
A Walk Around the SQL Server 2012 Audit Feature
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 8
Speaker: Timothy McAliley
Title: A Walk Around the SQL Server 2012 Audit Feature
Abstract:
In this session, we will start by covering an overview of server and database auditing capabilities of SQL Server 2012. The session will largely focus on the specifics of using the SQL Server Audit feature, and we will step through a demonstration on configuring, maintaining and troubleshooting SQL Server Audit for server and database events.
SessionID: 27458
Data Flow Architectures in Software Development Life-Cycle
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: Virginia Mushkatbat
Title: Data Flow Architectures in Software Development Life-Cycle
Abstract:
The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach.
SessionID: 27679
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Wayne Sheffield
Abstract:
SessionID: 34843
SQL Server Databaseology 201
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 7
Speaker: John Morehouse
Title: SQL Server Databaseology 201
Abstract:
Did you love "Bill Nye, the Science Guy" when you were a kid? Or maybe you were a MacGyver fan? Did you take apart your Mom's toaster or your Dad's alarm clock just to see how it ticked? Ever wonder how that database you built or support works behind the scenes? SQL Server Databaseology 201 is the science concerned with the study of SQL Server databases and their structures. This session will explore some of the deep inner workings of a SQL Server databases. The attendee will walk away with a deeper understanding of how SQL Server databases work which would allow them to build better and faster databases.
SessionID: 35785
Data Career Paths and Decision Making Strategies
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Melissa Demsak
Title: Data Career Paths and Decision Making Strategies
Abstract:
SessionID: 9223
Advanced T-SQL Development with latest features.
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Alex Grinberg
Title: Advanced T-SQL Development with latest features.
Abstract:
SessionID: 9239
Patch Management Strategies for SQL Server
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Allan Hirt
Title: Patch Management Strategies for SQL Server
Abstract:
SessionID: 9481
Big Data-BI Fusion: Microsoft HDInsight MS BI
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Andrew Brust
Title: Big Data-BI Fusion: Microsoft HDInsight MS BI
Abstract:
HDInsight is the name of Microsoft’s distribution of Apache Hadoop, the essential and defining technology of the Big Data world. But why in the world would Microsoft embrace an open source technology, written in Java, and customarily run on clusters of Linux servers? Two words: Business Intelligence. HDInsight (and Hadoop in general) become far more enterprise-friendly when combined with Microsoft BI technologies like PowerPivot, Analysis Services and Power View. And then there’s SQL Server Parallel Data Warehouse, which actually blends the BI and Big Data worlds together in one product. In this session, Microsoft BI expert and ZDNet Big Data blogger Andrew Brust will introduce you to HDInsight and its developer tools, demonstrate relevant BI tools and show how they work together. He’ll also show how developers with relational database skills can make the jump into this exciting and opportunity-filled area.
SessionID: 9915
SQL Server 2014 - Staying Ahead of the curve
Event Date: 17-08-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Ashish Sharma
Title: SQL Server 2014 - Staying Ahead of the curve
Abstract:
This session will discuss new features and improvements in SQL Server 2014 which is the next release of SQL Server. Topics will include In- Memory database engine, Always-On Improvements, Business Intelligence improvements and Cloud Enhancements.