Nr: 227
SQLSaturday #227 - Charleston 2013
SessionID: 10825
SQL 2012 Table Compression
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Jason Brimhall
Title: SQL 2012 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: 11252
“Indexing” Encrypted Data
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Chris Bell
Title: “Indexing” Encrypted Data
Abstract:
As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to "index" commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.
SessionID: 11434
10 Things all BI System Administrators Should Know
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Robert Davis
Title: 10 Things all BI System Administrators Should Know
Abstract:
Conversations about SQL Server administration tends to be all about administering OLTP systems. If you administrer BI systems, you can't apply everything you know about administering OLTP systems to BI systems. BI systems usually end up being administered by OLTP DBAs or by BI developers and architects. Where does one even find a BI Administrator?
Fortunately, I've been administering BI systems for several years, and I have learned the hard way the difference between administering OLTP and BI systems. This session will cover the top 10 things that I think an administrator of BI systems need to know.
SessionID: 11547
Check Engine Lights
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Chris Skorlinski
Title: Check Engine Lights
Abstract:
Has a system failure brought down your SQL Server causing major outage? Together we'll explore "check engine lights" for your SQL Server warning you of pending doom.
SessionID: 11913
Visualizing Data with Reporting Services
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Christopher Price
Title: Visualizing Data with Reporting Services
Abstract:
SessionID: 12550
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: David Klee
Abstract:
SessionID: 14744
What to look for in Execution Plans
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Grant Fritchey
Title: What to look for in Execution Plans
Abstract:
Why is my query running slow? Why isn't my index getting used? In order to answer these questions, you have to ask the same return question in each case: have you looked at the execution plan?
SessionID: 16614
The Transaction Log – Beginner's Mind
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Jeremy Carroll
Title: The Transaction Log – Beginner's Mind
Abstract:
Have you ever wondered where your data goes before it goes to the data file? Have you ever wanted to save yourself from a mistaken delete or update? Do you want to know what controls recovery, mirroring, log shipping, and availability groups?
Well, welcome to the “The Transaction Log – Beginner's Mind”. In one hour, we will cover everything you will ever need to know to examine, play with, and care for your tlog. You will leave with hours of homework, useful skills for saving your job, and an appreciation of the often overlooked but oh so necessary write-ahead log.
SessionID: 17361
SSIS Programming Using .NET
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Jorge Novo
Title: SSIS Programming Using .NET
Abstract:
SessionID: 17524
SSRS: On Premises or Azure? What's the difference?
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Josh Luedeman
Title: SSRS: On Premises or Azure? What's the difference?
Abstract:
With a lot of companies looking to the cloud for cost savings, it helps to know what the differences are between on premises and cloud installations of your IT services. In this session, we'll take a look at SQL Server Reporting Services and the feature differences between deploying in the cloud, and deploying on premises. We'll look at different options for where you can deploy your reports as well. Also, Shannon Lowder will help with the associated costs of each solution, as well as preparing you for some of the gotchas you'll face as you move to the cloud today.
SessionID: 18009
Being the Swiss Army Knife of DB Pros
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Brian Kelley
Title: Being the Swiss Army Knife of DB Pros
Abstract:
Being a specialist means you're really, really good at one thing. Being a generalist means you're good at a a lot of different things. The generalist has an advantage over the specialist because he or she can see and solve problems the specialists can't. In this session I'll cover why it's important to diversify your skill set, not only for career protection, but to be better as a database professional. We'll look at what skill sets to build on to expand your abilities around SQL Server to include the operating system, development, networks, and security. Remember, this saying isn't complete, "Jack of all trades, master of none." The full saying is, "Jack of all trades, master of none, though often times better than master of one."
SessionID: 18924
Full automation of the installation of and Hyper-V VM - (W2012 / SQL2012).Core –PoSh 3.0 Workflows
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Laerte Junior
Title: Full automation of the installation of and Hyper-V VM - (W2012 / SQL2012).Core –PoSh 3.0 Workflows
Abstract:
Automation is a dedicated technique and for that we have the magic that PowerShell can bring to us. In this session, we will see how to full automate the installation of a new Hyper-V MV with Windows Server 2012 and Core. We will see how to create the answer file, add to the ISO file and the the script to automate all the process, using also workflows.
SessionID: 20372
DBA Task Automation: Unleash the PowerShell Hero in You!
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Michael Wells
Title: DBA Task Automation: Unleash the PowerShell Hero in You!
Abstract:
As DBAs, we constantly have to stretch our time and budget resources, and the best way to keep up with demands is through process automation. Workflow and PassThru parameters are just two of the features that will allow you to turn complex tasks into simple, repeatable, automated processes easier than you would have ever dreamed possible. And if you’ve had trouble with PowerShell in the past, the auto-completion and eager loading of modules will make your transition to PowerShell hero even simpler. Come see how mid-tone blue can help take your skills to the next level.
SessionID: 20697
Temporary Insanity
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Michael Femenella
Title: Temporary Insanity
Abstract:
SessionID: 24490
Branding Yourself for a Dream Job
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 2
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: 24621
OnPremise to Azure
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Shannon Lowder
Title: OnPremise to Azure
Abstract:
During this talk I'll walk you through the process actually used to migrate a client's systems from hosted in a company closet to multiple Microsoft Azure data centers. Along the way we'll discuss the planning that went into the migration, the testing we went through, the pain points we hit, all the way to up and running in the cloud. This session covers the roadmap, we won't go through the actual migration itself...that took almost a year to complete.
SessionID: 27690
Table Vars Temp Tables - What you NEED to Know!
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Wayne Sheffield
Title: Table Vars Temp Tables - What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represent temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 9577
Building Your Professional Development Plan
Event Date: 12-10-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Andy Warren
Title: Building Your Professional Development Plan
Abstract: