Build Schedule

Advanced Filters:
  • Track

    clear all





  • Speaker


  • Level


  • Session Type

Sessions Found: 21
A lot of database professionals today  do not have a Computer-Science Degree  so they never attended a  “Introduction to Databases” course. In this session we are trying to fix at least one thing and we’ll look in depth at the three types of join operations, visualize how their algorithms work in order to understand how query plans are computed, explain why these join operations have very different performance characteristics and why the optimizer chooses a specific  join operator to use in a query plan. Will demonstrate that empirical cost calculations are similar to what Query Optimizer actually outputs. Good understanding of join algorithms is vital in order to diagnose and remedy issues related to bad query plans.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room 3

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session will describe some time-tested techniques that we employ here at the University of Iowa to automate the administration of our 100+ SQL Server instances. I will describe the creation of a DBA utility database, the proper setup and configuration of SQL Server Agent features (operators, database mail, jobs and alerts), and the creation of SQL Server Agent jobs that perform maintenance tasks requiring little human intervention. I will also explain how to create a SQL Server central management server to manage multiple instances from a single SSMS query window.
Speaker:

Session Type:
Regular Session

Track:
Room 2

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

SQL Server on VMware??? Many of our customers are either virtualizing databases or planning to do so soon. I hear from many groups that attempted running their database on VMware but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools, you may be getting misleading data. Understand what metrics are important and how to get to that data.
Speaker:

Session Type:
Regular Session

Track:
Room 2

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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:

Session Type:
Regular Session

Track:
Room 4

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

There are many DBCC statements at the disposal of Database Administrators and Developers. Some are used for the greater good; others can wreak havoc in your system. The majority of these commands are informational, but if you’re not careful you can introduce chaos or at worst, lose data you may never find again. In this session we will explore DBCC commands that are useful for the DBA and developer, and cover when to use them and how. Expect demonstrations that provide a practical application of these commands - both documented and not - that database professionals can utilize quickly and easily.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Data modeling is often an abstract exercise involving a lot of talk and diagrams, but little hands-on experimentation.  This may still be viable in the world of transactional systems where a lack of source data prevents the modeler from quickly creating a prototype system, however in the world of dimensional modeling where source data is abundant there’s no longer a reason to treat data modeling as an academic exercise.  This session will cover how to use PowerPivot for Excel to quickly create prototypes of different dimensional models to try out and discard as necessary.  The features of PowerPivot which allow quick import of data from a variety of data sources will also be demonstrated.
Speaker:

Session Type:
Regular Session

Track:
Room 4

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Join Rick and Dave on this most excellent adventure as they teach you how to get more work done in less time. Leave your checkbook at home, because this is all about maximum productivity with minimum budget. Leave with Visual Studio and SQL Server Management Studio shortcut keys, extensions, and add-ins. We guarantee you will see something you haven’t seen before, or your money back. Co-Presenter: Rick Krueger (@DataOgre)
Speaker:

Session Type:
Regular Session

Track:
Room 2

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Tired of your PostGIS and Oracle friends bragging about all their geography data?  Microsoft continues to support and add features to the spatial data types.  It is time to let your friends know that Microsoft has stepped up.  In this session we will take a deep look at analyzing the SQL Server Geography spatial data type in T-SQL.  We will look at different scenarios to show how you can begin using the Geography data type.  To begin, we will look at using T-SQL to analyze geographic locations and the surrounding geography data.  Secondly, we will look at using T-SQL to analyze geographic lines such as roads, and borders.
Speaker:

Session Type:
Regular Session

Track:
Room 4

