SQLSaturday #19 - East Iowa 2009
Event Date: 10/17/2009 00:00:00
Event Location:
- University of Iowa
- 101 Jessup Hall
- East Iowa, Iowa
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: An Introduction to ASP.NET MVC
Abstract: ASP.NET MVC is Microsoft’s implementation of an old design pattern, which fits web development better than ASP.NET does. It simplifies multiple aspects of web development that were complex in ASP.NET. It also gives ASP.NET developers a better and more accurate abstraction layer over the web. For example it doesn’t use the problematic ViewState object. It removes most of the overly complex page lifecycle and it simplifies the ability to unit test web requests.
In this presentation we’ll explain the MVC terminology and then we’ll explore how to work with Controllers, Actions, Views and the Model. Then we’ll walk though a real but simple ASP.NET MVC site so you can leave this session with enough knowledge to start a new ASP.NET MVC project.
Speaker(s):
- Chris Sutton
Track and Room: App Dev II - N/A
Title: Introduction to PowerShell
Abstract: PowerShell is Microsoft’s next-generation command-line shell and scripting language. In this session we will discuss why you need it, how to use it, and what makes it different from any other shell on any platform. For administrators, Microsoft is investing heavily in PowerShell as the hub for its Windows Server products, starting with Exchange 2007 and SQL Server 2008. For developers, PowerShell provides full access to .NET for Read-Eval-Print loops (REPL), rapid prototyping, object exploration and extensibility. We will take a quick look at features for both groups before diving into an interactive demo, so come prepared with questions you have or problems we can solve together.
Speaker(s):
- Keith Dahlby
Track and Room: App Dev I - N/A
Title: Improving Daily Imports with Partitioned Tables
Abstract: At some point, everyone struggles with loading data to OLTP systems. The business needs the data loaded so that users can work through the data. But the users can’t afford the downtime to get the data into the production tables. In this session we’ll review this problem and how to use partitioning to alleviate this issue.
Prerequisites Basic understanding for partitioned table concepts Familiarity with OLTP systems
Goals:
- Identify situations where partitioned tables can improve database performance
- Demonstrate partitioned table solution for daily imports
- Provide understanding of the pro’s and con’s to selecting partitioned tables as a import solution for an OLTP system
Speaker(s):
- Jason Strate
Track and Room: App Dev I - N/A
Title: Extended Events, Work Smarter Not Harder
Abstract: There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.
Prerequisites Understanding of performance issues that can occur in SQL Server Mid-level skills writing T-SQL code
Goals:
- Define the architecture for Extended Events
- Identify scenarios where Extended Event can be used to troubleshoot performance
- Demonstrate solutions to real-world performance sce
Speaker(s):
- Jason Strate
Track and Room: App Dev I - N/A
Title: SQL Server 2008 R2 - Moving to the Next Level
Abstract: SQL Server 2008 provided us with many features that developers and database administrators have been asking about for years. Separate Date and Time data types, sparse columns, FILESTREAM and compression for both data and backups have made the platform better than ever. So how do you build on a platform that strong? By adding features like multi-server management, application management and complex event processing, of course. Come along with me as we explore these new features with the August CTP of SQL Server 2008 R2.
Speaker(s):
- Chuck Heinzelman
Track and Room: App Dev II - N/A
Title: Tips Tricks For Administering SQL Server
Abstract: Having had to support a large number of SQL Server instances as a solo DBA for many years I’ve developed a toolbox of scripts that I rely on to give me insight into disk space, database file growth, backup status, job status, and login management. Some of these I’ve shared on mssqltips.com, others are seeing the public light for the first time. Attendees go home with scripts they can immediately put to use in their organizations.
Speaker(s):
- Tim Ford
Track and Room: Administrative / Platform - N/A
Title: Drive Your Way to the DMV
Abstract: Microsoft SQL Server provides a wealth of information at your fingertips through Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs). Information that was used difficult or pert near impossible to obtain is now at your fingertips. Unfortunately there are many find DMVs and DMFs mysterious. Step under SQL Servers hood and find answers to some common issues through DMVs and DMFs. From sessions to caches, this presentation will provide a walk-through of some of the more useful DMVs and a take practical look at how they can be used?
Prerequisites Understanding of database administration functions
Goals:
- Provide a definition of key DMVs within SQL Server
- Learn how to use DMVs to discover statistics on the s
Speaker(s):
- Jason Strate
Track and Room: App Dev I - N/A
Title: ABCs of CTEs
Abstract: Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.
Prerequisites Understand of basic T-SQL coding
Goals: Provide an understanding of the purpose and use of CTEs for recursion and derived tables Define the pro’s and con’s to using CTEs in recursion and for derived tables Demonstrate real-world examples detailing methods for using CTEs to solve coding challenges
Speaker(s):
- Jason Strate
Track and Room: App Dev I - N/A
Title: Introduction to Database Mirroring
Abstract: Database mirroring was introduced as a new database-scoped high-availability option in SQL Server 2005 and has quickly become a popular alternative to database clustering and log shipping. We will look at what makes database mirroring a particularly inviting option, the basics behind the technology and implementation as well as discuss first-hand the caveats we discovered during the implementation of database mirroring at the University of Iowa.
Speaker(s):
- Zakir Durumeric
Track and Room: Administrative / Platform - N/A
Title: Database Design
Abstract: In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have proven for many years. Many common T-SQL programming “difficulties” are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can’t use an index efficiently).
Speaker(s):
- Louis Davidson
Track and Room: BI / Relational Theory - N/A
Title: Introduction to SSAS Dimensions
Abstract: This session will provide an introduction to dimensions in SQL Server Analysis Services 2008. We will discuss the different types of dimensions and how to create dimension attributes, hierarchies, and properties. Finally, we’ll discuss the different properties of dimensions used to create more performant SSAS processing and querying.
Speaker(s):
- Jessica Moss
Track and Room: BI / Relational Theory - N/A
Title: Tuna Helper - A Proven Process for Tuning SQL
Abstract: Many DBAs and Developers are faced with tuning poorly performing SQL statements. 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 time data, indexing strategies, column selectivity and several more that will help the you succeed on future tuning projects.
Speaker(s):
- Janis Griffin
Track and Room: App Dev I - N/A
Title: 2 Years of Database Unit Testing: Lessons Learned
Abstract: This presentation is based on two years of real life experience with database unit testing. I will explain in which cases database unit testing is most useful. I will show how we test selects, modifications, and error handling. Also I will demonstrate which common maintenance problems arise when we cover our source code with unit tests and how to deal with them. Duration: 45 minutes
Speaker(s):
- Alex Kuznetsov
Track and Room: App Dev II - N/A
Title: High-Availability Options for Microsoft SQL Server
Abstract: A comparison of SQL high-availability options, by a practitioner who has implemented and managed most all of the various SQL HA approaches. Tim is an operational SQL DBA, charged with keeping SQL servers up and running and optimized, for managed-services customers. We will compare trade-offs between the various SQL HA options: for complexity, usability, hardware requirements, licensing, failover speed, initial costs, ongoing support costs, staff skill requirements, etc.
Speaker(s):
- Tim Plas
Track and Room: Administrative / Platform - N/A
Title: Service Broker: A Brief Introduction
Abstract: Service Broker was introduced in 2005 as an asynchronous message-based communications platform for SQL Server. If configured correctly, Service Broker can be a huge time saver when developing distributed applications. However, it has also become known as one of the trickiest parts of SQL Server to setup correctly. We will go over the basic architecture of service broker and the tricks to get it implemented right, the first time.
Speaker(s):
- Zakir Durumeric
Track and Room: Administrative / Platform - N/A
Title: Defensive database programming
Abstract: I will explain what is defensive database programming, what are its advantages, and provide several simple real life examples that show how to use it. I will demonstrate how to develop robust Transact SQL code that correctly works in high concurrency environments, gracefully handles cases of unintended use, and is easy to maintain in changing environments.
Speaker(s):
- Alex Kuznetsov
Track and Room: App Dev II - N/A
Title: SQL Server 2008 - Practical Uses for New Features
Abstract: When learning a new technology, I like to try to solve a real-world problem that will help me not only learn but also help me in my daily life. Learning SQL Server 2008 was no exception for me. Through the building of an electronic recipe box, I have taken advantage of many of the new features of SQL Server 2008 – including sparse columns, filestream, table-valued parameters, the MERGE statement and even spatial data. Come learn from my experiences as we walk through the design and development of this application – and you can even have the code when we’re done!
Speaker(s):
- Chuck Heinzelman
Track and Room: App Dev II - N/A
Title: Building Reports in SQL Server Reporting Services
Abstract: Let’s learn how to build reports in SQL Server Reporting Services 2008. This presentation will show the features of SSRS 2008 by building multiple reports. We will see how to include HTML in your reports, show various ways to present data, and make your data pop with visualizations.
Speaker(s):
- Jessica Moss
Track and Room: BI / Relational Theory - N/A
Title: Extract, Transform, and Load your Data Warehouse
Abstract: One data warehouse buzzword that often gets used is “ETL”, also known as extract, transform, and load. But what does this really mean from a data warehousing perspective and how do we use SQL Server Integration Services to perform these ETL functions? This session will answer these questions and show solutions to common ETL problems.
Speaker(s):
- Jessica Moss
Track and Room: BI / Relational Theory - N/A
Title: SQL Server 2008: The New and Cool…
Abstract: My developers keep asking me when we’re going to migrate to SQL Server 2008….you keep hearing about SQL Server 2008…. everything from resource governor to spatial data recognition… so what really ARE those new and cool features in SQL Server 2008 and why do you care?
Speaker(s):
- Zakir Durumeric
Track and Room: App Dev II - N/A
Title: The Benefits of SQL Azure
Abstract: This talk will focus on the benefits, features, sign up, code examples and ease of use of SQL Azure. Learn how your projects can benefit from a hosted data storage and query processing service. See by example how to design your program to use SQL Azure.
Speaker(s):
- Aaron King
Track and Room: Administrative / Platform - N/A
Title: Database Design Patterns
Abstract: Beyond database design fundamentals (for example, Normalization) lies the area where you have to create “real” solutions. In this session, I will cover a good number of patterns that we commonly find useful to try to apply to the problem of building a database solution. Ideas like generalization, subclassing, single table domain tables, optional data, and more will be discussed, some of them good, some not so good (don’t assume which will be which), but all that are common and/or useful for your database implementations.
Speaker(s):
- Louis Davidson
Track and Room: BI / Relational Theory - 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.
Alex Kuznetsov
Contact: http://sqlblog.com/blogs/alexander_kuznetsov/default.aspx
Alex Kuznetsov has worked with databases since 1994. Currently he leads database development team for a financial company in Chicago. He wrote multiple articles on database programming and is an active blogger on sqlblog.com. He is a SQL Server MVP.
Louis Davidson
Twitter: - drsql
LinkedIn: Louis Davidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
Aaron King
Contact: http://www.aaronstanleyking.com
Aaron has over 10 years experience in web development. He has designed large applications hosted on dozens of servers across locations that support thousands of users at once and millions of registered users. He has mentored several successful development teams. His main focus is connecting very large databases to internet users thru feature rich Microsoft web applications.
Louis Davidson
Twitter: - drsql
LinkedIn: Louis Davidson
Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/
Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.
Alex Kuznetsov
Contact: http://sqlblog.com/blogs/alexander_kuznetsov/default.aspx
Alex Kuznetsov is a database developer with more than a decade of experience. Alex has written a book entitled “Defensive Database Programming with Transact-SQL”, and contributed to “MVP Deep Dives” and “The Red Gate Guide to SQL Server Team-based Development”. He blogs on sqlblog.com and publishes articles on simple-talk.com and devx.com,.
Zakir Durumeric
Zakir Durumeric is a Systems Administrator at the University of Iowa where he is responsible for Windows based systems and data management within Research Information Systems. Zakir spends his day working with everything from database and application architecture to identity management programming, but one thing is for sure… he lives within SQL Server day-in and day-out.
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
Tim Plas
Twitter: - tjplas
LinkedIn: Tim Plas
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.
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
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.
Zakir Durumeric
Zakir Durumeric is a Systems Administrator at the University of Iowa where he is responsible for Windows based systems and data management within Research Information Systems. Zakir spends his day working with everything from database and application architecture to identity management programming, but one thing is for sure… he lives within SQL Server day-in and day-out.
Chuck Heinzelman
Chuck Heinzelman is a SQL Server MVP and a Senior Database Administrator with Big Hammer Data – a division of Edgenet, Inc. At Big Hammer, his primary role is database design and development, with the occasional sidestep into server configuration and administration. He holds a BS degree in Management Computer Systems and is currently working on his MBA. He has been working with SQL Server since 1998, and also has experience developing Windows and Web applications using Visual Basic and C#.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Zakir Durumeric
Zakir Durumeric is a Systems Administrator at the University of Iowa where he is responsible for Windows based systems and data management within Research Information Systems. Zakir spends his day working with everything from database and application architecture to identity management programming, but one thing is for sure… he lives within SQL Server day-in and day-out.
Tim Ford
Contact: http://thesqlagentman.com
Tim Ford is a Microsoft SQL Server MVP and co-founder of SQL Cruise (sqlcruise.com). He is currently a Senior DBA and the SQL Server SME with Spectrum Health, a major healthcare system located in West Michigan. He is the leader of the West Michigan SQL Server Users Group (westmisql.org) and is a community speaker and author. His book with Louis Davidson: Performance Tuning With SQL Server Dynamic Management Views is now widely available.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Chris Sutton
Contact: http://twitter.com/chrissutton
Chris Sutton is a software developer and technical trainer in Eastern Iowa. He helps run CRineta.org in Cedar Rapids, Iowa and he co-founded the Iowa Code Camp in 2008. Chris is a Microsoft MVP, a Microsoft Certified Trainer (MCT) and holds the MCPD:Enterprise certification. He has been consulting and speaking on the ASP.NET MVC Framework since the beginning of 2008 and loves developing for the web. He also enjoys hiking and biking in the summer with his family and snowshoeing in the winter.
Chuck Heinzelman
Chuck Heinzelman is a SQL Server MVP and a Senior Database Administrator with Big Hammer Data – a division of Edgenet, Inc. At Big Hammer, his primary role is database design and development, with the occasional sidestep into server configuration and administration. He holds a BS degree in Management Computer Systems and is currently working on his MBA. He has been working with SQL Server since 1998, and also has experience developing Windows and Web applications using Visual Basic and C#.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Keith Dahlby
Contact: http://solutionizing.net/
Keith Dahlby is a .NET developer and language geek from Cedar Rapids, IA. He works as a software guru at JP Cycles and blogs about various software development topics at Los Techies. Keith has spoken at community events around the midwest and studied Human-Computer Interaction at Iowa State University. His talks have been described as “terrific!”, “very interactive!”, and “the best I’ve seen all hour!”
Jason Strate
Contact: http://www.jasonstrate.com
Jason Strate, Digineer Inc, has been a Database Architect for over ten years. His experiences include designing and implementing both OLAP and OLTP solutions involving clustering servers, database monitoring and tuning, analysis services, DTS/Integration Services, Reporting Services, and Notification Services. Jason is actively involved with the local PASS chapter (SQL Server User Group); he is currently serving on the Executive Board and has presented at monthly meetings. Jason contributed to M
Sponsors
The following is a list of sponsors that helped fund the event: