sqlsathistory

Nr: 404

Back to Main list

SQLSaturday #404 - Nova Scotia 2015

Start Time (24h)	Speaker	Track	Title
08:30:00	Kevin Feasel	Other	Working Effectively With Legacy SQL
09:40:00	Russ Allen	Other	Divide and Conquer - Creating and Managing Partitioned Tables and
10:50:00	Meagan Longoria	Track 1	Overcoming Chartaphobia Moving Toward Enlightening Data Viz
13:00:00	Justin Dearing	Other	Version control with GIT for the DBA
14:10:00	Michael DeFehr	Other	Query Plans and Indexes in SQL Server

SessionID: 14210

Working Effectively With Legacy SQL

Back to calendar

Event Date: 13-06-2015 - Session time: 08:30:00 - Track: Other

Speaker: Kevin Feasel

Title: Working Effectively With Legacy SQL

Abstract:

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

SessionID: 23617

Divide and Conquer - Creating and Managing Partitioned Tables and

Back to calendar

Event Date: 13-06-2015 - Session time: 09:40:00 - Track: Other

Speaker: Russ Allen

Title: Divide and Conquer - Creating and Managing Partitioned Tables and

Abstract:

This presentation will provide an overview of table and index partitioning in SQL Server 2012 and 2014, and describe a step-by-step approach for creating and managing partitions in a large data warehouse. Topics will include:

• The benefits of table and index partitioning • Partitioning requirements and considerations • Laying the partitioning foundation • Creating partitioned tables and indexes • Adding data to a table one partition at a time • Removing partitions when data has “aged out” • Performing piecemeal restores of partitioned databases

The presentation will include a live demonstration of partitioning using fact tables from the AdventureWorksDW2012 sample database. All scripts used in the demonstration will be available to attendees after the presentation.

SessionID: 36460

Overcoming Chartaphobia Moving Toward Enlightening Data Viz

Back to calendar

Event Date: 13-06-2015 - Session time: 10:50:00 - Track: Track 1

Speaker: Meagan Longoria

Title: Overcoming Chartaphobia Moving Toward Enlightening Data Viz

Abstract:

Do your organization's reports consist mostly of giant tables of data? Perhaps you have gotten as far as adding KPI indicators or conditional highlighting to the tables. Although tables of data presented as reports are commonly found in many organizations, they may be doing you and your users a disservice. You should optimize your data viz just as you optimize your databases. Reports are a user interface that must be purposefully designed to help users achieve their goal of making informed decisions. In this session, we'll review requirements gathering and data viz best practices and apply those concepts to the use of Microsoft reporting tools such as Excel, Power View, and Reporting Services. You'll leave with guidance on how to take boring, unreadable tables of data and turn them into useful and visually appealing reports.

SessionID: 28344

Version control with GIT for the DBA

Back to calendar

Event Date: 13-06-2015 - Session time: 13:00:00 - Track: Other

Speaker: Justin Dearing

Title: Version control with GIT for the DBA

Abstract:

In 2005, Linus Torvalds developed a version control system (VCS) called git. Since then, it has become as platform agnostic and ubiquitous as the internet. In that same note, github, the most popular service for hosting git repositories has become so ubiquitous that Microsoft chose to host the source code for its OSS fork of the .NET framework there instead of its own codeplex.

What does this mean to a DBA? Well. whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.

In my session. We will cover:

What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?

We will be covering using git from both the command line and Vis

SessionID: 19988

Query Plans and Indexes in SQL Server

Back to calendar

Event Date: 13-06-2015 - Session time: 14:10:00 - Track: Other

Speaker: Michael DeFehr

Title: Query Plans and Indexes in SQL Server

Abstract:

Data access can be easy to set up in your applications with wizards and ORMs, but sometimes your queries are just not as fast as you think they should be – especially on those tables that are getting bigger and bigger. In this session, we will take a peek under the hood and see how SQL server answers the questions you ask of it. This is an introductory session, but it will be jam-packed with demos and useful tips that you will be able to use to make your applications more responsive.

This site is open source. Improve this page.