sqlsathistory

Nr: 358

Back to Main list

SQLSaturday #358 - Albuquerque 2015

Start Time (24h)	Speaker	Track	Title
00:00:00	Bill Fellows		Type More, Click Less: Programmatically build SSIS packages
00:00:00	Jason Brimhall		Murder They Wrote
00:00:00	Meredith Ryan-Smith		Women In Tech Panel discussion
00:00:00	B. Diane Blackwood		Data transformation best practices
00:00:00	Gabriel Villa		What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database
00:00:00	Ginger Grant		Top 10 SSIS Tuning Tricks
00:00:00	Jason Horner		Tricks from the DBA Inbox: Real World Performance Tuning
00:00:00	Jennifer McCown		Designing Stored Procedure Solutions
00:00:00	Jason Kassay		Visual Studio Database Projects and Database Deployment
00:00:00	John McAllister		Master Data Management - Getting Started with SQL Server MDS
00:00:00	John Morehouse		Social Networking Is Alive!!!
00:00:00	Jay Robinson		Fast and Furious Dynamic SQL
00:00:00	John Sterrett		Introduction to High Availability with SQL Server
00:00:00	Leslie Andrews		Why Be Normal?
00:00:00	Leslie Weed		Data Modeling 101
00:00:00	Lori Edwards		Let's Get It Started - SQL Server installation and configuration
00:00:00	Marc Beacom		Getting started with Dimensional Modeling
00:00:00	Jeff Renz		Dashboards - More Than One Way To Visualize Data
00:00:00	Ron Beatty		SSIS ETL for Type1 and Type2 SCD
00:00:00	Russ Thomas		PaaF: Performance as a Feature in an ORM World
00:00:00	Sean McCown		DIY Performance Reporting
00:00:00	Lance Tidwell		Parameter Sniffing the Good and the Bad
00:00:00	Matt Smith		Data wizardry with the next generation of Power BI!
00:00:00	Melody Zacharias		How to Become a Backup Tuning Wizard
00:00:00	Steve Wake		Date Dimension: Past Future in One Script
00:00:00	Seth Washeck		Advanced Statistics Management: Setting Up SQL Server For Success
00:00:00	Thane Schaffer		Intermediate set theory with demo
00:00:00	Christopher Wolff		Fun with Availability Groups
00:00:00	Tim Mitchell		Incremental Load Design Patterns
00:00:00	TJay Belt		Documentation – you know you love it
00:00:00	Tom Roush		Life Lessons in Communication
00:00:00	Trent Sherman		An Oracle DBA's Survival Guide to SQL Server Database Administration
00:00:00	Michael Fal		Powershell Tips and Tricks for SQL Server Administration
00:00:00	Alan Faulkner		SSAS Design and Performance Best Practices
00:00:00	Amy Herold		Making the Leap from Developer to DBA
00:00:00	Argenis Fernandez		Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!

SessionID: 10456

Type More, Click Less: Programmatically build SSIS packages

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Bill Fellows

Title: Type More, Click Less: Programmatically build SSIS packages

Abstract:

Developing repetitive strain injury (RSI) from all those mouse clicks in Business Intelligence Development Studio/SQL Server Data Tools? Longing to automate the tedium in SQL Server Integration Services package creation? In this session, we’ll explore the Integration Services object model and learn how to create rich packages without ever clicking our mouse. You’ll learn about the basic object model, the EzAPI wrapper for it, as well as using BIMLScript to build moderately complex packages.

SessionID: 10889

Murder They Wrote

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Jason Brimhall

Title: Murder They Wrote

Abstract:

Join Microsoft Certified Master, Jason Brimhall, as he examines numerous database design and coding implementations that they have seen over the years. They will explore these implementations and show how they can be murder on SQL Server in terms of performance, security, storage and even accuracy. You will learn how you can identify these “killers” and how you can implement alternatives that will keep data professionals, management, and end-users happy. All while keeping your databases happy, secure, turbo-charged and healthy.

This is the Solo version of the Joint version normally done as an all-day precon

SessionID: 11753

Women In Tech Panel discussion

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Meredith Ryan-Smith

Title: Women In Tech Panel discussion

Abstract:

The definition of confidence is “belief in oneself and one’s powers or abilities” but the authors of the new book “The Confidence Code” define confidence as “the quality that turns thoughts into actions.” Traditionally men have been found to have much more confidence in themselves than do women. For example, in a study at Hewlett-Packard, men applied for a promotion when they thought they could meet 60% of the qualifications while women applied only when they thought they could meet 100%.   Attend this WIT session with panelists Melody Zacharias, Ginger Grant, Amy Herold, and Meredith Ryan to learn more about confidence and how it impacts your career and life. To prepare for the session, it is recommended that you complete The Confidence Quiz (http://theconfidencecode.com/confidence-quiz/) before the event and print out the results and recommendation. NOTE: You will not be required to share your results with the other participants during the session.

SessionID: 13250

Data transformation best practices

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: B. Diane Blackwood

Title: Data transformation best practices

Abstract:

SQL 2012 best practices for data transformation

SessionID: 14127

What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Gabriel Villa

Title: What’s this ‘Scaffolding a CRUD’ all about? Build a Website from your SQL Database

Abstract:

So you have a SQL Server database, and you want a web site for your tables? Come see how to develop and deploy a simple .NET website against any SQL Server database. See firsthand how to use Microsoft’s Entity Framework, ASP.Net MVC and other tricks to develop a website by writing very little code. Take home the ability to create and deploy a simple website to your own database once this demonstration is seen.

SessionID: 14668

Top 10 SSIS Tuning Tricks

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Ginger Grant

Title: Top 10 SSIS Tuning Tricks

Abstract:

Interested in making SSIS perform faster? Do you wonder what the best practices for writing Packages really are? This session reviews how to create SSIS packages to perform as quickly as possible by revealing the Top 10 things you can do to improve the performance of your packages.

SessionID: 15874

Tricks from the DBA Inbox: Real World Performance Tuning

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Jason Horner

Title: Tricks from the DBA Inbox: Real World Performance Tuning

Abstract:

n this heavily demo based session, we show some techniques for performance tuning common problems faced by DBA's Including: how to identify the problem, resolve the issue, and test the solution. Along the way we will also discuss some of theory behind the solutions. We all know there is no such thing as DBCC GO_FASTER but this session is the next best thing.

SessionID: 16500

Designing Stored Procedure Solutions

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

In this session, you’ll learn about SQL Server stored procedures (SPs): what they are, when and why you'd use them, and how you'd go about developing a solution with one. We will address common SP myths and learn about planning for performance. Most of all, we’ll walk through examples to explore the process of solution building in SQL Server.

SessionID: 16897

Visual Studio Database Projects and Database Deployment

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Jason Kassay

Title: Visual Studio Database Projects and Database Deployment

Abstract:

How does your shop keep track of changes to your database schema? What are the database deployment procedures? Do you just make changes directly in production? In this beginner level session you will learn how to easily manage your database schema by leveraging SSDT in Visual Studio with Database Projects, create deployment scripts, and generate re-runnable deployment packages called DACPAC's. We will review how source control interacts with database projects as well as discuss how you can use PowerShell to automate your database deployments.

SessionID: 17163

Master Data Management - Getting Started with SQL Server MDS

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: John McAllister

Title: Master Data Management - Getting Started with SQL Server MDS

Abstract:

This session will provide an introduction to Master Data Management (MDM). We explore the basic concepts, types of MDM solution, and the basics for a successful MDM Implementation. With a working definition in hand, we'll discuss strategies for beginning a successful MDM pilot in your organization and look at some of the pitfalls to avoid. We'll wrap the business discussion up with some tips for selecting the right domains to solve and some tips for managing the politics of MDM. After we've set the stage for what, how and why you need MDM, we'll take a brief look at SQL Server MDS through the Excel add-in and talk about the Architecture of MDS

SessionID: 17264

Social Networking Is Alive!!!

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: John Morehouse

Title: Social Networking Is Alive!!!

Abstract:

Social Networking/Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter?? Can you believe Susie moved to that company?? Do any of those sound familiar? No? Never heard of Twitter? Don't have any fear as this session is for you! Social networking can be a very confusing place and when you don't know where to start, that makes it even worse. In this session, we will go over different facets of Social Networking/Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. We'll be covering Facebook, LinkedIn and Twitter.

SessionID: 17606

Fast and Furious Dynamic SQL

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Jay Robinson

Title: Fast and Furious Dynamic SQL

Abstract:

We all appreciate a well-defined and well-tuned stored procedure. But sometimes the problem calls for a more dynamic solution. What are those problems and how do you generate SQL to solve them? After attending this session, you will be able to identify situations that call for dynamic SQL and address them with rapid, maintainable, and secure code.

SessionID: 17730

Introduction to High Availability with SQL Server

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: John Sterrett

Title: Introduction to High Availability with SQL Server

Abstract:

Have you wondered which high availability features might be best for your shop? In this session we will go over a quick look at log shipping, database mirroring, transactional replication, failover cluster instances and availability groups. John will identify pros and cons for each features and share some tips from the field.

SessionID: 18947

Why Be Normal?

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Leslie Andrews

Title: Why Be Normal?

Abstract:

Is your database normal? While being different and off-beat can be good for your personal life it is not a happy situation for your database to live in. Databases like to be normal! Join me for a fun and informational session on how to create a normal database and find out why it is important. We will also talk about how to make a database normal using queries so you can benefit from normalcy without having to go through major psychotherapy.

SessionID: 19143

Data Modeling 101

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Leslie Weed

Title: Data Modeling 101

Abstract:

Covering the basics for the beginner and those that have been thrown into a modeling role and have been cowboy’n it like the Wild West. We’ll cover why you should bother with a conceptual model and invest some of your project time in the modeling task. We will go over some different modeling techniques around Normalized, Dimensional and Data Vault options. And lastly, considerations for scalability, sustainability and empowering you with a Data Access Layer so you stay in control of your architecture as opposed to the application beast. Yee-Haw!

SessionID: 19239

Let's Get It Started - SQL Server installation and configuration

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Lori Edwards

Title: Let's Get It Started - SQL Server installation and configuration

Abstract:

We've all installed SQL Server and, most of the times, the default settings work just fine. This is a beginner session that will help you to understand what those settings mean along with why there might be times that you want to use something other than the defaults and how that might impact your server. We'll also go through unattended installs, both with and without a config file. This can really help to standardize your SQL Server installations and save you some precious keystrokes.

SessionID: 19432

Getting started with Dimensional Modeling

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Marc Beacom

Title: Getting started with Dimensional Modeling

Abstract:

Technology has revolutionized the way organizations run today. Rather than a few file cabinets, organizations use many different software packages and applications that are mission critical to running their business. These systems gather a large amount of valuable data that must be used in decision making to maintain a competitive advantage. However, we've all heard and likely been around when mission critical systems have been rendered useless due to long running reports. To solve this and a host of other source system reporting issues we have proven Data Warehousing techniques to store the data in a report friendly way. Dimensional modeling is one of the most widely used set of techniques that will provide source system relief for reporting. In this session, we will take a look at what Dimensional Modeling is along with some key terms and techniques.

SessionID: 22927

Dashboards - More Than One Way To Visualize Data

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Jeff Renz

Title: Dashboards - More Than One Way To Visualize Data

Abstract:

Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical). Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.

SessionID: 23436

SSIS ETL for Type1 and Type2 SCD

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Ron Beatty

Title: SSIS ETL for Type1 and Type2 SCD

Abstract:

How to handle and track changes in a data warehouse dimension table is an important dimensional modeling consideration. The dimension tables of a data warehouse need to be designed to appropriately store a history of attribute changes over time. The ETL processes need to detect these changes and correctly update the dimensional table to preserve historical accuracy. Finally, fact records need to be associated with the correct historical version of the dimension. In this presentation, a SQL Server Integration Services (SSIS) will be demonstrated that creates an ETL data flow which will load a dimensional table with both Type 1 and Type 2 dimensional attributes.

SessionID: 23594

PaaF: Performance as a Feature in an ORM World

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Russ Thomas

Title: PaaF: Performance as a Feature in an ORM World

Abstract:

A high performing data tier does not happen by accident. High quality shops understand that performance must be designed as a feature. While SQL Server remains one of the most popular databases in the world, the modern software engineer would rather learn Entity Framework, Dapper, or ORMLite over straight TSQL. Since the TSQL keys have in many cases been handed over to a service tier or ORM, maintaining a high performing database in this environment places significant emphasis on fundamental design. This session will identify the 5 most important factors that every database requires to support "performance as a feature". This session is for the Software Engineer or DBA/Data Architect/DBE who works with database servers where TSQL has b

