sqlsathistory

Nr: 636

Back to Main list

SQLSaturday #636 - Pittsburgh 2017

Start Time (24h) Speaker Track Title
08:45:00 Sayed Saeed BI Information Delivery Enabling Familiar, Powerful Business Intelligence
08:45:00 Eugene Meidinger Professional Development Drinking From the Firehose: a Guide to Keeping Up with Technology
08:45:00 Michael John Other What is a DBA?
08:45:00 Brian Carrig Cloud Application Development Deployment Running SQL Server in AWS
08:45:00 Tracy Boggiano Enterprise Database Administration Deployment Does This Look Weird?  The Importance Of Baselining
08:45:00 Steve Hood Application Database Development Indexing Fundamentals
08:45:00 Alex Grinberg Advanced Analysis Techniques CONVERT_IMPLICIT is a hidden danger
10:00:00 Peter Shore Enterprise Database Administration Deployment Got stress? Sometimes the SQL Server needs some too
10:00:00 Azhagappan Arunachalam BI Platform Architecture, Development Administration Excel with DAX
10:00:00 Andrzej Pilacik Enterprise Database Administration Deployment Refresh a 1TB+ database in under 10 seconds
10:00:00 Ed Wagner Other DBA - What's Most Important
10:00:00 Jim Donahoe Cloud Application Development Deployment Configuring DBaaS for the first time!
10:00:00 Tim Radney Professional Development Getting Involved and Getting Ahead
10:00:00 Jeremy Frye BI Platform Architecture, Development Administration SSIS Incremental Loading: The Tortoise and The Hare
11:15:00 Mike Hillwig Other Recovery and Backup for Beginners
11:15:00 Thomas Chan Enterprise Database Administration Deployment Finding more space for your tight environment.
11:15:00 John Deardurff Professional Development How to get Microsoft Certified
11:15:00 Sam Nasr Application Database Development Using Filetables
11:15:00 Ryan Booz Application Database Development Tools for the DBA Newbie: What I Wish I Had Known Years Ago
11:15:00 Jeff Moden Application Database Development Cross Tabs Pivots - Much More Than Just Converting Rows to Columns
11:15:00 William Wolf Application Database Development Stop Doing That! Common T-SQL Anti-Patterns
12:15:00 Matt Nelson Advanced Analysis Techniques Lunch break
12:55:00 Matt Nelson Other New Horizons lunchtime chat
12:55:00 Matt Nelson Other Plus Consulting lunchtime chat
13:30:00 Slava Murygin Enterprise Database Administration Deployment SQL Server on Linux for SQL DBA.
13:30:00 Dummea Vincent Enterprise Database Administration Deployment Access, Users, Permissions for Beginners!
13:30:00 Vladimir Oselsky Application Database Development Crash Course on Better SQL Development
13:30:00 Steve Grier Application Database Development SQL Server Data Tools (SSDT) Basics
13:30:00 Frank La Vigne Analytics and Visualization Machine Learning Melee: AWS vs Azure
13:30:00 Allen White Enterprise Database Administration Deployment Maintain SQL Server Performance Baseline w/PowerShell
13:30:00 Rayis Imayev BI Information Delivery Geo Location of Twitter messages in Power BI
14:40:00 Mike Hays Professional Development Tackling Technical Blogging
14:40:00 Brian Beswick BI Platform Architecture, Development Administration SSAS 2016 Tabular - Diving into the new features
14:40:00 Bert Wagner Application Database Development DBAs vs Developers: JSON in SQL Server 2016
14:40:00 Jonathan Stewart BI Platform Architecture, Development Administration An introduction to the magical world of BIML!
14:40:00 Rick Heiges Professional Development Getting Noticed: Strategies for Your Resume and LinkedIn
14:40:00 Ned Otter Enterprise Database Administration Deployment The DBA Survival Guide for In-Memory OLTP
14:40:00 Eric Blinn Application Database Development SSMS Tips and Tricks
15:50:00 Drew Furgiuele Enterprise Database Administration Deployment SQL Server and PowerShell: Let's Get Serious
15:50:00 Jim Donahoe Enterprise Database Administration Deployment New Instance, Now what?
15:50:00 Thomas Grohser Application Database Development # vs @ - it's not about Social Media it's about temporary tables and data
15:50:00 Peter Shore Enterprise Database Administration Deployment DBA 102: Now What
15:50:00 Dan Mallott Strategy and Architecture Cassandra for SQL Server Professionals
15:50:00 Mike Hillwig Professional Development Managing Up: The Art of Managing your Manager
15:50:00 Rick Heiges Professional Development SQL Games
15:50:00 Marsha Pierce Strategy and Architecture How to talk to your Storage Admin

SessionID: 63261

Enabling Familiar, Powerful Business Intelligence

Back to calendar

Event Date: 30-09-2017 - Session time: 08:45:00 - Track: BI Information Delivery

Speaker: Sayed Saeed

Title: Enabling Familiar, Powerful Business Intelligence

Abstract:

This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. With the recent release of SQL Server, Microsoft dramatically enhanced the Microsoft BI platform. During this session you will explore the improvements to SQL Server reporting services and Power BI to show you how to create a blended value from your BI platform.

SessionID: 63884

Drinking From the Firehose: a Guide to Keeping Up with Technology

Back to calendar

Event Date: 30-09-2017 - Session time: 08:45:00 - Track: Professional Development

Speaker: Eugene Meidinger

Title: Drinking From the Firehose: a Guide to Keeping Up with Technology

Abstract:

Keeping up with technology can feel like a treadmill; you keep running but never get anywhere. We'll take a look at ways to keep up with technology without pulling your hair out. We'll balance cost versus benefit for the different types of learning. We will also talk about learning goals.

SessionID: 64778

What is a DBA?

Back to calendar

Event Date: 30-09-2017 - Session time: 08:45:00 - Track: Other

Speaker: Michael John

Title: What is a DBA?

Abstract:

Starting the day for the Wanna Be A DBA track, Michael John and Ed Wagner will discuss what a DBA is, requirements for working as a DBA, what a typical day as a DBA looks like, and answer your questions about starting a career as a DBA.

SessionID: 64998

Running SQL Server in AWS

Back to calendar

Event Date: 30-09-2017 - Session time: 08:45:00 - Track: Cloud Application Development Deployment

Speaker: Brian Carrig

Title: Running SQL Server in AWS

Abstract:

Amazon Web Services (AWS) is the world's largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies, security and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.

SessionID: 65370

Does This Look Weird?  The Importance Of Baselining

Back to calendar

Event Date: 30-09-2017 - Session time: 08:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Does This Look Weird?  The Importance Of Baselining

Abstract:

How do you know when your server is on fire? Without a set of known-good measurements to compare against, you don’t. This session will show you how to capture a performance baseline for a SQL Server instance and help you decide what to capture, and where to store it. Finally we will put it all together by walking through a scenario using the captured baseline data to identify a problem.

SessionID: 68159

Indexing Fundamentals

Back to calendar

Event Date: 30-09-2017 - Session time: 08:45:00 - Track: Application Database Development

Speaker: Steve Hood

Title: Indexing Fundamentals

Abstract:

What are indexes and how does SQL Server use them? Discuss the types of indexes that are available, and go in depth into heaps, clustered indexes and nonclustered indexes. Why does SQL Server choose an index, and how does it make your queries run faster? If you're a good fit to be in this session then columnstore, hash, and XML indexes aren't a good fit for you, so they will not get much more than an honorable mention.

SessionID: 68276

CONVERT_IMPLICIT is a hidden danger

Back to calendar

Event Date: 30-09-2017 - Session time: 08:45:00 - Track: Advanced Analysis Techniques

Speaker: Alex Grinberg

Title: CONVERT_IMPLICIT is a hidden danger

Abstract:

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.

SessionID: 62852

Got stress? Sometimes the SQL Server needs some too

Back to calendar

Event Date: 30-09-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: Got stress? Sometimes the SQL Server needs some too

Abstract:

We hear it in every session and every webinar “…test…” regardless of it being upgrades, new code, performance tuning or any of a thousand changes. Once we confirm nothing breaks., we don’t need to check anything else, nothing could possibly change the results, right? What about load on the database(s) in question or the server as a whole? In this session four readily available tools, distributed replay, Hammer DB, SQL Query Stress and oStress will be introduced. The session will cover how to use the tools as well as which situations they shine in. Once introductions are made, we will spend a little time with two of my favorites, HammerDB and SQL Query Stress. Join me as we apply a little heat to our SQL Servers.

SessionID: 63024

Excel with DAX

Back to calendar

Event Date: 30-09-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Azhagappan Arunachalam

Title: Excel with DAX

Abstract:

DAX is the new formula language (builds upon Excel's) supporting PowerPivot and Analysis Services Tabular mode. If you know Excel, you already know the basics of DAX (without even knowing it). PowerBI also uses DAX for all the formula expressions. We'll cover the basics of DAX, and go over some time intelligence functions.

SessionID: 63317

Refresh a 1TB+ database in under 10 seconds

Back to calendar

Event Date: 30-09-2017 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrzej Pilacik

Title: Refresh a 1TB+ database in under 10 seconds

Abstract:

The presentation covers recoverability options in SQL Server over time. It will take us through many different ways of recovering a large 1TB+ database. It will also walk us through many different options for creating development/test/uat environments. It will highlight the benefits and shortcomings of these options while delivering a business value of each. It will also evaluate a high level ROI of each of these options.

Finally, the presentation will focus on an architecture based on SAN technologies with respect to SQL Server. I will demonstrate an architecture put in place resolving many business needs in a financial trading environment, working with large data sets and many different environments. This section will highlight the benefits of using SQL Server together with newer SAN solutions and show the potential for reliability, scalability, and the delivery of a high quality HA/DR solution. That is where things get interesting...

SessionID: 65241

DBA - What's Most Important

Back to calendar

Event Date: 30-09-2017 - Session time: 10:00:00 - Track: Other

Speaker: Ed Wagner

Title: DBA - What's Most Important

Abstract:

In this second session of the WBADBA track, we'll examine what's most important for a DBA. There are many topics to deal with, but this session with deal with the top five for a beginning DBA.

SessionID: 66596

Configuring DBaaS for the first time!

Back to calendar

Event Date: 30-09-2017 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Jim Donahoe

Title: Configuring DBaaS for the first time!

Abstract:

Are you new to Azure? Are you new to DBaaS? This is the perfect session for you! We will discuss the deployment of the server, as well as how to template it. We will cover what you configure once the server is deployed(resource locks, firewall, etc). What maintenance does Microsoft provide? What is an elastic pool? What maintenance is still your responsibility? Overwhelmed yet? Don't be, by the end of this session, you will have enough knowledge on how to create your very first DBaaS instance. This session is geared towards new users of Azure DBaaS and future users of Azure DBaaS.

SessionID: 68586

Getting Involved and Getting Ahead

Back to calendar

Event Date: 30-09-2017 - Session time: 10:00:00 - Track: Professional Development

Speaker: Tim Radney

Title: Getting Involved and Getting Ahead

Abstract:

Learn how getting involved in the SQL Community can help you get ahead within your organization, improve you skill set as well as help provide career stability. PASS and other organizations practically give you all the tools you need to succeed in the DBA field, learn about the events that help make this possible as well as how you can get involved to help others who are starting out. The rewards of the SQL Community are endless.

SessionID: 69345

SSIS Incremental Loading: The Tortoise and The Hare

Back to calendar

Event Date: 30-09-2017 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Frye

Title: SSIS Incremental Loading: The Tortoise and The Hare

Abstract:

Extracting, transforming and loading data has become a major component to satisfying business requirements and needs. Depending on the size of the data you are working with, the way you design your SSIS packages can have an impact on performance and run times.

In this session, we will cover a variety of incremental design approaches centered around large data sets using SSIS. We will look at the architecture of each ETL strategy to determine the pros and cons and generate specific use cases to decide which strategy yields optimal results.

SessionID: 61680

Recovery and Backup for Beginners

Back to calendar

Event Date: 30-09-2017 - Session time: 11:15:00 - Track: Other

Speaker: Mike Hillwig

Title: Recovery and Backup for Beginners

Abstract:

We all know that backups are important. But are we building a backup strategy that can recover in a manner that meets business needs? All too often, we plan a backup strategy without a recovery strategy.

In this session, veteran DBA Mike Hillwig will start with understanding the recovery strategy and work toward implementing the right backups to meet that recovery strategy. He'll also set the record straight around some very common myths around database recovery and backups.

SessionID: 63805

Finding more space for your tight environment.

Back to calendar

Event Date: 30-09-2017 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Chan

Title: Finding more space for your tight environment.

Abstract:

If you do not have enough space in your hard disk and do not want buy more space, one way to get more space is compress the tables and also do some house keeping.

I will use T-SQL script to generate script to compress each tables and release the free space by shrinking the datafiles. And in the final I will defragment the indexes and update the statistics, since shrink datafile is not fragmentation aware task.

SessionID: 65465

How to get Microsoft Certified

Back to calendar

Event Date: 30-09-2017 - Session time: 11:15:00 - Track: Professional Development

Speaker: John Deardurff

Title: How to get Microsoft Certified

Abstract:

Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.

SessionID: 65713

Using Filetables

Back to calendar

Event Date: 30-09-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Sam Nasr

Title: Using Filetables

Abstract:

The FileStream feature allows BLOBs to be managed by the DB. FileTable expands on this feature by using specific tables for storing these BLOBs. This allows Windows apps to access these items as if there were stored on the file system but with benefits only a database can offer, such as text searching and querying.

SessionID: 68599

Tools for the DBA Newbie: What I Wish I Had Known Years Ago

Back to calendar

Event Date: 30-09-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Ryan Booz

Title: Tools for the DBA Newbie: What I Wish I Had Known Years Ago

Abstract:

Are you an DBA newbie looking for tools to improve your product and client experience?

In this session, you’ll be equipped with tools to improve query tuning, indexing tuning, and naming standards. You’ll understand helpful built-in technologies that often go unused, server setup practices, and performance logging. And you’ll hear about the best blogs to follow and where to get help from the community.

I’ve learned all of this gradually, but I’m happy to give you a head start. I’ll share insights that I’ve gained transforming our 18-year old, single-tenant database into a thriving multi-tenant SaaS environment. This talk is intentionally broad, demonstrating how we retooled our database and the wealth of information we discovered along the way. If you are just starting your SQL Server performance journey, this talk will give you at least one thing to dig into on Monday morning.

SessionID: 68604

Cross Tabs Pivots - Much More Than Just Converting Rows to Columns

Back to calendar

Event Date: 30-09-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: Jeff Moden

Title: Cross Tabs Pivots - Much More Than Just Converting Rows to Columns

Abstract:

This session covers and compares the PIVOT operator to an ancient but very high performance pivoting method known as CROSS TABs. Single and double column pivots will be covered and the “secret” to quickly making CROSS TABs is “Copy’n’Paste” easy. We’ll also introduce a couple of “Black Arts” techniques called “Pre-Aggregation” and “Divide’n’Conquer” to build a quarterly report for 1 year from 10 years and 10 MILLION rows of data in just half a second.

If time allows, we’ll also discover that you can very quickly format reports as pretty as you’ll see in SSRS without using SSRS.

Don't let the "Intermediate" rating of this session scare you beginners away because we start at the ground floor and work our way up to some very high performance code. Even if you already know how to use PIVOT or CROSS TABs, you won’t want to miss this one.

SessionID: 69340

Stop Doing That! Common T-SQL Anti-Patterns

Back to calendar

Event Date: 30-09-2017 - Session time: 11:15:00 - Track: Application Database Development

Speaker: William Wolf

Title: Stop Doing That! Common T-SQL Anti-Patterns

Abstract:

There are several programming design patterns that work great in object oriented code but do not scale inside SQL Server. Things like Scalar-Value functions, Unions, CTEs, and row by row processing can make for more work then you would expect.

In this session, we will focus on several anti-patterns like these and show how to rework them to improve scale in the database engine.

By the end of the session, you will be able to quickly identify these common anti-patterns and analyze their sometimes unclear cost to the engine. Heading back to the office, you’ll be able to identify pain points in your longest running queries from a T-SQL perspective and become a code tuning rockstar!

SessionID: 69808

Lunch break

Back to calendar

Event Date: 30-09-2017 - Session time: 12:15:00 - Track: Advanced Analysis Techniques

Speaker: Matt Nelson

Title: Lunch break

Abstract:

lunch break

SessionID: 69747

New Horizons lunchtime chat

Back to calendar

Event Date: 30-09-2017 - Session time: 12:55:00 - Track: Other

Speaker: Matt Nelson

Title: New Horizons lunchtime chat

Abstract:

After lunch, come learn more about New Horizons training programs and services.

No food is allowed in the classroom, please eat in the gallery or cafe first.

SessionID: 69748

Plus Consulting lunchtime chat

Back to calendar

Event Date: 30-09-2017 - Session time: 12:55:00 - Track: Other

Speaker: Matt Nelson

Title: Plus Consulting lunchtime chat

Abstract:

After lunch, come learn more about Plus Consulting's services.

No food is allowed in the classroom, please eat in the gallery or cafe first.

SessionID: 61684

SQL Server on Linux for SQL DBA.

Back to calendar

Event Date: 30-09-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Slava Murygin

Title: SQL Server on Linux for SQL DBA.

Abstract:

For the last 25 years SQL Server DBAs administered SQL databases using only Windows GUI.

For majority of them even Windows Core is too hard to accept. In the situation, when Microsoft invaded Linux territory with it's flagship product, as SQL DBA, you must not outsource SQL Server administration to some Linux geeks. You can do it yourself! Your way! And I show you how to do it.

SessionID: 62862

Access, Users, Permissions for Beginners!

Back to calendar

Event Date: 30-09-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dummea Vincent

Title: Access, Users, Permissions for Beginners!

Abstract:

Who, What, and Why are important when allowing access to anything in SQL server. Who needs the access, why they need it, and what they will be doing with it, are key factors to think about when assigning permissions. Join me in learning about the different levels of permissions allowed in SQL server, from the server level to the database level and more. You will leave with a better idea and plan of how to say “NO” to that one developer that NEEDS sysadmin access.

SessionID: 64014

Crash Course on Better SQL Development

Back to calendar

Event Date: 30-09-2017 - Session time: 13:30: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: 66484

SQL Server Data Tools (SSDT) Basics

Back to calendar

Event Date: 30-09-2017 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Steve Grier

Title: SQL Server Data Tools (SSDT) Basics

Abstract:

In this session, we will dive into SQL Server Data Tools (SSDT) features. SSDT can be used to manage database development. This session covers creating a database project, extracting a database project from an existing database, interacting with a database project to change object definitions, and deploying a database project to a SQL Server environment.

SessionID: 66749

Machine Learning Melee: AWS vs Azure

Back to calendar

Event Date: 30-09-2017 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Frank La Vigne

Title: Machine Learning Melee: AWS vs Azure

Abstract:

The world is drowning in data and there’s a gold rush in the business of turning data into actionable insight. In one corner, stands AWS, a long time cloud services innovator, that wants to leverage its PaaS dominance to take it into the next decade. In the other corner, stands a scrappy re-invigorated Microsoft with a new focus on making the cloud smarter.

Both are feverishly working on creating compelling solutions for developers to build intelligent solutions upon. Is one better than the other? What are each one’s strengths and weaknesses?

And what does Google have up its sleeve?

Come to this session to get a first hand account of a former Microsoft evangelist now working at an AWS partner startup, who promises to keep it a good clean fight!

SessionID: 67890

Maintain SQL Server Performance Baseline w/PowerShell

Back to calendar

Event Date: 30-09-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

Title: Maintain SQL Server Performance Baseline w/PowerShell

Abstract:

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 69323

Geo Location of Twitter messages in Power BI

Back to calendar

Event Date: 30-09-2017 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Rayis Imayev

Title: Geo Location of Twitter messages in Power BI

Abstract:

There are several custom solutions that make Twitter messages analysis possible in Power BI. And with a recent addition of the Campaign/Brand Management for Twitter solution template for Power BI (https://powerbi.microsoft.com/en-us/solution-templates/brand-management-twitter/) it's getting even less complicated to get into this social media mainstream data exploration.

This solution has several components:

However, Geo location for twitter messages is not available (if we want to filter them by a particular country). Let's try to explore with live demos if we can customize this Azure solution and add a Country filter to our Power BI reports based on live tweet data.

SessionID: 63791

Tackling Technical Blogging

Back to calendar

Event Date: 30-09-2017 - Session time: 14:40:00 - Track: Professional Development

Speaker: Mike Hays

Title: Tackling Technical Blogging

Abstract:

Ever thought of writing a technical blog? This session will cover the Ws (who, what, when, where, why, how) of getting a technical blog started. Answer the question of how it can be done for free. Discuss why pay for your own domain name. Explain how to be on the first page of a search engine. Learn how to determine the time commitment. And finally determine topics to write about.

SessionID: 64862

SSAS 2016 Tabular - Diving into the new features

Back to calendar

Event Date: 30-09-2017 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brian Beswick

Title: SSAS 2016 Tabular - Diving into the new features

Abstract:

Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.

SessionID: 65040

DBAs vs Developers: JSON in SQL Server 2016

Back to calendar

Event Date: 30-09-2017 - Session time: 14:40:00 - Track: Application Database Development

Speaker: Bert Wagner

Title: DBAs vs Developers: JSON in SQL Server 2016

Abstract:

The war between DBAs and developers has been raging since the dawn of relational databases. One reason for disagreement comes from developers who want to store their data in JSON because it is fast, standard, and flexible. DBAs cringe when they hear of long text strings being stored in their SQL databases; they cry with concern, “No data validation? No schema binding?”. Is there any hope for these two warring factions to see eye-to-eye?

This session will explore the new JSON functionality introduced in SQL Server 2016. We will use T-SQL examples to learn how these functions can be used to parse, create, and modify JSON data. More importantly, we will discuss how to optimize performance when using these functions.

By the end of this session DBAs and developers will know how to efficiently work with JSON in SQL Server 2016. It will also usher in an era of peace between DBAs and developers…

… at least until someone brings up the topics of cursors, NOLOCKs, or Entity Framework.

SessionID: 65218

An introduction to the magical world of BIML!

Back to calendar

Event Date: 30-09-2017 - Session time: 14:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jonathan Stewart

Title: An introduction to the magical world of BIML!

Abstract:

Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

SessionID: 66993

Getting Noticed: Strategies for Your Resume and LinkedIn

Back to calendar

Event Date: 30-09-2017 - Session time: 14:40:00 - Track: Professional Development

Speaker: Rick Heiges

Title: Getting Noticed: Strategies for Your Resume and LinkedIn

Abstract:

You know you are well qualified for the jobs that you search for on any major job site. You know that if you just get to that next step that they will see it for themselves. This lightning talk focuses on strategies for your resume and LinkedIn profile to help get you noticed and reach that next step. Interaction with the audience is encouraged throughout the discussion.

SessionID: 68401

The DBA Survival Guide for In-Memory OLTP

Back to calendar

Event Date: 30-09-2017 - Session time: 14:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Ned Otter

Title: The DBA Survival Guide for In-Memory OLTP

Abstract:

You know it's coming . . . one day soon, you'll be asked to take ownership of a database that uses In-Memory OLTP. Then what?

Deploying In-Memory OLTP affects the database ecosystem, including monitoring, data migration, logging, capacity planning, backup, restore, recovery, and more.

DBAs need to know optimal methods of migrating large data sets from disk to In-Memory, the differences between restore and recovery for memory-optimized databases, and many other facets of the In-Memory world.

Attendees will gain a clear understanding of the knowledge and skills required to administer In-Memory OLTP environments.

SessionID: 69440

SSMS Tips and Tricks

Back to calendar

Event Date: 30-09-2017 - Session time: 14:40:00 - Track: Application Database Development

Speaker: Eric Blinn

Title: SSMS Tips and Tricks

Abstract:

Most of us do not have a lot of spare time at work. In this session we will share favorite shortcuts, tips, and tricks for using SQL Server and Management Studio. Learn how to manage your server and write code quickly to help you save a few minutes every day.

SessionID: 61679

SQL Server and PowerShell: Let's Get Serious

Back to calendar

Event Date: 30-09-2017 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Drew Furgiuele

Title: SQL Server and PowerShell: Let's Get Serious

Abstract:

Whether you've dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you're a DBA, a SSIS developer, or security professional, In this session you'll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.

SessionID: 61681

New Instance, Now what?

Back to calendar

Event Date: 30-09-2017 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Donahoe

Title: New Instance, Now what?

Abstract:

Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.

In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.

By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.

SessionID: 62813

# vs @ - it's not about Social Media it's about temporary tables and data

Back to calendar

Event Date: 30-09-2017 - Session time: 15:50:00 - Track: Application Database Development

Speaker: Thomas Grohser

Title: # vs @ - it's not about Social Media it's about temporary tables and data

Abstract:

In this session Thomas will explore and explain the different options that exist in SQL Server to temporary store data and show you when to use which and why not the others. This will cover #, ##, @, Non-Durable Memory Optimized and regular user tables. He will also present alternatives like common table expressions.

SessionID: 62851

DBA 102: Now What

Back to calendar

Event Date: 30-09-2017 - Session time: 15:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: DBA 102: Now What

Abstract:

Things happened, you got a knock on the head and when you awoke your boss said “congratulations” you are our new DBA, perhaps you came to the role in a more intentional manner or are just DBA curious. Your environment is running but you are wondering “now what” or “what’s next”. In this session we will give an overview of a few things that could, perhaps even should be next and give some recommendations as to where you can find more resources on-line and maybe even suggest a few sessions to attend at this very SQL Saturday. So, what will be covered, recovery strategy (you think I mean backups, I don’t, you’ll see why), a touch on performance tuning with a hint of indexing thrown in, add a pinch of high availability and a smattering of security all of which will give you some idea how to answer “now what”.

SessionID: 64571

Cassandra for SQL Server Professionals

Back to calendar

Event Date: 30-09-2017 - Session time: 15:50:00 - Track: Strategy and Architecture

Speaker: Dan Mallott

Title: Cassandra for SQL Server Professionals

Abstract:

Recently, there's been a big shift towards Big Data and event-driven architectures with eventual consistency. Tech leaders in your organizations may even be using words like Hadoop or Spark or ElasticSearch as answers to these Big Data problems. In this session, we'll look at Cassandra, what it is, how it works, and how it compares to SQL Server. We'll walk through use cases and highlight some places where SQL Server is still a better choice.

SessionID: 65253

Managing Up: The Art of Managing your Manager

Back to calendar

Event Date: 30-09-2017 - Session time: 15:50:00 - Track: Professional Development

Speaker: Mike Hillwig

Title: Managing Up: The Art of Managing your Manager

Abstract:

Everyone has a boss. Part of your success depends on keeping your manager successful.

In this session, veteran IT professional Mike Hillwig will teach you how to manage your manager. You'll learn to understand what her/his motivations are, how to understand what's being measured, and how success is defined. Taking that to the next level, you'll start to play to your manager's strengths and understand the value of making your manager look good.

SessionID: 66992

SQL Games

Back to calendar

Event Date: 30-09-2017 - Session time: 15:50:00 - Track: Professional Development

Speaker: Rick Heiges

Title: SQL Games

Abstract:

SessionID: 69793

How to talk to your Storage Admin

Back to calendar

Event Date: 30-09-2017 - Session time: 15:50:00 - Track: Strategy and Architecture

Speaker: Marsha Pierce

Title: How to talk to your Storage Admin

Abstract:

A general discussion for DBAs about what they need to consider when using storage. I cover how to monitor performance, how storage can affect SQL server, what DBAs can do to mitigate storage issues, and also misconceptions DBAs have about SANs.