Nr: 71
SQLSaturday #71 - Boston 2011
SessionID: 28436
T-SQL : Bad Habits to Kick
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Performance/Monitoring
Speaker: Aaron Bertrand
Title: T-SQL : Bad Habits to Kick
Abstract:
The session will cover a collection of minor bad habits that can occasionally lead to major problems.
SessionID: 28475
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: SSIS/ETL
Speaker: Michael Coles
Abstract:
SessionID: 28551
Understanding Indexes in SQL Server 2008
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Data Development
Speaker: Andrew Kelly
Title: Understanding Indexes in SQL Server 2008
Abstract:
SessionID: 28552
Maximizing Plan Re-use in SQL 2008
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Data Development
Speaker: Andrew Kelly
Title: Maximizing Plan Re-use in SQL 2008
Abstract:
SessionID: 28607
So Many High Availability Options, So Little Time
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Infrastructure
Speaker: Allan Hirt
Title: So Many High Availability Options, So Little Time
Abstract:
Are you confused by the various SQL Server high availability technologies? Do you understand what each one does and where each one may or may not benefit you? Do you know the basics of what you need to implement highly available SQL Server instances and databases? If these burning questions speak to you, so will this session. Whether you are an accidental DBA, new to SQL Server, or looking to brush up your skills, this session will cover the different methods of making SQL Server available, compare and contrast them, as well as and cover the top things both SQL Server and non-SQL Server you need to do to ensure uptime for databases and instances.
SessionID: 28637
15 Powerful SQL Server Dynamic Management Objects
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Performance/Monitoring
Speaker: Adam Machanic
Title: 15 Powerful SQL Server Dynamic Management Objects
Abstract:
SessionID: 28680
SSIS - The New Stuff
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: SSIS/ETL
Speaker: Andy Leonard
Title: SSIS - The New Stuff
Abstract:
Matt Masson and Andy Leonard team up to deliver an overview of new and improved features in SSIS Denali. Andy and Matt focus on:
Stuff that will continue working as is
Stuff you’ll want migrate to use the new features
Stuff you’ll develop for Denali from the ground up
SessionID: 28682
“I See a Control Flow Tab. Now What?”
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: SSIS/ETL
Speaker: Andy Leonard
Title: “I See a Control Flow Tab. Now What?”
Abstract:
This highly-interactive, demo-intense presentation is for beginners and developers just getting started with SSIS. Attend and learn how to build SSIS packages from the ground up.
SessionID: 28939
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Performance/Monitoring
Speaker: Allen White
Abstract:
SessionID: 28940
Let Service Broker Help You Scale Your Application
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Future Directions
Speaker: Allen White
Title: Let Service Broker Help You Scale Your Application
Abstract:
Service Broker was introduced in SQL Server 2005 to provide asyncronous messaging in your database applications, but it's seldom used because it isn't well understood. In this session we'll walk you through the basics of Service Broker and show how you can use it to build highly scalable applications.
SessionID: 28956
SQL Server 2008 Auditing
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Infrastructure
Speaker: Ayad Shammout
Title: SQL Server 2008 Auditing
Abstract:
You may ask yourself, “Who did drop my table? Who altered this Stored Procedure? When did this SQL login grant access to a database? Who inserted, updated or deleted records in a table? Do you need to meet regulatory compliance needs?”
If you’d like to know the answers, this session is for you, I will cover the technical details of the new Auditing feature in SQL Server 2008 with lots of demos and how you can leverage it in your SQL server environment. I will show you how to build a Centralized Auditing Solution where you can view all audit events in your environment centrally with rich dashboards and reports to track and view all audit actions by server, database, object and users across all SQL servers.
SessionID: 28990
PowerPivot, Idea to Solution in 60 Minutes
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Barry Ralston
Title: PowerPivot, Idea to Solution in 60 Minutes
Abstract:
SessionID: 29511
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Performance/Monitoring
Speaker: Chris Skorlinski
Abstract:
SessionID: 29577
Storing Data in the Cloud: Beyond SQL Azure
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Future Directions
Speaker: Bill Wilder
Title: Storing Data in the Cloud: Beyond SQL Azure
Abstract:
We live in world where the management of structured data is dominated by relational databases. What happens when we get to the cloud? You may have heard about SQL Azure, Microsoft's take on SQL Server for the cloud. Won't everything be just like the old days? Not so fast... In this talk we will review some of the key differences between SQL Server and SQL Azure, then consider some of the other data storage options offered by Windows Azure. After this talk you will understand the broader picture of storage in Windows Azure and have a basic understanding of how to employ these complementary data storage solutions -- along-side some of the old-school approaches you currently know and love.
SessionID: 29610
Inroduction to Triggers
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Future Directions
Speaker: Jack Corbett
Title: Inroduction to Triggers
Abstract:
SessionID: 29643
Database Mirroring in the Real World
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Infrastructure
Speaker: Craig Purnell
Title: Database Mirroring in the Real World
Abstract:
A review of Database Mirroring in the context of operations at Baker Hostetler, where mirroring has been a cornerstone high availability tool for over 5 years. A high level look at the key modes of mirroring; specific analysis of setup and configuration problems; various real time monitoring techniques of the mirrored databases; pros and cons of WAN hardware acceleration devices to improve performance; using mirroring to perform a rolling upgrades or to move large databases to a different location.
SessionID: 30378
Axis Technology: Data Masking
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Data Development
Speaker:
Title: Axis Technology: Data Masking
Abstract:
Data Masking is the act of replacing sensitive data with fictitious but realistic data in order to eliminate the risk of exposure to unauthorized parties. Implementing a sustainable data masking program in a modern enterprise environment can be surprisingly challenging—not just technically and organizationally, but culturally. The reactions and concerns you’ll encounter from your development and QA teams are understandable. You’re not just introducing new controls over confidentiality exposures in development and testing systems. You’re shutting off developers’ and testers’ unfettered access to live customer Production data—something that’s been quite normal and convenient for them to date, something they think they just can’t do th
SessionID: 30379
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: SSIS/ETL
Speaker: Ira Warren
Abstract:
SessionID: 30410
Career Development for Local SQL Professionals
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Future Directions
Speaker: Jason Alexander
Title: Career Development for Local SQL Professionals
Abstract:
Whether you are seeking a new position or working to increase your knowledge-base, career development is a hot topic in the greater Boston area. This session will address tips and tactics that successful SQL professionals are utilizing to further their career and increase their income potential. Jason Alexander is the Managing Partner of Alexander Technology Group, a full service consulting and staffing firm focused exclusively on the greater Boston marketplace. Jason also serves on multiple area boards of directors including the Massachusetts and New Hampshire High Technology Councils and speaks frequently on the topic of career development at area colleges and outplacement events.
SessionID: 30638
Building your first SQL Cluster
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Infrastructure
Speaker: Joseph D'Antoni
Title: Building your first SQL Cluster
Abstract:
Interested in high availability, but don't know where to start? This session will start at the ground level and work through all the requirements of building a SQL Cluster environment, including Windows steps, storage steps, and networking needs. Of course, SQL Server will be included in this process.
SessionID: 30657
Introduction to Developing with SQL Azure
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Future Directions
Speaker: Jeff Mlakar
Title: Introduction to Developing with SQL Azure
Abstract:
SessionID: 30822
Encryption in SQL 2008 R2 - Column and TDE
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Data Development
Speaker: John Flannery
Title: Encryption in SQL 2008 R2 - Column and TDE
Abstract:
SessionID: 31196
Women in Technology
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: SSIS/ETL
Speaker: Karen Lopez
Title: Women in Technology
Abstract:
· Is the gender disparity actually an issue
· Why is this still an issue after all these year
· What should we be doing about it
· How can we encourage younger women and girls to consider an IT career
· How can we encourage women to remain in IT
· Other diversity issues
· Call to action
SessionID: 31197
Database Design Contentious Issues
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Data Development
Speaker: Karen Lopez
Title: Database Design Contentious Issues
Abstract:
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as: * Natural vs. Surrogate keys * Varchar(1) and other Varying datatypes * Identity Properties * Naming Standards - Who needs them? * Who Calls the Shots and Who Does What? ...and others. Bring your votes, your debates, and your opinions.
SessionID: 31535
Self Service BI on a Budget
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Rob MacNaughton
Title: Self Service BI on a Budget
Abstract:
SessionID: 31608
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: SSIS/ETL
Speaker: Matt Masson
Abstract:
SessionID: 31833
Consolidation and Virtualization: A Success Story
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Infrastructure
Speaker: Mike Hillwig
Title: Consolidation and Virtualization: A Success Story
Abstract:
Consolidating SQL Server Instances can be daunting. Virtualizing SQL Server instances can be intimidating. Doing both at the same time can be absolutely frightening.
When Mike Hillwig inherited his SQL environment, he had 14 SQL Server instances, running five different versions of SQL, all using local disk. In one project, his team consolidated this down to four servers. And the entire environment is virtual. In this session, MIke will share what they did, how they did it, what worked, and what didn't work so well.
SessionID: 32041
As A DBA, Where Do I Start?!
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Mike Walsh
Title: As A DBA, Where Do I Start?!
Abstract:
SessionID: 32192
SQL Query Optimization - It's Not Rocket Science!
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Performance/Monitoring
Speaker: Paul White
Title: SQL Query Optimization - It's Not Rocket Science!
Abstract:
SessionID: 32972
Vendor Session - Red Gate
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Performance/Monitoring
Speaker:
Title: Vendor Session - Red Gate
Abstract:
TBD
SessionID: 33153
Database Design for mere developers
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: Data Development
Speaker: Steve Simon
Title: Database Design for mere developers
Abstract:
In this session, (aimed at software developers) we shall be touching upon several concepts of special importance to the developer. These include database development "patterns and anti-patterns", final proofing of design and creating versatile deployment scripts that can and will be utilized in future endeavors.
SessionID: 33194
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: SSIS/ETL
Speaker: Douglas Barrett
Abstract:
SessionID: 33265
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Sunil Kadimdiwan
Abstract:
PerformancePoint is now part of SharePoint 2010. You can now get a complete view of your business data using SharePoint and Analysis Services Cubes. How do you create interactive and context driven dashboards? In this session I will demo how you can go about doing this.
SessionID: 33847
Introduction to MDX
Event Date: 02-04-2011 - Session time: 00:00:00 - Track: BI
Speaker: Slava Kokaev
Title: Introduction to MDX
Abstract:
If you want to get the most out of your Analysis Services cube it’s essential to know and understand MDX: you need to be able to write MDX queries and calculations. MDX is part of the underlying foundation for the SSAS (OLAP architecture), and it offers detailed and efficient navigation and drill across of multidimensional data. MDX is designed to ease the process of accessing data from multiple dimensions
This session aimed at those with little or no previous MDX experience will teach you the basic concepts of the language as well as show you how to write common queries and calculations.