Nr: 381
SQLSaturday #381 - Richmond 2015
SessionID: 10097
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 6
Speaker: Ayman El-Ghazali
Abstract:
SessionID: 10105
Excel with DAX
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 4
Speaker: Azhagappan Arunachalam
Title: Excel with DAX
Abstract:
SessionID: 10893
Using Extended Events in SQL Server
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Jason Brimhall
Title: Using Extended Events in SQL Server
Abstract:
SessionID: 11284
Hacking Exposé - Using SSL to Protect SQL Connections
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 7
Speaker: Chris Bell
Title: Hacking Exposé - Using SSL to Protect SQL Connections
Abstract:
Are you someone (A DBA, Developer, etc) that connects to SQL Server to use data?
You probably hear a lot about how protected your database can be when at rest. But what about when you connect to SQL and start running some queries?
Using a simple hacking technique we will dig into some packets on our network and see what's in them. You may be shocked! Then we will create a self-signed SSL certificate, use it to encrypt our connections on the SQL Server, and see the actual changes in the packet as hackers would.
*Warning - do not try some of these demos at work without proper permissions as hacking techniques are used.
SessionID: 11531
Ten T-SQL Techniques with Tally Tables
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 8
Speaker: Chris Hyde
Title: Ten T-SQL Techniques with Tally Tables
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over thirteen years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
SessionID: 12142
Query Compilation and Plan Caching
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Dale Burnett
Title: Query Compilation and Plan Caching
Abstract:
SQL Server often appears to be a black box. Queries go in and results come out. But a lot goes into making that happen. In this session, we will take a look at the stages that SQL Server goes through when it compiles a query plan and some of the optimization that can be used. Once compiled the plans can be cached for reuse. I will explain where the plans get cached to and how SQL Server knows when it can re-use a plan.
SessionID: 12229
De-Mystifying SQL Server Statistics
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 8
Speaker: Dave Turpin
Title: De-Mystifying SQL Server Statistics
Abstract:
In order to build optimal query plans the SQL Server optimizer relies on statistics to estimate the size of the query workload, which determines the resources that get allocated to the query.
This session will demonstrate how to determine if your statistics are current, how to make them current, and how bad things can happen when they are not current.
SessionID: 13413
Are Availability Groups a good fit for your database?
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Doug Purnell
Title: Are Availability Groups a good fit for your database?
Abstract:
How do you know if Availability Groups are the correct high availability solution for your business application? We’ll cover some common business problems that Availability Groups can solve and go through a quick install where we’ll cover some pre and post checklist items to help you understand the requirements for a successful implementation.
SessionID: 13479
How In-Memory Database Objects Affect Database Design
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 4
Speaker: Louis Davidson
Title: How In-Memory Database Objects Affect Database Design
Abstract:
SessionID: 14204
APPLY Yourself
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Kevin Feasel
Title: APPLY Yourself
Abstract:
SessionID: 14415
Dealing With Difficult People
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 7
Speaker: Gigi Bell
Title: Dealing With Difficult People
Abstract:
John knows everything and goes out of his way to correct you at every turn. Mary is agreeable to a fault and just placates everyone. Mike is full of doom and gloom and whines constantly. Are these your co-workers? Relatives? Frenemies? You? Learn two golden rules to reduce the stress produced by the difficult people in your life.
SessionID: 14427
Learn How To Build A Golden Record for Any Subject Over Lunch!
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Gene Webb
Title: Learn How To Build A Golden Record for Any Subject Over Lunch!
Abstract:
Attend the lunch demo and see how you can use Master Data Services and Maestro to:
• Create a golden record for any subject area in a matter of minutes
Leverage your Microsoft licenses, skills and infrastructure to lower license costs and FTE costs, and reduce the complexity of an MDM environment?
• Understand how to implement workflow and business process solutions around the management of MDM, without having to write complex custom coding for everything?
• Tackle data quality, consistency and control by empowering business and subject matter experts, without needing heavy IT resources and writing complex code or scripting
• Improve data quality, data stewardship, workflow, and data sharing with any of your enterprise
SessionID: 14513
Scripting out SQL Server for Documentation and Disaster Recovery
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 8
Speaker: George Walkey
Title: Scripting out SQL Server for Documentation and Disaster Recovery
Abstract:
Even using Visual Studio and Database Projects, not all objects are exportable and live at the server level, above the database.
Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for moving or recovering a SQL server instance for Disaster Recovery purposes.
Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, and Server Triggers
SessionID: 14957
Basic Monitoring with Perfmon
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Rick Heiges
Title: Basic Monitoring with Perfmon
Abstract:
SessionID: 15636
What exactly is big data and why should I care?
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 7
Speaker: James Serra
Title: What exactly is big data and why should I care?
Abstract:
You may understand what a data warehouse is, but what is big data? And why should I care about it? How will it help me? I’ll talk about the things to look at to understand if you have big data, and cover those buzz words you may have heard but don’t know what they mean (data scientist, Hadoop, Internet of Things, data lake, modern data warehouse). I’ll also give examples of how big data is making companies make better business decisions.
SessionID: 15734
Query Tuning - Get it Right the First Time
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 4
Speaker: Janis Griffin
Title: Query Tuning - Get it Right the First Time
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 16671
Analysis Services: Multidimensional vs Tabular
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 8
Speaker: Jessica Moss
Title: Analysis Services: Multidimensional vs Tabular
Abstract:
The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
SessionID: 16774
TempDB Parasites!
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 5
Speaker: Jason Hall
Title: TempDB Parasites!
Abstract:
Unless you happen to be Chuck Norris, your SQL Server instances only have one tempDB. That makes tempDB a single point of contention for an instance. What’s worse is that there are a lot of things going on in tempDB that you may not be aware of. Let’s look at some things that can use tempDB while we’re not looking.
SessionID: 16898
XQuery: get FLWORed
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 5
Speaker: Jennifer Kenney
Title: XQuery: get FLWORed
Abstract:
There are a number of difficult tasks in SQL querying that can be solved using XML and XQuery. Learn about pivoting, row concatenation, transactional processing techniques, and other things that can be accomplished by reshaping small data sets into XML.
SessionID: 17260
Social Networking Is Alive!!!
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: John Morehouse
Title: Social Networking Is Alive!!!
Abstract:
SessionID: 17581
Essential Policy-Based Management
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 6
Speaker: Justin Randall
Title: Essential Policy-Based Management
Abstract:
Policy-Based Management, introduced in SQL Server 2008 gives DBAs an easily accessible tool for ensuring consistent SQL Server configurations across their environment. This presentation will offer a core set of essential policies and options for implementing and maintaining them.
SessionID: 17813
Automated SQL Server installation and configuration using PowerShell
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 7
Speaker: Jamie Wick
Title: Automated SQL Server installation and configuration using PowerShell
Abstract:
Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process. PowerShell scripts can greatly reduce the time required to complete the process. They can also ensure build standardization throughout your SQL environment. In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of a SQL Server.
SessionID: 18179
The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 4
Speaker: Kevin Wilkie
Title: The Real Value of Name-Value Pairs: Using PIVOT and UNPIVOT
Abstract:
This session will show in-depth how to use both PIVOT and UNPIVOT. How to use the functionality will be described in detail along with how to use more advanced features like Dynamic PIVOT!
SessionID: 18234
Convince Me – Persuasion Techniques That Get Things Done
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Kevin Kline
Title: Convince Me – Persuasion Techniques That Get Things Done
Abstract:
This was the top scoring professional development session from the PASS Summit 2013.
Ever wanted to convince the boss try something new, but didn't know where to start? Ever tried to lead your peers only to fail to achieve your goals? This session teaches you the eight techniques of influencing IT professionals, so that you can innovate and achieve change in your organization.
- Learn about the fundamental difference between influence and authority and how you can achieve a high degree of influence without explicit authority.
- Learn the eight techniques of influencing IT professionals, when to apply them, and how to best use them.
- Discover the communication and procedural techniques that ensure your ideas get a hearing by bosses and peers, and how to best win support for them.
SessionID: 18579
Transactional Replication-10 steps for successful implementation
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 6
Speaker: Konstantin Melamud
Title: Transactional Replication-10 steps for successful implementation
Abstract:
What is potentially our biggest problem with transactional replication? You guessed it...it breaks! It may break for a variety of reasons and we as DBA’s probably have experienced them all at one point or another. Our biggest worry? Bringing replication back online whenever a full snapshot reinitialization is not an option due to time or space concerns. But don't you worry; we have a couple of tricks up our sleeves! During this session, we will go over options available to you to re-sync your replication with minimal downtime for your production environments.
SessionID: 18873
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: Ravi Kumar
Abstract:
SessionID: 20214
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 5
Speaker: Mark Hudson
Abstract:
Whether predicting customers or All Stars, the process and the tools remain the same. Microsoft’s Analysis Services Data Mining tools enable you to quickly profile your data, identify hidden relationships and predict future outcomes based on those relationships. Join me to see what data mining is, what data mining is not and how Microsoft's data mining tools can help you analyze your business. During this session, I will walk us through a start-to-finish data mining prediction project. It's easier than you might have thought.
SessionID: 22078
Common Coding Mistakes and how to Mitigate them
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: William Wolf
Title: Common Coding Mistakes and how to Mitigate them
Abstract:
There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
SessionID: 22216
ETL Design Topics - Staging
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 5
Speaker: Philip Noakes
Title: ETL Design Topics - Staging
Abstract:
SessionID: 22608
But it worked great in Dev! Perfomance for Devs
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 6
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: 23253
Know Your Role(s)!
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Robert Verell
Title: Know Your Role(s)!
Abstract:
Developers and DBAs naturally conflict with each other over permissions since developers want to be able to fix their code and research issues, but DBAs are the gatekeepers. In this session we will discuss Microsoft recommended best practices for setting up users and service account permissions. We will go over common server and database roles and what they actually allow, including roles that should be avoided as potential security loopholes. He will also look into alternatives for elevated database roles, and easier ways of setting up users across an enterprise environment, all as part of how to consolidate your development servers into fewer instances.
SessionID: 23911
From Zero to Loading a Data Warehouse
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Samuel Vanga
Title: From Zero to Loading a Data Warehouse
Abstract:
You're tasked to create the ETL process for a brand-new data warehouse. Where do you start? Data warehouse ETL boils down to three specific problems: Staging, Dimensions, and Facts. This session will show you solutions to these three problems. You'll first learn the fundamentals of a data warehouse before diving into creating packages and leveraging common patterns. You'll see both simple and advanced scenarios such as incrementally loading staging tables, processing type1 and type2 slowly changing dimensions, early arriving facts, snapshot fact tables, and bridge tables. If you want to create scalable and efficient SSIS packages to load a data warehouse, this session is for you.
SessionID: 26637
Dealing with Dirty Data with SQL Server and SSIS
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 7
Speaker: Tim Mitchell
Title: Dealing with Dirty Data with SQL Server and SSIS
Abstract:
In this session, we'll discuss some design patterns for addressing different types of dirty data using SQL Server Integration Services. We will review the various cleansing tools accessible from within SSIS including native Integration Services components, T-SQL, and SSIS scripting. In addition, we'll briefly review the new SQL Server Data Quality Services and its integration with SSIS. We'll cap off the discussion with demonstrations of several methods for data cleansing.
SessionID: 26832
Audit Solutions using SQL Azure Database Audit the SQL Server Audit Feature
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 8
Speaker: Timothy McAliley
Title: Audit Solutions using SQL Azure Database Audit the SQL Server Audit Feature
Abstract:
SessionID: 27526
Charlie and the SQL Server Re-Fill Factory
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: Slava Murygin
Title: Charlie and the SQL Server Re-Fill Factory
Abstract:
Will show you the chocolate of Fill Factor and how to win the Golden Ticket by easy Re-FillFactoring
SessionID: 27750
Wheel of Doom
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 1
Speaker: Wayne Sheffield
Title: Wheel of Doom
Abstract:
SessionID: 28243
Mobile Data Made Easy
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: Kevin Hazzard
Title: Mobile Data Made Easy
Abstract:
SessionID: 34861
Supporting SharePoint and Project Server databases as SQL Server Database Administrator
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 2
Speaker: Ram Saini
Title: Supporting SharePoint and Project Server databases as SQL Server Database Administrator
Abstract:
SessionID: 9545
SSIS 2014 Data Flow Tuning Tips and Tricks
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 3
Speaker: Andy Leonard
Title: SSIS 2014 Data Flow Tuning Tips and Tricks
Abstract:
SessionID: 9851
I’m New, Select Me!
Event Date: 21-03-2015 - Session time: 00:00:00 - Track: Track 4
Speaker: Thomas Norman
Title: I’m New, Select Me!
Abstract:
I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA! Feeling overwhelmed, not sure where to begin. I know I have data and maybe lots of it. I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends. For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends. Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.