SQLSaturday #404 - Nova Scotia 2015
Working Effectively With Legacy SQL
Event Date: 13-06-2015 - Session time: 08:30:00 - Track: Other
Speaker: Kevin Feasel
Title: Working Effectively With Legacy SQL
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.
Divide and Conquer - Creating and Managing Partitioned Tables and
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
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.
Overcoming Chartaphobia Moving Toward Enlightening Data Viz
Event Date: 13-06-2015 - Session time: 10:50:00 - Track: Track 1
Speaker: Meagan Longoria
Title: Overcoming Chartaphobia Moving Toward Enlightening Data Viz
Version control with GIT for the DBA
Event Date: 13-06-2015 - Session time: 13:00:00 - Track: Other
Speaker: Justin Dearing
Title: Version control with GIT for the DBA
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
Query Plans and Indexes in SQL Server
Event Date: 13-06-2015 - Session time: 14:10:00 - Track: Other
Speaker: Michael DeFehr
Title: Query Plans and Indexes in SQL Server
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.