Nr: 90
SQLSaturday #90 - Oklahoma City 2011
SessionID: 28481
Understanding Storage Systems and SQL Server
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Wesley Brown
Title: Understanding Storage Systems and SQL Server
Abstract:
SessionID: 29014
SQL Server TDE in 30 Minutes
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Ben Miller
Title: SQL Server TDE in 30 Minutes
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: 29315
Building Secure Applications with SQL Server
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Bryan Smith
Title: Building Secure Applications with SQL Server
Abstract:
As recent breaches and disruptions have demonstrated, application security could not be more critical. As the foundation of many of our applications and the stores of our most sensitive data, databases are a prime target. Still, very few developers take advantage of security features available to them to secure the databases behind their applications. Join Bryan Smith, a Database Technical Specialist with Microsoft, in exploring security features and best practices applicable to Microsoft SQL Server which will allow you to secure your database applications.
SessionID: 30244
Making Heads or Tails of Analysis Services Storage
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Greg Galloway
Title: Making Heads or Tails of Analysis Services Storage
Abstract:
How can you make your cube more real-time? How can you get more out of your enterprise data warehouse by putting Analysis Services on top of it? What’s new in Denali for Analysis Services? In this session we will take a deep dive into storage modes in Analysis Services. We’ll discuss the pros and cons of the two storage modes a Multidimensional model can use: MOLAP and ROLAP. We’ll discuss the storage modes in new Tabular models coming in the next version of Analysis Services: Vertipaq and DirectQuery. We’ll preview the new columnar index in the next version of SQL Server and discuss how it impacts Analysis Services. And we’ll discuss why one Fortune 500 company chose ROLAP and another chose MOLAP.
SessionID: 30710
Unraveling Tangled Code – A Spellbinding Tale
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Jennifer McCown
Title: Unraveling Tangled Code – A Spellbinding Tale
Abstract:
SessionID: 32081
What's so special about PL/SQL in 30 Minutes
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Paul Hunter
Title: What's so special about PL/SQL in 30 Minutes
Abstract:
AKA, things I'd like to see in MS SQL Server. PL/SQL is a powerful and flexible SQL programming language that supports some nice features. This is a good overview of people that have to stray across the great divide into “Oracle world”.
SessionID: 32600
EntityFramework 360: CodeOnly 4.1
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Rob Vettor
Title: EntityFramework 360: CodeOnly 4.1
Abstract:
SessionID: 32689
How to use the XML Datasource in SSIS
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Russel Loski
Title: How to use the XML Datasource in SSIS
Abstract:
XML is a convenient method for transferring data from system to system. SQL Server SSIS provides the XML Datasource to import this data into SQL Server. In this session we will learn how to set up a simple XML Datasource. Then we will look at handling XML files with a more hierarchical structure.
SessionID: 32690
Stored procedure tracing using the xml datatype
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Developer
Speaker: Russel Loski
Title: Stored procedure tracing using the xml datatype
Abstract:
When running a stored procedure it is difficult to record what is happening. I developed a simple logging mechanism. In this session we will examine logger code in T-SQL I added to a stored procedure. We will use the xml datatype to record parameter values, variable values and debug statements. We will look at the "For xml" statement as well as the xml datatype methods, especially the modify method. Finally we will look at how to read the logs when finished.
SessionID: 32738
Manage your shop with CMS and Policy Based Mgmt
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Ryan Adams
Title: Manage your shop with CMS and Policy Based Mgmt
Abstract:
In this presentation we talk about Central Management Server and how it can help you manage a disperse environment. We 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. We will cover and demonstrate PBM for the beginner from creating and evaluating policies to receiving alerts on policy violations.
SessionID: 32855
The Backup Tune-up
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Database Administration
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 wi
SessionID: 32925
The Winding Road
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Steve Jones
Title: The Winding Road
Abstract:
Keynote
SessionID: 33189
Governing Your Database Environment
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Sri Sridharan
Title: Governing Your Database Environment
Abstract:
As we all know about SQL sprawl, it becomes cumbersome for the DBAs tostay on top of all the servers in the environment. Come to this sessionand learn about simple techniques can help DBA stay on top of thegrowing SQL environment.
SessionID: 33582
ETL Head-to-Head: T-SQL vs. SSIS
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Tim Mitchell
Title: ETL Head-to-Head: T-SQL vs. SSIS
Abstract:
Seesion Goals:
•Attendees will gain an understanding of the role of Transact-SQL as part of an ETL strategy.
•Attendees will gain an understanding of the logistical differences between using SSIS and Transact-SQL for ETL processing.
•Attendees will learn, through practical demonstration, some situations that may be better served by Transact-SQL rather than SSIS (and the reverse).
SessionID: 33583
BI Drive By: A Quick Tour of SQL Server BI
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Tim Mitchell
Title: BI Drive By: A Quick Tour of SQL Server BI
Abstract:
SessionID: 34125
Serene Velocity: Reporting Services and SSAS Data
Event Date: 27-08-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: William E Pearson III
Title: Serene Velocity: Reporting Services and SSAS Data
Abstract:
SSRS 2008 R2 provides powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.