SQLSaturday #70 - Columbia 2011

Event Date: 03/19/2011 00:00:00

Event Location:

Midlands Technical College - Airport Campus
1260 Lexington Dr
West Columbia, South Carolina

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: Reporting Services Deep Dive

Abstract: SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - New Features included in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access.

** This session is SQLSaturday favorite and is always packed full. Don’t miss it **

Speaker(s):

Brian McDonald

Track and Room: BI 1 - N/A

Title: Recipe for a happy DBA

Abstract: In a world where separation of responsibilities becomes more and more important, the borders between DBAs and developers have grown wider than ever. For the developer seeking to employ the services of SQL Server, Interaction with one or more DBAs at certain stages of the development life cycle is nearly a given. This session discusses tips and techniques to follow that can ensure these interactions are civil, and maybe even pleasant. We will also briefly discuss features included in SQL Server 2008 R2 designed to help abstract DBA and developer division of responsibilities. This topic includes tips on TSQL scripting, deployment techniques, bad habits to avoid beginning execution plan analysis.

Speaker(s):

Jason Hall

Track and Room: Professional Dev - N/A

Title: Report Calcs - SSRS Source Query vs. Expressions

Abstract: As a report developer, you want to ensure your reports are structured for accuracy, performance, maintenance, and reusability. One of your many decisions includes where to perform report-specific calculations when the source is a SQL Server relational database.

In this session we will compare and contrast a sampling of functions available in T-SQL and SSRS, with an emphasis on handling aggregation, ranking, dates, and strings. A “cheat sheet” will be available online for future reference.

Session Goal: Identify common situations when performing calculations within SSRS is preferred, versus when the T-SQL source query may be more appropriate.

Speaker(s):

Melissa Coates

Track and Room: BI 2 - N/A

Title: T-SQL Awesomeness – 3 Ways to Write Cool SQL

Abstract: There’s nothing quite as satisfying as writing a cool bit of T-SQL. Luckily for us, there are some truly awesome ways to make your data do just what you need it to do, while improving performance and/or readability. Come learn three new-school ways to expand your T-SQL repertoire with:
• Recursive Common Table Expressions (CTE) • EXCEPT and INTERSECT • CROSS APPLY and OUTER APPLY We will look at data models and scenarios you might encounter that lend themselves to these techniques, see old-school ways to solve T-SQL challenges, and then compare them to newer, leaner ways to get the same result set. Impress your friends and confound your frenemies with your mad T-SQL skills.

Speaker(s):

Audrey Hammonds

Track and Room: DB Development - N/A

Title: Introducing Microsoft’s EDIM Products

Abstract: Starting in the SQL Server Denali release, data takes on a new life in the business intelligence world. Often forgotten, data management needs to be an integral part of your reporting systems. Learn how Microsoft has made your life easier by incorporating external parameters, environments, and groupings into Integration Services. They have also included impact analysis and data lineage, which can be tied to tables and SSIS packages. Two additional newcomer products, data quality services and master data services, complete the quartet. This session will use the first Community Technical Preview of SQL Server Denali to describe and demonstrate the enhancements to the four products that make up EDIM.

Speaker(s):

Jessica Moss

Track and Room: BI 3 - N/A

Title: Deploying Visual Studio 2010 Database Projects

Abstract: Declarative database development has made great strides forward with the Visual Studio 2010 data tools allowing developers to focus on the model instead of the implementation. But once you have the model, what are the options for deployment and what if your solution doesn’t match the Books Online example? The session will demonstrate multiple ways to deploy database projects using TFS Build, MSBuild, VSDBCMD, Powershell and more. For each deployment method, automation and customization techniques will be examined and demonstrated (including the common requirement of deploying one model to multiple targets.) Attendees will leave with a better understanding of database deployment options when using Visual Studio 2010

Speaker(s):

Kevin Goode

Track and Room: DB Admin 2 - N/A

Title: Designing an SSIS Framework

Abstract: In this “demo-tastic” presentation, SSIS trainer, author, and consultant Andy Leonard explains the what, why, and how of an SSIS framework that delivers metadata-driven package execution, connections management, and centralizes logging. Key takeaways: 1) Developers can migrate packages from Development, through their lifecycle, to Production without editing SSIS Connection Managers properties. 2) A metadata-driven approach to SSIS package execution. 3) Demonstration of a centralized logging reporting application.

Speaker(s):

Andy Leonard

Track and Room: BI 3 - N/A

Title: DW-ETL: 10 Mistakes to Avoid

Abstract: With data being the focal point of a data warehouse, its data integration component becomes a critical point of failure of the whole system, and to make matters worse, we, as developers, face increasingly complex scenarios and requirements such as larger number of systems and volumes of data, data quality problems and complex business logic. In this session Rafael will share a compilation of pitfalls and mistakes he has seen –and made!– across many implementations, and offers recommendations to avoid them. We will look at problems related to metadata, data quality, monitoring, system reliability and some SSIS specific issues among other common problems.

Speaker(s):

Rafael Salas

Track and Room: BI 1 - N/A

Title: “I See a Control Flow Tab. Now What?”

Abstract: This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.

Speaker(s):

Andy Leonard

Track and Room: BI 1 - N/A

Title: Service Broker…What’s That How Do I Use It?

Abstract: Have you heard of Service Broker? Do you know what it is? How about how to use it? This session will answer these questions and more. Service Broker is arguably one of the least known and used features of SQL Server. We’ll explore Service Broker and learn what it is and how it works. We’ll walk through the setup and configuration along with demonstrating its use. You’ll leave this session with a better understanding of Service Broker, its use and implementation, along with ideas of how you can implement it in your own environments.

Speaker(s):

Brian Davis

Track and Room: DB Admin 1 - N/A

Title: SSRS Administration - Enter a BIDS Free Zone

Abstract: You are about to enter the BIDS Free Zone. Beware! This session is NOT about report design, spatial data, R2 new features or .NET extensions. We will explore what the ReportServer and ReportServerTempDB databases contain. By understanding their purpose we can discuss, for your company, what recovery mode each should be in and select backup strategies. Furthermore, we will talk about two other resources to backup: the ever critical encryption key and XML configuration files. Next, we’ll cover the three scalability options: caching, snapshots and scaling out. There are numerous server configurations that are familiar to administrators just hard to find. Some are so hidden you might not know they exist!

Speaker(s):

Sandra Mueller

Track and Room: DB Admin 3 - N/A

Title: Information: Are You Blinded by the Light ?

Abstract: This session will provide you with some surprising and interesting insights into how dashboards should be designed. Called Information Visualization, there is a whole line of thinking which maps how the brain interprets what the eyes see. We will translate this into best (and worst) practices related to visualization in dashboard, scorecard, table, and report design. Both funny and informative, you will probably learn, as I did, that you have been designing your dashboards/scorecards and reports badly. We are going to take a visualization test, and learn how to convey information in a clearer, better way. You will be surprised. Join me - this session is going to be hoot!

Speaker(s):

Wayne Snyder

Track and Room: BI 3 - N/A

Title: Design and Implement BI Like Edison!

Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.

Speaker(s):

William E Pearson III

Track and Room: BI 2 - N/A

Title: PowerShell for Data Professionals

Abstract: You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.

Speaker(s):

Aaron Nelson

Track and Room: DB Admin 1 - N/A

Title: From DBA to Data Architect: Changing Your Game

Abstract: The role of database administrator has been around for years, but as information collection and storage needs have skyrocketed, a new career opportunity has opened within enterprises: the data architect. This session is intended to give some guidance on the differences between database administrators (and their cousins, the database developer) and data architects, including specific advice on how to transition from one role into the next.

Speaker(s):

Stuart Ainsworth

Track and Room: Professional Dev - N/A

Title: You inherited a database, now what?

Abstract: You have recently inherited the support of a new or existing database, what are the things you should immediately check and start monitoring and what are the things that you should address over the next few weeks. When taking over support of a database or system, you cannot ASSUME anything. At the end of this session you will have a nice checklist of things you should check and be doing on ALL your databases not just the one you inherited. Whether you are a seasoned DBA or just starting out, this session should be informative and something you can relate to.

Speaker(s):

Tim Radney

Track and Room: DB Admin 2 - N/A

Title: Bad SQL

Abstract: How do you tell good code from bad? Bad SQL code makes the system work harder for the same results. Bad SQL does not scale well with larger data sizes, nor does it scale with increased server activity. Extreme Bad SQL can bring a server to a grinding halt. This presentation shows you how and why certain commonly used SQL constructions are Bad SQL. Bad SQL is not very useful by itself so each example includes its Good SQL counterpart.

Speaker(s):

Geoff Hiten

Track and Room: DB Admin 2 - N/A

Title: DAX Formulas: Evaluation Context

Abstract: Data Analysis Expressions (DAX) is an expression language used to develop calculations based on PowerPivot data. A lot of its capabilities are very intuitive to Excel power users as it emulates current functionality but over a much larger set of data. However, Its real power emerges with the ability to create aggregations that are evaluated at different contexts on the data stored in-memory. This session will explore DAX formula context, which is of great benefit when developing business calculations like ratios or weighted averages. A brief comparison with MDX will be established in order to contrast the process followed by each language when establishing the context of a calculation.

Speaker(s):

Javier Guillen

Track and Room: BI 2 - N/A

Title: Windows PowerShell Best Practices for DBA’s

Abstract: Learn Windows PowerShell best practices as they apply to each stage of the script development lifecycle. See the differences between working interactively from the Windows PowerShell prompt, writing an inline script, adding basic function, advanced functions and finally the implementation of Windows PowerShell Modules. What is a local best practice for Windows PowerShell development is not the same as a global best practice, and this talk covers those differences

Speaker(s):

Ed Wilson

Track and Room: DB Admin 1 - N/A

Title: To click or to type, that is the question

Abstract: When adminstering SQL Server, in SSMS are you a clicker or a typer? This session explores the use of the GUI vs. using scripting in SSMS to get day to day tasks accomplished, with a bent toward scripting for increased accuracy, control and speed. Tasks are illustrated through the use of the Day-to-Day section of Brad McGeehee’s Sure DBA Checklist at http://www.bradmcgehee.com , Used with Permission and Great Thanks.

Speaker(s):

David Taylor

Track and Room: Professional Dev - N/A

Title: Up and Running with SSIS in 5,4,3,2, (Datachix)1 !

Abstract: This presentation is for absolute beginners to Integration Services, giving the bare essentials to start working in this environment with confidence. We’ll cover basic architecture, basic development, and basic administration in one hour! List of scary acronyms and terms on the list for “demystification”: SSIS, BIDS, ETL, Configurations, Package Deployment, Package Execution, SQL Server Agent.

Speaker(s):

Julie Smith

Track and Room: BI 1 - N/A

Title: Fast Track Data Warehouse

Abstract: Fast Track Data Warehouse is a single-server BI Repository based on the Microsoft SQL Server Parallel Data Warehouse research and technology, but in single-server sizes. The presentation discusses methods, reference configurations, and best practices maximize your hardware investment for moderately sized (4-48 TB) Data Warehouses.

Speaker(s):

Geoff Hiten

Track and Room: DB Admin 1 - N/A

Title: Common SQL Programming Mistakes

Abstract: Become a better SQL developer by learning the most common pitfalls in the SQL language. Both inexperienced and experienced SQL developers and DBAs can get caught by many of these. Practical examples and internal logical processing explanation will help you understand why mistakes happen and how to develop good SQL coding practices to avoid them.

Speaker(s):

Plamen Ratchev

Track and Room: DB Development - N/A

Title: Shade Tree Mechanic’s Guide to SSAS

Abstract: This is a session for the SQL DBA that has SSAS in their environment, but is not sure what happens under the hood when it queried, much less how to tell if it’s performing at its best. This is not a session on query optimization. But, this session will help you better understand if there is room for query optimization or if some basic configuration changes might provide that needed boost. We’ll discuss the basic architecture of SSAS and cover some of the most pertinent metrics to give you a quick and easy view into your SSAS server’s performance.

Speaker(s):

Steven Wright

Track and Room: DB Admin 2 - N/A

Title: Introduction to Microsoft StreamInsight

Abstract: With the release of SQL Server 2008 R2, Microsoft also released a powerful though relatively little known tool called StreamInsight. Microsoft StreamInsight is a complex event processing (CEP) engine that allows you to process, filter and aggregate high volumes of data with relatively low latency. This session will cover core concepts related to StreamInsight including events and windows along with examples of of how to incorporate StreamInsight into your environment. Though bundled with SQL Server, a familiarity with .NET is required.

Speaker(s):

Brett Tomson

Track and Room: DB Development - N/A

Title: A Best Practice Approach to SQL Server CLR

Abstract: This talk will go over some of the best practices of software engineering as they apply to SQL Server CLR projects. We will also show how to build a small library of utilities, stored procedures, functions, etc., that should help you remove some of SQL Server built-in functional barriers.

Speaker(s):

Alex Tocitu

Track and Room: DB Development - N/A

Title: Adding SSRS Report Bells and Whistles

Abstract: Producing a good looking report will wow your business users even if your data isn’t all that impressive. If you’ve ever had trouble finding the best way to display that data or how to show trends appropriately, this is the session for you. We will review grouping logic, graphs, gauges, and more in Reporting Services 2008 R2. With the knowledge in this session, you won’t ever need to show a plain, boring report again!

Speaker(s):

Jessica Moss

Track and Room: BI 2 - N/A

Title: Zen and the Art of Writing SQL Query

Abstract: Writing a query is an art! Simplicity, focus, and practice is all it takes. Understand the logical processing of a query and discover the art of writing simple and efficient queries. It is a journey that starts with FROM and ends with ORDER BY!

Speaker(s):

Plamen Ratchev

Track and Room: DB Development - N/A

Title: SQL University: Class is in Session!

Abstract: This session is aimed at those who are looking to come fresh into the wonderful world of SQL Server administration. Based off my blog project of the same name, SQL University is aimed at teaching students SQL Server from the ground up. In this session we’ll cover some of the essential basics in terminology, tools and general tasks needed to get started in administration. So sharpen your pencils and enroll in SQLU today!

Speaker(s):

Jorge Segarra

Track and Room: Professional Dev - N/A

Title: SQL Developer’s Intro to SSAS

Abstract: This session is geared around introducing the SQL Dev or Data Analyst to SQL Server Analytical Services. Topics covered:

Intro to SSAS Welcome to the Cube Beginning Cube Ninjary Data Mining Kung Fu

Speaker(s):

Nathan Mourfield

Track and Room: BI 2 - N/A

Title: Do More (ETL) with Less (Effort) - Automating SSIS

Abstract: SSIS is a great tool for transferring data from one data source to another, and for implementing complex ETL processes. However, for simple, straightforward data transfer tasks, creating SSIS packages by hand can be time-consuming and repetitious. By attending this session, you’ll learn how to automate package creation in SSIS, including the dynamic generation of data flows. We’ll cover some of the free and open source tools available for this, and discuss “roll your own” options.

Speaker(s):

John Welch

Track and Room: BI 2 - N/A

Title: Enterprise Data Mining for SQL Servr Professionals

Abstract: This presentation presents SQL Server Data Mining (SSDM) for SQL Server Professionals based on the speaker’s past presentations for SQLSaturday. Starting with SQL Server Management Studio (SSMS), the demo includes the interfaces important for professional development, including Business Intelligence Development Studio (BIDS), highlighting Integration Services, and PowerShell. The interactive demos are based on Microsoft’s Contoso Retail sample data. Finally we will evaluate where Microsoft data mining can help you in a practical business environment, which may include Oracle and SAS.

Speaker(s):

Mark Tabladillo

Track and Room: BI 1 - N/A

Title: Down With Ugly Data - Relational Modeling Basics

Abstract: Ugly data is the scourge of developers and DBA’s alike. Do your part to rid the world of ugly data models! Beautiful data starts with a beautiful design. In this session we’ll begin with requirements and end with a physical model, discussing how to make sure that your database design equals data integrity, scalability, and good looks.

Topics include:
–Requirements Analysis –Conceptual Modeling –Logical Physical Modeling –Best Practices

Speaker(s):

Audrey Hammonds

Track and Room: Professional Dev - N/A

Title: Handling Advanced Data Warehouse Scenarios in SSIS

Abstract: So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance.

Speaker(s):

John Welch

Track and Room: BI 1 - N/A

Title: Powerful BI in SharePoint 2010

Abstract: Business Intelligence is a fast growing specialization due to the need of large and small corporations to quickly interpret real-time information for decision making. To meet this growing need, Microsoft has greatly enhanced the Business Intelligence of SharePoint 2010 from MOSS 2007. In this session, you will be provided with an overview of what is possible with SharePoint 2010, include Status Indicators, Chart Web Parts, Performance Point Services, Excel Services, BI Search and Visio Services. We will close the session by building a fast and simple BI Dashboard on a SharePoint Intranet Portal.

Speaker(s):

Cory Loriot

Track and Room: BI 3 - N/A

Title: Making sense of SQL Server availability options

Abstract: With more mission critical databases being deployed in VMs, availability options for SQL Server have grown immensely. Clustering, vMotion, Live Migration, HA, FT, database mirroring and more. Who is responsible to ensure your database is available 24 x 7? Is it the DBA? Is it the server team? Maybe it is the virtualization team? Maybe it is a joint decision among all of those teams. Regardless of who is ultimately responsible, this session will give you a great understanding of the options available and what they do and do not protect against to ensure the availability of your database.

Speaker(s):

David Bermingham

Track and Room: DB Admin 3 - N/A

Title: Database Mirroring in the Real World

Abstract: A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone high availability tool for over 5 years. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.

Speaker(s):

Craig Purnell

Track and Room: DB Admin 3 - N/A

Title: PowerPivot, Idea to Solution in 60 Minutes

Abstract: This fast-paced session will construct a PowerPivot for SharePoint dashboard, analyzing a humorous, everyday problem-set. Beginning with installing PowerPivot for Excel and concluding with a working, interactive dashboard, this session will prepare attendees to leverage PowerPivot to load data from disparate, related sources. Limitations for creating good relationships, and the construction of good dimensions will be covered. Finally, surfacing the assembled data using slicers, charts and tables.

Speaker(s):

Barry Ralston

Track and Room: BI 3 - N/A

Title: Dirt, Spit, and Happy FLWOR: Hands on with XQuery.

Abstract: Relational databases have become storage engines for more than just the traditional datatypes; the inclusion of XML in SQL Server 2005 and SQL Server 2008 opens up a host of new avenues for application development. XQuery is a powerful language for querying XML fragments in conjunction with the relational engine; this session is designed to cover the basic FLWOR syntax of XQuery in an interactive fashion. Participants are encouraged to discuss their own challenges with XML as well as seek out solutions from each other.

