Nr: 190
SQLSaturday #190 - Denver 2013
SessionID: 10235
SQL Server TDE
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Ben Miller
Title: SQL Server TDE
Abstract:
Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? This session will go over all the steps and caveats that go with this technology. This is a topic that is an Enterprise Feature, but allows you to have your database encrypted on disk. We will discuss the Encryption Hierarchy as well as how it relates to SQL Server TDE.
SessionID: 10236
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DEV/DBA
Speaker: Ben Miller
Abstract:
SessionID: 10429
Type More, Click Less: Programmatically build SSIS packages
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Bill Fellows
Title: Type More, Click Less: Programmatically build SSIS packages
Abstract:
SessionID: 10990
Bringing Sexy Back...to the Database?
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Bruce Adair
Title: Bringing Sexy Back...to the Database?
Abstract:
"Bringing Sexy Back...to the Database" examines the negative impact that schema changes have on the strategic business objectives of a company.
SessionID: 11333
Getting started with Big Data and BI
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Power BI
Speaker: Carlos Bossy
Title: Getting started with Big Data and BI
Abstract:
SessionID: 11494
Interview Tips
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Chris Shaw
Title: Interview Tips
Abstract:
Have you been asked for an interview for that perfect job? The job that you would love to have on a team that you really want to be a part of? It is time to sharpen those interview skills.
Every interview is different. During this session we will talk about my observations from many interviews that I have been a part of. There are many examples in this session on how not to present yourself, during an interview. We may laugh at some of the observations, but there are many lessons to learn. Get an inside look at how hiring managers make decisions, and make sure you know what to look for as the candidate.
Have you been tasked with conducting an interview? We will complete the session with some tips on how to make sure that you get the information you need to make a good decision.
SessionID: 11505
Becoming Certified In Microsoft SQL Server
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Professional Dev
Speaker: Chris Hyde
Title: Becoming Certified In Microsoft SQL Server
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with maxIT-VCS, a subsidiary of SAIC that specializes in healthcare IT consulting for the healthcare market, which he particularly enjoys as he gets to tackle different types of SQL problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
SessionID: 11751
Backup Basics
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DEV/DBA
Speaker: Meredith Ryan-Smith
Title: Backup Basics
Abstract:
Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one.
SessionID: 11752
Women In Technology Roundtable
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Keynote/Lunch
Speaker: Meredith Ryan-Smith
Title: Women In Technology Roundtable
Abstract:
It has been shown many times that diverse teams create better products and develop more creative solutions to issues. Given that why does Technology still have problems with diversity? It seems for every article that you see highlighting a group doing good work that encourages women to consider STEM career choices, there is another that points out the issues women face inside STEM. Join a group of prominent women from data professions as we discuss the current state of WIT, and what can be done to create a more welcoming space for all.
SessionID: 12414
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: More DBA
Speaker: Sios Technology and Allan Hirt
Abstract:
SessionID: 12586
Virtualizing Critical SQL Servers
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: David Klee
Title: Virtualizing Critical SQL Servers
Abstract:
SessionID: 13270
Implementing Data Partitioning and Tiered Storage
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Dmitri Korotkevitch
Title: Implementing Data Partitioning and Tiered Storage
Abstract:
SessionID: 13388
SQL Server Murder Mystery Hour: Dead Reports Don't Talk
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Power BI
Speaker: Doug Lane
Title: SQL Server Murder Mystery Hour: Dead Reports Don't Talk
Abstract:
SABOTAGE? MURDER?
Before a pivotal meeting to secure venture capital, a key report vanishes from the server without a trace, leaving Cromulent Technologies' future in jeopardy. Our group must solve the crime. Time is critical as the CEO has promised to explain the matter to investors just sixty minutes from now. Only with your investigative skills, SQL Server knowledge, and teamwork can we find the missing report, bring the perpetrator to justice, and save Cromulent Technologies!
SQL Server Murder Mystery Hour is part technical presentation, part networking event. We'll focus on Reporting Services administration in areas that are vital to business continuity: security roles, encryption keys, and backups. All attendees have a part to play.
SessionID: 14681
Hardware 201: Selecting Database Hardware
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: More DBA
Speaker: Glenn Berry
Title: Hardware 201: Selecting Database Hardware
Abstract:
SessionID: 15850
Dimension Modeling Design Patterns: Beyond Basics
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: BI
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: 16889
Getting Started with Execution Plans
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: More DBA
Speaker: Jason Kassay
Title: Getting Started with Execution Plans
Abstract:
You just received a phone call from your boss telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, the first thing you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points
SessionID: 18857
The Curious Case of Isolation Levels
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: More DBA
Speaker: Keith Tate
Title: The Curious Case of Isolation Levels
Abstract:
Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.
SessionID: 19198
Somebody got BIDS Helper in my Data Tools
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Meagan Longoria
Title: Somebody got BIDS Helper in my Data Tools
Abstract:
SessionID: 19399
Self Service BI using Office 2013 and SQL 2012
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Power BI
Speaker: Akesh Gupta
Title: Self Service BI using Office 2013 and SQL 2012
Abstract:
This session covers the Self Service BI solutions available using Office 2013 and SQL 2012 for business users to do their ad-hoc analysis. In addition, the Analysis Models can be used by Power View for visual representation of the analysis.
SessionID: 19427
Introduction to Tabular Models
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Power BI
Speaker: Marc Beacom
Title: Introduction to Tabular Models
Abstract:
SessionID: 20141
How flash storage modernizes databases and tips for tuning databases for all flash arrays
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Matt Henderson
Title: How flash storage modernizes databases and tips for tuning databases for all flash arrays
Abstract:
For decades the characteristics of spinning hard drives have acted as a tail wagging the dog requiring the processes and behaviors of software, architecture and administrators to bend to its requirements. With the advent of a new technology, flash storage, comes the unleashing of a new round of performance potential as well as a shedding of long encumbering patterns. Modernizing databases is about both vastly boosting performance and also significantly reducing the complexity and effort to maintain them. Come see a deep dive into how ultra-fast and random-optimized storage is modernizing database performance, architecture and maintenance.
SessionID: 20971
The Accidental Report Designer: Data Visualization Best Practices in SSRS
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Power BI
Speaker: Meagan Longoria
Title: The Accidental Report Designer: Data Visualization Best Practices in SSRS
Abstract:
SessionID: 21162
What secrets does your database schema hold?
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Andre DuBois
Title: What secrets does your database schema hold?
Abstract:
SessionID: 22775
Get Into Evaluation Context with DAX, the Language of PowerPivot and Tabular
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Power BI
Speaker: Reeves Smith
Title: Get Into Evaluation Context with DAX, the Language of PowerPivot and Tabular
Abstract:
Data Analysis Expressions (DAX) is the language of PowerPivot and the BISM Tabular Model. Review the basics of the DAX language and get introduced to evaluation context: including row and filter context. Learn why different cells return different results based on the same formula. Understanding evaluation context is the driving force behind releasing the potential to create truly dynamic DAX formulas. The demo will walk through various examples the DAX query language and demo row and filter context
SessionID: 22888
Dashboards - Introducing Pyramid Analytics
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Jeff Renz
Title: Dashboards - Introducing Pyramid Analytics
Abstract:
Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical). Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.
SessionID: 22889
Data Vault Data Warehouse Architecture
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Jeff Renz
Title: Data Vault Data Warehouse Architecture
Abstract:
Data vault is a compelling architecture for an enterprise data warehouse using SQL Server 2012. A well designed data vault data warehouse facilitates fast, efficient and maintainable data integration across business systems. In this session Leslie and I will review the basics about enterprise data warehouse design, introduce you to the data vault architecture and discuss how you can leverage new features of SQL Server 2012 help make your data warehouse solution provide maximum value to your users.
SessionID: 23723
Manage your shop with CMS and Policy Based Mgmt
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: More DBA
Speaker: Ryan Adams
Title: Manage your shop with CMS and Policy Based Mgmt
Abstract:
In this SQLRally #3 rated session I will talk about Central Management Server and how it can help you manage a disperse environment. I will also cover what Policy Based Management is and how you can leverage its power to better manage your environment. With PBM we'll see what it can and cannot do to help you enforce standards in your enterprise. I will demonstrate PBM from creating and evaluating policies to receiving alerts on policy violations.
SessionID: 24469
Branding Yourself for a Dream Job
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Professional Dev
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: 24614
Lessons Learned: Hurricane Sandy
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: More DBA
Speaker: Brandon Tucker
Title: Lessons Learned: Hurricane Sandy
Abstract:
In the life of a DBA, we rarely get to experience an actual disaster. And by “actual disaster”, we aren’t just talking about an UPDATE without a WHERE clause on a live table. At the end of October 2012, Hurricane Sandy ravaged much of the New Jersey/New York area, causing business impacts up and down the Eastern seaboard. In this talk, I’ll share experiences from my first disaster, covering what went well, what didn’t, and what we’ve put into place since to help in the future.
SessionID: 24950
SQL Server encryption 3 ways - in transit, at rest and in the database
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: Dan Hess
Title: SQL Server encryption 3 ways - in transit, at rest and in the database
Abstract:
Dude, where's my keys??!?!
Confused about the various ways SQL Server handles encryption? Tasked with securing your environment or trying to pass an audit? There's a lot of information that can be difficult to wade through. In this session, I'll go over three ways to encrypt SQL Server, showing practical examples of the various techniques. We'll look at encrypting the information at the network level (in transit), encrypting the data and backup files (at rest using Transparent Data Encryption) and encryption of sensitive information in the database (columns and stored procedures).
This will be a high level, hands-on discussion that will enable any administrator to put the techniques discussed into practice immediately. You'll see how encryption will fit into your overall security scheme.
SessionID: 25740
Common Table Expressions - Advanced
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DEV/DBA
Speaker: Steve Stedman
Title: Common Table Expressions - Advanced
Abstract:
SessionID: 26614
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: BI
Speaker: Tim Mitchell
Abstract:
In this demo-packed session, we'll work through some of the most common causes of performance bottlenecks in SSIS packages, along with recommended practices for maximizing performance. Among the topics we'll cover: troubleshooting methods to detect performance hotspots; optimizing sources and destinations for maximum throughput; choosing the most efficient data flow transformations; and using parallelism to improve performance.
SessionID: 26850
Periodic Table of DMVs: Part Two - The SQL
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: More DBA
Speaker: Tim Ford
Title: Periodic Table of DMVs: Part Two - The SQL
Abstract:
SessionID: 26907
Documentation – you know you love it
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DEV/DBA
Speaker: TJay Belt
Title: Documentation – you know you love it
Abstract:
SessionID: 27102
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: Power BI
Speaker: Trent Mera
Abstract:
SessionID: 27804
Navigating the Options for Data Redundancy
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DEV/DBA
Speaker: Wendy Pastrick
Title: Navigating the Options for Data Redundancy
Abstract:
SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.
SessionID: 8883
T-SQL Tips Tricks
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DEV/DBA
Speaker: Aaron Cutshall
Title: T-SQL Tips Tricks
Abstract:
SessionID: 9114
DBA Survival Guide: Daily Checklist and Server Mon
Event Date: 28-09-2013 - Session time: 00:00:00 - Track: DBA
Speaker: AJ Mendo
Title: DBA Survival Guide: Daily Checklist and Server Mon
Abstract:
You are responsible for the health and welfare of the servers and the databases under your command. What should you check daily? How about weekly? Should we automate? We will talk about all these things and discuss how having a Daily Checklist and monitoring your server will help you maintain balance in the galaxy.