SQLSaturday #320 - Raleigh 2014

Event Date: 09/06/2014 00:00:00

Event Location:

  • Wake Technical Community College - Northern Wake Campus
  • 6600 Louisburg Road, Building E
  • Raleigh, North Carolina

PDF of Schedule

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

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: SQL 2012 Table Compression

Abstract: SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.

Speaker(s):

  • Jason Brimhall

Track and Room: Performance/Internals - N/A


Title: The Froogle DBA – Combining SQL Features and Open Source

Abstract: There are some really great toolsets for sale to help you manage your SQL Server environment. If you want to learn more about them, then this is not the session for you. While there is nothing wrong with buying a solution to solve your needs. The Froogle DBA has a recipe for combining free software with built in SQL Server features to put together a framework that will give you the peace of mind you need to sleep at night. That’s right, no software licensing needed beyond your SQL Server investment and you too could be maintaining and monitoring your systems with the best of them. We’ll be combining Zenoss, MDW, CMS, and Performance Dashboard Reports to build a comprehensive monitoring and management framework in place. With this flexible framework you will be able to keep systems up and sleep easier.

Speaker(s):

  • John Greeson

Track and Room: DBA - N/A


Title: What Just Happened? Why You Need to Constantly Monitor Your Environment

Abstract: You get back from lunch on a Friday and your inbox is exploding with emails from the users claiming the system is hanging. What do you do now? How are you going to figure out what is currently causing the issue and what started the problem in the first place?

In this session you’ll learn why it’s important to monitor what your server is doing and track any changes that have been made. You’ll learn about the components you can use to create your own solution as well as some real world examples of how correct monitoring can help you troubleshoot day-to-day issues. You’ll also see how it can help the new DBA get a grip on what’s going on in their environment.

Full-time monitoring can provide you with quick answers to many common issues; such as “random” system slow-downs, deadlocks, and that pesky SQL error the users see once every two months. Having a great infrastructure in place can leave you with more time for the fun stuff, like online training and post-lunch power naps.

Speaker(s):

  • Mark Wilkinson

Track and Room: Introductory Topics - N/A


Title: Data Analysis for the DBA - Performance and Audit Reporting

Abstract: Sometimes you really need to see what your SQL Server is truly capable of doing. You need to find the bottlenecks on performance that could prevent you from adding additional workloads, more users or more databases, whether you are in a virtual or physical environment and regardless of your SQL Server version. But first you have to know what is happening under the hood right now. In this session we will look at how to load test SQL Server while monitoring the important performance metrics and then extrapolate from that data what would happen if you added more users. We might even cover how to automate this process for other servers. We will also dive into PowerView and SSRS to see how they compare on delivering appealing visualizations of the collected data.

Speaker(s):

  • Rodney Landrum

Track and Room: DBA - N/A


Title: Your Free Tools Swiss-Knife for SQL Server

Abstract: A lot like fancy gadgets but those do not come for cheap and sometimes we do not even need them and you do not need expensive 3rd party tools to do many tasks with SQL server.

I want to share with you my Swiss-knife of free tools that I use almost daily to work with SQL server. From SQL Nexus , PAL,Qure Analyzer, PSSDiag , and more ;some help with productivity and some cut the time needed to troubleshoot an issue.

Those are powerful, free and easy to use tools to help you with your daily work. I would like also to hear from you if you are using any other tools that you find useful and save you time and cost even if they are not free so please come.

Speaker(s):

  • Mohamed Mawla

Track and Room: Professional Development - N/A


Title: Twice in a Lifetime: T-SQL Refactoring 101

Abstract: Whether it’s because you inherited the code from the “last guy,” or your stored procedures haven’t been looked at since the database was created in 2001, there will come a time when you need to rewrite old code. When you start this project you may ask yourself, how did I get here? And you may ask yourself, how do I work this? This is not my beautiful database. This is not my beautiful T-SQL. Letting the data go by, information flowing to the end users is the goal. Refactoring old code can be tedious, but necessary. Sometimes it isn’t just about identifying the worst queries in your application, but figuring out how to rewrite everything to introduce the best practices that the last guy didn’t know about five years ago.

This session will cover ways to quickly find old T-SQL antipatterns, tools that can help make things easier to update code, and deprecated features that can’t be used in modern versions of SQL Server. Don’t leave your old T-SQL the same as it ever was.

Speaker(s):

  • MIKE DONNELLY

Track and Room: T-SQL/Dev - N/A


Title: Automated Deployments - Lowering the risk of database releases

Abstract: Releasing changes can feel like the most stressful part of managing databases. Whether we’re in a development shop reviewing changes from several unique development instances, a healthcare shop walking a series of changes through an extreme change management process, or the only DBA pushing manual changes into production, hitting that final button is stressful.

In this session, we’ll build a deployment pipeline that will reduce the stress and risks we’re used to from manual deployments while providing a framework for cleaner change tracking and management, shorter release windows, and the ability to keep numerous environments in sync with the latest available changes without constant restores. While the primary focus will be an end-to-end demo, we’ll also discuss the business value of deployment pipelines, how they reduce risk and enable us to move faster, and alternatives to the set of tools used in the demo.

Speaker(s):

  • Eli Weinstock-Herman

Track and Room: DBA - N/A


Title: Scalable, Large-Volume Data Synchronization in OLTP Systems

Abstract: Synchronizing data from any external source (file, web form, web service, etc.) poses problems as the data volume and/or transaction count increases. While a data warehouse might have a regular window in which to ETL its data, an OLTP system–especially one that serves a 24 / 7 / 365 business–has to deal with issues such as concurrency, disk space, and even memory management on the app server. And the processing still needs to be done ASAP. Various methods will be discussed to synchronize tens of thousands and up to millions of rows quickly, with very little app-memory used, and all while performing validations and transformations.

Speaker(s):

  • Solomon Rutzky

Track and Room: Cloud/Big Data - N/A


Title: SQL Server on VMWare Monitoring: Optimized for Performance

Abstract: Your SQL Server instance has been placed on a VMWare virtualized machine (VM), now what. When a SQL Server instance moved to a virtualized architecture, the DBA typically loses visibility to CPU, Memory, Storage and network metrics. This session will cover basic virtualization concepts specifically related to VMWare, VMWare tools, as well as discuss specific tools to help restore the visibility of server metrics and correlate those metrics directly to SQL Server performance. Monitoring the server metrics along with monitoring overall SQL Server performance provides for an effective solution to manage monitor your SQL Server/VMWare virtualized environment.

Speaker(s):

  • Trent Sherman

Track and Room: DBA - N/A


Title: What can SQLCLR do for you?

Abstract: Most articles and blog entries regarding SQLCLR are focused on how to write functions or stored procedures, but very little time is spent on showing what SQLCLR does really well and where it can be truly beneficial. Here we will explore the what / why / when of using SQLCLR to accomplish things that cannot be done in T-SQL, such as: Dynamic SQL, error handling, and calling Stored Procedures within functions; capturing PRINT output; Custom Aggregates; multi-threading; and more. We will look at practical examples of using SQLCLR to reduce code complexity, reduce the time it takes to complete a project, increase performance, and assist in automation (i.e. stay within T-SQL instead of using SSIS or xp_cmdshell).

Speaker(s):

  • Solomon Rutzky

Track and Room: T-SQL/Dev - N/A


Title: Optimizing Protected Indexes

Abstract: As a SQL Server DBA I see my role having 2 main focuses. First is to protect the data and second is to ensure performance is maximized. More often than not companies forget about data security when they focus on performance tuning. In this presentation I will mention a few cases where encryption could have saved a lot of hassle. I will then demo a method that can be used to “index” commonly searched on encrypted values (ex: SSNs, Credit Card, etc) helping reduce the impact on the performance of a query.

Speaker(s):

  • Chris Bell

Track and Room: Performance/Internals - N/A


Title: Getting Started With Execution Plans

Abstract: Are you just breaking into the query tuning side of managing your SQL Servers? In this session, we will cover the basics you need to start leveraging execution plans as part of your tuning process. We will discuss how SQL Server creates and uses plans, and how to collect them. Once we have the plans, we will go step-by-step through how to read them, and what the most common operators mean. We will look at the different types of operators not just from a standpoint of what they do, but how they can impact query performance. We will also cover how good database design and maintenance allow you to get better execution plans through having the right indexes and up-to-date statistics.