Level: Advanced

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Most DBAs at one time or another have been taught the importance of master data management(MDM), which is comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of SQL Server 2012, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the how Master Data Services is implemented in SQL Server 2012, setting up models,  working through the Excel plug-in, and utilizing DQS and business rules to help with that dirty data. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft BI Architect and SQL Server MVP Bill Pearson overviews PowerPivot for Excel, the client side of Microsoft’s foray into self-service BI. The targeted audience includes BI professionals who are seeking an introduction to what PowerPivot offers their organizations. Among others interested will be Excel power users who are fluent with PivotTables and want to understand the new capabilities.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Normalizing a database - splitting apart tables into simpler, more focused tables - can yield concrete benefits, including manageability, scalability, and space savings.  The concept is a central tenet of a relational database system such as SQL Server, yet far too many database professionals are unfamiliar with it.  This session will present a practical primer on normalization: what it is, why it's beneficial, how to do it, and when not to do it.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room 4

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

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 you in definitely help in figuring out what is going on. It'll be AWESOME!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 1

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Join Russ Fustino as he shares how he develops reports for Silverlight viewing and how to use your Silverlight skills developing with the C1 Studio for Windows Phone Controls. This session will focus on the component approach using the ActiveReports  Silverlight Report Viewer. See how the Silverlight Report Viewer is simple, lightweight, flexible, localizable, and easy to customize for quick end user deployment.  Studio for Windows Phone enables Silverlight developers to create advanced phone applications with ease. These controls are designed to enhance and extend the rich user experience of the Windows Phone 7, making effective use of the phone’s form factor, touch and gesture capabilities, and Metro theme.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 2

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

This session is to introduce to SQL Azure Federations.

Will walk you through the process of setting up federation, managing feredations etc and converting an existing database to Federations. 

This topic requires rudimentary SQL Azure understanding
Speaker:

Session Type:
Regular Session

Track:
Room 3

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

In this session, you will get introduced to SQL Azure and learn how to get started. We will explore how to migrate an existing on-premise SQL Server database to SQL Azure. We will then walkthrough how to manage and administer your SQL Azure servers and databases. We will take a look at how to connect and build applications using SQL Azure. Next, we will look at more advanced scenarios using new capabilities like reporting with SQL Azure Reporting, synchronizing data with SQL Azure Data Sync for hybrid scenarios and global reach. Finally, we will explore some of the things you should consider when using SQL Azure
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Room 3

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

You're a database application developer who's using SQL Server now, but you're no DBA. Sure you use SQL Server Management Studio (SSMS), and maybe you're even pretty good at designing tables and executing queries. But there's a whole lot more functionality in this seemingly simple program than you may realize. In this session we'll share features in SSMS that you may have overlooked but will make your life as a developer a lot easier.

This session is good for anyone who spends some time in SSMS and wants to pick up some time-saving tips and tricks.
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Room 3

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Business Intelligence gets a lot of press these days, but do you often wonder to yourself as you are writing a report, ‘Who is going to use this’? Learn about the rich information that SSRS is already capturing for you about your reports: who is running them and how often, how long do they take to execute, how much time is spent in data retrieval vs rendering, which parameters were passed in, and more…

Co-Presenter: Dave Valentine (@IngeniousSQL)
Speaker:

Session Type:
Regular Session

Track:
Room 2

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Though most developers agree that unit testing plays an important role in software development, to ensure quality and meet milestones, most developers write unit tests only as an afterthought. Visual Studio Team System (VSTS) helps to mainstream Test Driven Development methodology (TDD) into world of database development.  Unit testing presents a unique challenge in Database development, because of the need to provide a consistent test environment.
In this session, we will not only cover the basis of unit testing concepts and terminology, but also discuss how unit testing helps ensure and document the quality and accuracy of database deliverables. We will run through a demo of creating and running database unit tests using VSTS 2010.
Speaker:

Session Type:
Regular Session

Track:
Room 4

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, and David Klee (@kleegeek) will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments and prepare your organization for the change. Practical tips, tricks, and gotcha’s will be discussed in this dynamic dialog session.
Speaker:

Session Type:
Regular Session

Track:
Room 2

Level: Intermedia

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Referred to as “DBA by Default” or “Reluctant DBA”, many people are faced with the situation of suddenly becoming a SQL Server database administrator.  Once the initial shock passes they realize that they need help. The abundance of SQL Server books and websites that exist, some good and some not so good, might only increase confusion leading to panic and rash decisions. DON’T PANIC! In this session we will cover ways to address basic problems and offer some suggestions for finding good places to find help. 
Speaker:

Session Type:
Regular Session

Track:
Room 3

Level: Beginner

Session Code:

Date: August 11

Time: 12:00 AM - 1:00 AM

Room: TBD

Sessions Found: 21
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids