Event Location:
Mammel Hall, University of Nebraska-Omaha
6708 Pine Street
Omaha, Nebraska
Abstract:
Microsoft 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. And it doesn’t mean that database administration on SQL Server is problem free. And since SQL Server is constantly growing from small, home-grown applications, many IT professionals end up 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. In fact, wouldn’t you like to learn about those mistakes before they ever happen? There are a short list of mistakes that, if you know of them in advance, will make your life much easier.
Speaker(s): Kevin Kline,
Abstract:
Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like: - What’s different about 32- and 64-bit systems? - What are the various areas of memory inside of SQL Server? - How are queries handled behind the scenes? - What does SQL Server do with procedural code, like functions, procedures, and triggers? - ...and much more.
Speaker(s): Kevin Kline,
Abstract:
When working with Reporting Services, you need to consider all aspects of security from access to the report server to filtering the report data. This session will delve into the various techniques used to secure reports throughout the architecture and the nuances of integrating with SharePoint security as well.
Speaker(s): Steve Hughes,
Abstract:
A comparison of SQL HA DR options, by a practitioner who has implemented managed all the SQL HA and DR approaches ( various combinations thereof). Tim is an operational SQL DBA, who keeps SQL servers up running optimized for managed-services customers. We will compare trade-offs between the various SQL HA DR options: for complexity, usability, hardware, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc. And we’ll briefly cover some of the upcoming SQL Denali HA / DR features.
Speaker(s): Tim Plas,
Abstract:
Is Business Intelligence a critical strategy within your organization? Companies that have a depth of analytic support, that use it across their entire organization, and value the insights they gain from their analytic solutions—these are companies far more likely to be high corporate performers. And as such, availability of analytics across the enterprise, and the USE of those analytics—this can drive competitive differentiation for an organization. In this session, we will move past the technology and discuss the value of focusing on some very basic, but very critical components to be considered when developing your Business Intelligence strategy.
Speaker(s): Pete Ceplecha,
Abstract:
Everyone has heard that the number of women in technology is declining. How can all of us, women and men, encourage more young women to consider a career in technology? Join Kathi and other dynamic Women in Technology to discuss this important and hot topic. Attendees are encouraged to ask questions, make suggestions, and share their experiences as well.
Speaker(s): Kathi Kellenberger,
Abstract:
Learning how to detect, diagnose and resolve performance problems in SQL Server can be very difficult. It often takes years of on-the-job experience to learn how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem. This hands-on session will take you from the very start of a problem situation on SQL Server, showing you how to use the native tools that help you keep SQL Server at top performance.
Speaker(s): Kevin Kline,
Abstract:
If you've ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why "SQL that works" is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that "worked great in dev" but caused major issues when it hit production and how this can be avoided.
Speaker(s): Randy Knight,
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:
Slow running packages? SSIS consuming all your resources? No idea what it's doing? After attending this session, you will come out with an understanding of how Configuration, Logging, Package settings and deployment work in SQL Server Integration Services. Additionally, you will be armed with a list of transformations and perfmon counters to
Speaker(s): Bill Fellows,
Abstract:
Trying to manage many database instances is no easy task. SQL Server Service Broker and Event Notifications are just one way to get near-real time feedback of what is occurring across all instances. This session will demonstrate how Blue Cross and Blue Shield have implemented Event Notifications to monitor database changes, logins, permission changes, log/data file growths, etc...
Speaker(s): Phil Brammer,
Abstract:
Utilizing TFS 2010 and Visual Studio Database Projects, databases can be included with the Application's CI build. We will discuss Database Projects, walk through a basic scenario, and finish with an enterprise solution that performs the following: Drop DB > Create to Prod > Create Development Delta > Apply Development Delta > Run Data Generation plan > Run Database Tests.
Speaker(s): Mike Douglas,
Abstract:
The focus of this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
Speaker(s): Brad McGehee,
Abstract:
The time to virtualize your entire datacenter is now. The seven primary benefits of virtualization will be discussed: OpEx reductions from improved manageability, near 100% reliable disaster recoverability, product release cycle optimization, high availability, license optimization and hardware-based software licensing, production error capture, and security considerations. Tier-1 virtualization should be embraced, and virtualization is ready. High availability for the C-level and our observation of the current virtualization trends will also be examined.
Speaker(s): David Welch,
Abstract:
Denali has something for everyone: new HA/DR flexibility, an SSIS overhaul, unmatched data warehouse query speeds and much more. Have you heard about all the new T-SQL features and functions that will be delivered with Denali? Attend this session to learn how you will benefit from Microsoft's continued investment in T-SQL!
Speaker(s): Kathi Kellenberger,
Abstract:
This session will provide an overview of the five SQL CLR objects available for SQL Server 2005-2008 and demonstrate how to create, deploy and use these objects for fun and profit.
Speaker(s): Bill Fellows,
Abstract:
As Microsoft continues to expand its cloud computing offerings, this session will look at how developers can leverage the SQL Azure platform in their applications. In this session, we will use SQL Azure as a data store for .NET applications. We will cover how to set up a SQL Azure database and connect to it with our application. During the session, we will also highlight key differences between SQL Server and SQL Azure that can impact how you can leverage SQL Azure in your environment.
Speaker(s): Steve Hughes,
Abstract:
This is a wonderful session for those that don't yet grok the three types of joins available to the SQL Server engine or the scenarios for which each join type is optimal. All will be explained here with some very slick visual demonstrations of internal data flow as well as TSQL code samples.
Speaker(s): Kevin Boles,
Abstract:
In this session we'll discuss the common causes of poor overall performance in a SQL instance. We'll cover the tools and techniques for identifying typical performance issues, and ways to address them.
Speaker(s): Mark House,
Abstract:
Attend this session to learn the new and exciting things coming the next release of SQL Server codenamed 'Denali'. Denali is just round the corner and bring some amazing improvements in the core engine, HA, DR, BI, and DW space. You do not want to miss this discussion on the new and exciting features of Denali. This session will help you decide on how to leverage the new featurses of Denali.
Speaker(s): Sudhir Gajre,
Abstract:
SSIS has some drastic changes coming in the next version of SQL Server, code-named "Denali." This session will touch on the major changes and will demonstrate how they are used.
Speaker(s): Phil Brammer,
Abstract:
New to 2008, Extended Events allow granular performance analysis of individual queries that wasn't possible in prior versions of SQL. In this session we'll cover the collection and analysis of poorly-running queries via extended events.
Speaker(s): Mark House,
Abstract:
What exactly does it mean to parallelize a query? Why would the optimizer do this and what are the benefits and what are the drawbacks?? Is it always faster? Can it cause problems? Are there reasons we might NOT want parallelization? What can prevent it's use by the engine? These are some of the topics we will cover as we dig into this facet of the SQL Server relational engine.
Speaker(s): Kevin Boles,
Abstract:
As SQL Server Analysis Services becomes commonly used in various business intelligence solutions, many administrators are looking for ways to monitor and tune performance on the platform. This session will cover various monitioring techniques and tools and how to use that information to tune Analysis Services.
Speaker(s): Steve Hughes,
Abstract:
In this session you will learn: What is SQL Trace; The Pros and Cons of Using SQL Trace; How SQL Trace Works; What are the SQL Trace System Stored Procedures; How to Create Your Own SQL Trace Script; How to Query Trace Data Directly From a Trace File; and How to use the SQL Server Profiler GUI to Automatically Write SQL Trace Scripts. This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use Profiler. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.
Speaker(s): Brad McGehee,
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 have given this talk over a dozen times now and it is always very highly rated!
Speaker(s): Kevin Boles,
Abstract:
As a Premier Field Engineer I use Performance Monitor much more heavily in troubleshooting than I did before coming to Microsoft. The problem with measuring performance using this tool is that no one knows what counters are important, and if they do, they don't know what values are desired. i will discuss the few most significant counters for diagnosing performance problems.
Speaker(s): Joe Ferry,
Abstract:
Simple title says it all. Lets get down and dirty on some fundamentals and then numerous details of how SANs work and how we can best utilize and tune them to improve SQL Server's IO performance and reliability.
Speaker(s): Kevin Boles,
Abstract:
Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and this session will provide a deep dive into how to properly prepare for and implement a successful virtualization campaign for ALL your SQL Server environments.
Speaker(s): David Klee,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/dataonwheels
Contact: http://www.dataonwheels.com
Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.
LinkedIn: https://www.linkedin.com/in/tplas
Tim is a Principal Consultant at Virteva, in Mpls MN. His current focus areas are cloud architecture / engineering / migration, operational-DBA services (esp. HA/DR), server migrations, server virtualization, and storage. His experience over the past 25+ years has been primarily with server / data-center infrastructure, including being CTO / co-founder of a successful hosting company. Tim has held a variety of MS certifications since 1994.
Contact: http://davidklee.net
David Klee is a SQL Server performance and virtualization expert, and has been working with the product since version 2000. With over fifteen years of IT experience, David spends his days virtualizing mission critical SQL Servers as a Solutions Architect for House of Brick Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis.
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.
Contact: http://www.CodeSmartNotHard.com
Mike Douglas is a Solution Consultant at Deliveron Consulting Services. He specializes in working with development teams to implement Application Lifecycle Management (ALM) solutions to eliminate traditional silos between development, QA, and project management to establish cohesive processes with the Visual Studio ALM tools. He is also Microsoft Visual Studio ALM MVP and External Ranger - Visual Studio ALM. He is an experienced presenter and has spoken at local, regional, and national events.
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.
Mark started working with SQL Server in 1999. He's worked for Microsoft for the past 3 years, and is currently a Sr. Support Engineer in the SQL group. His primary interests are performance, high-availability, and database design.
Contact: http://www.sqlservercentral.com/blogs/kathi_kellenberger/default.aspx
Kathi Kellenberger is a Data Technology Specialist with Microsoft in St. Louis, MO. Before joining Microsoft in 2010, she was a DBA and a SQL Server MVP. Kathi is author of "Beginning T-SQL 2008" and co-author of "Professional SQL Server 2005 Integration Services" and "SQL Server MVP Deep Dives." In her spare time, Kathi enjoys singing (she is the original #sqlkaroke), cycling, playing with her 5 year old grandson, and climbing the stairs in very tall buildings.
LinkedIn: http://www.linkedin.com/in/dataonwheels
Contact: http://www.dataonwheels.com
Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
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.
Mark started working with SQL Server in 1999. He's worked for Microsoft for the past 3 years, and is currently a Sr. Support Engineer in the SQL group. His primary interests are performance, high-availability, and database design.
Contact: http://www.sqlservercentral.com/blogs/kathi_kellenberger/default.aspx
Kathi Kellenberger is a Data Technology Specialist with Microsoft in St. Louis, MO. Before joining Microsoft in 2010, she was a DBA and a SQL Server MVP. Kathi is author of "Beginning T-SQL 2008" and co-author of "Professional SQL Server 2005 Integration Services" and "SQL Server MVP Deep Dives." In her spare time, Kathi enjoys singing (she is the original #sqlkaroke), cycling, playing with her 5 year old grandson, and climbing the stairs in very tall buildings.
LinkedIn: http://www.linkedin.com/in/dataonwheels
Contact: http://www.dataonwheels.com
Steve Hughes is the Director of Consulting at Pragmatic Works. In his current role, Steve manages the consultant team at Pragmatic Works and directs implementation of our cloud practices for customers. He focuses on team development and company growth with this role. In his previous role as a Principal Consultant Lead, he focused designing solutions for customers on Microsoft technologies including SQL Server, Power BI, and Azure. He has been working with technology for over 20 years with much of that time spent on creating business intelligence solutions and helping customers implement leading BI and cloud solutions. He is passionate about using data effectively and helping customers understand that data is valuable and profitable.
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
LinkedIn: http://www.linkedin.com/pub/sudhir-gajre/30/732/5b5/
Contact: http://www.dbbest.com/blog/author/sudhir/
Sudhir has over 20 years of experience in the Data Management and the Analytics field. He spent the last 14 years at Microsoft where he was a Data Architect and later a Principal Technologist. He has authored SQL Server performance tuning whitepapers, designed VLDB and Highly Scalable SQL Server Architectures, and led technical teams. He is a frequent speaker at conferences and SQLSaturdays and is a recognized expert in the Data Management field. He is a Director with DB Best Technologies.
Contact: http://KevinEKline.com
Kevin Kline is the Director of Engineering Services at SQL Sentry. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS, editor-in-chief of SQLServerPedia.com and the author of popular IT books like “SQL in a Nutshell” (O’Reilly Associates). His twitter handle is @kekline and he blogs at http://KevinEKline.com. Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
LinkedIn: https://www.linkedin.com/in/philbrammer
Contact: http://www.ssistalk.com
Phil Brammer, a sixth year Microsoft MVP in SQL Server and a Microsoft Certified Solutions Expert, has over 12 years’ data management experience in various technologies from reporting through ETL to database administration. He has worked with SSIS since 2007 and he continues to play an active role in the SSIS community via online resources as well as his technical blog site, SSISTalk.com. He has contributed to books, SQLSaturdays, SQL PASS Summits, and other online communities.
LinkedIn: http://www.linkedin.com/in/billinkc
Contact: http://blog.billfellows.net
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City's eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.
LinkedIn: https://www.linkedin.com/in/philbrammer
Contact: http://www.ssistalk.com
Phil Brammer, a sixth year Microsoft MVP in SQL Server and a Microsoft Certified Solutions Expert, has over 12 years’ data management experience in various technologies from reporting through ETL to database administration. He has worked with SSIS since 2007 and he continues to play an active role in the SSIS community via online resources as well as his technical blog site, SSISTalk.com. He has contributed to books, SQLSaturdays, SQL PASS Summits, and other online communities.
Contact: http://www.bradmcgehee.com
Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master's in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years' SQL Server experience. He has been involved in the industry since 1982. Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.
Contact: http://www.bradmcgehee.com
Brad M. McGehee is an MCSE+I, MCSD, and former MCT with a Bachelor’s degree in Economics and a Master's in Business Administration. Currently the Director of DBA Education for Red Gate Software, Brad is a Microsoft SQL Server MVP with over 16 years' SQL Server experience. He has been involved in the industry since 1982. Brad is a frequent speaker at industry conferences and events, including PASS Summit, the European PASS Conference, SQL Server Connections, SQLTeach, devLINK, SQLBits, SQLSaturdays, Code Camps, and SQL Server user groups. He founded the popular community site SQL-Server-Performance.com, which he operated from 2000 through 2006, and is the author or co-author of more than 15 technical books and over 275 published articles. He blogs at www.bradmcgehee.com.
To be forwarded in a separate email.
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.
LinkedIn: http://www.linkedin.com/in/billinkc
Contact: http://blog.billfellows.net
Bill Fellows is a SQL Server MVP and has been a database developer for most of his career, with the past 15 years focused on ETL. He is the organizer of Kansas City's eight SQLSaturdays and a speaker at many other SQLSaturdays, User Groups and the PASS Summit. Bill is the owner of Sterling Data Consulting where he gets to solve interesting data problems.
Contact: http://www.houseofbrick.com
Dave Welch is a co-founder of House of Brick Technologies. He serves as House of Brick’s CTO and Chief Evangelist. Dave is expert in system stack architecture, hardware sizing and platform selection, performance, integration and operations, and troubleshooting. Dave pioneered the use of virtualization for the delivery of Oracle University Partner-provided RAC classes. He is certified in both Oracle and VMware technologies and speaks around the globe.
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.
I have been a Microsoft Premier Field Engineer for four years, assisting customers with SQL Server Analysis Services, SQL Server Integration Services and the SQL Server Relational Engine. I don’t have to find myself to be the smartest guy in the room to be helpful because I have seen more environments and issues than most dbas and can share my experiences that help others to focus in on what is important rather than what is more likely to be of academic interest.
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.
The following is a list of sponsors that helped fund the event.
Blue Cross Blue Shield of Nebraska