sqlsathistory

Nr: 209

Back to Main list

SQLSaturday #209 - Rochester, NY 2013

Start Time (24h) Speaker Track Title
00:00:00 Chris Bell Track 3 “Indexing” Encrypted Data
00:00:00 Chris Hyde Track 6 Becoming Certified In Microsoft SQL Server
00:00:00 Jack Corbett Track 4 An Introduction to Extended Events
00:00:00 Jack Corbett Track 4 Inroduction to Triggers
00:00:00 Christopher Crane Track 2 Introduction to SQL Server Analysis Services
00:00:00 Daniel Bowlin Track 3 Managing your reporting services environment
00:00:00 Daniel Bowlin Track 3 SSIS templates, configurations and variables, oh my
00:00:00 Carlton Ramsey Track 1 How PowerShell helps me as a DBA (2013 Edition)
00:00:00 Edward Pollack Track 3 Query Optimization Crash Course
00:00:00 Edward Pollack Track 3 My Favorite DMVs
00:00:00 George Walters Track 4 SQL Server 2012 AlwaysOn Availability Groups
00:00:00 George Walters Track 4 SQL Server 2012 Performance Tuning
00:00:00 Grant Fritchey Track 6 Database Backups for the Accidental DBA
00:00:00 Grant Fritchey Track 5 Tune Queries By Fixing Bad Parameter Sniffing
00:00:00 Jay Holliday Track 4 Full-Text Search, it's not just for documents
00:00:00 Janis Griffin Track 5 Extend Your Knowledge with Extended Events!
00:00:00 Janis Griffin Track 6 Don't Panic, DBAs! Databases on VMware made easy.
00:00:00 Jorge Segarra Track 5 Policy-Based Management in a Nutshell
00:00:00 Jorge Segarra Track 6 Do More With Less: Consolidate and Virtualize
00:00:00 Karen Lopez Track 1 Database Design Contentious Issues
00:00:00 Karen Lopez Track 1 $#*! Your Database Says About Me
00:00:00 Mike Hillwig Track 2 How Not to Be a Cranky DBA
00:00:00 Mike Hillwig Track 2 What the VLF?
00:00:00 Mike Hays Track 2 Troubleshooting your TCP/IP connections
00:00:00 Matt Slocum Track 6 Installing SQL Server 2012 and what the heck is SSMS
00:00:00 Robert Schoedel Track 2 SQL Server Data Tools: Write it, test it, deploy it with Visual Studio
00:00:00 Kevin Boles Track 1 Windowing Functions: THE Reason to Upgrade to 2012
00:00:00 Kevin Boles Track 1 Common TSQL Mistakes
00:00:00 Kevin Boles Track 5 Indexing Deep Dive

SessionID: 11250

“Indexing” Encrypted Data

Back to calendar

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

Back to calendar

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

Back to calendar

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:

  1. How to investigate XEvents objects using the DMV's
  2. How to create an XEvents Session
  3. How to transition an existing Trace to an XEvents Session.

What you should know coming in:

  1. Basic use of SSMS
  2. Familiarity with Trace/Profiler

SessionID: 11857

Inroduction to Triggers

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: Jack Corbett

Title: Inroduction to Triggers

Abstract:

This session will give a brief overview of the different types of triggers available in SQL Server (DDL DML) and then go into more detail on how and when to use DML triggers. This session will cover misconceptions about how triggers work, when triggers should and shouldn't be used (we will discuss options), common mistakes, and how to fix the most common mistakes. After attending this session a person will: 1. Identify different types of triggers and when to use them. 2. Be able to identify when a trigger is the right solution 3. Be able to write triggers that perform well

SessionID: 12043

Introduction to SQL Server Analysis Services

Back to calendar

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

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Daniel Bowlin

Title: Managing your reporting services environment

Abstract:

This session will investigate some of the tables and views of the reporting services database in SQL Server 2008 2008 R2. We will then go on to demonstrate how to build a long term reporting repository for tracking report performance, report use, and subscription results. Finally we will review a few reports that can be built from this data to make the whole process a bit easier.

SessionID: 12886

