Nr: 209
SQLSaturday #209 - Rochester, NY 2013
SessionID: 11250
“Indexing” Encrypted Data
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 3
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: 11508
Becoming Certified In Microsoft SQL Server
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Chris Hyde
Title: Becoming Certified In Microsoft SQL Server
Abstract:
Becoming certified in SQL Server is a great career enhancement for a database professional. This session will provide you with an overview of the SQL Server Certification program, including the numerous changes made to the program for SQL 2012. You'll discover several reasons why you should become certified, and some of the best ways in which to do so. You'll also leave the session armed with some tips and tricks for passing the exams that the presenter has used over the last twelve years.
SessionID: 11856
An Introduction to Extended Events
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jack Corbett
Title: An Introduction to Extended Events
Abstract:
XEvents were introduced with SQL Server 2008 and enhanced in SQL Server 2012 and with the announcement that SQL Trace/Profiler is being deprecated now is the time to begin learningXEvents. We will look at why you should start working with Extended Events, when you should start, and how to start. What you will learn:
- How to investigate XEvents objects using the DMV's
- How to create an XEvents Session
- How to transition an existing Trace to an XEvents Session.
What you should know coming in:
- Basic use of SSMS
- Familiarity with Trace/Profiler
SessionID: 11857
Inroduction to Triggers
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jack Corbett
Title: Inroduction to Triggers
Abstract:
SessionID: 12043
Introduction to SQL Server Analysis Services
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Christopher Crane
Title: Introduction to SQL Server Analysis Services
Abstract:
What are cubes? What is all this talk about BI? Why is it important, anyway? If you have asked these questions recently, then this session is for you. We'll discuss the fundamentals of designing a Data Warehouse and building a Cube as well as When and Where you would need them.
SessionID: 12885
Managing your reporting services environment
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Daniel Bowlin
Title: Managing your reporting services environment
Abstract:
SessionID: 12886
SSIS templates, configurations and variables, oh my
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Daniel Bowlin
Title: SSIS templates, configurations and variables, oh my
Abstract:
SessionID: 13652
How PowerShell helps me as a DBA (2013 Edition)
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Carlton Ramsey
Title: How PowerShell helps me as a DBA (2013 Edition)
Abstract:
In this session we will review some example code of ways I use PowerShell to help me as a DBA. Together we will learn how PowerShell can be the "Super Glue" that can be used to solve some of your problems.
SessionID: 13842
Query Optimization Crash Course
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Edward Pollack
Title: Query Optimization Crash Course
Abstract:
Do you have users complaining that applications are running "too slow"? Do your DB traces look like a short story written by monkeys at typewriters?
This is a fun, fast-paced walkthrough of the most effective strategies for query tuning. We'll investigate the most common causes of sub-optimal queries (and some quite unusual ones) while building a foundation for solving any optimization problem that the application throws your way!
SessionID: 13843
My Favorite DMVs
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 3
Speaker: Edward Pollack
Title: My Favorite DMVs
Abstract:
We will dig into some of the most useful DMVs available and review some real-world code examples that illustrate what they can do for you.
SessionID: 14522
SQL Server 2012 AlwaysOn Availability Groups
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: George Walters
Title: SQL Server 2012 AlwaysOn Availability Groups
Abstract:
The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring.
SessionID: 14524
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: George Walters
Abstract:
SessionID: 14749
Database Backups for the Accidental DBA
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Grant Fritchey
Title: Database Backups for the Accidental DBA
Abstract:
You've fallen into a job that requires you to manage a SQL Server Database Management System. Now you have to keep these databases on their feet. You've heard of this concept called a backup, and it sounds great, but you sure don't know what it is. This session is for you. We're going to go over backups, right from the beginning, so that when you come out of this session you can go back to your systems and set up backups, log backups, differentials, and anything else you might need. Further, you'll know how to recover your database in the event of an actual failure. The fundamentals you need to get a good backup in place and then be able to restore it will be covered in this session.
SessionID: 14750
Tune Queries By Fixing Bad Parameter Sniffing
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Grant Fritchey
Title: Tune Queries By Fixing Bad Parameter Sniffing
Abstract:
SessionID: 14997
Full-Text Search, it's not just for documents
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 4
Speaker: Jay Holliday
Title: Full-Text Search, it's not just for documents
Abstract:
Full-text search is an often overlooked feature of SQL Server that can be used for more than searching documents. This session will cover setting up and using full-text search to handle some of those dirty data situations we've all inherited without using the dreaded "LIKE '%text%'". As an example, we will demonstrate how full-text search can be used to find names in poorly formatted data like 'mailing address' or 'billing address' fields. It will also cover how to handle noise words that may match some names and synonyms for first names to create a really robust solution that goes beyond what could be done with plain old SQL.
SessionID: 15694
Extend Your Knowledge with Extended Events!
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Janis Griffin
Title: Extend Your Knowledge with Extended Events!
Abstract:
SessionID: 15695
Don't Panic, DBAs! Databases on VMware made easy.
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Janis Griffin
Title: Don't Panic, DBAs! Databases on VMware made easy.
Abstract:
More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
SessionID: 17407
Policy-Based Management in a Nutshell
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Jorge Segarra
Title: Policy-Based Management in a Nutshell
Abstract:
We will be learning an overview of this powerful feature and how you can leverage it to help manage your existing SQL environment. This will include plenty of demos, best practices and QA so by the end you should be able to walk away ready to take control of your SQL Server environment using this awesome feature!
SessionID: 17408
Do More With Less: Consolidate and Virtualize
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Jorge Segarra
Title: Do More With Less: Consolidate and Virtualize
Abstract:
SessionID: 17880
Database Design Contentious Issues
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Classwords and other Naming Standards * Varchar Minimums *Identity Crisis * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 17881
$#*! Your Database Says About Me
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 1
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: 20529
How Not to Be a Cranky DBA
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mike Hillwig
Title: How Not to Be a Cranky DBA
Abstract:
Mike Hillwig is known as the Cranky DBA. You probably have pain points in your environment that make you cranky, too. Mike has lots of horror stories to tell about bad SQL Server implementations and practices. More importantly, he has developed a list of 12 key tips for managing your SQL Server environment. By following these tips, you’ll make your DBAs, developers, and system administrators a little less cranky.
SessionID: 20531
What the VLF?
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mike Hillwig
Title: What the VLF?
Abstract:
Experienced DBAs know that SQL Server stores data in data files and transaction log files. What is less commonly known is that the transaction log file is broken up into smaller segments known as Virtual Log Files, or VLFs.
Having too many VLFs will cause performance to suffer. And having too few will cause backup performance to suffer. How do you strike the right balance?
In this more advanced session, veteran DBA Mike Hillwig will show you what VLFs are, how they're created, how to identify them, and how to strike the right balance between too few and too many.
SessionID: 20649
Troubleshooting your TCP/IP connections
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Mike Hays
Title: Troubleshooting your TCP/IP connections
Abstract:
Database professionals are often challenged to troubleshoot why a user cannot connect to a SQL Server instance. Attend this session to learn the basics of how SQL Server listens for connections and how it uses its browser service. Also learn what utilities the Windows operating system offers to help you in troubleshooting those connection issues.
SessionID: 21143
Installing SQL Server 2012 and what the heck is SSMS
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 6
Speaker: Matt Slocum
Title: Installing SQL Server 2012 and what the heck is SSMS
Abstract:
SessionID: 21443
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 2
Speaker: Robert Schoedel
Abstract:
SessionID: 26181
Windowing Functions: THE Reason to Upgrade to 2012
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Boles
Title: Windowing Functions: THE Reason to Upgrade to 2012
Abstract:
SessionID: 26182
Common TSQL Mistakes
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Boles
Title: Common TSQL Mistakes
Abstract:
SessionID: 26184
Indexing Deep Dive
Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 5
Speaker: Kevin Boles
Title: Indexing Deep Dive
Abstract:
Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.