Nr: 153
SQLSaturday #153 - Salt Lake City 2012
SessionID: 10242
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Ben Miller
Abstract:
SessionID: 10243
SQL Server TDE
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1
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: 10800
SQL 2012 Extended Events
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Jason Brimhall
Title: SQL 2012 Extended Events
Abstract:
SessionID: 10803
Table Compression
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Jason Brimhall
Title: Table Compression
Abstract:
SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.
SessionID: 11386
Microsoft Hadoop and Your Enterprise BI Strategy
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Dipti Sangani
Title: Microsoft Hadoop and Your Enterprise BI Strategy
Abstract:
Session takeaways:
• Understand what Big Data, Hadoop, Hive, and Pig are at a high level and how to use Hadoop, Hive and Pig as part of an integrated enterprise strategy for analyzing Big Data.
• Learn why Big Data is so important in the business intelligence arena.
• Kickstart your Big Data learning and know where to go to learn more.
SessionID: 11387
What’s all the Buzz about Hadoop and Hive?
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Dipti Sangani
Title: What’s all the Buzz about Hadoop and Hive?
Abstract:
Everyone is buzzing about Hive and trumpeting the virtues of Hadoop. But what does it mean? Why does it matter to a SQL Server and/or BI professional? Come get a taste of the Hive honey and see why this new technology is worth buzzing about!
SessionID: 11393
Service Broker in Action
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Chad Crawford
Title: Service Broker in Action
Abstract:
SQL Server Service Broker is a messaging framework built into the SQL Server engine. It enables SQL Server to handle messaging between servers and applications with light setup and overhead. The flexibility of the framework enables Service Broker to queue event notifications, task execution requests or other messages while leveraging the strength of SQL Server transaction management, reliability and recoverability. In this session we will see how to set up Service Broker, discuss case studies where it has been implemented in industry, and step through a practical example implementing an audit log.
SessionID: 16881
The Accidental Programmer
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3
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 have to work with databases. How about the other side of the coin? What about DBA's an Dev's who have to write code or have to work closely with programmers? 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: 20977
Introduction to Dimensional Data Modeling
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Martin Miller
Title: Introduction to Dimensional Data Modeling
Abstract:
SessionID: 21847
Oh, so Tabular!
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Paul Turley
Title: Oh, so Tabular!
Abstract:
Relational, multidimensional, now Tabular... how many ways can you bend your data (and your brain)?
It took some work to get our heads around cubes, MDX OLAP concepts; and now the next generation of analytical data technology from Microsoft is not so radical. Learn how to enable deep analytics BI in your environment without popping brain cells learning yet another foriegn technology. The magic of VertiPaq: PowerPivot on the desktop BISM Tabular models leverage modern computing power in a new way. Gain insight about how to choose among all these options and build compelling dashboards reports with SharePoint, Reporting Services Power View.
SessionID: 21850
Power View and PowerPivot: High-Octane Self-svc BI
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Paul Turley
Title: Power View and PowerPivot: High-Octane Self-svc BI
Abstract:
SessionID: 22490
But it worked great in Dev! Perfomance for Devs
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Randy Knight
Title: But it worked great in Dev! Perfomance for Devs
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production.
SessionID: 22491
Understanding Transaction Isolation Levels
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: Randy Knight
Title: Understanding Transaction Isolation Levels
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 24059
Processing XML Files into SQL Server using SSIS
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Scott Heffron
Title: Processing XML Files into SQL Server using SSIS
Abstract:
This talk will show the steps needed to process an XML file for an order entry system. We will go through the lifecycle of the XML file and how the data is processed so that it is usable for entry in an order entry system. We will show the different pieces of the XML process and files and how they work together. We will also show how to dynamically change information as the need arises.
SessionID: 24104
SQL Azure - What is it and why do I need it?
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Scott Klein
Title: SQL Azure - What is it and why do I need it?
Abstract:
This session will take an exploratory look at Microsoft's cloud-based relational database offering. We'll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We'll discuss how SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA's alike can focus on the aspects of their job they really care about.
SessionID: 24105
SQL Azure Scalability with Federations
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Scott Klein
Title: SQL Azure Scalability with Federations
Abstract:
SessionID: 24760
Introduction to SSIS Event Handlers.
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Scott Heffron
Title: Introduction to SSIS Event Handlers.
Abstract:
SSIS event handlers are the simplest means of turning an SSIS script into a reliable system that is auditable, reacts appropriately to error conditions, reports progress and allows instrumentation and monitoring your SSIS packages. They are easy to implement, and provide a great deal of flexibility. Rob Sheldon once again provides the easy, clear introduction
SessionID: 24874
DBA Open Panel
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 3
Speaker: Pat Wright
Title: DBA Open Panel
Abstract:
We have 3 excellent DBA's/Designers/Architects from here in the Valley that will be available to answer questions about your system. If you have specific design questions or what's the best way to do X this is the session to attend! Ben Miller, Jason Brimhall and Randy Knight will be on the panel and Pat Wright will be moderating.
SessionID: 25690
SSIS 2012: More Than Just a Pretty UI
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 2
Speaker: Steve Wake
Title: SSIS 2012: More Than Just a Pretty UI
Abstract:
SessionID: 26906
Release Management: A Necessary Evil
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 1
Speaker: TJay Belt
Title: Release Management: A Necessary Evil
Abstract:
SessionID: 26946
Deploying without a Hitch
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Tobe Pittman
Title: Deploying without a Hitch
Abstract:
Making life a little easier by creating an airtight deployment process. Will address methods of scripting, versioning, creating bootstrap and test data, security, rolling back, etc. By reducing human interaction (and thus error) and increasing the ability to reproduce development, QA and production conditions, deployment night will be much less stressful and much shorter.
SessionID: 8881
T-SQL Tips Tricks
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Aaron Cutshall
Title: T-SQL Tips Tricks
Abstract:
SessionID: 9676
What Every DBA Should Know About NoSQL
Event Date: 20-10-2012 - Session time: 00:00:00 - Track: Track 4
Speaker: Kelly Martinez
Title: What Every DBA Should Know About NoSQL
Abstract:
NoSQL is one of the hot "new" things in the developer world. As DBAs inevitably someone will come to us for help or advice on (or possibly choosing) a NoSQL solution. This session aims to give you a basic understanding in order to best answer those questions for your organization.
In this presentation I will cover: What exactly NoSQL is (and is not), ACID compliance of some popular NoSQL solutions, main differences between traditional RDBMS and NoSQL, why NoSQL popular with developers, and when you might (or might not) want to leverage it for a solution.