SSIS templates, configurations and variables, oh my

Back to calendar

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:

This session will investigate the benefits of package and logging management framework templates. Then we will move on to adding data connectors to your template packages and building these connectors into package configurations that use a common table to store all your connections and how this will save you time and effort. Then finally we will explore some of the useful things you can do with package configured variables

SessionID: 13652

How PowerShell helps me as a DBA (2013 Edition)

Back to calendar

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

Back to calendar

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

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 3

Speaker: Edward Pollack

Title: My Favorite DMVs

Abstract:

Dynamic Management Views are a beautiful gift from Microsoft. With them you can gather immense amounts of information about your SQL environment, optimize performance problems, and solve problems you didn't even know you had!

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

Back to calendar

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

SQL Server 2012 Performance Tuning

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 4

Speaker: George Walters

Title: SQL Server 2012 Performance Tuning

Abstract:

SQL Server 2012 has some built in tools to help with performance tuning. This session will review these tools, and other tuning tips and tricks.

SessionID: 14749

Database Backups for the Accidental DBA

Back to calendar

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

Back to calendar

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:

Parameter sniffing is a misunderstood issue on SQL Server. Most of the time, parameter sniffing is helping performance on your servers. But sometimes, circumstances change, and what was helping you is now hurting you – bad. In this session, we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then we’ll explore how parameter sniffing can go wrong and look at seven different ways you can deal with it when it does. You’ll take away a wealth of knowledge that will help you identify and resolve bad parameter sniffing in your own environment.

SessionID: 14997

Full-Text Search, it's not just for documents

Back to calendar

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!

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Janis Griffin

Title: Extend Your Knowledge with Extended Events!

Abstract:

SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.

SessionID: 15695

Don't Panic, DBAs! Databases on VMware made easy.

Back to calendar

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

Back to calendar

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

Back to calendar

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:

In today's economic times, we are being asked to do more with less. Less budget, less hardware and yet our data needs keep growing! So how do we keep our database infrastructure humming along given these restrictions? In this session we will talk about different options of consolidation including: database-level consolidation, instance-level consolidation, and virtualization. Additionally we will also talk about some of the tools and methods you can use today to help you consolidate your SQL Server environment and do more with less!

SessionID: 17880

Database Design Contentious Issues

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Karen Lopez

Title: Database Design Contentious Issues

Abstract:

SessionID: 17881

$#*! Your Database Says About Me

Back to calendar

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

Back to calendar

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?

Back to calendar

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

Back to calendar

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

Back to calendar

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:

You’re just starting out as a DBA, but you’ve just been given a tight deadline to install and configure a new SQL Server 2012 instance. In this session you’ll learn process of installing an instance of SQL Server 2012 so that you have the knowledge to confidently perform the install (and get it right the first time). You’ll also learn some of the out-of-the box SQL Server settings that need to be tweaked to ensure performance and resilience.

SessionID: 21443

SQL Server Data Tools: Write it, test it, deploy it with Visual Studio

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 2

Speaker: Robert Schoedel

Title: SQL Server Data Tools: Write it, test it, deploy it with Visual Studio

Abstract:

SQL Server Data Tools (SSDT) is the latest iteration of technology that makes use of Visual Studio for coding, testing, and deploying databases. SSDT provides a single solution, whether you choose to deploy your code to your own computer, to a nearby server, or to an Azure cloud database. I'll talk about my recent "real world experiences" with this technology -- where SSDT really helped and where it ...didn't. There will be more time for QA, so that you can better understand if this technology is right for your projects.

SessionID: 26181

Windowing Functions: THE Reason to Upgrade to 2012

Back to calendar

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:

For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!

SessionID: 26182

Common TSQL Mistakes

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 1

Speaker: Kevin Boles

Title: Common TSQL Mistakes

Abstract:

We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FORTY times now and it is always very highly rated!

SessionID: 26184

Indexing Deep Dive

Back to calendar

Event Date: 11-05-2013 - Session time: 00:00:00 - Track: Track 5

Speaker: Kevin Boles

Title: Indexing Deep Dive

Abstract: