sqlsathistory

Nr: 617

Back to Main list

SQLSaturday #617 - Pensacola 2017

Start Time (24h) Speaker Track Title
08:00:00 Anthony Nocentino Enterprise Database Administration Deployment Designing High Availability Database Systems using AlwaysOn Availability Groups
08:00:00 Daniel Glenn Other Keys to Successful SharePoint Administration for the DBA
08:00:00 Samir Behara Application Database Development Increase Your Coding Speed in SQL Server Management Studio
08:00:00 John Morehouse Application Database Development SQL Server Databaseology: A Deep Dive Into Database Internals
08:00:00 Kerry Tyler Application Database Development Managing Your Schema with Database Projects in Visual Studio
09:45:00 Janis Griffin Enterprise Database Administration Deployment Does your performance tuning need a 12-step program?
09:45:00 Arvin Meyer Application Database Development Intelligent Indexing
09:45:00 Thomas LeBlanc BI Information Delivery What is Power BI?
09:45:00 Chris Hyde Analytics and Visualization SQL Server R Services in SQL 2016
09:45:00 Andy Yun Application Database Development T-SQL Tips Tricks to Make Your Life Easier!
11:15:00 Rie Irish Professional Development Let Her Finish: Supporting Women's Voices from meetings to the board room
11:15:00 Robert Bishop Application Database Development You want me to Isolate what? An introduction into data integrity and Isolation Levels of SQL Server
11:15:00 Tim Mitchell BI Platform Architecture, Development Administration Testing SSIS Packages
11:15:00 Lance Tidwell Application Database Development Introduction to Execution Plans
11:15:00 Monica Rathbun Professional Development I’m It – Survival Techniques for the Lone DBA
11:15:00 Tim Radney Enterprise Database Administration Deployment Azure SQL Database for the Production DBA
13:00:00 Rodney Landrum Cloud Application Development Deployment SQL and VMWare - More than just virtualization demos
13:00:00 Jason Hall Enterprise Database Administration Deployment Root cause analysis with SentryOne
13:00:00 Janis Griffin Enterprise Database Administration Deployment DPA – A Product Overview from SolarWinds
13:45:00 Christine Assaf Professional Development Mastering your Resume Interview: Tips to Get Hired
13:45:00 William Assaf Application Database Development SQL Server Permissions and Security Principals
13:45:00 Kevin Feasel Application Database Development Working Effectively With Legacy SQL
13:45:00 William E Pearson III BI Platform Architecture, Development Administration Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI
13:45:00 Jennifer McCown Application Database Development T-SQL's Hidden Support Feature
13:45:00 Mike Lawell Enterprise Database Administration Deployment Execution Plans for Mere Mortals
15:00:00 Pritesh Ostwal BI Information Delivery Embedding Power BI In your Web Application
15:00:00 Vishal Pawar Application Database Development SSIS - Lightning fast processing using Parallel processing Optimization
15:00:00 Mike Byrd Application Database Development A Rocket Scientist View on Indexes
15:00:00 Michael Viron Strategy and Architecture Fundamentals of Disaster Planning Recovery
15:00:00 Sean McCown Enterprise Database Administration Deployment Monster Text Manipulation: Regular Expressions for the DBA
15:00:00 Mike Hillwig Professional Development Lighten Up: Soft Skills for Hardcore Techies
16:15:00 Jamey Johnston Analytics and Visualization Code Like a Pirate ... Intro to R and Data Science Tools in MS
16:15:00 Vladimir Oselsky Application Database Development Crash Course on Better SQL Development
16:15:00 Rob Volk Application Database Development Autonomous Transaction Logging in SQL Server
16:15:00 Neal Waterstreet BI Platform Architecture, Development Administration Master Data Management with SQL Server 2016 MDS
16:15:00 Jason Hall Application Database Development TempDB Parasites!
16:15:00 Christopher Sims Application Database Development I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search
16:15:00 Amy Herold Enterprise Database Administration Deployment Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

SessionID: 57823

Designing High Availability Database Systems using AlwaysOn Availability Groups

Back to calendar

Event Date: 03-06-2017 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Anthony Nocentino

Title: Designing High Availability Database Systems using AlwaysOn Availability Groups

Abstract:

Are you looking for a high availability solution for your business critical application? You're heard about AlwaysOn Availability Groups and they seem like a good solution, but you don't know where to start. It all starts with a solid design. In this session we introduce the core concepts needed to design a Availability Group based system. Covering topics such as recovery objectives, replica placement, failover requirements, synchronization models, quorum, backup and recovery and monitoring. This session is modeled after real world client engagements conducted by Centino Systems that have lead to many successful Availability Groups based systems supporting tier 1 business critical applications.

SessionID: 58239

Keys to Successful SharePoint Administration for the DBA

Back to calendar

Event Date: 03-06-2017 - Session time: 08:00:00 - Track: Other

Speaker: Daniel Glenn

Title: Keys to Successful SharePoint Administration for the DBA

Abstract:

Inherited SharePoint or being tasked to implement it? In this session we will start with the fundamentals of SharePoint and work our way to understanding what it looks like to be a successful SharePoint administrator. We will cover common SharePoint misconceptions use live demos to show frequently performed tasks - all to set you up for success day one. Lastly we will cover the training options and other resources available to make your job easier and more automated.

SessionID: 59405

Increase Your Coding Speed in SQL Server Management Studio

Back to calendar

Event Date: 03-06-2017 - Session time: 08:00:00 - Track: Application Database Development

Speaker: Samir Behara

Title: Increase Your Coding Speed in SQL Server Management Studio

Abstract:

Every developer wants to be productive and get more things accomplished during their day to day work. Given a choice between working harder and working smarter, you will most likely choose the latter. But the big question is – How do you boost your productivity? How do you reduce your development time? How do you increase your coding speed?

Be it a T-SQL developer or DBA, we spend most of our time working in SQL Server Management Studio. In this session, we will learn a number of tips and tricks to increase productivity and efficiency in SSMS IDE. We will also look at the new and improved features of SSMS 2016. We will learn how adding few free third party tools to the SSMS IDE will enhance your coding speed. This will be a content rich session with plenty of live demonstrations.

By the end of this session, you will learn some useful techniques to take back with you and apply in your day to day work.

SessionID: 63447

SQL Server Databaseology: A Deep Dive Into Database Internals

Back to calendar

Event Date: 03-06-2017 - Session time: 08:00:00 - Track: Application Database Development

Speaker: John Morehouse

Title: SQL Server Databaseology: A Deep Dive Into Database Internals

Abstract:

Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge will allow you to build better, faster databases.

SessionID: 63454

Managing Your Schema with Database Projects in Visual Studio

Back to calendar

Event Date: 03-06-2017 - Session time: 08:00:00 - Track: Application Database Development

Speaker: Kerry Tyler

Title: Managing Your Schema with Database Projects in Visual Studio

Abstract:

Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a daunting and often tedious proposition. Adding the complexity of version control to the mix complicates this scenario. Fortunately, beginning with Visual Studio 2012, Database Projects add an "easy" button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does no code management.

SessionID: 59665

Does your performance tuning need a 12-step program?

Back to calendar

Event Date: 03-06-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Does your performance tuning need a 12-step program?

Abstract:

Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to:

  1. Quickly fine tune a SQL statement
  2. Identify performance inhibitors to help avoid future performance issues
  3. Recognize and understand how new SQL Server features can help improve query
    performance

SessionID: 61083

Intelligent Indexing

Back to calendar

Event Date: 03-06-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Arvin Meyer

Title: Intelligent Indexing

Abstract:

Using indexing to improve performance

SessionID: 61098

What is Power BI?

Back to calendar

Event Date: 03-06-2017 - Session time: 09:45:00 - Track: BI Information Delivery

Speaker: Thomas LeBlanc

Title: What is Power BI?

Abstract:

Do you want to know what all the fuss (or excitement) is about concerning PowerBI? Then, this session is for you. We will walk through the process and marketing of what now is Power BI. Reports will be developed and displayed as well as the history of development of Power BI and what to look out for in this ever changing application. You will also learn that this tool is not replacing the Data Warehouse and Architect positions. Actually, it will produce more work for us (DBAs, Architects, etc.) It is another reporting option Microsoft that is positioning itself in the changing world of Business Intelligence.

SessionID: 62673

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 03-06-2017 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 63378

T-SQL Tips Tricks to Make Your Life Easier!

Back to calendar

Event Date: 03-06-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Andy Yun

Title: T-SQL Tips Tricks to Make Your Life Easier!

Abstract:

Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you.

This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges.

This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life!

SessionID: 57800

Let Her Finish: Supporting Women's Voices from meetings to the board room

Back to calendar

Event Date: 03-06-2017 - Session time: 11:15:00 - Track: Professional Development

Speaker: Rie Irish

Title: Let Her Finish: Supporting Women's Voices from meetings to the board room

Abstract:

Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out.

This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

SessionID: 58131

You want me to Isolate what? An introduction into data integrity and Isolation Levels of SQL Server

Back to calendar

Event Date: 03-06-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Robert Bishop

Title: You want me to Isolate what? An introduction into data integrity and Isolation Levels of SQL Server

Abstract:

Isolation Levels in SQL Server can benefit your application and help control data integrity by managing concurrency effects but can also hurt your application if you are unaware of what they are and how they are used. A review of SQL Concurrency issues and how SQL Isolation Levels can help eliminate them and keep the integrity of your data. This presentation will demonstrate with queries what causes concurrency issues and what isolation levels will prevent them.

SessionID: 59465

Testing SSIS Packages

Back to calendar

Event Date: 03-06-2017 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Mitchell

Title: Testing SSIS Packages

Abstract:

Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.”

As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system.

This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these:

SessionID: 59711

Introduction to Execution Plans

Back to calendar

Event Date: 03-06-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Lance Tidwell

Title: Introduction to Execution Plans

Abstract:

In this session we will take a look at the basics of execution plans. We will discuss what they are, how they are made, and how they are used. We will explore some of the common operators seen in execution plans and their functions. Next we will look at the differences between estimated and actual execution plans. Throughout, you will be getting insight on how to read execution plans to help tune your queries.

SessionID: 62438

I’m It – Survival Techniques for the Lone DBA

Back to calendar

Event Date: 03-06-2017 - Session time: 11:15:00 - Track: Professional Development

Speaker: Monica Rathbun

Title: I’m It – Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 63402

Azure SQL Database for the Production DBA

Back to calendar

Event Date: 03-06-2017 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Radney

Title: Azure SQL Database for the Production DBA

Abstract:

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

SessionID: 65680

SQL and VMWare - More than just virtualization demos

Back to calendar

Event Date: 03-06-2017 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Rodney Landrum

Title: SQL and VMWare - More than just virtualization demos

Abstract:

The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. As a true platform of virtualized hardware, vSphere should be considered the premier platform on which to implement SQL Server. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as to how this enhances your SQL Server environment.

SessionID: 65681

Root cause analysis with SentryOne

Back to calendar

Event Date: 03-06-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Hall

Title: Root cause analysis with SentryOne

Abstract:

SentryOne helps DBAs elevate performance across the Microsoft Data Platform. In this session, SentryOne’s Director of Product Management, Jason Hall, will lead the audience through the SentryOne platform, including our popular FREE query tuning solution Plan Explorer, on a mission to monitor, diagnose, and optimize performance on a live SQL Server instance. The session is composed of mostly demonstrations, and heavy audience participation should be expected.

SessionID: 66388

DPA – A Product Overview from SolarWinds

Back to calendar

Event Date: 03-06-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: DPA – A Product Overview from SolarWinds

Abstract:

Are you struggling with database performance issues and your current tools are not providing answers? This presentation outlines a method for determining the best approach for quickly finding and fixing inefficient queries by utilizing wait-time analytics. Janis Griffin, database performance evangelist, SolarWinds, will use real-life case studies to show how quickly you can identify and fix the problems that are affecting your end user applications while saving countless of hours of investigation.

SessionID: 57799

Mastering your Resume Interview: Tips to Get Hired

Back to calendar

Event Date: 03-06-2017 - Session time: 13:45:00 - Track: Professional Development

Speaker: Christine Assaf

Title: Mastering your Resume Interview: Tips to Get Hired

Abstract:

Looking for a job? Learn trade secrets from a Recruiter! Resume blunders and interview tips, this session will focus on ten most important things you can do to get hired.

SessionID: 57802

SQL Server Permissions and Security Principals

Back to calendar

Event Date: 03-06-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: William Assaf

Title: SQL Server Permissions and Security Principals

Abstract:

A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA's, developers and system admins, and has been recently updated for Azure SQL!

SessionID: 57907

Working Effectively With Legacy SQL

Back to calendar

Event Date: 03-06-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Kevin Feasel

Title: Working Effectively With Legacy SQL

Abstract:

A legacy code base can be a frightening thing. Between strict deadlines, ever-evolving requirements, differing skill levels of contributors over time, and historical circumstances, keeping database code clean and concise is difficult at best. This example- and demo-driven talk will help you build out a mental framework to prune those gnarled code bases. Much of this talk will be familiar to software developers who know of the "clean code" philosophy, but no knowledge of the topic is necessary. If you shudder whenever you look at your SQL code base, this talk may be for you.

SessionID: 58293

Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI

Back to calendar

Event Date: 03-06-2017 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: William E Pearson III

Title: Seeking the Perfect Hybrid: On-Prem Data with Reports and Dashboards in Power BI

Abstract:

For many new Power BI implementations, initial self-service and team objectives are soon met, and the natural evolution of Power BI turns to an organizational focus. In other scenarios, the enterprise seeks to preserve its investments in "classic BI" by integrating Power BI with Analysis Services and the underlying data warehouse.

In this session, Data Platform (SQL Server / BI) MVP and SSAS Maestro Bill Pearson explores the construction of organizational BI solutions, wedding the "traditional" solutions with the reporting and analysis power of Power BI. We'll focus upon the components of a "traditional" solution, up to the semantic model (with SQL Server Analysis Services as an example), and then explore paths to the implementation of an end-to-end enterprise solution that uses Power BI as the presentation layer. This session applies, in most respects, to Analysis Services 2012 and above.

SessionID: 61534

T-SQL's Hidden Support Feature

Back to calendar

Event Date: 03-06-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: T-SQL's Hidden Support Feature

Abstract:

The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature's name is "comments".

#160; In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond.#160; These methods help prevent errors and reduce troubleshooting.

SessionID: 62554

Execution Plans for Mere Mortals

Back to calendar

Event Date: 03-06-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Mike Lawell

Title: Execution Plans for Mere Mortals

Abstract:

For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.

SessionID: 57813

Embedding Power BI In your Web Application

Back to calendar

Event Date: 03-06-2017 - Session time: 15:00:00 - Track: BI Information Delivery

Speaker: Pritesh Ostwal

Title: Embedding Power BI In your Web Application

Abstract:

Embedding Power BI In your Web Application

Power BI is growing by leaps and volumes and there is need to host the portal in your web application.

This session goes through different ways you can embed Power BI (Portal Reports) and Embedded Power BI Service Reports in your Web Application.

SessionID: 58016

SSIS - Lightning fast processing using Parallel processing Optimization

Back to calendar

Event Date: 03-06-2017 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Vishal Pawar

Title: SSIS - Lightning fast processing using Parallel processing Optimization

Abstract:

SSIS package can be run in Parallel and Optimized .In this session we will learn how to improve SSIS Package performance using parallel processing and Optimization. This knowledge will encourage development of better performing packages and optimize package performance.When creating an efficient and robust solution for Extract, Transform and Load Process, Lot of things do matter especially when you are working with huge size of databases. Challenge is not only to meet functional requirements Also to look at the performance requirements. This session will also cover best practices to enhance and boost performance of a SSIS package.

SessionID: 60978

A Rocket Scientist View on Indexes

Back to calendar

Event Date: 03-06-2017 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: A Rocket Scientist View on Indexes

Abstract:

Indexes can be a boon or decrement for query performance. This presentation will present what they are (in layman’s terms) and how they may affect query performance – both from a read (SELECT) viewpoint as well as a data modification aspect (INSERT, UPDATE, DELETE). This session will concentrate with a deep dive into clustered indexes and nonclustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases. Covering nonclustered indexes will also be examined in detail and the scenarios they should be applied. There will be many query demos illustrating index utilization using statistics and query plans. Attendee should have some TSQL and Management Studio experience.

SessionID: 61086

Fundamentals of Disaster Planning Recovery

Back to calendar

Event Date: 03-06-2017 - Session time: 15:00:00 - Track: Strategy and Architecture

Speaker: Michael Viron

Title: Fundamentals of Disaster Planning Recovery

Abstract:

In this session, we'll cover the basics of Disaster Planning and key operational items to consider when establishing software systems. We'll cover terms and their importance as well as commonly used software and hardware techniques for disaster planning purposes.

