Event Location:
Wake Technical Community College - Northern Wake Campus
6600 Louisburg Road, Building E
Raleigh, North Carolina
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/srutzky
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/ .
LinkedIn: http://www.linkedin.com/pub/timothy-mcaliley/10/530/787/
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.
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.
LinkedIn: http://www.linkedin.com/in/armordba
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.
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: http://www.linkedin.com/in/melsar93
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.
LinkedIn: http://www.linkedin.com/pub/timothy-mcaliley/10/530/787/
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.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
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.
LinkedIn: https://www.linkedin.com/pub/scott-fallen/28/731/a9b
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.
LinkedIn: http://www.linkedin.com/pub/allen-white-sql-server-mvp/5/784/b08/
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 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.
LinkedIn: http://www.linkedin.com/pub/christopher-bell/19/a08/93/
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.
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.
LinkedIn: http://www.linkedin.com/pub/bill-anton/12/526/4bb
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.
LinkedIn: http://www.linkedin.com/in/jasonryonhall
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.
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 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;
LinkedIn: https://www.linkedin.com/in/jamiewick/
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.
LinkedIn: https://www.linkedin.com/in/briandavis78
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 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;
LinkedIn: https://www.linkedin.com/in/pturley
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 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.
LinkedIn: https://www.linkedin.com/in/srutzky
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/ .
LinkedIn: https://www.linkedin.com/in/briandavis78
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.
LinkedIn: http://www.linkedin.com/pub/john-greeson/84/bb/ba/
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.
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.
LinkedIn: https://www.linkedin.com/in/pturley
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.
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
LinkedIn: http://www.linkedin.com/in/thesqlguru
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.
LinkedIn: https://www.linkedin.com/in/carloslchacon
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.
LinkedIn: http://www.linkedin.com/in/randyknight
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.
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.
LinkedIn: http://www.linkedin.com/in/armordba
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.
LinkedIn: http://www.linkedin.com/in/johnwflannery/
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.
LinkedIn: https://www.linkedin.com/in/geoffhiten
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.
LinkedIn: https://www.linkedin.com/in/mindycurnutt
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.
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.
LinkedIn: http://www.linkedin.com/pub/allen-white-sql-server-mvp/5/784/b08/
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.
LinkedIn: http://www.linkedin.com/in/randyknight
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.
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.
LinkedIn: http://www.linkedin.com/in/WayneSheffield
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
LinkedIn: http://www.linkedin.com/in/WayneSheffield
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
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
LinkedIn: https://www.linkedin.com/in/dougpurnell/en
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.
The following is a list of sponsors that helped fund the event.