Event Location:
University of Iowa
101 Jessup Hall
East Iowa, Iowa
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,
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,
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: 1. Identify situations where partitioned tables can improve database performance 2. Demonstrate partitioned table solution for daily imports 3. 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,
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: 1. Define the architecture for Extended Events 2. Identify scenarios where Extended Event can be used to troubleshoot performance 3. Demonstrate solutions to real-world performance sce
Speaker(s): Jason Strate,
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,
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,
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: 1. Provide a definition of key DMVs within SQL Server 2. Learn how to use DMVs to discover statistics on the s
Speaker(s): Jason Strate,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: http://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.
LinkedIn: http://www.linkedin.com/in/louisdavidson
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.
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
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.
LinkedIn: http://www.linkedin.com/in/louisdavidson
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.
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 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.
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
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://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
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.
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 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#.
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 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.
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.
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.
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 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#.
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.
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!"
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
The following is a list of sponsors that helped fund the event.