Speaker(s):

Stuart Ainsworth

Track and Room: DB Development - N/A

Title: Configuring and Troubleshooting Tempdb

Abstract: Tempdb is used by all kinds of operations in all sorts of ways. In SQL 2005 2008 it has become even more critical to the internal operation of the engine and performance can be affected by a misconfigured or mistuned instance. We will cover the areas that cause the most issues in terms of performance along with demos that illustrate the symptoms. This session will help you ensure your tempdb is up to the task.

Speaker(s):

Andrew Kelly

Track and Room: DB Admin 3 - N/A

Title: Automate Policy-Based Management using PowerShell

Abstract: The Policy-Based Management feature in SQL Server 2008 provides a great way to ensure your systems are configured consistently and correctly, but it can be tedious to implement on each server in your environment. PowerShell scripts allow you to automate the implementation of your policies so you can focus on more important problems. This session will walk you through how PBM works, how to define your policies in PowerShell, and how to set up Agent jobs to evaluate those policies regularly to let you know when you need to take action.

Speaker(s):

Allen White

Track and Room: DB Admin 1 - N/A

Title: Entity Strategies: Structuring Your Consultancy

Abstract: Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.

Speaker(s):

William E Pearson III

Track and Room: Professional Dev - N/A

Title: SQL Server Internals - how things work?

Abstract: In this session we will go over areas of SQL Server functionality that always raise questions. What is SQLOS, scheduler, worker? How does internal scheduling work? How does Resource Governor work? How does CPU affinity work in SQL Server? What are the preemptive and non-preemptive waits? Should we be afraid of SOS_SCHEDULER_YEILD and CXPACKET waits?

Speaker(s):

Sergey Pustovit

Track and Room: DB Admin 3 - N/A

Title: Role of Microsoft Solver Foundation In BI

Abstract: Session will introduce Microsoft Solver Foundation and its application with Microsoft BI Platform. This is a basic session and intended to target audience with none or limited exposure to Microsoft Solver Foundation.

Speaker(s):

Tejas Patel

Track and Room: BI 3 - N/A

Title: “Extra Eyes” with Microsoft Atlanta

Abstract: Are all your databases backed up? Has SQL reported any errors? Are there critical Windows or SQL patches you need to apply? Are all of your SQL Servers configured to Microsoft “Best Practices”? This sessions shows how Microsoft Atlanta Tool can be used to provide the CIO or DBA an “extra set of eyes” to check the health of your SQL Severs.

Speaker(s):

Chris Skorlinski

Track and Room: DB Admin 2 - N/A

Title: Gather SQL Server Performance Data with PowerShell

Abstract: We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don’t always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

Speaker(s):

Allen White

Track and Room: DB Admin 1 - N/A

Title: New features in SQL Server Denali

Abstract: In this session we will go over the new features in upcoming SQL Server release with current code name - Denali

Speaker(s):

Sergey Pustovit

Track and Room: DB Admin 2 - N/A

Title: All about Indexes

Abstract: This session will cover everything a good SQL Developer needs to know about indexing. Will cover how to identify when needed indexes are missing, how to find bad indexes and remove them, understanding exactly what data is stored within indexes and much more. Understand why having indexes can be both bad and good by understanding your own data and how it is structured and accessed. Will cover various design patterns, SQL Server DMVs, as well as real world examples of good and bad indexes.

Speaker(s):

Ashton Hobbs

Track and Room: DB Admin 3 - N/A

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Javier Guillen

Twitter: - @javiguillen

LinkedIn: Javier Guillen

Contact: http://javierguillen.wordpress.com/

Javier Guillen is a Solutions Architect for BlueGranite.

An active blogger, speaker, and Microsoft community contributor, Javier has more than 10 years developing SQL Server solutions and is very interested in SQL Server Analysis Services and the practical application of MDX and DAX patterns.

Javier is also a Power BI Workshop instructor, delivering classes in private and public settings, an adjunct BI instructor for Central Piedmont Community College in Charlotte, NC and an adjunct lecturer for the City University of New York (CUNY) School of Professional Studies undergraduate and bridge graduate courses in Business Analytics. He is also the co-founder and co-organizer of the Charlotte Business Intelligence User Group (CBIG).

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Melissa Coates

Contact: http://www.sqlchick.com

Melissa Coates is a Business Intelligence developer based in Charlotte, NC. As a consultant with Mariner, she specializes in delivering BI and Data Warehousing solutions. Formerly a CPA, Melissa is ridiculously proud to be an IT geek. Her background gives her a valuable blend of technical, business, and training skills. When Melissa steps away from the laptop, you can probably find her hanging out with her border collie. Melissa blogs at http://www.sqlchick.com.

Ashton Hobbs

Twitter: - @achobbs

Ashton has been working with SQL Server since SQL Server 6.5 and earlier versions of Sybase. Ashton is also the original creator and developer of ApexSQL Edit, a Gold Award winner from SQL Magazine. Ashton is currently consulting and speaking in addition to working on new SQL Server based products and tools.

Jorge Segarra

Twitter: - @sqlchicken

LinkedIn: Jorge Segarra

Contact: http://sqlchicken.com

Jorge Segarra is a senior consultant for Microsoft (Premier Support for Developers) and a former SQL Server MVP. Jorge has co-authored titles including “SQL 2008 Pro Policy-Based Management” and “SQL Server 2012 Bible” .

Alex Tocitu

Alex Tocitu is a software engineer with an MSEE in Automation and Control, and an MBA in Finance. With over 2x years of software practice he has enjoyed 1x of them in Sillicon Valley. After a long time with Java and Sybase/Oracle, he currently works with C#/C++ and SQL Server and has lots of fun. Alex Tocitu speaks at local user groups, SQLSaturdays and code camps; he also writes articles for MSSQLTips and SQLServerCentral. Alex is an avid chess player both live and online.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.

Andrew Kelly

Contact: http://sqlblog.com/blogs/andrew_kelly/default.aspx

Andrew J. Kelly is a SQL Server MVP with over 20 years’ experience with relational databases and application development but specializes in Performance, Scalability and Maintainability of large scale SQL Servers. He is a regular speaker each year and a contributing editor and writer for SQL Server Magazine.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Jason Hall

Twitter: - @SQLSaurus

LinkedIn: Jason Hall

Contact: http://blogs.sqlsentry.com/jasonhall

Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.

Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.

Kevin Goode

Contact: http://www.goodesql.com

Kevin has15 years of IT experience, 12 years of which has been SQL Server focused starting with version 6.5. I have worked in many industries including manufacturing, distribution and logistics, financial services, IT outsourcing and has worked for several fortune 500 companies. My specialties include SQL Server development, Performance Tuning, Business Intelligence, and ETL.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

Contact: http://dataperfpro.com/blog/

Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

Aaron Nelson

Twitter: - SQLvariant

LinkedIn: Aaron Nelson

Contact: http://sqlvariant.com/

Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.

Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.

Audrey Hammonds

Contact: http://www.datachix.com

Audrey Hammonds is a BI Consultant for Key2 Consulting in Atlanta, GA, and one half of the Datachix (www.datachix.com). She holds MCTS certifications in SQL Server 2008 Database Development and SQL Server 2008 Business Intelligence. Fourteen years ago, she volunteered for database training to escape the clutches of COBOL, and has never looked back. A firm believer in good fundamentals and solid design, she gets her kicks from making data do nifty things.

Ed Wilson

Twitter: - ScriptingGuys

LinkedIn: Ed Wilson

Contact: http://HTTP://WWW.ScriptingGuys.Com/Blog

Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the daily Hey Scripting Guy! blog. He has also spoken at TechEd, Tech Ready, Geek Ready, SQL Rally and various SQLSaturday conferences. A Microsoft-certified trainer he has taught scripting to Microsoft Premier Customers worldwide. He has written 11 books including 9 on Windows scripting that were published by Microsoft Press. His Windows PowerShell 3.0 Step by Step for MSPress is a current best seller.

Julie Smith

Twitter: - @juliechix

LinkedIn: Julie Smith

Contact: http://datachix.com

Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.

Barry Ralston

Contact: http://www.sqlbipro.com

Barry Ralston is the national practice manager for Business Intelligence at ComFrame a division of Waltham-based NWN. Barry is also Microsoft’s Virtual Technical Specialist (VTS) for BI, responsible for assisting in Alabama, Mississippi and Northwest Florida in sales efforts including customer meetings, software demonstrations and proof of concept efforts. Barry’s first book, “PowerPivot Solutions for Business Intelligence” will be released by Apress in March, 2011.

Sergey Pustovit

As an Architect in Parallel Data Warehouse Center of Excellence Sergey designs complex EDW solutions based on Massively Parallel Processing (MPP) approach. He has 20+ years of industry experience, working with distributed database systems, designing and developing software. Sergey serves on advisory board for the SQL PASS local chapter in Charlotte, NC.

Craig Purnell

Twitter: - @CraigPurnell

LinkedIn: Craig Purnell

Contact: http://www.craigpurnell.com/

Craig Purnell is a career database professional, trainer, and community activist. He has spent over 10 years as the Database Administrator at a large Midwestern law firm. He has been in IT for 15 years and has spent his entire career working with enterprise databases and ERP systems. Craig is an active member of the Ohio North SQL Server User Group and has presented at many user groups, SQLSaturdays, and the PASS Summit in 2012 and 2013

Plamen Ratchev

Twitter: - @PlamenRatchev

Contact: http://pratchev.blogspot.com

Plamen is an SQL Server MVP specializing in relational database applications analysis, implementation, and tuning. His particular interest is in design patterns, performance and optimization. In the past two decades he has worked in different roles as database developer and architect in medium and large scale enterprise applications. He has been involved on projects utilizing DB2 and Oracle, but his main passion is SQL Server, which he started using at version 4.2. Plamen has master’s degree in computer science with specialization in algorithms and compliers. He enjoys sharing his experience with user groups and at various conferences.

David Taylor

Contact: http://dyfhid.wordpress.com

David is an DBA/Developer for a private educational institution in New Hampshire. David has five years of experience learning and administering SQL Server and more recently developing BI solutions using SSIS. Having earned both his MCTS and MCITP DBA certifications for SQL Server 2008, he still considers himself a beginner sharing with other beginners.

Brian McDonald

Twitter: - @briankmcdonald

Contact: http://www.sqlbigeek.com

Brian K. McDonald, MCDBA, MCSD is a Business Intelligence Consultant. Brian has experience in Database Administration, SQL Server Reporting Services, SQL Server Integration Services and Analysis Services. He has worked as an Application Developer, Network Administrator and a Database Administrator throughout his 11 years in the IT industry. He even spent a year on a large Help Desk operation a long, long time ago. Brian takes pride in all his projects and diligently works to not only meet expectations, but greatly exceed them. Brian has written articles for industry websites and continually strives to learn more and become a better version of himself. Brian is an active member of the Jacksonville SQL Server User’s Group and has presented at User group meetings, Code Camps, many SQLSaturdays and SQL Rally events across Florida and South Carolina.

Steven Wright

Twitter: - @SQL_Steve

LinkedIn: Steven Wright

Contact: https://blogs.sentryone.com/author/StevenWright/

Steve currently serves as Director of Advanced Analytics at SentryOne. As a member of the SentryOne team for over 13 years, Steve has broad experience working in various environments supporting the Microsoft Data Platform both on-prem and in the cloud. Steve has earned the Microsoft Professional Program Data Science Certification and manages a team of Data Scientists and BI Developers in support of SentryOne’s internal and product facing advanced analytics initiatives.

Plamen Ratchev

Twitter: - @PlamenRatchev

Contact: http://pratchev.blogspot.com

Mark Tabladillo

Contact: http://www.marktab.net

Mark Tabladillo provides consulting and training for data mining. He has taught statistics at Georgia Tech and for the graduate business school of the University of Phoenix. In addition to his Microsoft certifications (MCT, MCITP, MCAD .NET), Mark has presented at many local, regional, and national technical conferences. Mark produces a data mining resource and blog at http://www.marktab.net

Brett Tomson

