Nr: 256
SQLSaturday #256 - Kalamazoo 2013
SessionID: 10043
Automate Your ETL Infrastructure with SSIS and PowerShell
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Wile Auditorium
Speaker: Allen White
Title: Automate Your ETL Infrastructure with SSIS and PowerShell
Abstract:
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
SessionID: 10673
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room D
Speaker: Brandon Leach
Abstract:
In this introductory session we'll delve into the basics of the resource governor feature in SQL Server. We'll look at the types of issues this feature can help resolve. We'll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we'll bring all this together with an example implementation. From there, if time allows, we'll look at best practices and questions to answer to ensure a successful implementation.
SessionID: 11874
SSIS Olympics
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room B
Speaker: Cory Stevenson
Title: SSIS Olympics
Abstract:
SessionID: 12369
T-SQL: Simple Changes That Go a Long Way
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room C
Speaker: David Valentine
Title: T-SQL: Simple Changes That Go a Long Way
Abstract:
Writing TSQL that performs well requires knowledge beyond proper syntax, sometimes it requires more than just knowing TSQL, and sometimes it takes a bit of rework and ingenuity. There are simple things that you will learn in this session that will improve the performance of your queries. Learn about indexing techniques and reading execution plans to see if the optimizer is using the index. Performance isn't everything though. There are small things you can do to make your TSQL more maintainable too. We will dive into a few TSQL tricks with Common Table Expressions, Table-Valued Parameters, and COALESCE.
SessionID: 13316
DBA 911 - Database Corruption
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room B
Speaker: David Maxwell
Title: DBA 911 - Database Corruption
Abstract:
SessionID: 14110
Partitioning for Perf and Mgmt of Large Tables
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room B
Speaker: Eddie Wuerch
Title: Partitioning for Perf and Mgmt of Large Tables
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
SessionID: 14300
Going Spatial
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room D
Speaker: Frank Murphy
Title: Going Spatial
Abstract:
SessionID: 14639
You're THE DBA. Now What?
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room B
Speaker: Gill Rowley
Title: You're THE DBA. Now What?
Abstract:
Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you're a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.
SessionID: 15003
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room A
Speaker: Hope Foley
Abstract:
You got the "It's Slow" call, yeah you know the one. There are many places to dig in and determine how true that is but we'll focus on what the server thinks utilizing Performance Monitor. We'll go a bit deep into those facts in the poster on the wall and tell you the what/where/whys of it all. We'll make sure you understand those items selected and what they mean. We will also go through ways to quickly analyze that mountain of data collected.
SessionID: 15464
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room D
Speaker: Ira Warren
Abstract:
SessionID: 16044
Disabling xp_CmdShell - Is it really a best practice?
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Wile Auditorium
Speaker: Jeff Moden
Title: Disabling xp_CmdShell - Is it really a best practice?
Abstract:
SessionID: 16206
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room A
Speaker: Joseph D'Antoni
Abstract:
Back in the old days, compression and databases was a really bad idea. Now, with powerful CPUs we can use to both improve performance and save disk space. We will cover the basics of how all compression and deduplication works, and then we will learn how SQL Server page and row compression work, and the special compression that is used in SQL 2012 Columnstore Indexes. We will demo performance and space savings in using compression.
SessionID: 16208
You Wouldn't Let HR Manage Your DBs...
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room C
Speaker: Joseph D'Antoni
Title: You Wouldn't Let HR Manage Your DBs...
Abstract:
So don't let them manage your career. This session will be a panel discussion with three long term IT professionals representing several different career tracks in IT. Learn about how your HR organization works, what salary levels and midpoints are, and get great career advice from our expert panel. Presented with Karen Lopez.
SessionID: 17889
Windows Azure SQL Database Design: Silver Lining and Dark Side
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room A
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. We’ll finish up with 5 tips for designing databases for both WASD and SQL Server.
SessionID: 20840
Five Easy Pieces
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room A
Speaker: Michael Swart
Title: Five Easy Pieces
Abstract:
It's story time. I explore 5 unrelated recent production episodes I tackled. For each issue, I explain the troubleshooting methods I used, the data I collected, the plan I made and the actions I took. DBAs or DB Developers in attendance will learn about data gathering methods and quick troubleshooting tricks. You'll learn the easy way some lessons I learned the hard way.
SessionID: 22657
Goodbye Next Next Next, Hello Automated Installs
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room D
Speaker: Brian Davis
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract:
SessionID: 22993
Temporary Objects Without Permanent Consequences
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room D
Speaker: Rick Krueger
Title: Temporary Objects Without Permanent Consequences
Abstract:
SessionID: 24590
Interrogating the Transaction Log
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room C
Speaker: Frank Gill
Title: Interrogating the Transaction Log
Abstract:
Without the transaction log, SQL Server would have no way of maintaining a consistent and durable view of its data. It would be pandaemonium!!! Think of the Stay-Puft Marshmallow Man!
Thankfully the transaction log is there and we can all breathe easier.
In this session, you will learn how SQL Server uses the transaction log to maintain the durability and consistency of its data, along with methods for reading the transaction log and identifying active transactions.
SessionID: 24653
A Big Data Primer
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Wile Auditorium
Speaker: Stacia Varga
Title: A Big Data Primer
Abstract:
The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
SessionID: 24933
Maximizing the Data Exploration Capabilities of Power View
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room B
Speaker: Melissa Coates
Title: Maximizing the Data Exploration Capabilities of Power View
Abstract:
We will identify which situations Power View is most suited for, as well as its strengths and limitations. Capabilities in SharePoint 2010/2013 vs. Excel 2013 will be reviewed, as well as restrictions on types of data sources allowed. We will also discuss how to prepare a dataset in order to maximize the usability and functionality of Power View.
SessionID: 25181
A World Where All Data Has a Place to Live: Centralizing Distributed Reference Data
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room C
Speaker: Shane Risk
Title: A World Where All Data Has a Place to Live: Centralizing Distributed Reference Data
Abstract:
Have you ever started work on a project only to find that one of your key reference datasets is only available in a spreadsheet on somebody's desktop? Even worse, you've probably run into situations where key data elements are 'common knowledge' amongst the business users, but don't even exist in a spreadsheet.
Take heart. Using Master Data Services (MDS) we now have an effective solution to this problem that has plagued IT for years, without having to create a custom solution. In this session you will learn the basics of MDS, and how it can be used to easily create a home for the homeless data on your latest project. Also, learn how Data Quality Services integration can be used to detect duplicate records, and perform cleansing operations.
Don't get hung up trying to build a custom solution to house homeless reference data during your next project. Join this session and learn how to use MDS so you can deliver your project on time and on budget.
SessionID: 25993
45 min to build your first SSRS report
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room A
Speaker: Tamera Clark
Title: 45 min to build your first SSRS report
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output.
SessionID: 25994
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room A
Speaker: Tamera Clark
Abstract:
SessionID: 26547
Back(up) to Basics
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room D
Speaker: Ben Thul
Title: Back(up) to Basics
Abstract:
Are your databases being backed up? Are you sure? Are you sure they're being backed up correctly? Maybe you're an "accidental DBA" or a developer who's not quite sure of the answers to those questions. In this session, you'll learn what the different types of basic backups are, how to execute them, and (perhaps most importantly) how to restore from them if and when necessary.
SessionID: 26868
Periodic Table of DMVs: Collecting Baselines
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Wile Auditorium
Speaker: Tim Ford
Title: Periodic Table of DMVs: Collecting Baselines
Abstract:
SessionID: 27454
Data Flow Architectures in Software Development Life-Cycle
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room B
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: 8908
T-SQL : Bad Habits Best Practices
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Wile Auditorium
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits Best Practices
Abstract:
Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.
SessionID: 8970
Introduction to SQL Server Service Broker
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room C
Speaker: Adam Belebczuk
Title: Introduction to SQL Server Service Broker
Abstract:
In this session, we'll cover the basics of setting up SQL Server Service Broker from the ground up with lots of demos. We'll discuss some pros and cons to using Service Broker, some common problems encountered when using it, and some example use cases. If you've ever been curious about Service Broker, need to send data between databases or instances, or are wondering if Service Broker is right for your organization, then you won't want to miss this session.
SessionID: 9080
Manageable SSAS Deployment Strategies
Event Date: 02-11-2013 - Session time: 00:00:00 - Track: Room C
Speaker: Kerry Tyler
Title: Manageable SSAS Deployment Strategies
Abstract:
If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.