sqlsathistory

Nr: 527

Back to Main list

SQLSaturday #527 - Columbus 2016

Start Time (24h)	Speaker	Track	Title
08:30:00	Dave Mattingly	Advanced Analysis Techniques	Word Up: Text Mining in SQL
08:30:00	Wendy Pastrick	Enterprise Database Administration, Architecture Deployment	Navigating the Options for Data Redundancy
08:30:00	Cassandra Faris	Professional Development	It's OK to Talk to Strangers
08:30:00	Colleen Morrow	Enterprise Database Administration, Architecture Deployment	Inside the Black Box - Making Sense of Service Broker
08:30:00	Allen White	BI Platform Architecture, Development Administration	Get Near Realtime ETL with Service Broker
09:45:00	Evelyn Maxwell	Professional Development	Improving Your PowerPoint Skills
09:45:00	Sean McCown	Enterprise Database Administration, Architecture Deployment	Monster Text Manipulation: Regular Expressions for the DBA
09:45:00	Jonathan Stewart	BI Platform Architecture, Development Administration	An introduction to the magical world of BIML!
09:45:00	Anthony van Gemert	Application Database Development	MICROSOFT: SQL Server 2016 Stretch Database
09:45:00	Aaron Nelson	Application Database Development	Achieve More in Less Time by Using SQLPS
11:00:00	John Deardurff	Application Database Development	The PROCESS of Queries
11:00:00	David Klee	Professional Development	The Many Paths of Consulting
11:00:00	Carlos L Chacon	Enterprise Database Administration, Architecture Deployment	Disaster Recovery Options with Azure
11:00:00	Tamera Clark	BI Information Delivery	Microsoft Business Intelligence 2016 – More Love for Your Data
11:00:00	Argenis Fernandez	Enterprise Database Administration, Architecture Deployment	Hacking SQL Server for Fun and Profit
13:15:00	Adam Belebczuk	Application Database Development	XML Without Xanax: How to Handle XML in SQL Server
13:15:00	Eugene Meidinger	BI Information Delivery	Why PowerBI? Introducing Microsoft’s new BI tool
13:15:00	Michael Fal	Cloud Application Development Deployment	Intro to Azure SQL Databases
13:15:00	Frank Gill	Enterprise Database Administration, Architecture Deployment	Using Powershell to Automate Your Restore Strategy
13:15:00	Pat Phelan	Application Database Development	Data Architecture 101
14:30:00	Aaron Cutshall	Application Database Development	The Lost Science of Set Theory
14:30:00	Jennifer McCown	Application Database Development	Designing Stored Procedure Solutions
14:30:00	Stacia Varga	BI Information Delivery	(Way Too Much) Fun with Reporting Services
14:30:00	Kerry Tyler	BI Information Delivery	Connecting Power BI to On-Prem Data with SSAS
14:30:00	Rie Irish	Professional Development	WIT: Identifying, Understanding and Combating Gender Bias
15:45:00	Kevin Feasel	Analytics and Visualization	R For the SQL Server Developer
15:45:00	Paul Popovich Jr	Enterprise Database Administration, Architecture Deployment	Clusters! From the ground up, let's build one together
15:45:00	Ravi Kumar	BI Platform Architecture, Development Administration	What Makes SSIS Tick? A Look at Internals for Performance
15:45:00	Stacia Varga	BI Platform Architecture, Development Administration	Reduce, Reuse, Recycle: Automating Your BI Framework
15:45:00	Eddie Wuerch	Professional Development	Join Us! Getting Started as a Technical Speaker
15:45:00	Azhagappan Arunachalam	Cloud Application Development Deployment	Getting to know U-SQL

SessionID: 46171

Word Up: Text Mining in SQL

Back to calendar

Event Date: 16-07-2016 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Dave Mattingly

Title: Word Up: Text Mining in SQL

Abstract:

Would a database by any other name smell as sweet?

Our databases are filled with words. By mining our text for patterns and meanings, we can extract the emotional content, track changes over time, ferret out plagiarism, find common phrases and usage, and even predict future text.

Learn how to dig through your library of language to make your data better.

SessionID: 46484

Navigating the Options for Data Redundancy

Back to calendar

Event Date: 16-07-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration, Architecture Deployment

Speaker: Wendy Pastrick

Title: Navigating the Options for Data Redundancy

Abstract:

SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.

SessionID: 48150

It's OK to Talk to Strangers

Back to calendar

Event Date: 16-07-2016 - Session time: 08:30:00 - Track: Professional Development

Speaker: Cassandra Faris

Title: It's OK to Talk to Strangers