Brett Tomson is an independent consultant specializing in delivering solutions using the Microsoft Business Intelligence stack and related .NET technologies. He is an accomplished architect and developer of large-scale enterprise systems as well as an author and mentor to others. Brett has been using SQL Server actively for the past 12 years and is the Chapter Leader of the Triangle SQL Server User Group (http://www.tripass.org).

Stuart Ainsworth

Twitter: - @codegumbo

LinkedIn: Stuart Ainsworth

Contact: http://codegumbo.com

Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.

Stuart Ainsworth

Twitter: - @codegumbo

LinkedIn: Stuart Ainsworth

Contact: http://codegumbo.com

Nathan Mourfield

Nathan has developing BI solutions with MS SQL and Sybase ASE for the last 11 years in health care, 8 of those involved working with SSAS. He currently works at a large hospital as a systems analyst, specializing in line and middle management analytic applications, specifically on the business/finance side.

Sergey Pustovit

David Bermingham

Twitter: - https://twitter.com/daveberm

LinkedIn: David Bermingham

Contact: http://clusteringformeremortals.com/

David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.

Sandra Mueller

Sandra A. Mueller started with Administration (via a programming job) in 1997 and moved into Database Design and performance optimization. She has always had a passion for sharing knowledge and trying to help others avoid the hard lessons she learnt. To this end she has been an MCT for 16 years, writing course ware, providing training and follow-on project consultation. In 2004 after an activation with the military her focus turned to SQL Server 2005 and its Business Intelligence (BI) capabilities. She is currently working as a BI Architect with SQL Server 2008R2 OLAP solutions.

Sandra blogs on http://www.SandraAMueller.com. She recently started the Raleigh NC SQL Server BI User Group (http://www.tripassBI.org). She consistency speaks at SQLSaturday events and supports her local community by speaking, volunteering and attending regional chapters.

Cory Loriot

Cory Loriot has been working with SharePoint as an Administrator, Architect and Developer since January of 2007 beginning with SharePoint Portal Server (SPS) 2003, Microsoft Office SharePoint Server (MOSS) 2007 and currently working with SharePoint Server 2010. Cory works for Computer Technology Solutions, Inc. (www.askcts.com) as a Consultant designing and implementing Microsoft SharePoint 2010 and ASP.Net Solutions.

Audrey Hammonds

Contact: http://www.datachix.com

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Geoff Hiten is a Technical Solutions Professional at Microsoft. Geoff began working with SQL Server in 1992 with version 4.2 and has used every version since. He specializes in highly available SQL systems, performance tuning, and systems migration. Geoff is heavily involved in the Microsoft SQL Server Community and was initially awarded MVP status in 2004. Geoff was appointed in 2011 to fill an interim Director position at the National PASS organization.

Brian Davis

Twitter: - @Brian78

LinkedIn: Brian Davis

Contact: http://blogs.sqlsentry.com

Brian Davis is a Product Integration Engineer at SentryOne and has over 15 years in the IT field in multiple areas including software development, support, user training, and as a DBA. He has been working with SQL Server since 2003 and has hands-on experience with SQL Server 2000 through 2016. Brian is also a PASS Regional Mentor and an active member and leader of the Ohio North SQL Server User Group.

Tejas Patel

Contact: http://intenseanalytics.com/default.aspx

Tejas Patel is a Business Intelligence Architect with EyeWonder, LLC. He has 8+ years of experience working in Business Intelligence field. He is a frequent presenter on local and regional technical conferences and events. He has designed and developed enterprise level Business Intelligence Solutions for many fortune 500 companies.

Jessica Moss

Twitter: - @jessicammoss

Contact: http://www.jessicammoss.com

Wayne Snyder

Twitter: - @sqlwayne

Contact: http://www.msbicentral.com

Wayne Snyder specializes in Business Intelligence solutions and is an international speaker, author, and PASS volunteer. He is a SQL Server MVP and author of the popular Learnkey SQL Server Training series. He is a Distinguished Architect for Mariner (www.mariner-usa.com), who on the weekend sings and plays keyboards for the regional band soundbarrier (www.soundbarrierband.com).

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

Contact: http://dataperfpro.com/blog/

Geoff Hiten

Twitter: - SQLCraftsman

LinkedIn: Geoff Hiten

Rafael Salas

Twitter: - @RafSalas

Contact: http://www.rafael-salas.com

Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.

Chris Skorlinski

Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;

SQLSaturday #70 - Columbia 2011

Sessions

Title: Reporting Services Deep Dive

Title: Recipe for a happy DBA

Title: Report Calcs - SSRS Source Query vs. Expressions

Title: T-SQL Awesomeness – 3 Ways to Write Cool SQL

Title: Introducing Microsoft’s EDIM Products

Title: Deploying Visual Studio 2010 Database Projects

Title: Designing an SSIS Framework

Title: DW-ETL: 10 Mistakes to Avoid

Title: “I See a Control Flow Tab. Now What?”

Title: Service Broker…What’s That How Do I Use It?

Title: SSRS Administration - Enter a BIDS Free Zone

Title: Information: Are You Blinded by the Light ?

Title: Design and Implement BI Like Edison!

Title: PowerShell for Data Professionals

Title: From DBA to Data Architect: Changing Your Game

Title: You inherited a database, now what?

Title: Bad SQL

Title: DAX Formulas: Evaluation Context

Title: Windows PowerShell Best Practices for DBA’s

Title: To click or to type, that is the question

Title: Up and Running with SSIS in 5,4,3,2, (Datachix)1 !

Title: Fast Track Data Warehouse

Title: Common SQL Programming Mistakes

Title: Shade Tree Mechanic’s Guide to SSAS

Title: Introduction to Microsoft StreamInsight

Title: A Best Practice Approach to SQL Server CLR

Title: Adding SSRS Report Bells and Whistles

Title: Zen and the Art of Writing SQL Query

Title: SQL University: Class is in Session!

Title: SQL Developer’s Intro to SSAS

Title: Do More (ETL) with Less (Effort) - Automating SSIS

Title: Enterprise Data Mining for SQL Servr Professionals

Title: Down With Ugly Data - Relational Modeling Basics

Title: Handling Advanced Data Warehouse Scenarios in SSIS

Title: Powerful BI in SharePoint 2010

Title: Making sense of SQL Server availability options

Title: Database Mirroring in the Real World

Title: PowerPivot, Idea to Solution in 60 Minutes

Title: Dirt, Spit, and Happy FLWOR: Hands on with XQuery.

Title: Configuring and Troubleshooting Tempdb

Title: Automate Policy-Based Management using PowerShell

Title: Entity Strategies: Structuring Your Consultancy

Title: SQL Server Internals - how things work?

Title: Role of Microsoft Solver Foundation In BI

Title: “Extra Eyes” with Microsoft Atlanta

Title: Gather SQL Server Performance Data with PowerShell

Title: New features in SQL Server Denali

Title: All about Indexes

Speakers

Sponsors