SQLSaturday #154 - St. Louis 2012
Event Date: 09/15/2012 00:00:00
Event Location:
- Center for Application of Information technology (CAIT) at Washington University in St.Louis
- 5 Jackson Avenue
- Clayton, Missouri
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Pivoting Performance Data Pinpointing Problems
Abstract: Have you ever been wrought with end user complaints of database performance issues only to open your tools that show only live performance or limited historical performance and find no answers? After being bit by this many times, I developed my own eye in the sky to monitor CPU Physical IO at the database, user and application levels. This solution logs data continuously and parses it into an Analysis Services cube which can be queried by Excel. No need to requisition funds for 3rd party tools. You can do this with the tools you have and I’ll give you the scripts to get started. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels.
Speaker(s):
- Brian Flynn
Track and Room: Track 5 - N/A
Title: Windows Azure SQL database Intro and what’s New
Abstract: Windows Azure provides many options for storing data. Windows Azure SQL Database is one of the Windows Azure’s solution for working with relational data. If you are familiar with SQL Server, SQL Azure will be a natural extension of your knowledge and skills. In this session, you will get introduced to: Windows Azure SQL Database and learn how to get started.We will explore how to migrate an existing on-premise SQL Server database to Windows Azure SQL Database. We will then walkthrough how to manage and administer your Windows Azure SQL servers and databases. We will take a look at how to connect and build applications using Windows Azure SQL. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azu
Speaker(s):
- Andy Thiru
Track and Room: Track 5 - N/A
Title: Database Design Done Right
Abstract: From beginning to end application development is upside down. So much emphasis is placed on the front end and so little on the analysis of database structure that many application development projects fail to achieve the goals set by the business. This presentation uses an interwoven analogy to illustrate the process currently used by most enterprises, the results, and the short comings. Yet with a change of focus, the same projects can not only be successful; they can be done under budget, with greater flexibility and extensibility. Future projects can benefit from this change of focus with additional savings in timelines and fewer bug fixes downstream. Any business person or data professional who works directly with business people c
Speaker(s):
- Rickey Nunn
Track and Room: Track 1 - N/A
Title: PWNED! Security, SQL Server, and You!
Abstract: With an ever increasing workload, security is often hoisted upon the DBA. So where do you start? Sometimes it’s better to start off by understanding what an attacker could do to you in order to get a clearer picture of what you need to do to prevent it. In this session, we will delve into the key features of the SQL Server and explain what the various attack vectors are, what an attack can do with them, and what you can do about them. We’ll also look at important features such as SQL Audit that, while not helping to prevent, can definitely help in figuring out what is going on. It’ll be AWESOME!
Speaker(s):
- Arie Jones
Track and Room: Track 3 - N/A
Title: SQL Server in Healthcare
Abstract: Did you know Microsoft started a new company dedicated to healthcare? Did you even know Microsoft has an electronic health records product and a large suite of security products specifically focused on healthcare solutions? You may not know it but healthcare is driving today’s technology. Everything from business analysis, security, and tele-communications is focusing on healthcare solutions. Even Microsoft Kinect is getting in the act. Where there is growth, there is opportunity. This session will define the lingo and point out the trends in order to demystify the industry. I’ll start with the big picture and drill down to the specifics. Together we’ll navigate the trends and get excited about where all of this is going.
Speaker(s):
- Scott Shaw
Track and Room: Track 5 - N/A
Title: Database Health and Performance
Abstract: Sure, your SQL Server is up and running. Is it healthy? Is it performing the best that it can? Where are your performance bottlenecks? This dynamic dialog session will present a solid process for checking your environment’s overall health and performance levels as well as solutions for common problems. Some of the items focused on include dynamic management views (DMVs), Windows Perfmon, and disk performance tools such as IOMeter and SQLIO.
Speaker(s):
- David Klee
Track and Room: Track 4 - N/A
Title: Transactional Replication 101
Abstract: Replication simplified! Learn the basic parts that make up replication, what tools are included to help you along plus a look into monitoring.
We will cover the players in the game: Pubishers, Subscribers and Distributors, then delve into the data delivery process with Publications, Subscriptions and Articles, finishing up with the Log Reader and how to make sure everything is working and running smoothly.
Speaker(s):
- Wendy Pastrick
Track and Room: Track 4 - N/A
Title: Read Dirty to Me - Isolation Levels/User Impact
Abstract: Issue a “SELECT {data} FROM {myTable}” statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.
Speaker(s):
- Wendy Pastrick
Track and Room: Track 3 - N/A
Title: 2012 TSQL Sweets
Abstract: The 2012 release of SQL Server promise a variety of delicious new language features to solve problems. After this session, you’ll have a taste for all the sweets they’ve packed into the language including conversions, date time functions, windowing functions, analytic functions and sequences.
Speaker(s):
- Bill Fellows
Track and Room: Track 5 - N/A
Title: Kama Sutra of SSIS: A guide to loving ETL
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. You will also be armed with a list of transformations and perfmon counters to watch out for.
Speaker(s):
- Bill Fellows
Track and Room: Track 1 - N/A
Title: Common TSQL Mistakes
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 a dozen times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Track 3 - N/A
Title: Creating a Metadata Mart w/ SSIS - Data Governance
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
Track and Room: Track 5 - N/A
Title: Maintain Your DBs with Help from Ola Hallengren
Abstract: One of the most widely respected and recommended free tools for SQL Server is Ola Hallengren’s MaintenanceSolution.sql. It is a one-stop package to backup your databases, maintain your indexes and statistics, and validate the integrity of databases. Come learn about the solution and how it can help you escape the world of canned maintenance plans as well as the importance of performing the various maintenance tasks.
Speaker(s):
- Andy Galbraith
Track and Room: Track 2 - N/A
Title: Microsoft’s Monitoring Options for SQL Server
Abstract: A look at different options for monitoring and debugging your SQL Server environment. We’ll start from low level and work our way to enterprise level options. We’ll look at traces flags, logs, data collectors, utility control points, and up to system center.
Speaker(s):
- Eddie Hendrix
Track and Room: Track 4 - N/A
Title: Don’t Panic, DBAs! Databases on VMware made easy.
Abstract: More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
Speaker(s):
- Janis Griffin
Track and Room: Track 4 - N/A
Title: Cubicle to Consulting
Abstract: What you do for a living may say a lot about who you are. No where is this as true as in IT. How you learn, how you grow, your passions, and your goals can all be reflected in your job. There are many ways your skills can be delivered and you need to choose the best fit for who you are. This session aims to take an unbiased look at the difference between working in a solid, stable IT environment or trekking out and offering your skills as an IT consultant. The differences are staggering and each has their risks and rewards. Each role has its own myths and, like most myths, some are true and some are not. This session will draw on real-world experience and won’t hesitate to point out the successes as well as the failures.
Speaker(s):
- Scott Shaw
Track and Room: Track 1 - N/A
Title: Time Saving Tips Tricks for SSMS 2012
Abstract: SQL Server Management Studio can be really annoying sometimes. Over the years a few really nice features have been added that you may have overlooked or just couldn’t find. This session will focus some time saving tips and tricks for SSMS 2008 R2. We’ll also cover a few great new features being introduced in SSMS 2012. Since I can’t provide scripts for this session I guess I better get started working on some screen shots on where they hid all this stuff!
Speaker(s):
- Aaron Nelson
Track and Room: Track 2 - N/A
Title: Maximizing SQL Server Insert Performance
Abstract: This session describes how to maximize throughput for high-volume insert applications using both programming and database server techniques. Performance of bulk insert and table-valued-parameter methods will be contrasted with traditional insert methods.
Speaker(s):
- Dan Guzman
Track and Room: Track 3 - N/A
Title: Behind the Scenes: SQL Server Statistics
Abstract: An informative, entry level session regarding SQL Server statistics and the importance of their accuracy. The presentation will cover, in detail, the statistics object - how they are generated and how the optimizer utilizes them, along with some foundation SQL Server internals principles. Examples will be provided that construct situations where the optimizer chooses poor execution plans due to issues with statistics. Finally, a free stored proc will be provided that allows for comprehensive statistics management by the DBA.
Speaker(s):
- Travis Whitley
Track and Room: Track 1 - N/A
Title: SQL Server 2012 T-SQL
Abstract: Have you heard about all the great new T-SQL features? Attend this session to learn about new functions, OVER clause enhancements, the Sequence Object and more!
Speaker(s):
- Kathi Kellenberger
Track and Room: Track 3 - N/A
Title: SQL 2012 Integration with SharePoint
Abstract: This session will showcase what is new in the BI arena in SQL 2012, focusing on BI in SharePoint. Discussion will be centered around Power View, SSRS, PowerPivot 2.0 and the new Tabular Model. Learn what each tool can do and when to use them.
Speaker(s):
- Melissa Meyer
Track and Room: Track 1 - N/A
Title: SQL Server Detective Duo – Change Tracking and CDC
Abstract: ‘Change ‘is the only constant. It is the undoubted truth for data in our world of OLTP databases. Most of us are required to implement an array of solutions to track data changes, for reasons ranging from simple logging to complex regulatory compliance. So the important question is, how best can tracking be done? To help you make the right choice, this session will list and demonstrate some Change Tracking mechanisms. Some of the highlights will be SQL Server Change Tracking and Change Data Capture (CDC) features.
Speaker(s):
- Hima Nagisetty
Track and Room: Track 2 - N/A
Title: Looney Tuner? No, there IS a method to my madness
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker(s):
- Janis Griffin
Track and Room: Track 2 - N/A
Title: Get Ready for SSIS in SQL Server 2012!
Abstract: With the next release of SQL Server, BI developers and database professionals need to know what’s available and how to take advantage of new features and capabilities. During this session, we’ll drilldown on the next release of SSIS and discuss development improvements, the new deployment model, and better managability options. Along the way, we’ll look at new SSIS features including project parameters, shared connection managers, team-based development improvements, and a brand new deployment model with significantly improved management features. Come see some of the exciting changes now available in your favorite data integration tool!
Speaker(s):
- Dave Fackler
Track and Room: Track 2 - N/A
Title: Your Database Code is in My TFS!
Abstract: Tooling for application developers has always surpassed those available for database developers. Microsoft now provides tools that give database developers some love: get database code into source control, branch for concurrent development, automate builds and deployments, refactor, and so much more.
Speaker(s):
- Jeff Fattic
Track and Room: Track 4 - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Aaron Nelson
Twitter: - SQLvariant
LinkedIn: Aaron Nelson
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award.
Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
Bill Fellows
Twitter: - @billinkc
LinkedIn: Bill Fellows
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.
Jeff Fattic
Contact: http://jfattic.wordpress.com
Jeff Fattic has been employed in IT in some fashion for over 10 years. Most of his career, he’s been a software developer on the Microsoft stack, but about five years ago, he began studying Application Lifecycle Management tools and processes. In Jan 2012, Jeff joined Microsoft as a Developer Technology Specialist helping customers be more successful with developer tools. He is a co-founder and board member of the St. Louis Days of .NET conference.
Rickey Nunn
I have worked in IT for twenty-five years. I have had job responsibilities over the years which have progressively increased my technical skills and involved me in all parts of the development life cycle. For the last five years, working for Scottrade, Inc. I have responsibly for database design and architecture. I have been involved in small and large projects on a half dozen platforms over my career and have experience with what works and what does not.
Andy Galbraith
Twitter: - https://twitter.com/DBA_ANDY
LinkedIn: Andy Galbraith
Contact: http://nebraskasql.blogspot.com/
I’m a forty-something Microsoft SQL Server DBA of 18+ years, a devoted husband, and a father of three young boys (all aged eight and under!) I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.
Dave Fackler
Twitter: - @sqlbiguru
LinkedIn: Dave Fackler
Contact: http://davefackler.blogspot.com/
Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Travis Whitley
Contact: http://whitleysql.wordpress.com
Travis is a Senior SQL Server Consultant at Oakwood Systems Group in St. Louis, with a focus on performance tuning and troubleshooting both OLTP and OLAP environments. He’s been working with SQL Server since version 6.5, and also has 8 years of experience as a production SQL Server DBA and developer in the healthcare, finance, retail, and manufacturing industries.
Scott Shaw
Contact: http://www.dbaexperience.com
Scott Shaw is the co-author of two books on T-SQL through Apress publishing. He is a frequent speaker at SQL community events and is the co-leader for the PASS Virtual Chapter on Virtualization. He frequently teaches Big Data and Microsoft BI related courses for Saint Louis University Workforce and Organizational Development Center. He currently lives in Saint Louis working for Oakwood Systems Group as a Principal Consultant and Data Management Lead.
Andy Thiru
Andy aka Abhi has several years of BI experience including planning, design, development and implementation in business database applications. Andy has worked primarily as a consultant holding positions primarily in the Energy, Banking, Media and Consulting fields. He is currently working on Cloud development projects.
Ira Warren
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
Hima Nagisetty
Hima is a SQL Server professional with extensive experience in designing, developing, testing and supporting database solutions. She is working as a Development DBA for a financial firm in Saint Louis. She started of working with SQL Server 2000 about 7 years ago. She has played the roles both database developer and administrator and specifically enjoys being the database safeguard.
Bill Fellows
Twitter: - @billinkc
LinkedIn: Bill Fellows
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.
**Eddie Hendrix **
I am currently a SQL Server Technical Sales Professional for Microsoft. I have been a Database Professional in the St. Louis market for 8+ years working with many different database technologies for many different organizations.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Melissa Meyer
Contact: http://www.covenanttechnologypartners.com
Melissa is an architect with Covenant Technology Partners who has a passion for all things data. Melissa has been worked in BI for 10 years and specializes in implementing the SharePoint BI stack and BI solutions of all types and sizes. In her free time, she enjoys travel, hunting, cooking and spending time with family.
Scott Shaw
Contact: http://www.dbaexperience.com
Scott Shaw is the co-author of two books on T-SQL through Apress publishing. He is a frequent speaker at SQL community events and is the co-leader for the PASS Virtual Chapter on Virtualization. He frequently teaches Big Data and Microsoft BI related courses for Saint Louis University Workforce and Organizational Development Center. He currently lives in Saint Louis working for Oakwood Systems Group as a Principal Consultant and Data Management Lead.
Arie Jones
Twitter: - @programmersedge
LinkedIn: Arie Jones
Contact: http://www.programmersedge.com
Arie Jones (quot;AJquot;) is one of the owners and Vice President of Emerging Technologies for Indy Data Partners, Inc. in Indianapolis, IN. AJ is a frequent speaker at national conferences and local user groups. With over 15 years of experience in application development and database administration on various platforms, he specializes in developing cross-platform solutions with an emphasis on .NET and SQL Server technologies. He blogs extensively at http://www.programmersedge.com.
Dan Guzman
Twitter: - guzmanda
Contact: http://www.dbdelta.com
Dan Guzman has been using Microsoft SQL Server since version 4.21 was introduced on the Windows Server platform and has 30 years of experience in Database Administrator, Developer, and Architect roles.
Brian Flynn
Brian Flynn has a Computer Science and Math degree from Saint Louis University and has been working in IT for 20 years. He’s served in many roles, both technical and managerial. Brian encourages IT pros to diversify skillsets to build more comprehensive big picture understandings that businesses care about.
Wendy Pastrick
Twitter: - @wendy_dance
Contact: http://wendyverse.blogspot.com
Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Sponsors
The following is a list of sponsors that helped fund the event: