sqlsathistory

Nr: 350

Back to Main list

SQLSaturday #350 - Winnipeg 2014

Start Time (24h) Speaker Track Title
00:00:00 Bill Preachuk New Technology Track Bring your SQL Server Skills to the Hive
00:00:00 Bill Preachuk New Technology Track Hadoop for the SQL Server Developer/DBA
00:00:00 Christian Cote BI Track Modernize your data warehouse
00:00:00 Felipe Ferreira BI Track Power BI QA: Take your data analysis to the next level
00:00:00 Janis Griffin DBA Track Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues
00:00:00 Janis Griffin Developer Track Looney Tuner? No, there IS a method to my madness
00:00:00 Jeff Prom New Technology Track SQL Inejctions and How To Stop Them
00:00:00 Kirby Richter DBA Track Implement a Dynamic Table Partitioning Solution
00:00:00 Mark Vaillancourt BI Track MDX Trek: First Contact
00:00:00 Mark Vaillancourt BI Track Analysis Services Terms and Concepts for the DBA
00:00:00 Mike Diehl Developer Track Coupling and Cohesion Patterns and Anti-Patterns in SQL and ETL development
00:00:00 Phillip Labry BI Track Getting Started with Analysis Services Tabular mode
00:00:00 MIKE DONNELLY Developer Track Twice in a Lifetime: T-SQL Refactoring 101
00:00:00 Terry Bunio DBA Track Breaking Data - How to Load and Stress test your database using SQL Profiler and OStress
00:00:00 Ben Thul DBA Track Practical Powershell for the Harried DBA
00:00:00 Tim Plas DBA Track Protecting SQL Data for Availability and DR
00:00:00 Tim Costello Developer Track 10 things I wish I knew about loading data
00:00:00 Tim Costello New Technology Track Windowing Functions
00:00:00 Aaron Bertrand Developer Track T-SQL : Bad Habits Best Practices

SessionID: 10614

Bring your SQL Server Skills to the Hive

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: New Technology Track

Speaker: Bill Preachuk

Title: Bring your SQL Server Skills to the Hive

Abstract:

Hive is the gateway for SQL Server professionals to enter the world of Hadoop. In this session you will learn why how you should augment your relational systems with HDP/HDinsight and Hive. We will discuss the differences between SQL Server and Hadoop/Hive at the Hardware, Software, and Query levels. We’ll go into the syntax differences between T-SQL and HiveQL (surprise, there aren’t that many). Finally we will discuss common Use Cases where Hive shines. Expect plenty of useful tips and side-by-side comparisons.

SessionID: 10615

Hadoop for the SQL Server Developer/DBA

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: New Technology Track

Speaker: Bill Preachuk

Title: Hadoop for the SQL Server Developer/DBA

Abstract:

How does The Hortonworks Data Platform (HDP and HDInsight) fit into our neat tidy database world? In this beginner-friendly technical session you'll learn about Big Data from the ground up with a focus on what SQL Server professionals need to know. Find out technical details about what HDFS, MapReduce and YARN actually are how they work. Discover the Hadoop ecosystem and the projects within. Learn how Hadoop complements the traditional relational database world. See demos of real-world data tasks/use cases that Hadoop can accomplish.

SessionID: 11577

Modernize your data warehouse

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Christian Cote

Title: Modernize your data warehouse

Abstract:

SessionID: 14234

Power BI QA: Take your data analysis to the next level

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Felipe Ferreira

Title: Power BI QA: Take your data analysis to the next level

Abstract:

Are you bored on spending your days creating reports for the business users? Do you dream on the day the user will simple use a search box and ask what they want and the magic will happen and the report will show up on their screen? Wait no more, this day is today!

Let's see on this session how to use this powerful new tool to transform our BI solution in a true self-service BI

SessionID: 15729

Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: DBA Track

Speaker: Janis Griffin

Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Abstract:

Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.

SessionID: 15730