Abstract:

Tired of job boards and recruiter spam? There’s a better way to manage your career growth. Networking is something that doesn’t come naturally to many people, but it’s a tool that every tech professional should have in their tool belt. In this talk, you’ll learn tips for growing your professional network online and offline. You’ll also learn strategies for intentionally fostering relationships. A good network means fewer strangers, more free lunches, and a better path to finding your next opportunity.

SessionID: 50097

Inside the Black Box - Making Sense of Service Broker

Back to calendar

Event Date: 16-07-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration, Architecture Deployment

Speaker: Colleen Morrow

Title: Inside the Black Box - Making Sense of Service Broker

Abstract:

SQL Server Service Broker is often seen as a black box. Messages go in, and hopefully they come out on the other side. But when they don't, DBAs typically don’t know where to look. Trying to figure out what’s wrong quickly turns into a guessing game.

It’s not that complicated once you understand how it all works. Service Broker is an asynchronous messaging technology built into SQL Server that allows you to scale out your application, replicate data or perform ETL, all while guaranteeing messages are delivered and processed in the right order. In this session, we'll discuss the basics of the Service Broker architecture, its components, and deployment options. We will discuss troubleshooting tips and performance best practices to help you deploy a Service Broker solution in your own environment.

SessionID: 50702

Get Near Realtime ETL with Service Broker

Back to calendar

Event Date: 16-07-2016 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Allen White

Title: Get Near Realtime ETL with Service Broker

Abstract:

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this simple and painless. This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.

SessionID: 47015

Improving Your PowerPoint Skills

Back to calendar

Event Date: 16-07-2016 - Session time: 09:45:00 - Track: Professional Development

Speaker: Evelyn Maxwell

Title: Improving Your PowerPoint Skills

Abstract:

PowerPoint can enhance the presentation of any speaker or business professional, but using it effectively in your sessions or presentations can be difficult without practice. In this session, you will learn how to take your PowerPoint skills to the next level, using more advanced transitions, animations, and media forms in your presentations. This will help you engage your audience and communicate visually instead of just verbally, making your presentations more effective. After attending this session, you can feel confident that your PowerPoint skills have improved.

SessionID: 49406

Monster Text Manipulation: Regular Expressions for the DBA

Back to calendar

Event Date: 16-07-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration, Architecture 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 cut that work from hours or days to minutes or even seconds. Stop writing code manually and let regular expressions do it for you. 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: 50112

An introduction to the magical world of BIML!

Back to calendar

Event Date: 16-07-2016 - Session time: 09:45: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: 50313

MICROSOFT: SQL Server 2016 Stretch Database

Back to calendar

Event Date: 16-07-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Anthony van Gemert

Title: MICROSOFT: SQL Server 2016 Stretch Database

Abstract:

Your cold data growth is getting out of control, storage consumption is increasing faster than your budget, your end-users won't (or can't) tell you what can delete or truncate, but they demand their cold or archived data always be online and available. Now you have tables so big that you dread re-indexing, and you have to look for ever more creative solutions to manage this data, while still remaining compliant.

#160; There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries. #160; Come find out how you can move your data securely and transparently, free up disc space and reduce your enterprise storage consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Server Stretch database will simplify your journey to the Cloud!

SessionID: 50515

Achieve More in Less Time by Using SQLPS

Back to calendar

Event Date: 16-07-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Aaron Nelson

Title: Achieve More in Less Time by Using SQLPS

Abstract:

Let’s face it, using SQLPS prior to SQL Server 2016 was like installing training wheels on a Ducati. Then, some community feedback was incorporated before SQL 2016 shipped and presto, SQLPS is actually useful all of a sudden.

There is a faster way to manage and even SQL Servers using PowerShell. I will show you what the new features in SQLPS and why you will probably find it useful, even if you aren't a "DBA".

SessionID: 47228

The PROCESS of Queries

Back to calendar

Event Date: 16-07-2016 - Session time: 11:00:00 - Track: Application Database Development

Speaker: John Deardurff

Title: The PROCESS of Queries

Abstract:

This session is an introduction into the PROCESS of queries. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss the differences between Heaps, Clustered Indexes, and Non-Clustered Indexes. Finally we introduce Execution Plans and Statistics. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.

SessionID: 48854

The Many Paths of Consulting

Back to calendar

Event Date: 16-07-2016 - Session time: 11:00:00 - Track: Professional Development

Speaker: David Klee

Title: The Many Paths of Consulting

Abstract:

People often dream of becoming a consultant, but what does that actually mean? Is consulting really the right path for you? Many choices are available when deciding to become a consultant, but these options can be overlooked. Contracting, consulting for an established team, going out on your own, or looking to build a larger business are all great options, depending on your vision and future goals.

This session will help you ask the right questions to better chose and prepare for your path. We then explore the various realities and strategies of each path. Real-life experiences will be shared to help you make the most informed decision on which path is best for you, and how to accelerate your career as a consultant.

SessionID: 50502

Disaster Recovery Options with Azure

Back to calendar

Event Date: 16-07-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration, Architecture Deployment

Speaker: Carlos L Chacon

Title: Disaster Recovery Options with Azure

Abstract:

Recovery in the cloud is now easier and more convenient than ever. This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure.

SessionID: 50527

Microsoft Business Intelligence 2016 – More Love for Your Data

Back to calendar

Event Date: 16-07-2016 - Session time: 11:00:00 - Track: BI Information Delivery

Speaker: Tamera Clark

Title: Microsoft Business Intelligence 2016 – More Love for Your Data

Abstract:

Heartbroken over Microsoft’s neglect of SSRS over the years? Well the 2016 release might start healing that broken heart. This upcoming release boast a handful of great new items; from connecting SSRS PowerBI to mobile report publishing. Join me while I walk you through the best of 2016 for Business Intelligence and help you fall in love with Microsoft BI again.

SessionID: 50680

Hacking SQL Server for Fun and Profit

Back to calendar

Event Date: 16-07-2016 - Session time: 11:00:00 - Track: Enterprise Database Administration, Architecture Deployment

Speaker: Argenis Fernandez

Title: Hacking SQL Server for Fun and Profit

Abstract:

In this session we’ll explore several methods of hacking into SQL Server instances. Some methods assume you have Windows Administrator privileges on the box; others only require access to your physical network. We will cover SQL injection, memory dumps, man-in-the-middle, pass-the-hash, and other attack vectors. Armed with this knowledge, you should be able to go back to your job and make a difference in your network security.

SessionID: 46101

XML Without Xanax: How to Handle XML in SQL Server

Back to calendar

Event Date: 16-07-2016 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Adam Belebczuk

Title: XML Without Xanax: How to Handle XML in SQL Server

Abstract:

Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!

We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.

If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.

SessionID: 46310

Why PowerBI? Introducing Microsoft’s new BI tool

Back to calendar

Event Date: 16-07-2016 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Eugene Meidinger

Title: Why PowerBI? Introducing Microsoft’s new BI tool

Abstract:

The Power BI Suite has been around for less than a year and is changing every week. However, the technology behind it has been around for years now. It can be confusing trying to understand PowerThis and PowerThat. In this session, we will cover the different parts of PowerBI and what makes it new and exciting. We will look at how PowerBI fits into the existing Microsoft BI ecosystem. Finally, we will go over the process of creating and publishing a dashboard.

SessionID: 50277

Intro to Azure SQL Databases

Back to calendar

Event Date: 16-07-2016 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Michael Fal

Title: Intro to Azure SQL Databases

Abstract:

Azure SQL Databases are still something that is new and not completely understood by many data professionals. There is a definite shift from installing SQL Server on a machine to creating and using a Microsoft's Platform-as-a-Service database. This session will cover the basics of what an Azure SQL Database is, how we create one, and what it takes to access and use this database. After attending this session, you will have a solid understanding of what Azure SQL Database is, how to configure it, and how to use in your own environment.

SessionID: 50436

Using Powershell to Automate Your Restore Strategy

Back to calendar

Event Date: 16-07-2016 - Session time: 13:15:00 - Track: Enterprise Database Administration, Architecture Deployment

Speaker: Frank Gill

Title: Using Powershell to Automate Your Restore Strategy

Abstract:

As DBAs, our most important job is protecting the data. Making sure our backups are running successfully gets us halfway there, but those backups are useless if we can’t restore them. Join me for this session to learn how to use Powershell to automate a restore process for backup validation.

SessionID: 52263

Data Architecture 101

Back to calendar

Event Date: 16-07-2016 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Data Architecture 101

Abstract:

This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.

SessionID: 46356

The Lost Science of Set Theory

Back to calendar

Event Date: 16-07-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: The Lost Science of Set Theory

Abstract:

Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.

SessionID: 49405

Designing Stored Procedure Solutions

Back to calendar

Event Date: 16-07-2016 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.

SessionID: 50483

(Way Too Much) Fun with Reporting Services

Back to calendar

Event Date: 16-07-2016 - Session time: 14:30:00 - Track: BI Information Delivery

Speaker: Stacia Varga

Title: (Way Too Much) Fun with Reporting Services

Abstract:

Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia and Dean Varga introduce you to some word play, all wrapped up in SQL Server Reporting Services. They'll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more?

SessionID: 50530

Connecting Power BI to On-Prem Data with SSAS

Back to calendar

Event Date: 16-07-2016 - Session time: 14:30:00 - Track: BI Information Delivery

Speaker: Kerry Tyler

Title: Connecting Power BI to On-Prem Data with SSAS

Abstract:

Microsoft Power BI is going great places. Its great visualizations, easy-to-use tools, and robust sharing capabilities are improving with new releases almost every time you turn around. But, what if uploading or storing your company's data in the cloud is a potential deal-breaker? Fortunately, the Microsoft Power BI Gateway - Enterprise make it possible to live query data in an on-premises SSAS instance for display in Power BI. In this session, we will go through what this gateway does, how it works, and how it is installed to show that BI in the cloud doesn't require data in the cloud.

SessionID: 51179

WIT: Identifying, Understanding and Combating Gender Bias

Back to calendar

Event Date: 16-07-2016 - Session time: 14:30:00 - Track: Professional Development

Speaker: Rie Irish

Title: WIT: Identifying, Understanding and Combating Gender Bias

Abstract:

Gender Bias is something we're all guilty of. It's typically unconscious and often stems from long held misperceptions about women and job responsibilities. We'll learn about the origins of some of these biases and how to identify gender bias when we see it. We'll discuss some strategies for how both men and women can combat this at work and in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.

SessionID: 46078

R For the SQL Server Developer

Back to calendar

Event Date: 16-07-2016 - Session time: 15:45:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: R For the SQL Server Developer

Abstract:

R is the premiere language for data analysis. If the world of data science sounds fun and exciting, now is the time to get into R. We will walk through the core constructs of R, learn how to retrieve data from flat files and databases, and get a peek at the power behind R. This session will also give resources on where to go in order to become more familiar with statistics, R the language, and the R package ecosystem.

SessionID: 46266

Clusters! From the ground up, let's build one together

Back to calendar

Event Date: 16-07-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration, Architecture Deployment

Speaker: Paul Popovich Jr

Title: Clusters! From the ground up, let's build one together

Abstract:

You're looking to protect your SQL instance from a machine failure. Or maybe your storage budget and tight and you don't want to have your databases in two places with one of the other highly available options that SQL provides. Let's learn what a cluster is and why it might be the right thing for you. We'll explore the system, network, storage and database administration sides of the equation. And, when it's all said and done we'll even have built a SQL clustered instance!

SessionID: 47002

What Makes SSIS Tick? A Look at Internals for Performance

Back to calendar

Event Date: 16-07-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ravi Kumar

Title: What Makes SSIS Tick? A Look at Internals for Performance

Abstract:

You can build basic SSIS packages, or you can build packages that perform. In this session, you'll learn about the internals of Integration Services. Using this knowledge, we'll review the DOs and DON'Ts that lead to improved ETL performance. (This session applies to SSIS versions from 2008, 2012, 2014 and 2016.)

SessionID: 50482

Reduce, Reuse, Recycle: Automating Your BI Framework

Back to calendar

Event Date: 16-07-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Stacia Varga

Title: Reduce, Reuse, Recycle: Automating Your BI Framework

Abstract:

Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, and SSIS packages that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.

SessionID: 50545

Join Us! Getting Started as a Technical Speaker

Back to calendar

Event Date: 16-07-2016 - Session time: 15:45:00 - Track: Professional Development

Speaker: Eddie Wuerch

Title: Join Us! Getting Started as a Technical Speaker

Abstract:

Have you ever thought about speaking at a user group, SQL Saturday, or even the PASS Summit, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and submit it to a conference, * Design and build the presentation, and * Prepare and deliver your first session.

SessionID: 50546

Getting to know U-SQL

Back to calendar

Event Date: 16-07-2016 - Session time: 15:45:00 - Track: Cloud Application Development Deployment

Speaker: Azhagappan Arunachalam

Title: Getting to know U-SQL

Abstract:

With so many languages around to extract, transform, analyze, and visualize data, Microsoft introduced yet another language : U-SQL. In this session, we'll take a look at what U-SQL is, what it brings to the table, and how it differs from (or overlaps with) the existing constructs (T-SQL, SQL CLR, DAX/MDX, PowerQuery/M, R etc.,). We'll go over step-by-step in getting started with U-SQL, and review some use case scenarios.

This site is open source. Improve this page.