Speaker(s):

  • Scott Fallen

Track and Room: Introductory Topics - N/A


Title: BI Expert Panel - Part 1

Abstract: Join a panel of Business Intelligence experts from SolidQ and learn the best practices for planning and delivering successful BI solutions. Join Rushabh Mehta, Brett Tomson and Paul Turley to discuss how to bring BI to your organization, avoid common pitfalls, apply proven design patterns and learn from deployments in companies around the world. Bring your hard questions and be prepared for an interactive discussion.In this first of two sessions, learn how to wrangle requirements from the business, plan, prototype, design your solution.

Speaker(s):

  • Paul Turley

Track and Room: BI - N/A


Title: SQL Injection

Abstract: Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!

Speaker(s):

  • Kevin Boles

Track and Room: T-SQL/Dev - N/A


Title: Windowing Functions in SQL Server 2012

Abstract: SQL Server 2012 brings with it nearly full ANSI compliance with the windowing functions. Come to this code filled session to learn about all of the windowing functions in SQL Server 2012: Ranking functions, changes for windowing in the Aggregate functions, and the new Analytic and Sequence functions. We’ll examine how this latest implementation of the windowing functions allows us to perform running and sliding aggregations; retrieve data from adjacent rows in the partition, and much more – all without self-joins back to the source table.

Speaker(s):

  • Wayne Sheffield

Track and Room: T-SQL/Dev - N/A


Title: BI Expert Panel - Part 2

Abstract: In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization. BI solution experts and SolidQ Mentors Rushabh Mehta, Brett Tomson and Paul Turley will help you define an end-to-end BI solution including data sourcing security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.

Speaker(s):

  • Paul Turley

Track and Room: BI - N/A


Title: Crazy Things That Developers Do

Abstract: Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it’s bad to the database server (or your career)… and alternatives that can be used instead. Trust me… your DBA will love you for making these changes.

Speaker(s):

  • Wayne Sheffield

Track and Room: T-SQL/Dev - N/A


Title: We Have Normality

Abstract: The relational database architecture stands on solid mathematical footing. Central to the math behind the relational architecture is the concept of normalization. This presentation goes through each of the major normal forms, describing (with examples each step along the way) how to get into each normal form, why you want to be in that normal form, and how to recognize when you are not in that normal form. This talk will show you exactly why good normalization technique is vital in relational database design.

Speaker(s):

  • Kevin Feasel

Track and Room: Introductory Topics - N/A


Title: SQL Server Bingo – Install, Migration Config

Abstract: Get ready to play SQL Buzzword Bingo with the subject matter being SQL Install, Migration Configuration. Are you preparing to move a database from one SQL Server to another? Whether it’s your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to “get it right.” Come to this session and find out all about the process - and have some fun while you’re at it. First one to hit BINGO! will win a copy of the book SQL Server 2012 - Step by Step.

Speaker(s):

  • Mindy Curnutt

Track and Room: DBA - N/A


Title: “I Know What You Did Last Query” –SQL Server

Abstract: Starting with the 2005 release, SQL Server captures information about the workload on an instance, which you can use to monitor the system, gather performance metrics, and validate system settings. This information is available via Dynamic Management View and functions and officially they “return internal, implementation-specific state data.” This session gives an introduction to these concepts, how they make DBA life much sweeter and we discuss many of the different community queries available to help you get jump started in your environment. We also open up the floor for ideas of how you are using these views/functions.

Speaker(s):

  • Carlos L Chacon

Track and Room: Performance/Internals - N/A


Title: Check Engine Lights

Abstract: Problem with Windows server, IO storage or SQL Server stopped your business dead in its tracks? Together we’ll explore “check engine lights” for your SQL Server warning you of pending doom. I’ll cover Performance Monitor, IO STACK, Dashboards, ErrorLogs, and DMVs to keep your server and SQL Server running smooth.

Speaker(s):

  • Chris Skorlinski

Track and Room: Performance/Internals - N/A


Title: Your Best Interview Ever

Abstract: Presented by Chris Skorlinski with a collection of tips from 20 years of interviewing new hire candidates at Microsoft. He’ll cover techniques for building your résumé and key strategies during interviews, whether via phone, Skype, or in-person, to increase your chances for a new job and a new adventure.

Speaker(s):

  • Chris Skorlinski

Track and Room: Professional Development - N/A


Title: Sizing your DW Hardware - SMP, Fast Track or PDW

Abstract: Data Warehouses can be placed on many different types of Hardware. Deciding on the correct one is vital to the end users experience. Setting up the hardware correctly can make the difference between a system that performs for a short period of time to one that lasts. No one wants to trouble shoot performance issues. Come hear how to set up your server the first time.

Speaker(s):

  • Andy Isley

Track and Room: Cloud/Big Data - N/A


Title: Indexing Deep Dive

Abstract: Another in TheSQLGuru’s very popular “Deep Dive” series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.

Speaker(s):

  • Kevin Boles

Track and Room: DBA - N/A


Title: Congrats on your promotion to DBA, now what?

Abstract: For those of you that don’t have a full time DBA on staff, this session is built around you. I will give you the skills and tools necessary to successfully manage Microsoft SQL Server. Automation is the key to any monitoring effort and SQL Server is no different. I will show you publicly available tools and scripts to alert you when key areas of SQL Server are being stressed. Proactively monitoring SQL Server will make you more efficient and allow you to continue your success within your role.

Speaker(s):

  • Doug Purnell

Track and Room: Professional Development - N/A


Title: Much Ado About Hadoop

Abstract: Hadoop is a hot topic right now, and Microsoft is betting that Hadoop and SQL Server will go together like peanut butter and chocolate. This presentation will spend a few minutes on the theory behind Hadoop, but the rest will be a demo-driven look at how to get a handle on Hadoop before somebody introduces it into your enterprise.

Speaker(s):

  • Kevin Feasel

Track and Room: Cloud/Big Data - N/A


Title: Managing Very Large Databases with SQL Server

Abstract: If some of your databases have grown to over 1TB and it has become a challenge to maintain them - or if you are anticipating what to do in the future when they do - then this talk is for you!

In this session, I will provide some practical advice on managing VLDBs with SQL server, focusing on common problem areas for new and experienced DBAs alike, including index maintenance, integrity checks, backups and restores.

Speaker(s):

  • Brian Carrig

Track and Room: DBA - N/A


Title: Floating on a Hybrid Cloud: SQL Server 2014 Windows Azure

Abstract: In this session we will discuss and demonstrate the cloud integration capabilities of SQL Server 2014, the Windows Azure Platform, and scenarios for leveraging hybrid cloud infrastructure. We will discuss and demonstrate deploying SQL Server 2014 running on a Windows Azure Virtual Machine and also discuss and demonstrate the Windows Azure SQL Database. We will also discuss best practices and demonstrate techniques for managing both on-premises and cloud-based resources.

Speaker(s):

  • Timothy McAliley

Track and Room: Cloud/Big Data - N/A


Title: I’m New, Select Me!

Abstract: I have been new to something at some point in my life, new town, new job or new profession. Now, I am the new DBA! Feeling overwhelmed, not sure where to begin. I know I have data and maybe lots of it. I need a friend and mentor to help me discover my new role. Select wants to be my friend, in fact Select and I need to become best friends. For Select and I to become best friends, we need to learn about each other, our weaknesses and our strengths. Come along, Select wants to introduce you to all of Selects friends. Let’s meet Where, Join, Group By and more of Select friends. Come along, let’s discover Select and his friends.

Speaker(s):

  • Thomas Norman

Track and Room: Introductory Topics - N/A


Title: Backup to the Cloud: Integrating On-Premises SQL Server Backup and Recovery with Window Azure

Abstract: In this session, we will discuss and demonstrate backup and recovery of your on-premises SQL Server databases to and from Windows Azure, a key Hybrid Cloud capability of SQL Server 2014. We will discuss key feature concepts such as the enhanced Backup UI, Restore UI, encrypted backups, SQL Server backup to URL, and the SQL Server Backup to Windows Azure Tool. We will also discuss the scenarios for integration of this technology.

Speaker(s):

  • Timothy McAliley

Track and Room: Cloud/Big Data - N/A


Title: Get Near Realtime ETL with Service Broker

Abstract: Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.

Speaker(s):

  • Allen White

Track and Room: BI - N/A


Title: TempDB Parasites!

Abstract: Unless you happen to be Chuck Norris, your SQL Server instances only have one tempDB. That makes tempDB a single point of contention for an instance. What’s worse is that there are a lot of things going on in tempDB that you may not be aware of. Let’s look at some things that can use tempDB while we’re not looking.

Speaker(s):

  • Jason Hall

Track and Room: DBA - N/A


Title: Policy Based Management, Trolls and Watchmakers

Abstract: Peanut Butter and Jelly holds two slices of bread together what can hold my Sql Servers together, PBM? Do you like to be constant, have a pattern and be reliable? I have way too much to do, I can’t review every line of code. Help me, please! PBM is your friend, your ally and the gateway to your system. Policy Based Management can be your bridge to your Sql Server. Let PBM be your troll, letting the best pass. But wait, PBM can also be your watchmaker. Policy Based Management, Trolls and Watchmakers, come watch PBM control our systems.

Speaker(s):

  • Thomas Norman

Track and Room: DBA - N/A


Title: What the Hekaton

Abstract: In SQL Server 2014 – Microsoft is introducing In-Memory OLTP. (Formally known as project Hekaton.) In this session – we will introduce this technology, optimize an existing AdventureWorks stored procedure to use In-Memory OLTP, and native compilation. Finally, we’ll discuss non OLTP applications such as ETL.

Speaker(s):

  • John Flannery

Track and Room: Introductory Topics - N/A


Title: Manage SQLServer Efficiently w/PowerShell Remoting

Abstract: You have more and more servers to manage and less time to accomplish everything. You’re writing scripts to automate those tasks but they still take time to run. PowerShell remoting allows you to manage servers without the overhead of Remote Desktop, and allows you to run processes on all your servers simultaneously. In this session we’ll walk through how PowerShell remoting works, how to set it up, and how you can save time getting things done more quickly.

Speaker(s):

  • Allen White

Track and Room: DBA - N/A


Title: Understanding Transaction Isolation Levels

Abstract: SQL Server offers several isolation levels beyond the default “READ COMMITTED”. But understanding when to use each one can be daunting. Whether you are a developer who needs to understand how isolation works and and why NOLOCK is not an appropriate hint in most cases, or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each level, how it impacts the engine, and examine appropriate (and inapproriate) use cases for each.

Speaker(s):

  • Randy Knight

Track and Room: Introductory Topics - N/A


Title: F# Type Providers Change The Way You Interact With Data Sources

Abstract: F# is the functional language that ships with Visual Studio. It is a great language that combines the power of functional programming with the benefits of being a 1st class citizen in the .NET stack. One feature unique to F# is type providers. Type providers are constructs to allow you to dynamically connect and consume data sources ranging from Sql Server to Json to Hadoop to MongoDb and everything in between. Type providers are particularly useful analyzing very large datasets where it is impossible to code-gen the schema. They are also very useful for developers who want to write fewer bugs.

Speaker(s):

  • Jamie Dixon

Track and Room: T-SQL/Dev - N/A


Title: Getting the Most Out of Plan Reuse

Abstract: Both DBA’s and Developers should be acutely aware of what it takes to ensure that every call to SQL Server has the best chance of reusing a previously generated query plan. Having to generate a new plan each time will waste precious resources and ultimately prevent you from obtaining peak performance and scalability for that SQL Server Instance. We will cover the fundamentals of how query plans get reused and how you need to write your code to take advantage of that. Lots of demos will show just how critical some of your code choices can be in order to obtain peak performance.

Speaker(s):

  • Andrew Kelly

Track and Room: Performance/Internals - N/A


Title: What’s in the SQL Server 2014 Business Intelligence Suite?

Abstract: The Microsoft SQL Server business intelligence suite contains many tools to help in your data warehousing. Deciding which on to use can be confusing if you’re first learning the toolset. This session will provide an overview of each tool in the business intelligence suite in SQL Server 2014 and explain when you would use each one. Soon, you too can answer the question of what is in the SQL Server 2014 Business Intelligence Suite!

Speaker(s):

  • Jessica Moss

Track and Room: BI - N/A


Title: The 20-Minute Tabular Model

Abstract: The Tabular model is the new kid on the block in Analysis Services 2012. Based on xVelocity, a new highly compressed in-memory technology, Tabular models promise considerable performance improvements over Multidimensional models in many scenarios. But, as is the case with any new technology, there are certain limitations of which to be aware. Join me in this introductory-level session focusing on how Tabular fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live demo where we’ll build a basic Tabular model in visual studio.

Speaker(s):

  • Bill Anton

Track and Room: BI - N/A


Title: Locks, Blocks, and Deadlocks Oh My!

Abstract: Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.

Speaker(s):

  • Randy Knight

Track and Room: Performance/Internals - N/A


Title: Cloudy with a Chance of Data

Abstract: Cloud, Cloud, Cloud. Microsoft is “all in”. CxOs love the idea of renting compute resources. You know this is where our profession is headed, but when and how fast. When should you jump on board? The good news is cloud will not eliminate or even reduce the need for IT and Data professionals. The bad news is our world and our profession is changing. Come see what Microsoft Azure has to offer Data Professionals.

Speaker(s):

  • Geoff Hiten

Track and Room: Cloud/Big Data - N/A


Title: PowerShell SQL Management Objects: automated sql server installs and configurations

Abstract: Creating new SQL servers is a time-intensive process. Beyond the Next, Next, Next of the initial install are the multitude of configuration details unique to your environment. Maintenance Jobs, alerts, min/max memory, operators, dbmail, audits and the list goes on. In this presentation we will go over basic PowerShell syntax and PowerShell SQL Management Objects (SMO), resulting in a set of reusable scripts for automating the installation and configuration of new SQL servers.

Speaker(s):

  • Jamie Wick

Track and Room: DBA - N/A


Title: Goodbye Next Next Next, Hello Automated Installs

Abstract: Tired of clicking through all those setup screens and entering the same information over and over again? I know I am, so I’m doing something about it…I’m automating my installs! From base SQL Server installs to Service Packs, Cumulative Updates and even Client Tools for DBA’s and Developers, I’ll show you ways to automate your installs using SQL Server FineBuild (CodePlex Project). We’ll cover many of the scenarios you may encounter and you’ll walk away with some pre-built install scripts to help get you started.

Speaker(s):

  • Brian Davis

Track and Room: DBA - N/A


Title: SSIS Templates Can Make Your Life Easier

Abstract: How many times have you started a new SSIS project and added the same components that you’ve added to almost every other package you’ve created? Components to handle logging and errors or even a standard workflow for loading data files. In this session I’ll show you how you can create standard templates that already contain any and all of the common components you desire. We’ll also look at how to implement and use these templates so that the next time you create a SSIS package you can spend your time on the work you actually need to do instead of implementing common components over and over again.

Speaker(s):

  • Brian Davis

Track and Room: BI - 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.

Solomon Rutzky

Twitter: - SqlQuantumLeap

LinkedIn: Solomon Rutzky

Contact: http://SqlQuantumLeap.com/

Solomon Rutzky has been working with databases for since 1996, focusing on SQL Server since 2002. He has written several articles for SQL Server Central (including the Stairway to SQLCLR series), and SimpleTalk, and has a blog: https://SqlQuantumLeap.com/ . Solomon is owner / founder of Sql Quantum Lift ( https://SqlQuantumLift.com/ ), and is the creator of the popular SQLCLR library of functions: SQL# ( https://SQLsharp.com/ ). He does what he can to help others by answering questions on a couple of StackExchange sites ( https://stackexchange.com/users/281451/ ), Ask.SqlServerCentral.com/users/20164/SRutzky.html , and SqlServerCentral.com/Forums/ .

Timothy McAliley

Twitter: - sysframeworks

LinkedIn: Timothy McAliley

I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.

Mark Wilkinson

Twitter: - http://twitter.com/m82labs

Contact: http://www.m82labs.com

I am a father of 4, and live in Raleigh North Carolina. I love fixing problems, and learning new technologies that can help me fix those problems faster and better than I did the time before.