Looney Tuner? No, there IS a method to my madness

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: Developer Track

Speaker: Janis Griffin

Title: Looney Tuner? No, there IS a method to my madness

Abstract:

SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.

SessionID: 16376

SQL Inejctions and How To Stop Them

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: New Technology Track

Speaker: Jeff Prom

Title: SQL Inejctions and How To Stop Them

Abstract:

SQL injections are a technique where malicious users can inject SQL commands into a SQL statement, through web page input. If left unprotected, SQL injections can cause havoc with web applications by compromising security, manipulating data, hoarding system resources, retrieving sensitive data, removing databases and database objects, or taking databases offline! This session will show how SQL injections work, identify if you are being attacked, and cover various prevention techniques and their effectiveness.

SessionID: 18391

Implement a Dynamic Table Partitioning Solution

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: DBA Track

Speaker: Kirby Richter

Title: Implement a Dynamic Table Partitioning Solution

Abstract:

Have a large or potentially large database that you would like to partition? Manually implementing partitioning and the corresponding maintenance can be a lot of work, especially if you have many tables. In this presentation we look at how you would implement a partitioning solution dynamically for all tables with the designated partition column. We set it up to keep a FIXED number of file groups. The partition maintenance will recycle the file groups over time as partitions are dropped and created. We do as much as possible through dynamic scripting. This solution can easily be used for archiving but in this example we are simply keeping the most current 6 months of data and dropping the rest. Assumes you have a basic understanding of SQL Server table partitioning.

SessionID: 19656

MDX Trek: First Contact

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Mark Vaillancourt

Title: MDX Trek: First Contact

Abstract:

Cube space; the final frontier. In this Star Trek themed introduction to MDX, we will discuss the fundamentals of cube structure and vocabulary, including tuples, members, sets, hierarchies, and more. We will introduce and demonstrate the basic syntax of MDX with queries that include navigating hierarchies and even some time-based expressions. This session will give you the tools you need to write simple, yet meaningful, MDX queries in your own environment.

SessionID: 19658

Analysis Services Terms and Concepts for the DBA

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Mark Vaillancourt

Title: Analysis Services Terms and Concepts for the DBA

Abstract:

Despite some overlapping concepts, the worlds of the Relational engine and Analysis Services really are quite different. With more and more organizations realizing the power of Analytics, there is a good chance a BI initiative will come your way at some point.

This session is intended for the DBA that wants/needs to learn more about SQL Server Analysis Services. The goal is to provide a meaningful base of knowledge that will allow you to effectively participate in discussions of Analysis Services in your organization.

Through both slides and demos, you will learn: -- The differences between SSAS Multidimensional and SSAS Tabular -- Key terms like Measures, Dimensions, Hierarchies -- Storage options such as MOLAP, HOLAP, ROLAP, and Direct Query -- Monitoring with Extended Events -- Overviews of MDX, DAX, and XMLA -- and more

Come take a few steps into the exciting world of Business Intelligence with SQL Server Analysis Services.

SessionID: 20678

Coupling and Cohesion Patterns and Anti-Patterns in SQL and ETL development

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: Developer Track

Speaker: Mike Diehl

Title: Coupling and Cohesion Patterns and Anti-Patterns in SQL and ETL development

Abstract:

Frequently I encounter SQL servers and databases in enterprises with huge interdependency issues, such as linked servers, cross-database views and stored procedures, and complicated ETL packages. In this session I will show the most grievous bad practices, what sorts of problems and constrictions they cause, and how they can be re-written to achieve much looser coupling across all data in an enterprise. Any DBA or developer that uses more than two part table or view names in their queries or stored procedures should attend!

SessionID: 22125

Getting Started with Analysis Services Tabular mode

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: BI Track

Speaker: Phillip Labry

Title: Getting Started with Analysis Services Tabular mode

Abstract:

Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization's data.

SessionID: 24986

Twice in a Lifetime: T-SQL Refactoring 101

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: Developer Track

