Event Location:
UCSD Extension - University City Center
6256 Greenwich Dr.
San Diego, California
Abstract:
Creating automated unit tests to validate the logic of a unit/method/function of .NET code is nothing new, but many of the day-to-day applications we develop have business logic in the database tier that can be difficult to validate and regression test. SQL Server Data Tools allows developers to create Test Projects, which can be used to build up a repository of automated tests designed to validate the functionality of the objects in a SQL Server database (e.g. Constraints, Stored Procedures, UDFs, View, etc). In this session we will demonstrate how to use SSDT Test Projects to unit test your databases. This presentation is almost entirely demonstration of the tools, but there are a couple slides to review :-)
Speaker(s): Josh Sivey,
Abstract:
When it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments? If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.
Speaker(s): Kerry Tyler,
Abstract:
SQL Server is easier to administrate than any other relational database on the market. But “easier than everyone else” doesn’t mean it’s easy, nor does it mean is problem free. After all, many apps are growing from small, home-grown applications every year, with green IT professionals encountering issues that others had tackled and solved years ago. Why not learn from those who first blazed the trails of database administration, so that we don’t make the same mistakes over and over again. There is a short list of mistakes that, if you know of them in advance, will make your life much easier. Once you apply the lessons learned from this session, you’ll find yourself performing at a higher level of efficiency and effectiveness than before.
Speaker(s): Kevin Kline,
Abstract:
You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker(s): Aaron Nelson,
Abstract:
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.
Speaker(s): Benjamin Nevarez,
Abstract:
This is an expanded and updated version of the session I presented at the SQL Rally in Orlando. We will cover Tactical Data Governance and in detail specific code examples, using Stock and Custom SSIS Transforms ,Data Models, SSAS Cubes used to create and populate a Metadata Mart as defined by Michael Belcher(Gartner). We will demonstrate incorporating complete custom Data Profiling capabilities (SSIS Transform Scripting, TSQL) capable of Profiling any Source and Targeting any destination. In addition we will implement Data Quality(Address Correction, Fuzzy Matching) and Visualization via PowerPivot , Excel and QlikView. Last will will demonstrate code generation.
Speaker(s): Ira Warren,
Abstract:
A practical way to derive business value from big data is to microtarget customers, but where do you begin? In this session, we examine real data from one of the nation's largest cable TV providers and combine it with data from the 2010 census and other data sources. In addition, we demonstrate how to use Hadoop and the Microsoft BI stack with this integrated data to develop powerful analytics quickly and easily. We demystify the process of working with big data by showing you first how to gather and load the data into Hadoop, and then how to extract a subset of that data and apply data visualization to reveal insightful patterns that can be used to connect more effectively with customers.
Speaker(s): Joseph D'Antoni,
Abstract:
For many organizations, having a second data center or co-location center doesn’t make sense, financially or logistically. Typically, this would limit options for building out a disaster recovery (DR) solution. However, now with Windows Azure virtual machines and SQL Server AlwaysOn Availability Groups, you can connect your on-premise solution to a real-time secondary replica, providing read scalability and a solid DR solution. This session will demonstrate how to extend an Availability Group into Windows Azure, discussing the pros and cons as well as the cost of the solution. You will walk away with a solid understanding of AlwaysOn functionality within Windows Azure VMs, the costs and benefits of building a DR solution within Windows Azure, and how Azure-based backup and recovery can work.
Speaker(s): Joseph D'Antoni,
Abstract:
For decades humans have been collecting data in ever increasing formats and exponentially increasing volumes. Data collection tools have historically outnumbered data analytics tools, hence leading to a huge backlog of raw data waiting to be analyzed. This backlog has increased dramatically in recent years with the explosion of social media and the advent of a plethora of Internet connected devices. The challenge in clearing the backlog was exacerbated by requirements imposed by various analytics technologies to get data into common formats that would then be pumped into standardized data models. The big data revolution challenges this approach by tapping into various, high velocity and large volume sources to identify correlations and patterns that we could only dream of identifying using traditional analytic technologies. In this presentation I will discuss the history of big data tools and will briefly discuss Microsoft HDInsight,an Apache Hadoop compatible Big Data implementation.
Speaker(s): Orion Gebremedhin,
Abstract:
As a Data Warehouse / ETL developer who sometimes waits weeks or months without capturing or loading any source data while a new data warehouse / mart target model is being defined, would you instead like to be able get ahead of the curve by – quickly and mostly automatically – designing and even loading a robust and fully history-tracking DW / staging repository? Or, have the recent requests from sponsors – requests that your DW reporting / analytics solution also supply data for upcoming Master Data Management needs – got you a little nervous about your data transformations? If either of these scenarios resonate, you will appreciate Data Vault, an emerging DW design and architecture. Leaving this session, you will be familiar with Data Vault’s simple design fundamentals, appreciate its potential for task automation, and understand where and when it fits your needs.
Speaker(s): Phil Robinson,
Abstract:
SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.
Speaker(s): David Dye,
Abstract:
We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application's performance. I have given this talk over FORTY times now and it is always very highly rated!
Speaker(s): Kevin Boles,
Abstract:
Want to quickly roll out ultra-flexible reports that will wow your end users? Want to learn how to display the data in multiple layouts on the same report? Want to consolidate similar reports while still providing flexibility to your end users? This can all be achieved by leveraging the three controls based on the Tablix template: Table, Matrix, and the List control. In this demo-heavy session, you'll learn how to create a columnar report that grows vertically as well as horizontally. You'll see the magic of having multiple layouts for the same data on the same report. You'll see how to do more useful things with fewer reports, and you’ll come away with a bag full of new tricks to make your reports flexible and scalable works of art.
Speaker(s): Mickey Stuewe,
Abstract:
Windows Azure is Microsoft's cloud computing platform, and it includes a number of services that benefit you as a database professional. In this session I'll show you how you can leverage services like, SQL Database, Virtual Machines, Data Sync, Reporting Services, HDInsight and more to augment your on premise databases.
Speaker(s): Bret Stateham,
Abstract:
The presenter will consider different architectures to move data across environments during the software development life-cycle. Whether you start from scratch working with XP, or you have to establish processes in already existing organization working in waterfall, whether the data to move is 1 MB or terabytes, the presenter will present ways to handle the tasks and outline the cons and pros of each approach
Speaker(s): Virginia Mushkatbat,
Abstract:
Self-service BI is usually an independent activity. But when individuals discover interesting information that they want to share, they need a centralized location to do that. When people work together, new insights are possible, and that’s what collaboration is all about. As more people see the benefits of the solution, they become more likely to use it. As individual products, SQL Server 2008 R2, SharePoint 2010, and Excel 2010 expand your options for enabling BI in your organization, but collectively they create a solid platform for collaborative BI. Knowing which tool to use for which job can be tricky. Come to this session to learn how to use these tools to foster collaboration.
Speaker(s): Stacia Varga,
Abstract:
SQL Server Data Tools is an evolving product. Besides revamping database projects this product has also changed the lifecycle in which we receive new features. In this session we will demonstrate features such as database snapshots, localdb, and database unit testing. Most importantly we’ll show the many benefits of the Publish feature, and why you will want to use the built-in refactoring instead of just renaming objects. Throughout this presentation we will also highlight and demonstrate the features that have been added to SSDT in the past year.
Speaker(s): Aaron Nelson,
Abstract:
This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
Speaker(s): David Dye,
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:
Does your data sit around mocking your best attempts to support good data practices? Databases are also bound by the GIGO rule: Garbage In is Garbage Out. In this presentation, Karen shows you examples of the types of mistakes, misunderstandings and outright cheats that lead to poor data quality, mistrust in IT systems and overall smelliness in our IT solutions. Using real-life evidence of her own data in your systems.
Speaker(s): Karen Lopez,
Abstract:
Join Thomas LaRock and Karen Lopez for valuable interviewing tips from both sides of the desk. Based on Tom's blog posts of 10 Things I Hate About Interviewing You and 10 Things I Hate About Interviewing With You, this session will be packed with valuable insight and tips to help you sail through your next job interview
Speaker(s): Karen Lopez,
Abstract:
Need to get more performance out of your existing SQL deployment? Need to virtualize SQL Server but can't because of IO latency? Need to overcome poorly written code that slams your IO subsystem? This session presents three successful strategies to leverage Flash in your SQL Server environment reduce IO latency to sub Millisecond ranges, and dramatically improve performance and user experience.
Speaker(s): Peter Andrews,
Abstract:
In this talk Lynn will share her real-world experience deploying solutions to the AWS cloud. She will focus on data solutions such as EC2 w/SQL Server, RDS w/SQL Server and more. Her talk will include coverage of NoSQL offerings such as Glacier, S3 and DynamoDB. She will also cover the RedShift and the new Data Pipeline service. Attend this talk to learn which services to use and tips for usage in the real world.
Speaker(s): Lynn Langit,
Abstract:
Quick overview of the SQL# CLR library where we'll examine a few implementations of some of the functions that I've found useful. Some examples will include string manipulation, file handling, as well as some RegEx usage. There are over 225 procedures and functions, user defined aggregates, and user defined types ... and counting. Come explore some of the interesting problems that SQL# can solve. If you'd like to download and view the CLR library ahead of the presentation, you can get most of the CLR features for free at www.sqlsharp.com.
Speaker(s): David Sumlin,
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
Speaker(s): Steve Jones,
Abstract:
The future of data analysis is the new, in-memory xVelocity Tabular analytic engine but is this new product ready for enterprise solutions? Is it easier to build Tabular models than multidimensional cubes in SQL Server 2012? Maybe… It depends on what you need to do. Is it faster? Heck, yea. Taking off the Microsoft BI marketing hat, let’s take a tabular journey together and learn some lessons from the first generation of real, enterprise-scale solutions: The Good, the Bad, the Ugly and the Beautiful.
Speaker(s): Paul Turley,
Abstract:
Great database performance starts with great database design. During the database design process it is important to select your datatypes wisely. The wrong choices will often lead to wasted space, increased response times, and less stability. Additionally you run the risk of having your design not scale as well as it should. Leave this session armed with the knowledge you need to help your databases perform at their peak efficiency.
Speaker(s): Thomas LaRock,
Abstract:
SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer's decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.
Speaker(s): Ami Levin,
Abstract:
Cluster MVP David Bermingham will walk you through the process of creating high availability and disaster recovery configurations using the new features of SQL Server 2012 AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters and Multisite Clusters. And then finally David will demonstrate how Availability Groups and Failover Clusters can be used together for a combination of High Availability and Disaster Recovery. This session will make use of VMs to demonstrate the technology in a "hands-on" fashion.
Speaker(s): David Bermingham,
Abstract:
We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge.
Speaker(s): TJay Belt,
Abstract:
With SQL 2012 comes a slew of enhancements on the Programmability side. This session will explore some of those new features such as Analytic Functions, Over Clause (Window Functions), Date Functions, Conversion Functions, Sequence Objects, Paging and FileTables to name just a few. If you want to get a jump on those features you will be seeing in SQL 2012 this is the session for you.
Speaker(s): Andrew Karcher,
Abstract:
Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.
Speaker(s): Steve Jones,
Abstract:
This is a lecture and demonstration on how to deploy highly available SQL Server instances in the Amazon EC2 cloud presented by Microsoft Cluster MVP David Bermingham. Starting with preparing the EC2 environment including configuring the VPC, routing and security, Bermingham then continues on and shows you how to configure both AlwaysOn Availability Groups as well as AlwaysOn Failover Clusters for cross availability zone failover.
Speaker(s): David Bermingham,
Abstract:
In SSRS, a rendering extension is a component or module of a report server that transforms report data and layout information into a device-specific format. Out of the box, SSRS includes seven rendering extensions: HTML, Excel, Word, CSV, XML, Image, and PDF. During this presentation, Josh will show how to implement and deploy a JavaScript Object Notation (JSON) rendering extension for SSRS. JSON is a lightweight data-interchange format commonly used in rich client web applications.
Speaker(s): Josh Sivey,
Abstract:
Powered by Fusion-io, Protected by SIOS: Learn how to eliminate the bottlenecks and costs of SAN-based clustering. Leverage the performance of high-speed Fusion ioMemory and achieve higher levels of availability with SIOS. It is the best of both worlds - performance and protection – at a price you can afford. Join us and you could win a $100 American Express gift card. (Sponsor Session)
Speaker(s): SIOS ,
Abstract:
In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective. We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.
Speaker(s): Ami Levin,
Abstract:
For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour's time, and you can take the demo code back home with you to review at your leisure!
Speaker(s): Kevin Boles,
Abstract:
Each of our database systems has its complexities, its idiosyncrasies, its touchy points. Digging into each of these, understanding them, baselining them and monitoring them is an essential part of a DBA's job. Doing these simple tasks in such a way that allows you to sleep at night while your systems churn away safely and gracefully is an art that we all attempt to accomplish. We will discuss various ideas, tools, approaches, and solutions to how to monitor different pieces of our systems. Examples, code, tools, will all be shown off and shared so we can all do better.
Speaker(s): TJay Belt,
Abstract:
This session will focus on patterns and practices that are successful in designing Data Warehouse and Business Intelligence solutions. Designing an analytic database is different from designing a transactional database. This presentation will provide thorough coverage into the foundation of analytic database design: Facts and Dimensions. We'll also discuss the Star and Snowflake schema, dimension hierarchies, multiple calendar dimensions and how all of this fits with the query and reporting tools used to actually present information.
Speaker(s): Robert Hatton,
Abstract:
There are some classic database programming tasks that rely on answering the question "What did I just change?" Prior to SQL Server 2005, we had to use functions like SCOPE_IDENTITY() and some extra tricks for handling multiple rows. Some people even had to resort to triggers. Yikes!! This session focuses on the practical use cases for the T-SQL OUTPUT clause. More importantly, you will find out how you can ditch the tricks of the past for a simpler solution that will help keep you sane.
Speaker(s): Phil Helmer,
Abstract:
When do you use a sparkline, column, or line chart? How do you create a business scorecard – and with what tool? Using Excel, Power View, and Report Builder, this session will guide you through the choices and help you apply the right visual to your business data. Come see what well-known industry experts have to say about the correct use of visualization choices and techniques, colors, backgrounds, borders, and 3-D effects. Then see demonstrations of how to create those rich visuals in the different reporting tools, used with PowerPivot and tabular semantic models.
Speaker(s): Paul Turley,
Abstract:
SQL Server 14 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012. During this session we will explore the new in memory database tables which were developed under the code name project hekaton. During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn’t be used.
Speaker(s): Denny Cherry,
Abstract:
For decades the characteristics of spinning hard drives have acted as a tail wagging the dog requiring the processes and behaviors of software, architecture and administrators to bend to its requirements. With the advent of a new technology, flash storage, comes the unleashing of a new round of performance potential as well as a shedding of long encumbering patterns. Modernizing databases is about both vastly boosting performance and also significantly reducing the complexity and effort to maintain them. Come see a deep dive into how ultra-fast and random-optimized storage is modernizing database performance, architecture and maintenance.
Speaker(s): Mickey Stuewe,
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output.
Speaker(s): Tamera Clark,
Abstract:
Query optimizers are highly complex pieces of software, which even after 40 years of research, still face several technical challenges in some fundamental areas. As a result, there may be cases when even after you've provided the query optimizer with all the information it needs, you still don’t get an efficient execution plan for your queries. This session will show you the current challenges and limitations of query optimizers in general and the SQL Server query optimizer in particular, along with solutions or workarounds to avoid each of these problems.
Speaker(s): Benjamin Nevarez,
Abstract:
The easiest part of any deployment is running the deployment script on production. But what have you done to prepare that script for production? Was the script tested? Is the script tightly coupled with the application code? The difference between a successful deployment and a failed or problematic deployment is all the preparation work you’ve done to ensure that you’re deploying the right script, the right way to your production environment. This session will explore best practices that you can implement within your environment to ensure that your deployments are as successful as they can be.
Speaker(s): Grant Fritchey,
Abstract:
Parameter sniffing is a misunderstood issue on SQL Server. Most of the time, parameter sniffing is helping performance on your servers. But sometimes, circumstances change, and what was helping you is now hurting you – bad. In this session, we’ll gain an understanding of what exactly parameter sniffing is and why it’s usually so helpful. Then we’ll explore how parameter sniffing can go wrong and look at seven different ways you can deal with it when it does. You’ll take away a wealth of knowledge that will help you identify and resolve bad parameter sniffing in your own environment.
Speaker(s): Grant Fritchey,
Abstract:
Ten simple things you can do that will dramatically improve your ability to create solid, high-performance database applications.
Speaker(s): David Moutray,
Abstract:
In this session on SQL Server Licensing we will review the various options for purchasing SQL Server 2012, as well as the options available for reducing your overall license costs. Additionally we will look at the options which are available when installing new servers running older versions of Microsoft SQL Server.
Speaker(s): Denny Cherry,
Abstract:
Combining the backend power of enterprise BI stacks with the fluidity and accessibility of self-service BI designs, Pyramid fuses the needs of both business users and IT administrators into a singular solution.
Speaker(s): Mickey Stuewe,
Abstract:
Performance is getting worse in your SQL Server database, and you're not sure why. You'd like to turn on Profiler, but you've heard that it might hurt your performance. In this session, Microsoft Certified Master Kendra Little will show you which tools help you identify what queries are running in your SQL Server, and which queries are hurting your performance the most-- without killing your performance in the process.
Speaker(s): Kendra Little,
Abstract:
SharePoint makes it easy for users to create their own dashboards but there's more to dashboards than just fast and easy set-up. This session will explore not only the characteristics of an effective BI dashboard using SharePoint 2013, but also the design flaws to avoid. Attend this session and learn how to perform a dashboard makeover. Starting with a review of a dashboard that uses technology correctly but not as effectively as it could, you’ll explore common problems found in dashboards, learn the characteristics of good dashboard design and discover how to implement a dashboard that communicates information clearly and concisely.
Speaker(s): Stacia Varga,
Abstract:
Ten programming mistakes that Database Administrators wish Database Developers would stop making, why they make them, and what to do instead.
Speaker(s): David Moutray,
Abstract:
Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, communication skills and project/job tracking skills. Attendees will learn: 1. What are the fundamental ways that a new leader can build credibility and trust with their team? 2. What are the unique ways in which IT people are motivated? 3. How can a leader effectively communicate with their IT team using a variety of communication channels? 4. How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?
Speaker(s): Kevin Kline,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: http://mask-me.net
Virginia Mushkatblat is currently a founder of Hush-Hush, a data masking company. She wrote her first computer program at the age of 14 and has been in technology ever since, progressively rising through the ranks and trying on different hats including database architecture, development, security and operations. She has worked for Startups and Fortune 100 companies in finance, entertainment, e-commerce, internet advertisement, manufacturing, and communications industries and dealt with both heavily transactional and BI applications.She holds B.S. and Masters Degrees in Engineering and in Computer Science, originated a couple of patents, and currently teaches databases and multimedia to graduating seniors in CSUN, her Alma Mater.
Contact: http://BretStateham.com
My name is Bret Stateham, and I’m a Microsoft Technical Evangelist based in San Diego, CA. As an Evangelist for Microsoft I am passionate about Microsoft technologies like Windows 8, Windows Phone, Windows Azure and my long term favorite Microsoft SQL Server. However, I am a lover of technology in general, and the impact that it can have on peoples lives. if you would like to learn more about me, you can read my blog at http://BretStateham.com
LinkedIn: https://www.linkedin.com/in/sqlvariant
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award. Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
LinkedIn: http://www.linkedin.com/in/kekline/
Contact: http://blogs.sentryone.com/author/kevinkline
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.
LinkedIn: http://www.linkedin.com/pub/lynn-langit/1/621/b40
Contact: http://www.lynnlangit.com
Lynn Langit is a Cloud and Big Data Architect. She's been working with a team on an AWS IoT project this year. Lynn speaks, blogs and creates courses on technical topics for LinkedIn/Lynda.com. She holds a number of partner awards - Microsoft MVP for Data Platform, AWS Community Hero, Google Developer Expert (Cloud). Her blog is at www.LynnLangit.com. She is also director of the non-profit Teaching Kids Programming (www.TeachingKidsProgramming.org).
LinkedIn: http://www.linkedin.com/in/sqlrockstar/
Contact: http://thomaslarock.com
Thomas LaRock is a Head Geek at SolarWinds and a Microsoft Certified Master, Data Platform MVP, VMware vExpert, and a Microsoft Certified Trainer. He has over 15 years’ experience in the IT industry in roles including programmer, developer, analyst, and database administrator.
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.
LinkedIn: http://www.linkedin.com/in/levinami/
Contact: http://www.amilevin.com
Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a freelance consultant, senior SQL instructor at O'Reilly Media, as an author for PluralSight and LinkedIn Learning.
LinkedIn: http://www.linkedin.com/in/karenlopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality. Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
LinkedIn: http://www.linkedin.com/in/kekline/
Contact: http://blogs.sentryone.com/author/kevinkline
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.
LinkedIn: https://www.linkedin.com/in/joshuasivey/
Josh Sivey is a Microsoft Certified Professional with over fifteen years of experience delivering solutions using Microsoft technologies. He enjoys helping empower users to unlock the power of corporate data using the Microsoft BI stack. Josh is a Technology Solutions Professional with Microsoft. In his free time, he enjoys saving Hyrule from the clutches of Ganon with his son and playing My Little Ponies with his daughter.
LinkedIn: https://www.linkedin.com/in/kerrytyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
LinkedIn: https://www.linkedin.com/in/oriongm
Contact: http://www.bi-insights.com/
Orion Gebremedhin, is the Director of Technology for Data and Analytics Platform at Neudesic . He is also a Data Platform (vTSP) for Microsoft Corporation focusing on Big Data technologies. Orion brings extensive experience in implementing advanced analytics and big data technology solutions in various industries. He is a frequent speaker in various technology events; and currently leads the Big Data and Advanced Analytics roadshow sponsored by Neudesic and Microsoft. Neudesic has been providing innovative technologies, services and software products for more than a decade to help organizations gain a competitive advantage and position them for success.
LinkedIn: http://www.linkedin.com/in/karenlopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality. Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
Contact: http://www.fusionio.com
I have worked with SQL Server as a DBA and Database Architect since release 6.5. Presently I am a Systems Engineer for Fusion-io designing Flash solutions for SQL Server customers. I joined Fusion-io from Microsoft where I was the Database Architect for their Bing Maps High Performance Compute center in Boulder, CO. and prior to that, Production DBA for Microsoft's MSN property in Redmond, WA.
Contact: http://www.andrewkarcher.com
Andrew is a Data Professional that is super passionate about the ability of data to drive change in our world, work, and personal lives. He has over 15 years of experience across multiple roles, companies and technologies. A passion for learning is core to how I approach life. Over 10+ years I have spoken at User Groups, Code Camps, SQLSaturdays and Conferences along with supporting my local community as a SQLSaturday Organizer, User Group leader, and advocate for community involvement for all technology professionals. I was also recognized by Microsoft as a four-time SQL Server MVP for my technical community contributions.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
LinkedIn: http://www.linkedin.com/in/tameraclark/
Contact: http://tameraclark.com
Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.
LinkedIn: http://www.linkedin.com/in/scarydba
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
LinkedIn: https://www.linkedin.com/in/joshuasivey/
Josh Sivey is a Microsoft Certified Professional with over fifteen years of experience delivering solutions using Microsoft technologies. He enjoys helping empower users to unlock the power of corporate data using the Microsoft BI stack. Josh is a Technology Solutions Professional with Microsoft. In his free time, he enjoys saving Hyrule from the clutches of Ganon with his son and playing My Little Ponies with his daughter.
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/profile/view?id=3997984amp;trk=hb_tab_pro_top
Contact: http://joeydantoni.com
Joseph D'Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book "Introducing SQL Server 2016”.
LinkedIn: http://www.linkedin.com/in/mickeystuewe/
Contact: http://www.MickeyStuewe.com
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design. She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events. When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often...just ask her children.
LinkedIn: https://www.linkedin.com/in/mrdenny
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
LinkedIn: http://www.linkedin.com/in/way0utwest
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
LinkedIn: http://www.linkedin.com/in/staciavarga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, Stacia has provided consulting and education services for Microsoft's Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
LinkedIn: http://www.linkedin.com/in/mickeystuewe/
Contact: http://www.MickeyStuewe.com
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design. She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events. When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often...just ask her children.
LinkedIn: https://www.linkedin.com/in/mrdenny
Contact: https://www.dcac.com
Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.
LinkedIn: https://www.linkedin.com/pub/david-sumlin/3/2b0/49
David is currently a Senior Database Architect and Consultant within the Enterprise Data amp; Analytics group at Wells Fargo. He has been developing data driven applications and working with SQL Server and many other RDBMS for the last 15 years. He has implemented both small and large OLTP applications as well as large DSS data warehouses.
LinkedIn: http://www.linkedin.com/in/tjaybelt/
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can't be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
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/scarydba
Contact: http://scarydba.com
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.
LinkedIn: http://www.linkedin.com/in/tjaybelt/
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can't be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
LinkedIn: http://www.linkedin.com/in/way0utwest
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
Database Administrator with five years experience in database design, business intelligence, application development, performance tuning and day-to-day administration with SQL Server. Experience covers administration of both transactional and data-warehouse databases, application development and database design for business applications. Certifications include MCITP Database Administrator and Developer. Passionate about database security and promoting data integrity through rock-solid database design and good development practices.
Phil Robinson is an independent consultant focused on developing Business Intelligence solutions using Microsoft Reporting Services and Power BI. He is founder of the San Diego SQL Business Intelligence Group and co-founder of SQLSaturday – San Diego.
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.
LinkedIn: http://www.linkedin.com/in/levinami/
Contact: http://www.amilevin.com
Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a freelance consultant, senior SQL instructor at O'Reilly Media, as an author for PluralSight and LinkedIn Learning.
LinkedIn: https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile
Contact: http://clusteringformeremortals.com/
David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.
LinkedIn: http://www.linkedin.com/in/mickeystuewe/
Contact: http://www.MickeyStuewe.com
Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design. She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events. When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often...just ask her children.
LinkedIn: https://www.linkedin.com/in/rob-hatton-3ab4b845
Contact: http://www.RobertJHatton.com
Rob Hatton is the author of the Business Intelligence Team Handbook. Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.
LinkedIn: https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile
Contact: http://clusteringformeremortals.com/
David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.
LinkedIn: https://www.linkedin.com/in/philhelmer
Contact: http://www.philhelmer.com
Phil has been designing and building relational databases in a variety of industries ever since he first realized how many people don't understand the limitations of Excel and sticky notes as databases. When he was a poor college student, that meant teaching himself MS Access. After moving to SQL Server 13 years ago, he found out about the PASS community and never looked back. He now spends his days developing databases using T-SQL, exploring data management tools techniques and trying to make sense of Microsoft's marketing.
LinkedIn: http://www.linkedin.com/in/staciavarga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, Stacia has provided consulting and education services for Microsoft's Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
LinkedIn: https://www.linkedin.com/in/sqlvariant
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award. Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
LinkedIn: https://www.linkedin.com/in/kendralittle
Contact: http://littlekendra.com
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
Contact: http://us.sios.com
Dave Bermingham is the Senior Technical Evangelist at SIOS Technology Corp. He is a Microsoft Cluster MVP with over 25 years IT experience. He specializes in HA clustering and related technologies.
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/profile/view?id=3997984amp;trk=hb_tab_pro_top
Contact: http://joeydantoni.com
Joseph D'Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book "Introducing SQL Server 2016”.
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
Database Administrator with five years experience in database design, business intelligence, application development, performance tuning and day-to-day administration with SQL Server. Experience covers administration of both transactional and data-warehouse databases, application development and database design for business applications. Certifications include MCITP Database Administrator and Developer. Passionate about database security and promoting data integrity through rock-solid database design and good development practices.
The following is a list of sponsors that helped fund the event.