Nr: 295
SQLSaturday #295 - Las Vegas 2014
SessionID: 10230
SQL Server TDE
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 2
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 in general as well as how it relates to SQL Server TDE.
SessionID: 12527
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 2
Speaker: David Klee
Abstract:
SessionID: 13606
Stats Across The Stack
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 1
Speaker: Erika Bakse
Title: Stats Across The Stack
Abstract:
SessionID: 13686
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 1
Speaker: Ed Watson
Abstract:
SessionID: 15813
Dimensional Modeling Design Patterns: Beyond Basics
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: BI
Speaker: Jason Horner
Title: Dimensional 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: 16160
The Modern Analytics Architecture
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: BI
Speaker: Joseph D'Antoni
Title: The Modern Analytics Architecture
Abstract:
SessionID: 17868
$#*! Your Database Says About Me
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: BI
Speaker: Karen Lopez
Title: $#*! Your Database Says About Me
Abstract:
Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions. Using real-life evidence of her own data in your systems.
SessionID: 22532
But it worked great in Dev! Perfomance for Devs
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 2
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: 22760
Increase your SSIS productivity with Biml
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: BI
Speaker: Reeves Smith
Title: Increase your SSIS productivity with Biml
Abstract:
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign.
This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
SessionID: 23589
XPath - XQuery; I guess if I HAVE to
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 1
Speaker: Russ Thomas
Title: XPath - XQuery; I guess if I HAVE to
Abstract:
I don't know anyone who likes it. But the reality is sooner or later you'll have to use XML in your database career. It appears in extended events, ring buffer queries, and more and more in stored procedures and columns. Attend this session to find out what you need to know to leverage xpath, xquery, and semi-structured data in administering databases.
SessionID: 24529
The Encryption Primer
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 2
Speaker: Steve Jones
Title: The Encryption Primer
Abstract:
Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.
SessionID: 24877
Integrating SQL Server with Hadoop
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: BI
Speaker: Pat Wright
Title: Integrating SQL Server with Hadoop
Abstract:
SessionID: 25148
Database Design: Size DOES Matter
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 1
Speaker: Thomas LaRock
Title: Database Design: Size DOES Matter
Abstract:
SessionID: 26011
45 min to build your first SSRS report
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: BI
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: 26893
Database Monitoring : Trying To Keep Sane
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 2
Speaker: TJay Belt
Title: Database Monitoring : Trying To Keep Sane
Abstract:
Each of our database systems has its complexities, its idiosyncrasies, its touchy points. Digging into each of these, understanding them, baselining them and monitoring them is an essential part of a DBA's job. Doing these simple tasks in such a way that allows you to sleep at night while your systems churn away safely and gracefully is an art that we all attempt to accomplish.
We will discuss various ideas, tools, approaches, and solutions to how to monitor different pieces of our systems. Examples, code, tools, will all be shown off and shared so we can all do better.
SessionID: 34792
Managing Log File Obesity
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 1
Speaker: Michael Fal
Title: Managing Log File Obesity
Abstract:
Have your efforts to trim a few pounds off your log file been met with frustration? Are you scratching your head on why that DBCC SHRINKFILE doesn’t seem to do anything? Log file obesity is a problem that can challenge DBAs of any level. This session will help you deal with your overweight database by covering how log files grow, why truncating the log is a bad idea, and what you can do to keep your files trim and fit.
SessionID: 9980
Manage SQLServer Efficiently w/PowerShell Remoting
Event Date: 05-04-2014 - Session time: 00:00:00 - Track: DBA 2
Speaker: Allen White
Title: Manage SQLServer Efficiently w/PowerShell Remoting
Abstract:
You have more and more servers to manage and less time to accomplish everything. You're writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we'll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.