Speaker: MIKE DONNELLY

Title: Twice in a Lifetime: T-SQL Refactoring 101

Abstract:

Whether it's because you inherited the code from the "last guy," or your stored procedures haven't been looked at since the database was created in 2001, there will come a time when you need to rewrite old code. When you start this project you may ask yourself, how did I get here? And you may ask yourself, how do I work this? This is not my beautiful database. This is not my beautiful T-SQL. Letting the data go by, information flowing to the end users is the goal. Refactoring old code can be tedious, but necessary. Sometimes it isn't just about identifying the worst queries in your application, but figuring out how to rewrite everything to introduce the best practices that the last guy didn't know about five years ago.

This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can't be used in modern versions of SQL Server. Don't leave your old T-SQL the same as it ever was.

SessionID: 26047

Breaking Data - How to Load and Stress test your database using SQL Profiler and OStress

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: DBA Track

Speaker: Terry Bunio

Title: Breaking Data - How to Load and Stress test your database using SQL Profiler and OStress

Abstract:

This session will present how you can load and stress test your SQL Server database using SQL Profiler and OStress. This session will review how to performance test Extract, Transform, and Load SSIS processes, application SQL code, Reports, and free-roaming SQL. We will share SQL Profiler templates that help to trap the poorly performing SQL statements that can then be using to stress test your database until it breaks. In addition, we will show how SQL Profiler can be used to extract the SQL submitted by SSIS and Object-Relational Modeling tools like Hibernate and then use that SQL to take stress testing to the next level.

The first third of the presentation will be presentation style and the following two thirds will be demonstrations where we try and break the database with our stress testing. All this with a Breaking Bad theme!

SessionID: 26550

Practical Powershell for the Harried DBA

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: DBA Track

Speaker: Ben Thul

Title: Practical Powershell for the Harried DBA

Abstract:

We DBAs are a busy lot. As time passes, it seems like we're being asked to configure and manage more and more servers and databases without an increase in headcount. What can we do to keep up? In this session, you'll learn about Powershell and how you can use it to automate your routine (and not-so-routine) tasks. After covering the basics, we'll get into some practical scenarios and compare the Powershell approach with the alternatives.

SessionID: 26591

Protecting SQL Data for Availability and DR

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: DBA Track

Speaker: Tim Plas

Title: Protecting SQL Data for Availability and DR

Abstract:

This session provides a comparison of SQL High Availability Disaster Recovery options, presented by a practitioner who has implemented and managed all the SQL High Availability and Disaster Recovery approaches (and various combinations thereof). We will provide an overview of all the various HA DR options, then compare trade-offs for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.

SessionID: 26806

10 things I wish I knew about loading data

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: Developer Track

Speaker: Tim Costello

Title: 10 things I wish I knew about loading data

Abstract:

In this session I’ll share some of the lessons I've learned the hard way about loading data. I’ll show you some ways SQL Server Integration Services can make your life easier (or harder!) and ways you can move data without ever leaving SQL Server management studio. Want to move data like a boss Monday morning? This session will show you how!

SessionID: 26809

Windowing Functions

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: New Technology Track

Speaker: Tim Costello

Title: Windowing Functions

Abstract:

Window functions are one of the coolest new things in SQL Server 2012, but they can be tricky to figure out. In this session we'll talk about how windows functions work and why you should start using them. This is going to be a demo heavy session with code samples you can take back to work and start using Monday morning!

SessionID: 8923

T-SQL : Bad Habits Best Practices

Back to calendar

Event Date: 22-11-2014 - Session time: 00:00:00 - Track: Developer Track

Speaker: Aaron Bertrand

Title: T-SQL : Bad Habits Best Practices

Abstract:

Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance or maintainability. You will also learn about best practices that will help you avoid falling into some of these bad habits. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them - leading to more efficient code, a more productive work environment, and - in a lot of cases – both.

This site is open source. Improve this page.