Nr: 169
SQLSaturday #169 - Denver 2012
SessionID: 11310
Big Data for the SQL Server DBA w/Kevin Cox-Part 2
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Big Data/Cloud
Speaker: Carlos Bossy
Title: Big Data for the SQL Server DBA w/Kevin Cox-Part 2
Abstract:
SessionID: 11313
Big Data for the SQL Server DBA w/Kevin Cox-Part 1
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Big Data/Cloud
Speaker: Carlos Bossy
Title: Big Data for the SQL Server DBA w/Kevin Cox-Part 1
Abstract:
SessionID: 11489
"What is the Best Disaster Recovery Solution?"
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DB Developer/DBA
Speaker: Chris Shaw
Title: "What is the Best Disaster Recovery Solution?"
Abstract:
It depends, every situation is different. The question is often asked of DBA's to provide a solution to very open ended requirements. However, the best solution can only be provided if the database professional is getting all the answers. This session is a case study into many of Disaster Recovery options that we as database professionals have. Understand the answers to the important questions that we should be asking to provide the best solution not only for the database but for the business as well. As an attendee you will learn how to change an answer from it depends into a solid solution that can be built upon. We will take examples from experiences and as a group determine what the best solution is.
SessionID: 11654
SSIS Configurations
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Chris Schmidt
Title: SSIS Configurations
Abstract:
SessionID: 11936
A Lap Around Data Quality Services 2012
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: SQL Server 2012 Roundup
Speaker: Christopher Price
Title: A Lap Around Data Quality Services 2012
Abstract:
We will explore data quality issues that face today’s business and how Data Quality Services 2012 can help IT Pros and Data Stewards meet those challenges. We will start from zero, build a knowledge base, profile data to train our knowledge base and then use that knowledge to highlight both the cleansing and matching capabilities of DQS. This session will also cover the DQS SSIS component that’s available in SQL Server 2012.
SessionID: 12861
Oracle for the SQL Server DBA
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Kellyn Pot'Vin-Gorman
Title: Oracle for the SQL Server DBA
Abstract:
The attendee will leave this session with a solid understanding of the similarities and differences in comparison to common Oracle features, design basics and how they correspond to SQL Server architecture.
Prerequisites: An open mind to different database platforms and a solid understanding of SQL Server. No exposure to Oracle database administration is required to attend this presentation.
SessionID: 12868
Data Warehouse Best Practices
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Doug Barrett
Title: Data Warehouse Best Practices
Abstract:
This session will describe the best practices for designing a data warehouse to get the most out of SQL Server. Raphael has worked in data warehousing for 12 years and will blend experience, with best practices and recommendations from Microsoft's Fast Track program. Each version of SQL Server introduces new features specifically for data warehousing - by applying the correct technique, feature, hint, modelling approach and layout the data warehouse will be faster and more scalable.
SessionID: 13385
What To Do When It's Just You
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Professional Development
Speaker: Doug Lane
Title: What To Do When It's Just You
Abstract:
Are you the only SQL Server professional at your company? Join Glenn Berry, Mike Fal, Carlos Bossy, and Doug Lane in an interactive discussion about how to deal with the challenges of being the only SQL person on staff. Whether you're one of five employees or five hundred, you'll learn tips and techniques for how to survive and thrive as a solo DBA/developer. Topics will include managing time and expectations amid frequent interruptions, how and when to automate and delegate tasks, maintaining data quality, and getting help when you're stuck.
SessionID: 14122
Develop a Quick and Dirty Web interface to your DB
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DB Developer/DBA
Speaker: Gabriel Villa
Title: Develop a Quick and Dirty Web interface to your DB
Abstract:
SessionID: 14685
DMV Emergency Room!
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Glenn Berry
Title: DMV Emergency Room!
Abstract:
SessionID: 15836
Dimension Modeling Design Patterns: Beyond Basics
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Jason Horner
Title: Dimension Modeling Design Patterns: Beyond Basics
Abstract:
This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
SessionID: 16517
T-SQL Brush-up: The Best Things You Forgot
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DB Developer/DBA
Speaker: Jennifer McCown
Title: T-SQL Brush-up: The Best Things You Forgot
Abstract:
You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool. This session is chock full of code examples, including before-and-after demos and how-tos.
SessionID: 16518
Women in Technology: Career Roundtable
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Professional Development
Speaker: Jennifer McCown
Title: Women in Technology: Career Roundtable
Abstract:
SessionID: 16656
Exploring your Data with Power View
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: SQL Server 2012 Roundup
Speaker: Jessica Moss
Title: Exploring your Data with Power View
Abstract:
SessionID: 16657
Upgrading and Overhauling SSIS Packages for 2012
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: SQL Server 2012 Roundup
Speaker: Jessica Moss
Title: Upgrading and Overhauling SSIS Packages for 2012
Abstract:
SQL Server 2012 makes great strides in the development, maintainability, and administration features of Integration Services packages. Whether you already have packages from an earlier version or you are starting from scratch, you will learn how to take advantage of these new features. In this session, we will show: an upgrade of Integration Services packages from 2008 R2 to 2012, the modifications needed to run these packages in 2012, and the information produced about package execution.
SessionID: 16884
The Accidental Programmer
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DB Developer/DBA
Speaker: Jason Kassay
Title: The Accidental Programmer
Abstract:
Most people in the database world have heard of the term, "The Accidental DBA", those programmers who out of nowhere get thrown into working with databases. Well what about the other side of the coin? What about those DB Developers and DBA's who have to write code? This presentation is a best practices guide for working with SQL Server in a .Net environment. You will learn how to recognize when bad code is written that interacts with the database, how to track it down, and most importantly how to fix it. On top of that you will also receive an introduction to object oriented programming concepts such as data abstraction, encapsulation, tier architecture, and class objects so that you can better communicate with your programmers.
SessionID: 17110
SSRS Patterns and Practices: Cube Reporting
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Joe Salvatore
Title: SSRS Patterns and Practices: Cube Reporting
Abstract:
This session focuses on many patterns, practices, and general considerations for accessing SQL Server Analysis Services (SSAS) cube data using SQL Server Reporting Services.
SessionID: 18250
Largest SQL Azure projects in the world
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Big Data/Cloud
Speaker: Kevin Cox
Title: Largest SQL Azure projects in the world
Abstract:
See the architecture of the largest Azure projects in the world. Find out why most use a combination of SQL Azure and NoSQL.
SessionID: 19424
New T-SQL 2012 features
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: SQL Server 2012 Roundup
Speaker: Marc Beacom
Title: New T-SQL 2012 features
Abstract:
SQL Server 2012 has many new T-SQL features and enhancements that will simplify your code and life. We’ll roll up our sleeves and dive in head first to take a look at some of the new features.
SessionID: 19950
A Practical Approach to Table Partitioning
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Mike Byrd
Title: A Practical Approach to Table Partitioning
Abstract:
There are many white papers and articles about table partitioning, but when it comes down to implementing partitioning there is little "real world" documentation. This presentation will cover definitions (so you will know what I am talking about), tips on what tables to partition and how to pick a partition key, and finally a real world example with scripts on implementation and ongoing maintenance of the partitioned tables.
SessionID: 19973
SSIS 2012 New Features
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: SQL Server 2012 Roundup
Speaker: Mike Davis
Title: SSIS 2012 New Features
Abstract:
The newest version of SQL Server is out and packed with new features. Come see all of the newest features and best practices in SSIS 2012. Learn about the new SSIS parameters, environments, deployment, and the new tasks. Understand the new project deployment mode and how to execute SSIS 2012 packages with T-SQL.
SessionID: 19974
Complex DAX Functions
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Mike Davis
Title: Complex DAX Functions
Abstract:
SessionID: 22898
Tabular Models
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Jeff Renz
Title: Tabular Models
Abstract:
Tabular modules allow developers to create models based upon different data sources; create hierarchies, perspectives, partitions and roles similar to traditional OLAP cubes. In this session will highlight the differences between traditional OLAP and tabular models and reasons for selecting one approach over another. I will demonstrate how to create a data model first in power pivot model and then import into an Analysis Services Tabular Project. Working with the imported data I will then create measures, KPIs, perspectives, and implement security. Finally I will deploy the model to an Analysis Server.
SessionID: 24041
SQL Azure and Hadoop: A practical example
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Big Data/Cloud
Speaker: Scott Berkley
Title: SQL Azure and Hadoop: A practical example
Abstract:
Increasingly, firms are encountering issues when attempting to turn massive data sets from social media and other textual sources into usable information. Solutions like Hadoop and MapReduce offer the ability to mine and aggregate large amounts of information, but there is quite a difference between these systems and traditional relational databases. This session will provide an overview and demonstration of Microsoft’s Azure cloud offering with Hadoop and will cover the benefits and challenges of implementing a “Big Data” solution
SessionID: 24255
The Backup Tune-Up
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Sean McCown
Title: The Backup Tune-Up
Abstract:
Have you ever gotten tired of your 1TB database taking 4+ hrs to backup? Are you sick of having your users breathe down your neck for 2hrs because it’s taking too long to restore a DB? Well now you don’t have to worry about that anymore. I’m going to show you some little known tricks, methods, and trace flags you can use to tune your backups just like you would a query. Backups actually have kind of an execution plan that you can access if you know how, and knowing how to get the individual portions of your backup process down will allow you to knock 80% and even more off of your backup and restore time. I’m not holding anything back in this session. This is a method I’ve used for 15yrs to tune my backups and I’ve had great success.
SessionID: 24257
Mouth Wide Shut: Coherent Interviewing
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Professional Development
Speaker: Sean McCown
Title: Mouth Wide Shut: Coherent Interviewing
Abstract:
"Interviews are so easy," says absolutely nobody. In fact, interviewing for your next DBA or SQL developer job is a very tricky process, with many common pitfalls. In this fun and interactive session, we'll give you all the best advice you've never heard about pre-interview preparation, typical traps, and the new professionalism. You will start to refine the way you present yourself, tailor your answers appropriately, and learn about our revolutionary negotiating tactics. Most importantly, we'll quantify the most difficult aspect of interviews: knowing when to keep silent.
SessionID: 24475
Branding Yourself for a Dream Job
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Professional Development
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 24477
Unstructured Data in SQL Server
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Big Data/Cloud
Speaker: Steve Jones
Title: Unstructured Data in SQL Server
Abstract:
A look at the Filestream and Filetable features in SQL Server that can allow you to handle unstructured data inside your SQL Server database.
SessionID: 24613
Reverse Engineering The Database
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DB Developer/DBA
Speaker: Brandon Tucker
Title: Reverse Engineering The Database
Abstract:
SessionID: 26928
Track'em! What are DBA's doing on my server?
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: Thomas Norman
Title: Track'em! What are DBA's doing on my server?
Abstract:
Everyday a DBA needs to access our system. They might need to make a change. Can I see what they
did, of course. Let's look at DDL tracking, events and service broker to see how we can see security,
object and jog changes. What did that DBA really to in our Sql Server? We need a log to show our
auditor, let's prove what the DBA did.
SessionID: 26958
SQL 2012 Encryption and You
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: SQL Server 2012 Roundup
Speaker: Todd Kleinhans
Title: SQL 2012 Encryption and You
Abstract:
When do you need your data encrypted? After providing a brief history and intro to encryption and cryptography, we will look at several ways to secure your SQL Server 2012 data and systems. We are going to cover: column level encryption, transparent data encryption (TDE), discuss third party tools, and enterprise key management (EKM) using hardware security modules (HSM)s. We will also cover certain gotchas and pitfalls to avoid.
SessionID: 34807
Exposing the Core: SQL 2012 on Server Core
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DB Developer/DBA
Speaker: Michael Fal
Title: Exposing the Core: SQL 2012 on Server Core
Abstract:
Everything that's old is new again, as Windows Server moves back to the terminal interface. With SQL 2012, we can now run our SQL Servers on Server Core, a version of the Windows OS that is smaller and more secure. This presentation will introduce you to Server Core, how to prepare it for a SQL installation(including using Powershell for management), and how to actually install SQL 2012 on to it.
SessionID: 34809
Musically Speaking: Building Better Presentations
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: Professional Development
Speaker: Michael Fal
Title: Musically Speaking: Building Better Presentations
Abstract:
SessionID: 34823
10 Things That Every DBA Should Know!
Event Date: 22-09-2012 - Session time: 00:00:00 - Track: DBA
Speaker: John Morehouse
Title: 10 Things That Every DBA Should Know!
Abstract:
Are you just starting out in the DB world? Are you unsure of things that you should know? Are you a developer wanting to gain further insight on how to improve your SQL Skills? If you answered 'Yes' to any of those question, then this is the session for you! John will be talk about things that he's seen in the trenches that every DBA should know and understand.