Nr: 320
SQLSaturday #320 - Raleigh 2014
SessionID: 10058
Get Near Realtime ETL with Service Broker
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Allen White
Title: Get Near Realtime ETL with Service Broker
Abstract:
SessionID: 10059
Manage SQLServer Efficiently w/PowerShell Remoting
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
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.
SessionID: 10784
Managing Very Large Databases with SQL Server
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Brian Carrig
Title: Managing Very Large Databases with SQL Server
Abstract:
If some of your databases have grown to over 1TB and it has become a challenge to maintain them - or if you are anticipating what to do in the future when they do - then this talk is for you!
In this session, I will provide some practical advice on managing VLDBs with SQL server, focusing on common problem areas for new and experienced DBAs alike, including index maintenance, integrity checks, backups and restores.
SessionID: 10876
SQL 2012 Table Compression
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Performance/Internals
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: 11162
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Professional Development
Speaker: Mohamed Mawla
Abstract:
I want to share with you my Swiss-knife of free tools that I use almost daily to work with SQL server. From SQL Nexus , PAL,Qure Analyzer, PSSDiag , and more ;some help with productivity and some cut the time needed to troubleshoot an issue.
Those are powerful, free and easy to use tools to help you with your daily work. I would like also to hear from you if you are using any other tools that you find useful and save you time and cost even if they are not free so please come.
SessionID: 11209
"I Know What You Did Last Query" --SQL Server
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Performance/Internals
Speaker: Carlos L Chacon
Title: "I Know What You Did Last Query" --SQL Server
Abstract:
SessionID: 11280
Optimizing Protected Indexes
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Performance/Internals
Speaker: Chris Bell
Title: Optimizing Protected Indexes
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: 11569
Check Engine Lights
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Performance/Internals
Speaker: Chris Skorlinski
Title: Check Engine Lights
Abstract:
SessionID: 11570
Your Best Interview Ever
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Professional Development
Speaker: Chris Skorlinski
Title: Your Best Interview Ever
Abstract:
Presented by Chris Skorlinski with a collection of tips from 20 years of interviewing new hire candidates at Microsoft. He'll cover techniques for building your résumé and key strategies during interviews, whether via phone, Skype, or in-person, to increase your chances for a new job and a new adventure.
SessionID: 13415
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Professional Development
Speaker: Doug Purnell
Abstract:
SessionID: 14206
We Have Normality
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Introductory Topics
Speaker: Kevin Feasel
Title: We Have Normality
Abstract:
SessionID: 14209
Much Ado About Hadoop
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Cloud/Big Data
Speaker: Kevin Feasel
Title: Much Ado About Hadoop
Abstract:
Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a few minutes on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.
SessionID: 14499
Cloudy with a Chance of Data
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Cloud/Big Data
Speaker: Geoff Hiten
Title: Cloudy with a Chance of Data
Abstract:
Cloud, Cloud, Cloud. Microsoft is "all in". CxOs love the idea of renting compute resources. You know this is where our profession is headed, but when and how fast. When should you jump on board? The good news is cloud will not eliminate or even reduce the need for IT and Data professionals. The bad news is our world and our profession is changing. Come see what Microsoft Azure has to offer Data Professionals.
SessionID: 15564
F# Type Providers Change The Way You Interact With Data Sources
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: T-SQL/Dev
Speaker: Jamie Dixon
Title: F# Type Providers Change The Way You Interact With Data Sources
Abstract:
F# is the functional language that ships with Visual Studio. It is a great language that combines the power of functional programming with the benefits of being a 1st class citizen in the .NET stack. One feature unique to F# is type providers. Type providers are constructs to allow you to dynamically connect and consume data sources ranging from Sql Server to Json to Hadoop to MongoDb and everything in between. Type providers are particularly useful analyzing very large datasets where it is impossible to code-gen the schema. They are also very useful for developers who want to write fewer bugs.
SessionID: 16679
What's in the SQL Server 2014 Business Intelligence Suite?
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Jessica Moss
Title: What's in the SQL Server 2014 Business Intelligence Suite?
Abstract:
SessionID: 16744
What the Hekaton
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Introductory Topics
Speaker: John Flannery
Title: What the Hekaton
Abstract:
SessionID: 16777
TempDB Parasites!
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
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: 17150
The Froogle DBA – Combining SQL Features and Open Source
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: John Greeson
Title: The Froogle DBA – Combining SQL Features and Open Source
Abstract:
There are some really great toolsets for sale to help you manage your SQL Server environment. If you want to learn more about them, then this is not the session for you. While there is nothing wrong with buying a solution to solve your needs. The Froogle DBA has a recipe for combining free software with built in SQL Server features to put together a framework that will give you the peace of mind you need to sleep at night. That’s right, no software licensing needed beyond your SQL Server investment and you too could be maintaining and monitoring your systems with the best of them.
We’ll be combining Zenoss, MDW, CMS, and Performance Dashboard Reports to build a comprehensive monitoring and management framework in place. With this flexible framework you will be able to keep systems up and sleep easier.
SessionID: 17815
PowerShell SQL Management Objects: automated sql server installs and configurations
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Jamie Wick
Title: PowerShell SQL Management Objects: automated sql server installs and configurations
Abstract:
Creating new SQL servers is a time-intensive process. Beyond the Next, Next, Next of the initial install are the multitude of configuration details unique to your environment. Maintenance Jobs, alerts, min/max memory, operators, dbmail, audits and the list goes on. In this presentation we will go over basic PowerShell syntax and PowerShell SQL Management Objects (SMO), resulting in a set of reusable scripts for automating the installation and configuration of new SQL servers.
SessionID: 20783
SQL Server Bingo – Install, Migration Config
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Mindy Curnutt
Title: SQL Server Bingo – Install, Migration Config
Abstract:
Get ready to play SQL Buzzword Bingo with the subject matter being SQL Install, Migration Configuration. Are you preparing to move a database from one SQL Server to another? Whether it's your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to "get it right." Come to this session and find out all about the process - and have some fun while you're at it. First one to hit BINGO! will win a copy of the book SQL Server 2012 - Step by Step.
SessionID: 21700
Automated Deployments - Lowering the risk of database releases
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Eli Weinstock-Herman
Title: Automated Deployments - Lowering the risk of database releases
Abstract:
In this session, we'll build a deployment pipeline that will reduce the stress and risks we're used to from manual deployments while providing a framework for cleaner change tracking and management, shorter release windows, and the ability to keep numerous environments in sync with the latest available changes without constant restores. While the primary focus will be an end-to-end demo, we'll also discuss the business value of deployment pipelines, how they reduce risk and enable us to move faster, and alternatives to the set of tools used in the demo.
SessionID: 21865
BI Expert Panel - Part 1
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Paul Turley
Title: BI Expert Panel - Part 1
Abstract:
Join a panel of Business Intelligence experts from SolidQ and learn the best practices for planning and delivering successful BI solutions. Join Rushabh Mehta, Brett Tomson and Paul Turley to discuss how to bring BI to your organization, avoid common pitfalls, apply proven design patterns and learn from deployments in companies around the world. Bring your hard questions and be prepared for an interactive discussion.In this first of two sessions, learn how to wrangle requirements from the business, plan, prototype, design your solution.
SessionID: 21866
BI Expert Panel - Part 2
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Paul Turley
Title: BI Expert Panel - Part 2
Abstract:
In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization. BI solution experts and SolidQ Mentors Rushabh Mehta, Brett Tomson and Paul Turley will help you define an end-to-end BI solution including data sourcing security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.
SessionID: 22585
Locks, Blocks, and Deadlocks Oh My!
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Performance/Internals
Speaker: Randy Knight
Title: Locks, Blocks, and Deadlocks Oh My!
Abstract:
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
SessionID: 22587
Understanding Transaction Isolation Levels
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Introductory Topics
Speaker: Randy Knight
Title: Understanding Transaction Isolation Levels
Abstract:
SQL Server offers several isolation levels beyond the default "READ COMMITTED". But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.
SessionID: 22674
SSIS Templates Can Make Your Life Easier
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Brian Davis
Title: SSIS Templates Can Make Your Life Easier
Abstract:
How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.
SessionID: 22675
Goodbye Next Next Next, Hello Automated Installs
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Brian Davis
Title: Goodbye Next Next Next, Hello Automated Installs
Abstract:
SessionID: 23393
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Rodney Landrum
Abstract:
SessionID: 24066
Getting Started With Execution Plans
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Introductory Topics
Speaker: Scott Fallen
Title: Getting Started With Execution Plans
Abstract:
Are you just breaking into the query tuning side of managing your SQL Servers? In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process. We will discuss how SQL Server creates and uses plans, and how to collect them. Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean. We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance. We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.
SessionID: 24984
Twice in a Lifetime: T-SQL Refactoring 101
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: T-SQL/Dev
Speaker: MIKE DONNELLY
Title: Twice in a Lifetime: T-SQL Refactoring 101
Abstract:
This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can't be used in modern versions of SQL Server. Don't leave your old T-SQL the same as it ever was.
SessionID: 25182
Scalable, Large-Volume Data Synchronization in OLTP Systems
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Cloud/Big Data
Speaker: Solomon Rutzky
Title: Scalable, Large-Volume Data Synchronization in OLTP Systems
Abstract:
SessionID: 25183
What can SQLCLR do for you?
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: T-SQL/Dev
Speaker: Solomon Rutzky
Title: What can SQLCLR do for you?
Abstract:
Most articles and blog entries regarding SQLCLR are focused on how to write functions or stored procedures, but very little time is spent on showing what SQLCLR does really well and where it can be truly beneficial. Here we will explore the what / why / when of using SQLCLR to accomplish things that cannot be done in T-SQL, such as: Dynamic SQL, error handling, and calling Stored Procedures within functions; capturing PRINT output; Custom Aggregates; multi-threading; and more. We will look at practical examples of using SQLCLR to reduce code complexity, reduce the time it takes to complete a project, increase performance, and assist in automation (i.e. stay within T-SQL instead of using SSIS or xp_cmdshell).
SessionID: 26504
SQL Injection
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: T-SQL/Dev
Speaker: Kevin Boles
Title: SQL Injection
Abstract:
Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
SessionID: 26505
Indexing Deep Dive
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
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.
SessionID: 26838
Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Cloud/Big Data
Speaker: Timothy McAliley
Title: Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure
Abstract:
SessionID: 26839
Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Cloud/Big Data
Speaker: Timothy McAliley
Title: Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure
Abstract:
SessionID: 27109
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Trent Sherman
Abstract:
SessionID: 27765
Crazy Things That Developers Do
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: T-SQL/Dev
Speaker: Wayne Sheffield
Title: Crazy Things That Developers Do
Abstract:
Throughout my career, I've seen developers do some pretty crazy things to databases (and truth be told, I've done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it's bad to the database server (or your career)... and alternatives that can be used instead. Trust me... your DBA will love you for making these changes.
SessionID: 27767
Windowing Functions in SQL Server 2012
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: T-SQL/Dev
Speaker: Wayne Sheffield
Title: Windowing Functions in SQL Server 2012
Abstract:
SessionID: 28176
The 20-Minute Tabular Model
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: BI
Speaker: Bill Anton
Title: The 20-Minute Tabular Model
Abstract:
SessionID: 9095
Sizing your DW Hardware - SMP, Fast Track or PDW
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Cloud/Big Data
Speaker: Andy Isley
Title: Sizing your DW Hardware - SMP, Fast Track or PDW
Abstract:
SessionID: 9151
Getting the Most Out of Plan Reuse
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Performance/Internals
Speaker: Andrew Kelly
Title: Getting the Most Out of Plan Reuse
Abstract:
SessionID: 9862
Policy Based Management, Trolls and Watchmakers
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: DBA
Speaker: Thomas Norman
Title: Policy Based Management, Trolls and Watchmakers
Abstract:
Peanut Butter and Jelly holds two slices of bread together what can hold my Sql Servers together, PBM? Do you like to be constant, have a pattern and be reliable? I have way too much to do, I can’t review every line of code. Help me, please! PBM is your friend, your ally and the gateway to your system. Policy Based Management can be your bridge to your Sql Server. Let PBM be your troll, letting the best pass. But wait, PBM can also be your watchmaker. Policy Based Management, Trolls and Watchmakers, come watch PBM control our systems.
SessionID: 9863
I’m New, Select Me!
Event Date: 06-09-2014 - Session time: 00:00:00 - Track: Introductory Topics
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.