SessionID: 61532

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 03-06-2017 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract:

Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures filled with table variables instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cuts that work from hours to seconds. I use regular expressions all the time and I have taken many tasks down from several days to just a few minutes. Stop writing code manually and let regular expressions do it for you.

Here you’ll learn: • the most useful regular expression commands • the appropriate times to use regular expressions • how to use regular expressions to write code for you • how to incorporate regular expressions into large tasks and combine them with other methods.

SessionID: 62825

Lighten Up: Soft Skills for Hardcore Techies

Back to calendar

Event Date: 03-06-2017 - Session time: 15:00:00 - Track: Professional Development

Speaker: Mike Hillwig

Title: Lighten Up: Soft Skills for Hardcore Techies

Abstract:

Your ideas are only as good as your ability to describe them to others.

As technology professionals, our tech skills need to be at their peak. However, we often lack the communication skills to describe technical concepts to others, including business users, executives, or even other technology professionals. In this session, veteran IT professional Mike Hillwig, will show you a handful of skills that are essential in communicating with people outside of the database world.

You will learn Mike's keys to good storytelling, making analogies, listening, writing, and putting technology concepts into things that give you a common language with business users. You'll leave this session with the ability to influence technology decisions based on your skills explaining why the DBA is usually right.

SessionID: 57795

Code Like a Pirate ... Intro to R and Data Science Tools in MS

Back to calendar

Event Date: 03-06-2017 - Session time: 16:15:00 - Track: Analytics and Visualization

Speaker: Jamey Johnston

Title: Code Like a Pirate ... Intro to R and Data Science Tools in MS

Abstract:

Come to this session to get an introduction to the R language including:

We will finish with a brief introductions of how R integrates in Azure ML, Power BI, and SQL Server 2016 using real demos.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!

SessionID: 57837

Crash Course on Better SQL Development

Back to calendar

Event Date: 03-06-2017 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

SessionID: 59749

Autonomous Transaction Logging in SQL Server

Back to calendar

Event Date: 03-06-2017 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Autonomous Transaction Logging in SQL Server

Abstract:

Autonomous/nested transactions are available in other database products, but are not natively supported in SQL Server. Fortunately there are several methods available to provide this functionality.

We'll cover the standard table variable techniques to preserve data outside of transaction scope, and how the new in-memory table type can improve their performance. Other techniques like user-defined events, CLR procedures, linked servers will also be demonstrated, and how they can enhance functionality.

We'll review minimal techniques like RAISERROR and the new SESSION_CONTEXT() feature in SQL Server 2016, to provide different levels of logging and transaction management.

SessionID: 61526

Master Data Management with SQL Server 2016 MDS

Back to calendar

Event Date: 03-06-2017 - Session time: 16:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Neal Waterstreet

Title: Master Data Management with SQL Server 2016 MDS

Abstract:

Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

SessionID: 61615

TempDB Parasites!

Back to calendar

Event Date: 03-06-2017 - Session time: 16:15:00 - Track: Application Database Development

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.

Learn about operations that happen in tempdb View demonstrations of performance hampering implicit activities in tempdb Learn about little known performance optimization techniques for tempdb

SessionID: 62617

I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search

Back to calendar

Event Date: 03-06-2017 - Session time: 16:15:00 - Track: Application Database Development

Speaker: Christopher Sims

Title: I like big data for $400 - Exploring quiz show questions using Angular, DocumentDB and Azure Search

Abstract:

In this talk, we will explore two powerful technologies from the Microsoft Azure Stack: DocumentDB and Azure Search. DocumentDB is Microsoft's NoSQL service for building globally scalable schema-free applications. Azure Search allows you to integrate the power of Microsoft's search and natural language processing abilities to explore your complex data stores. During this talk we will cover the benefits of implementing a schema-free database, we will learn how to replicate your data at a global scale with the ease of a simple configuration and we will cover various techniques of querying that data using SQL and the DocumentDB API. Once we have a large datastore in place (we will use 200k+ Jeopardy questions), we will apply the powerful natural language querying capabilities and faceted search features of Azure Search to quickly create an searchable data repository. All of this will be built and exposed using a cross-platform application built in Angular on the Electron framework.

SessionID: 62679

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Back to calendar

Event Date: 03-06-2017 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract:

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

This site is open source. Improve this page.