Event Location:
NSCC - Waterfront Campus
80 Mawiomi Place
Dartmouth, Nova Scotia, Canada
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.
Speaker(s): Russ Allen,
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
Speaker(s): Justin Dearing,
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.
Speaker(s): Meagan Longoria,
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.
Speaker(s): Michael DeFehr,
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.
Speaker(s): Kevin Feasel,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/meaganlongoria/
Contact: http://datasavvy.me
Meagan Longoria is a business intelligence consultant with Denny Cherry Associates, and lives in Denver, Colorado. She is a Microsoft Data Platform MVP. Meagan spends a lot of time thinking about how to use data integration, DAX, and data visualization techniques to make data useful for people. She enjoys sharing her knowledge and experiences at conferences and user group meetings, as well as through her blog (DataSavvy.me).
Russ Allen has over 30 years of experience as a software developer, technical instructor and database administrator for a variety of companies in Eastern Iowa. As a technical trainer he taught classes throughout the United States and in Spain and Australia. For the last nine years, Russ has been a SQL Server DBA and BI developer for the University of Iowa in Iowa City, Iowa.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
LinkedIn: http://ca.linkedin.com/in/mdefehr
Contact: http://mikedefehr.com
Michael DeFehr is an independent SQL Server consultant based in Winnipeg, Canada. He is focused on database administration and development using Microsoft SQL Server. A SQL Server MVP, Professional Engineer and MCITP in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity.
LinkedIn: https://www.linkedin.com/in/justindearingnyc
Contact: http://www.justaprogrammer.net
Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry. Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.
The following is a list of sponsors that helped fund the event.