sqlsathistory

Nr: 161

Back to Main list

SQLSaturday #161 - East Iowa 2012

Start Time (24h)	Speaker	Track	Title
00:00:00	David Klee	Room 2	Virtualizing Business Critical SQL Servers
00:00:00	David Klee	Room 4	Database Health and Performance
00:00:00	Dave Valentine	Room 2	Freaky Fast Database Development Tips
00:00:00	Ed Leighton-Dick	Room 4	Practically Normal
00:00:00	Eric Selje	Room 3	SSMS for Developers
00:00:00	Eric Ness	Room 4	Dimensional Data Model Prototyping With PowerPivot
00:00:00	Erin Stellato	Room 1	DBCC Commands: The Quick and the Dangerous
00:00:00	Erin Stellato	Room 1	You’re My Density: Making Sense of Statistics
00:00:00	Kathy Gibbs	Room 2	Best Practices for Monitoring Databases on VMware
00:00:00	Larry Toothman	Room 3	Yesterday I Couldn’t Even Spell ‘DBA’.
00:00:00	Nitin Salgar	Room 3	SQL Azure Federations
00:00:00	Rick Krueger	Room 2	SSRS: Reporting on Reports
00:00:00	Ross McNeely	Room 4	GeoGRAPHY Spatial Analysis
00:00:00	Russell Fustino	Room 2	Silverlight Reporting and Windows Phone Dev
00:00:00	Russ Allen	Room 2	Automating SQL Server Administration
00:00:00	Sanil Mhatre	Room 4	Unit Testing made easy for Database Development
00:00:00	Luke Jian	Room 3	Anatomy of a Join
00:00:00	Andy Thiru	Room 3	SQL Azure Intro and what’s New
00:00:00	William E Pearson III	Room 1	PowerPivot for Excel: For Those Unacquainted ...
00:00:00	Arie Jones	Room 1	PWNED! Security, SQL Server, and You!
00:00:00	Arie Jones	Room 1	Master Data Services in SQL Server 2012

SessionID: 12572

Virtualizing Business Critical SQL Servers

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 2

Speaker: David Klee

Title: Virtualizing Business Critical SQL Servers

Abstract:

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.

SessionID: 12573

Database Health and Performance

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 4

Speaker: David Klee

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.

SessionID: 13263

Freaky Fast Database Development Tips

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 2

Speaker: Dave Valentine

Title: Freaky Fast Database Development Tips

Abstract:

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)

SessionID: 13718

Practically Normal

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 4

Speaker: Ed Leighton-Dick

Title: Practically Normal

Abstract:

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.

SessionID: 13903

SSMS for Developers

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 3

Speaker: Eric Selje

Title: SSMS for Developers

Abstract:

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.

SessionID: 13911

Dimensional Data Model Prototyping With PowerPivot

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 4

Speaker: Eric Ness

Title: Dimensional Data Model Prototyping With PowerPivot

Abstract:

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.

SessionID: 13948

DBCC Commands: The Quick and the Dangerous

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 1

Speaker: Erin Stellato

Title: DBCC Commands: The Quick and the Dangerous

Abstract:

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.

SessionID: 13949

You’re My Density: Making Sense of Statistics

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 1

Speaker: Erin Stellato

Title: You’re My Density: Making Sense of Statistics

Abstract:

The Query Optimizer uses statistics to decide how to execute a query. If statistics are out of date, improperly sampled or simply don’t exist, then you could unintentionally deceive the Optimizer. Accurate statistics can help avoid poor query plans, so if you’re not familiar with how to read a histogram, the various options for updating statistics or want to know why sample size does matter, this session is for you! We will also delve into what happens when a value doesn’t exist in a statistic, discuss methods to manage statistics for volatile tables and examine the challenges that exist with statistics on partitioned tables. Expect a session filled with demos and real-world examples that will create a foundation of statistics knowledge.

SessionID: 17981

Best Practices for Monitoring Databases on VMware

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 2

Speaker: Kathy Gibbs

Title: Best Practices for Monitoring Databases on VMware

Abstract:

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.

SessionID: 18961

Yesterday I Couldn’t Even Spell ‘DBA’.

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 3

Speaker: Larry Toothman

Title: Yesterday I Couldn’t Even Spell ‘DBA’.

Abstract:

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.

SessionID: 21464

SQL Azure Federations

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 3

Speaker: Nitin Salgar

Title: SQL Azure Federations

Abstract:

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

SessionID: 23024

SSRS: Reporting on Reports

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 2

Speaker: Rick Krueger

Title: SSRS: Reporting on Reports

Abstract:

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)

SessionID: 23463

GeoGRAPHY Spatial Analysis

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 4

Speaker: Ross McNeely

Title: GeoGRAPHY Spatial Analysis

Abstract:

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.

SessionID: 23608

Silverlight Reporting and Windows Phone Dev

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 2

Speaker: Russell Fustino

Title: Silverlight Reporting and Windows Phone Dev

Abstract:

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.

SessionID: 23615

Automating SQL Server Administration

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 2

Speaker: Russ Allen

Title: Automating SQL Server Administration

Abstract:

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.

SessionID: 23944

Unit Testing made easy for Database Development

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 4

Speaker: Sanil Mhatre

Title: Unit Testing made easy for Database Development

Abstract:

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.

SessionID: 24320

Anatomy of a Join

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 3

Speaker: Luke Jian

Title: Anatomy of a Join

Abstract:

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.

SessionID: 27337

SQL Azure Intro and what’s New

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 3

Speaker: Andy Thiru

Title: SQL Azure Intro and what’s New

Abstract:

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

SessionID: 28062

PowerPivot for Excel: For Those Unacquainted ...

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 1

Speaker: William E Pearson III

Title: PowerPivot for Excel: For Those Unacquainted ...

Abstract:

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.

SessionID: 9825

PWNED! Security, SQL Server, and You!

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 1

Speaker: Arie Jones

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

SessionID: 9826

Master Data Services in SQL Server 2012

Back to calendar

Event Date: 11-08-2012 - Session time: 00:00:00 - Track: Room 1

Speaker: Arie Jones

Title: Master Data Services in SQL Server 2012

Abstract:

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.

This site is open source. Improve this page.