SessionID: 24287

DIY Performance Reporting

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Sean McCown

Title: DIY Performance Reporting

Abstract:

Stop relying on vendors to provide you with performance data. Between Windows and SQL Server you’ve already got all you need to collect and report on server performance. And it’s far more flexible than you’ll ever get from a vendor. This is often called a poor man’s method, but it’s so much more than that. I’m going to show you what your options are for collecting performance data for free and you’ll even walk away with a framework you can plug into your own environment and start using tomorrow with very little effort.

SessionID: 24431

Parameter Sniffing the Good and the Bad

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Lance Tidwell

Title: Parameter Sniffing the Good and the Bad

Abstract:

Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

SessionID: 24746

Data wizardry with the next generation of Power BI!

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Matt Smith

Title: Data wizardry with the next generation of Power BI!

Abstract:

This will be an action-packed culmination of entertainment, story telling, jokes, and data wizardry using the next generation of Power BI!

SessionID: 25067

How to Become a Backup Tuning Wizard

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Melody Zacharias

Title: How to Become a Backup Tuning Wizard

Abstract:

Do your backups take too long? Do you know how to determine how long they are taking? Would you like database backups to run faster without having to ask for faster hardware? Then come learn some tips and tricks to make your SQL database backups run faster. In this session, we’ll look at several tangible things that you can take back to your environment and make an immediate measurable difference.

SessionID: 25715

Date Dimension: Past Future in One Script

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Steve Wake

Title: Date Dimension: Past Future in One Script

Abstract:

All data warehouses need a date and time dimension to enable proper analysis across time. Most Data Warehouse designers will just use one provided by tools or whip it up in Excel, but what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all of the calculations and formatting up-front so the reports can be easier to create. Sample script will be provided that creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse and it only take seconds to run!

SessionID: 25939

Advanced Statistics Management: Setting Up SQL Server For Success

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Seth Washeck

Title: Advanced Statistics Management: Setting Up SQL Server For Success

Abstract:

The optimizer uses statistics to generate a cardinality estimate which, in turn, affects query plan decisions as well as system resources. In this session we're going to step through the process of evaluating the statistics present (or not present) and present a methodology for analyzing the presence of skew, candidate filtered statistics, and their efficacy in an environment. Additionally, we'll look at the impacts of the new Cardinality Estimator in SQL Server 2014 on plan generation This would, ultimately, be an excellent addition to any periodic SQL Server health check.

SessionID: 26140

Intermediate set theory with demo

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Thane Schaffer

Title: Intermediate set theory with demo

Abstract:

This presentation will compare and contrast set operations with Except, Intersect, and Unions compared with performance of accomplishing the same tasks with inner, outer, and full join queries.

SessionID: 26563

Fun with Availability Groups

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Christopher Wolff

