Event Location:
Chandler-Gilbert Community College Pecos Campus
2626 E Pecos Road
Phoenix, Arizona
Abstract:
The DBA can be the last line of defense guarding the integrity of their company’s data. Taking this responsibility seriously will make you more successful in your job. This session will discuss how the DBA can proactively ensure the data in their transactional system is clean and correct. The presenter will take a comprehensive view of this crucial aspect of the DBA’s job, drawing on many real-life examples. The topics covered will include table design, transactions, change management, and coding standards. She will explain how these distinct topics are actually part of an integrated approach to data protection. The presenter will also describe how pessimism and vigilance can be valuable traits for a DBA.
Speaker(s): Denise McInerney,
Abstract:
We will implement several code samples based on a series of articles amd posts identifying similar records between two different sources or grouping of records from a single source, based on existing column string of values. We will define an approach, review actual implementations with various SQL tools(TSQL, VB,SSIS and MDS). There are many facets to review. I would like to start by drawing concepts from several articles from experienced practitioners, either from academia or the commercial market. They will be footnoted at the end of the session. Although we are discussing matching, we need to address several steps prior to getting to the actual use of matching algorithms
Speaker(s): Ira Warren,
Abstract:
An overview of Database Mirroring.
Speaker(s): Robert Miller,
Abstract:
Reporting Services has quickly become and enterprise class report delivery system. As such, user adoption can grow quite rapidly and before you know it higher usage can bring the Report Server to its knees. This is why monitoring and maintaining reporting services from the beginning is important part of any deployment. In this session we will cover common scenarios for monitoring reporting services performance, tracking down performance issues and troubleshooting errors. We will also review solutions to improve performance in the report execution and engine configuration. Finally, we will discuss techniques to scale up and scale out to distribute load and isolate various forms of activity.
Speaker(s): John Racer,
Abstract:
A real life application of the Confio product Ignite8 to solve one companies serious production issues. This session will touch on many SQL Server tools, disciplines and resources and bring them all together into a synergy of useful index generation, interpreting execution plans, and using Benchmark Factory to get real performance measurements.
Speaker(s): Dale Cunningham,
Abstract:
Recently I have had a client that required migrating and re hosting a data warehouse from the Oracle environment to the Netezza Appliance. The application had hundreds of tables and almost 2900 Source to Target Mappings. This would have taken 1000's of hours of manual coding. For this client we implemented a reusable data driven architecture , via SSIS, that relys on a metadata mart. The end result a greatly reduced TCO(developemnt effort) for generating the code required vs manual cosing. In addition the process leaves behind a metadata mart to report on for auditing and other Data Governance efforts. We generated over 100,000 lines of code and over 3000 load scripts
Speaker(s): Ira Warren,
Abstract:
After creating and activating a Database Mirror, how do you manage and monitor your Mirror?
Speaker(s): Robert Miller,
Abstract:
We'll touch on SQL Profiler and review its best practices so that you don't impact the production system while gathering data. We'll take a deep dive into server-side traces (SQL Trace) and show how you can run a constant server-side trace with little impact on the production system. We'll also examine the things that I look for when troubleshooting performance issues.
Speaker(s): Tara Kizer,
Abstract:
Come learn how to create your first cube using SSAS. In this session, we will start from scratch and create an Analysis Services solution including setting up the data source, data source view, dimensions, hierarchies, attribute relationships, and creating some custom measures. At the end of the session we will browse the cube using Excel to create some ad-hoc reports.
Speaker(s): Amy Lewis,
Abstract:
Come learn how to use Integration Services to create an ETL (Extract, Transform, and Load) solution for populating your data marts/data warehouse. This session will cover best practices for dimension and fact table loading, package configurations, package variables, error and event handling, and SSIS package deployments.
Speaker(s): Amy Lewis,
Abstract:
Independent BI consultant, MSSQL Server MVP, and practicing CPA Bill Pearson examines the various options available for organizing and protecting your consulting business. In this section, he covers C Corp, S Corp, LLC, Partnership, and Sole Proprietorship (“Schedule C”) options, as well as other practical advice (trademarks, etc.) useful in forming your business entity.
Speaker(s): William E Pearson III,
Abstract:
With the introduction of Report Builder in Reporting Services 2005, end users were given the tools to create self-service Reporting Services reports quickly and easily. In this session we will discuss concepts of the Report Model including Entities, Attributes, Roles and other components. We will discuss organization and security within the Report Model to protect data and create a logical view for the business. Then we will cover the methods for creation of an over an existing database and modify them to support specific needs. Once we deploy the Report Model we will build reports and see how the evolution of the Report Builder has enhanced the self-service reporting experience.
Speaker(s): John Racer,
Abstract:
Many DBAs and developers are faced with tuning poorly performing SQL statements. There is no way to learn everything you need to know about SQL tuning in an hour, but you can learn a process to employ when badly written SQLs are ruining database performance. However, many tuning projects fail because the process being used is inefficient. This presentation will walk through a process Confio Software uses with great success and will include topics such as: SQL diagramming, wait type data, column selectivity, and several more that will help you succeed on future tuning projects.
Speaker(s): Janis Griffin,
Abstract:
In this session we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.
Speaker(s): William E Pearson III,
Abstract:
Server monitoring can be expensive and is generally licensed for only critical production servers. In this session, learn how to utilize Powershell along with SMO to not only be proactive, but productive in monitoring the servers in your environment. Attendees will come away from the session with an understanding of how to read the server event logs, check backups, and collect performance metrics. This will be useful for general monitoring in your environment and can also be used for collecting data in a physical to virtual migration.
Speaker(s): Zach Mattson,
Abstract:
Creating backups is one of the fundamental skills every DBA should know, but there are a plethora of choices when it comes to how you will back up your databases. Learn the options with SQL server, what each choice will do for you and when to use each one.
Speaker(s): Meredith Ryan-Smith,
Abstract:
Many of us started our IT careers in the exact same way: 80-hour work weeks, routine overnight gigs, no life outside the office—this was simply what we considered “normal.” Today, with our careers underway, how do we build a life outside of our IT world? I will share the tips, tricks and tools I’ve discovered and used to create a work/life balance that allows us to feel fulfilled and refreshed outside the office while maintaining our effectiveness as successful data professionals.
Speaker(s): Meredith Ryan-Smith,
Abstract:
In this sessions, you will learn about the various data collection strategies that are available for SQL Server 2008 R2 and with System Center Operations Manager to help you in troubleshooting and capacity planning for your applications. You'll see what strategies you can use during application development, deployment, and operating in production. You'll also learn how to use the data collected for capacity planning.
Speaker(s): Bill Ramos,
Abstract:
In this session, we'll look at using Visual Studio Database Edition tools in Visual Studio 2008 and 2010 to develop and deploy databases. We'll review how to manage your database changes, publish incremental changes to a development database, and how to deploy your database into a production environment.
Speaker(s): Michael Collins,
Abstract:
Bill Ramos will share with you how the Microsoft SQL Server development team designed the new SQL Server Denali Always On dashboard for the Availability Group feature that will be available later this year. Bill walk through how the team started with a vague idea of a new UI, capturing the functional requirements, verifying the metrics for success, and creating the first round of prototypes to validate with concepts with the TAP customers.
Speaker(s): Bill Ramos,
Abstract:
You can't develop software in 2010 without considering the impact of running applications in the cloud instead of your own servers. Microsoft has expanded SQL Server to the cloud with SQL Azure. In this session, we'll take a look at SQL Azure and how to get started with it. We'll cover best practices of developing solutions based around SQL Azure. Finally, we'll cover what features that SQL Azure doesn't have and things that you have to know when developing applications for the Azure platform.
Speaker(s): Michael Collins,
Abstract:
This session will describe OLAP Cube partitioning with practical examples. Hands on demonstration of OLAP cube Usage Based Optimization will be performed. The session will identify the QueryLogTable and QueryLogSampling settings , and how the contents of the QueryLogTable are used will be explained with practical examples.
Speaker(s): ORION GEBREMEDHIN,
Abstract:
We will be getting back to the basics of Microsoft SQL Server and looking in depth at all of the object types within SQL Server as well as the commands to work with them. All to often people focus on the advanced high end parts of SQL Server without getting a good grounding in the basics of SQL Server.
Speaker(s): Denny Cherry,
Abstract:
Management Data Warehouse (MDW) which was introduced in 2008 can provide DBAs with useful performance information about Disk Usage, Server Activity and Query Statistics. This presentation will explore how to set up MDW, look at its underlying schema / statistics and point out some of its shortcomings in comparison with other performance tools.
Speaker(s): Janis Griffin,
Abstract:
This will be a 100 level class that discusses the basics of powershell, how to set it up, how to use it, and how it will help the DBA be more productive.
Speaker(s): Colin Smith,
Abstract:
This session will deal with a detailed explanation of SSRS report delivery methods. And will focus on the two types of report delivery subscriptions; standard and Data Driven Subscriptions. A working demonstration of both methods will be shown. In the render device settings, we will discuss how we can can use device information settings on the report server to customize rendering and to override the default values that are supplied by the server. A practical demonstration will be provided.
Speaker(s): ORION GEBREMEDHIN,
Abstract:
In this session we'll be looking at all the various places within the application stack that data can be encrypted. This includes the application layer, the database layer, encrypting over the wire, transparent data encryption, encrypting using your MPIO driver and offloading encryption to your HBAs.
Speaker(s): Denny Cherry,
Abstract:
Illustrate methods for cursor alternatives including real world examples using: -set based logic -coalesce -while loops -common table expressions
Speaker(s): Jonathan Atkins,
Abstract:
In this session we will cover the basics and delve into the advanced techniques which can be used to cluster Windows servers using the Windows Cluster Service, what sort of protection this provides you, and how to properly set up your clusters for a rock solid environment which will last you for many years to come. We will start with planning our cluster configuration, selecting our software, and walk through the process of clustering two servers together into an active passive cluster. We will cover the differences between a standalone machine and clusters with regard to licensing and multiple instance configurations.
Speaker(s): Denny Cherry,
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/pub/janis-griffin/0/914/aba
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.
Contact: http://mfcollins3.github.com
Michael Collins is a Product Architect for Neudesic, LLC. Prior to joining the product team, Michael was the practice director for custom application development for the Phoenix region. Michael has been developing software professionally since 1994. Michael’s interests include computer architecture, electrical engineering, software engineering, algorithms and data structures, operating system theory, compiler theory, and database management systems.
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/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Contact: http://widba.blogspot.com
Zach Mattson is a reformed DBA turned BI Developer for Trek Bicycle Company in Waterloo, WI. Zach has spoken at multiple community events and been published several times on using Powershell for SQL Server monitoring. He now works from home full time, guarded full time by his yellow labs while developing solutions utilizing the full BI stack of Microsoft tools.
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/pub/janis-griffin/0/914/aba
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.
Contact: http://mfcollins3.github.com
Michael Collins is a Product Architect for Neudesic, LLC. Prior to joining the product team, Michael was the practice director for custom application development for the Phoenix region. Michael has been developing software professionally since 1994. Michael’s interests include computer architecture, electrical engineering, software engineering, algorithms and data structures, operating system theory, compiler theory, and database management systems.
Contact: http://blogs.msdn.com/billramo
I'm currently a Work Stream Manager for Advaiya. During my 15 years at Microsoft as a program manager, I shipped or been deeply involved in the following products: Project Houston, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7.0, SQL Server 6.5, Ashton-Tate/Microsoft SQL Server for OS2 (at Ashton-Tate), Excel 2003, Access 2003, Access XP, Access 2000,
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
LinkedIn: https://www.linkedin.com/in/dalecunningham
Contact: http://www.dalecunningham.com
Dale Cunningham is a Sr. Database Administrator and has worked for enterprises both large and small. Performance tuning, Clustering, High Availability and Disaster Recovery are his preferred fields of focus in the MS SQL arena. In his spare time, Dale enjoys flying as a private pilot and playing racquetball. As a father of 5 children and grandfather to 4, family is an important part of his life. Dale enjoys visiting foreign countries and exploring the world. He has recently been married to a wonderful woman from Ukraine and they enjoy traveling the world together. Dale desires to build a home that is energy self-sufficient by using solar, wind and hydro electric power. He enjoys Call of Duty on XBox under the handle XO UEG Barricuda.
LinkedIn: https://www.linkedin.com/in/millerrobert
Contact: http://sqlhuman.com
Robert Miller has managed Microsoft SQL Server implementations for the past twenty years. Additional, he is an accomplished architect, application developer, SAN and Systems administrator. In addition to Microsoft SQL Server, he has experience with Oracle and VMS/Rdb database environments. Robert#39;s specialty is working in and architecting high-performance, high-availability environments.
LinkedIn: https://www.linkedin.com/in/amylewisaz?
Contact: http://amylewisAZ.wordpress.com
Data and Business Intelligence Architect and Developer with over 20 years experience in a variety of industries. My current focus is the development of end-to-end business intelligence solutions using the Microsoft Business Intelligence suite of products.
A Microsoft Certified Business Intelligence Developer/Architect with hands on expertise in concept to completion of business intelligence applications/solutions. Expertise in end to end Development of multi-tier BI Data warehousing application for various line of business across multiple domains. Specialties •Architecture and development of business intelligence solutions using SQL Server BI tools: ETL, OLAP and Presentation Layers. •Agile Development
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.
Contact: http://www.speeddba.com
Database Administrator, Business Intelligence Developer and Data Warehouse Designer with strong knowledge of retail, telecommunications, care center, compensation and business operations systems. Over 11 years of IT experience including implementation and maintenance of SQL Server Multi-Terabyte High-Availability environments. Driven by the challenge to understand business and processes and apply this knowledge create innovative applications of technology to improve organizational efficiency.
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
LinkedIn: https://www.linkedin.com/in/amylewisaz?
Contact: http://amylewisAZ.wordpress.com
Data and Business Intelligence Architect and Developer with over 20 years experience in a variety of industries. My current focus is the development of end-to-end business intelligence solutions using the Microsoft Business Intelligence suite of products.
A Microsoft Certified Business Intelligence Developer/Architect with hands on expertise in concept to completion of business intelligence applications/solutions. Expertise in end to end Development of multi-tier BI Data warehousing application for various line of business across multiple domains. Specialties •Architecture and development of business intelligence solutions using SQL Server BI tools: ETL, OLAP and Presentation Layers. •Agile Development
LinkedIn: https://www.linkedin.com/in/millerrobert
Contact: http://sqlhuman.com
Robert Miller has managed Microsoft SQL Server implementations for the past twenty years. Additional, he is an accomplished architect, application developer, SAN and Systems administrator. In addition to Microsoft SQL Server, he has experience with Oracle and VMS/Rdb database environments. Robert#39;s specialty is working in and architecting high-performance, high-availability environments.
Meredith is a DBA, wife and mother to the only 5-year-old on the block who can recite Codd’s Law. With more than 10 years of experience in IT, Meredith’s responsibilities have included everything from manning the Help Desk to VAX/VMS cluster administration. Most recently she has served as the production database administrator specializing in cluster administration and performance.
Contact: http://itknowledgeexchange.techtarget.com/dba/
I am a SQL Server and Oracle DBA. I focus mostly on SQL Server. I use Powershell every day and I make my life as a DBA much easier by scripting most tasks in Powershell. I enjoy helping others with Powershell and SQL Server, even though I claim to be an expert in neither. I enjoy technology and spending time with my wife and new child.
Contact: http://www.atkinsps.com
Jonathan Atkins works for a national bank developing .NET applications and is also a SQL/Oracle database developer. He started Atkins Professional Services which specializes in building Silverlight, ASP.net, and SQL Server line of business and reporting solutions. Jon enjoys public speaking, teaching financial literacy, exercising, and Indian food.
LinkedIn: https://www.linkedin.com/in/denisemcinerney/
Contact: http://weblogs.sqlteam.com/denisem/default.aspx
Denise McInerney is a data professional with over 20 years of experience. She began her career as a database administrator and has worked as a data analyst and data engineer. She now works as a data architect at Intuit, where she designs and implements analytics solutions with a focus on enabling the work of analysts, data scientists, and business users. Denise is active in technical community organizations and has spoken at user groups and conferences over two dozen times. She served on the PASS Board of Directors for six years.
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
Contact: http://blogs.msdn.com/billramo
I'm currently a Work Stream Manager for Advaiya. During my 15 years at Microsoft as a program manager, I shipped or been deeply involved in the following products: Project Houston, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000, SQL Server 7.0, SQL Server 6.5, Ashton-Tate/Microsoft SQL Server for OS2 (at Ashton-Tate), Excel 2003, Access 2003, Access XP, Access 2000,
Contact: http://meredithryansmith.wordpress.com
Meredith is the database administrator for The Bell Group. With more than 10 years of experience in IT, Meredith’s responsibilities have included everything from manning the Help Desk to VAX/VMS cluster administration. Most recently she has served as the production database administrator specializing in cluster administration and performance. Meredith has attended seven PASS Summits, and had volunteered with the WIT Virtual Chapter since early 2009. Most recently Meredith became the chapter leader for the Women In Technology Virtual Chapter, and has kept busy speaking at SQLSaturday events in the western half of the US.
Contact: http://www.speeddba.com
Database Administrator, Business Intelligence Developer and Data Warehouse Designer with strong knowledge of retail, telecommunications, care center, compensation and business operations systems. Over 11 years of IT experience including implementation and maintenance of SQL Server Multi-Terabyte High-Availability environments. Driven by the challenge to understand business and processes and apply this knowledge create innovative applications of technology to improve organizational efficiency.
Contact: http://weblogs.sqlteam.com/tarad
Tara Kizer has 16 years of experience with SQL Server, 13 of it as a DBA. She currently works at Qualcomm, where she is a DBA supporting mission critical systems with high performance and high availability requirements. She has been a Microsoft SQL Server Most Valuable Professional (MVP) since July of 2007. She is one of the top contributors (34k+ posts) in the SQLTeam.com forums and posts under the username tkizer.
The following is a list of sponsors that helped fund the event.