In my spare time I like to read, speak, and learn new things. I currently work as a Database Administrator at ChannelAdvisor where I solve fairly interesting problems on fairly large databases.

You can often find me on Twitter where I talk about SQL, beer, and anything else I find interesting.

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

MIKE DONNELLY

Twitter: - SQLMD

LinkedIn: MIKE DONNELLY

Contact: http://sqlmd.wordpress.com

Michael Donnelly has been working with SQL Server for 15+ years and holds the MCSE: Data Platform certification. He is an avid runner, blogger, and a wannabe gourmet chef. Currently living the SQL Life on the Jersey Shore.

Timothy McAliley

Twitter: - sysframeworks

LinkedIn: Timothy McAliley

I am currently a Microsoft Cloud Solutions Architect in the Washington, DC area. Previously, I was a Microsoft Technology Solutions Professional (TSP), a Microsoft Account Technology Strategist and a SQL Server Premier Field Engineer. Prior to Microsoft, I was a Technical Trainer and DBA in the Enterprise Security Group at Symantec . I have been in IT for over 20 years. My particular interests are IT operations, IT auditing, IT audit frameworks, IT service management (ITSM), ITIL, information security, project management, and database/application tier high availability solutions. I also co-run the Northern Virginia SQL Server User Group ( @novasl) and also co-run the Azure Datafest events.

Jason Brimhall

Twitter: - sqlrnnr

LinkedIn: Jason Brimhall

Contact: http://jasonbrimhall.info

Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.

Scott Fallen

Twitter: - @ScottFallen

LinkedIn: Scott Fallen

Contact: http://blogs.sqlsentry.com/author/ScottFallen/

Scott Fallen (@ScottFallen) is a Solutions Engineering Manager on SentryOne’s Sales team and is responsible for technical sales support. He interacts with customers and prospective customers at conferences and trade shows. He also provides demos and online webinars existing and future users of SentryOne software.

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.

Brian Carrig

Twitter: - @briancarrig

Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.

Jamie Dixon

Twitter: - @jamie_dixon

Contact: http://jamessdixon.wordpress.com

Jamie Dixon writes code. That is what he does for his job and that is what he does for fun. He has worked in a series of positions and in a variety of industries. He is the former chair of his town’s Information Services Advisory Board and is on the board of his local .NET User Group (TRINUG). He has written articles for Make magazine, is a frequent blogger, and has been a Microsoft MVP since 2015 (F#/Visual Studio and Data Platform). He is the author of Mastering .NET Machine Learning (Packt 2016) and is authoring a series of upcoming videos on supervised machine learning techniques from Manning Press.

Bill Anton

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

LinkedIn: Bill Anton

Contact: http://byobi.com/blog/

Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.

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.

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.

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;

Jamie Wick

Twitter: - Jamie_Wick

LinkedIn: Jamie Wick

Contact: http://blog.wicktech.net

Jamie Wick is the Systems Database Engineer for The College of William Mary and has been working with SQL databases for the past 10+ years. His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Masters degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications. He is the Chapter Leader of the Richmond SQL Server Users Group, a volunteer and speaker at regional SQL events (User Groups/SQLSaturdays), helps run the SQLSaturday RVA events, and is an avid photographer.

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.

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;

Paul Turley

Twitter: - paul_turley

LinkedIn: Paul Turley

Contact: http://www.sqlserverbiblog.com

Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.

Trent Sherman

Twitter: - @dbatrent

Trent Sherman has over 25 years of overall IT experience and over 20 years of DBA experience primarily in the telecommunications amp; software industries using Oracle amp; SQL Server. He is currently an Engineer/DBA with Confio Corporation, recently acquired by Solarwinds. Prior to Solarwinds, Trent worked as a Senior Infrastructure Architect, Technical Manager, DBA, Developer and Design architect in several OLTP amp; VLDB/Data Warehouse database environments.

Solomon Rutzky

Twitter: - SqlQuantumLeap

LinkedIn: Solomon Rutzky

Contact: http://SqlQuantumLeap.com/

Solomon Rutzky has been working with databases for since 1996, focusing on SQL Server since 2002. He has written several articles for SQL Server Central (including the Stairway to SQLCLR series), and SimpleTalk, and has a blog: https://SqlQuantumLeap.com/ . Solomon is owner / founder of Sql Quantum Lift ( https://SqlQuantumLift.com/ ), and is the creator of the popular SQLCLR library of functions: SQL# ( https://SQLsharp.com/ ). He does what he can to help others by answering questions on a couple of StackExchange sites ( https://stackexchange.com/users/281451/ ), Ask.SqlServerCentral.com/users/20164/SRutzky.html , and SqlServerCentral.com/Forums/ .

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.

John Greeson

Twitter: - @sqlgman

LinkedIn: John Greeson

Contact: http://www.moderndba.com

John Greeson has been a database administrator for 17 years mostly concentrating on SQL Server. Currently he is the Manager of Database Services at SAS Institute Inc. In this capacity, he is responsible for a heterogeneous mixture of database platforms supporting line of business and decision support applications. In addition to database administration John served six years as a Reservist in the Air Force Office of Special Investigations where he conducted network monitoring and analysis.

Eli Weinstock-Herman

Contact: http://lessthandot.com

I deliver software and technology solutions for a living. My roles have included lone developer, accidental DBA, data integrator, team lead, and even unintentional Solaris consultant once. I’ve worked with SQL Server for over 10 years, as both a developer and accidental DBA. I’m currently the VP of Software Engineering for PrecisionLender and a blogger on LesThanDot.com.

Paul Turley

Twitter: - paul_turley

LinkedIn: Paul Turley

Contact: http://www.sqlserverbiblog.com

Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.

Rodney Landrum

Twitter: - @SQLBeat

Contact: https://www.simple-talk.com/blogs/author/2133-rodney-landrum/

Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Carlos L Chacon

Twitter: - @CarlosLChacon

LinkedIn: Carlos L Chacon

Contact: http://sqldatapartners.com/blog

Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Andy Isley

BI Practice Manager for Scalability Experts. Andy has 18 years of experience designing, managing and implementing data warehouses. I have implemented data warehouses from small 5 GB to 100/s TB.

His primary focus is business requirements, dimensional modeling, technical architecture designs, ETL design and implementation, reporting and analytics, and production support.

Andy is a certified PDW instructor. Andy has helped the MS COE develop best practices for implementing PDW.

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

John Flannery

Twitter: - @AgileDataArch

LinkedIn: John Flannery

John is the Data Architect at Evolution 1 in Simsbury Connecticut – and Adjunct Professor at Quinnipiac University in Hamden, Connecticut. He has 30 years industry experience; working with SQL server since version 4.2 on OS/2, Oracle since 7.3.4. John holds a Master of Science – Computer Science degree from Rensselaer (1995). John is co-leader of the Hartford SQL User Group - and organizer of SQLSaturday 184.

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.

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

Andrew Kelly

Twitter: - gunneyk

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

Andrew J. Kelly is a Senior Technical Subject Matter Expert with B3 Group Inc. and lives in Clarkdale, AZ. He has over 20 years experience with relational databases and application development, but his main focus now is SQL Server. In addition to general SQL Server training and mentoring, he specializes in performance, scalability, and maintainability of large-scale SQL Servers. He is a regular speaker at conferences and user groups and was a SQL Server / Data Platform MVP for 18 years.

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.

Randy Knight

Twitter: - randy_knight

LinkedIn: Randy Knight

Contact: http://www.sqlsolutionsgroup.com/blog

Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.

Mohamed Mawla

Trilingual Principal Consultant amp; Team Tech lead at a global Tech Consulting Mohamed had worked with large SQL server environments such as financials and gov of hundreds of SQL server instances and enormous amounts of data. His favorite subjects are Cloud Analytics, performance tuning, High Availability, especially Replication and Disaster recovery. Certified Google Cloud and Azure Data Engineer.

When not working, Mohamed carries his cameras and takes a trip somewhere.

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

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.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

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.

Doug Purnell

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

LinkedIn: Doug Purnell

Contact: http://sqlnikon.wordpress.com

Doug Purnell is a DBA at Elon University and is a co-leader for the Triad SQL BI PASS User Group. In his spare time you can find Doug taking photos and cooking up some BBQ on his cooker.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page