Title: Fun with Availability Groups

Abstract:

Follow along as we adventure through the vastness that is Availability Groups in SQL Server. In this beginners guys we show you how to make an Availability Group from scratch, the new system tables that go along with Availability Groups, and how to troubleshoot your Availability Group using the system tables and SSMS.

SessionID: 26641

Incremental Load Design Patterns

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Tim Mitchell

Title: Incremental Load Design Patterns

Abstract:

The volume of data addressed by the typical ETL operation is constantly on the rise. Not so many years ago, a table with a few million records was considered to be huge. These days, it's not uncommon to deal with multibillion row tables. As a result, ETL professionals are frequently tasked with finding efficient ways to incrementally process these large sets of data without resorting to expensive and time-consuming destructive reloads.

In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing. Among the topics of discussion: --Deciding whether an incremental load is appropriate --Pick your tool: T-SQL or SSIS? --Methods for detecting new and changed records --Common incremental load design patterns

SessionID: 26920

Documentation – you know you love it

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: TJay Belt

Title: Documentation – you know you love it

Abstract:

We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge.

SessionID: 26993

Life Lessons in Communication

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Tom Roush

Title: Life Lessons in Communication

Abstract:

Communicating. We all do it, every day. But can you do it better? You present to management, share with peers, advise your direct reports. A common thread of success or failure here is how well you get your message across.

Can you share bad news and soften the blow with humor while respecting the nature of the news you have to deliver? Can you support your direct reports when they make a very human mistake? Do you know how you communicate your support without micromanaging them can make a huge difference in the quality of their work for years to come? These questions and more will be answered, with stories, with humor, and with experience (both good and bad). Once you've figured these things out, how do you communicate your own skills to the world? After attending, you’ll be on the road to better, more direct communication, whether it’s with your management, your peers, or your reports.

SessionID: 27110

An Oracle DBA's Survival Guide to SQL Server Database Administration

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Trent Sherman

Title: An Oracle DBA's Survival Guide to SQL Server Database Administration

Abstract:

Often times, an Oracle DBA is given the new responsibility of administering SQL Server Instances. Or, conversely a SQL Server DBA has been given Oracle database instances to manage. This session provides a general survival guide to assist with the DBA’s journey to the “other-side”. An overview will be presented on the differences similarities between Oracle and SQL server in the areas of: terminology, object structures, memory, storage architecture, back recovery, basic administration, data transfers, security and performance analysis. We’ll discuss steps strategies to help guide you in learning this new database skill set, and also look at common performance analysis tools which can be used across both Oracle and SQL Server databases. Whether a DBA, developer or manager, this overview will help gain a basic understanding of the key similarities and differences between SQL Server Oracle.

SessionID: 34772

Powershell Tips and Tricks for SQL Server Administration

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Michael Fal

Title: Powershell Tips and Tricks for SQL Server Administration

Abstract:

Have you dipped your toe into the Powershell pool, but are still lost on how you can make it work for you? Maybe you're just looking for a few more tools to help you better manage SQL Server administration? In this session, we will cover a handful of useful scripts and patterns in Powershell that will ease your management of SQL Server. Backups, file management, instance configuration, and several other areas will be covered. By attending this session, you will learn more about how you can use Powershell effectively in your environment.

SessionID: 9066

SSAS Design and Performance Best Practices

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Alan Faulkner

Title: SSAS Design and Performance Best Practices

Abstract:

A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

SessionID: 9430

Making the Leap from Developer to DBA

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Amy Herold

Title: Making the Leap from Developer to DBA

Abstract:

You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

SessionID: 9788

Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!

Back to calendar

Event Date: 07-02-2015 - Session time: 00:00:00 - Track:

Speaker: Argenis Fernandez

Title: Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!

Abstract:

Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail! We will look at raw performance, memory consumption, plan cache usage, and network bandwidth utilization. We will also discuss options for environments on which the code cannot be modified.

This site is open source. Improve this page.