Nr: 93
SQLSaturday #93 - Toronto 2011
SessionID: 28984
Build a Scale-Out Reporting Services 2008 R2 Farm
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Edwin Sarmiento
Title: Build a Scale-Out Reporting Services 2008 R2 Farm
Abstract:
Delivering reports is becoming more critical due to the increasing demand for business intelligence solutions. And while there are a lot of guides that walk us through building a highly available database engine, you’ll rarely see one for SQL Server Reporting Services. This session will walk you through building a scale-out SQL Server 2008 R2 Reporting Services farm from the ground up. You’ll be surprised how easy it is to do so that you can start building your own test environment.
SessionID: 28986
Database Recovery Techniques To Keep Handy
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Edwin Sarmiento
Title: Database Recovery Techniques To Keep Handy
Abstract:
Nothing is more frightening to a DBA as getting that wake-up phone call that the system is down, especially when it's a mission critical one.This session will focus on being prepared for and dealing with a recovery situation for a SQL Server 2005/2008 database, an instance or an entire server. Topics covered will be backup schemes, partial backups and piecemeal restores, and page-level recovery
SessionID: 28988
Gone Clustering in 60 Minutes
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Edwin Sarmiento
Title: Gone Clustering in 60 Minutes
Abstract:
Creating a SQL Server 2008 Failover Cluster on Windows Server 2008 has become a lot easier with the availability of online resources such as blog posts and articles. However, making it easy does not mean ignoring the basic principles of the underlying technology. In this session, learn the fundamentals and principles behind how Windows Failover Clustering works and how SQL Server leverages on the technology, allowing you to build highly available database infrastructures.
SessionID: 29517
CAMP Geekalot for DBAs
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Expanded Horizons
Speaker: Chris Skorlinski
Title: CAMP Geekalot for DBAs
Abstract:
This instructor lead workshop encourages open dialog by all attendees as they share experience and best practices around key SQL Server DBA topics like 1) how big is your database? 2) Disaster planning, 3) security, security, security, 4) common server best practices, 4) common SQL best practices
SessionID: 29518
Transactional Replication – Follow the Data
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Chris Skorlinski
Title: Transactional Replication – Follow the Data
Abstract:
Okay, you’ve run the Wizard and have Replication up and running; but how does it really work? Learn the behind the scenes for Transactional Replication as we follow the data from Publisher to Subscriber. We’ll look at both design and troubleshooting techniques to ensure your data is moving at near-real-time through your topology.
SessionID: 29519
How to get Hired in the first 10 minutes
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Expanded Horizons
Speaker: Chris Skorlinski
Title: How to get Hired in the first 10 minutes
Abstract:
Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. We’ll cover key strategies you can use during the interviews first 10 minutes to increase chances for a new job and new adventure.
SessionID: 29531
Implement data validation strategies with SSIS
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Christian Cote
Title: Implement data validation strategies with SSIS
Abstract:
SessionID: 29532
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Christian Cote
Abstract:
Too many times, database maintenance and deployment represent a challenge during application development. And now with Visual Studio 2010, Oracle databases are first class citizens of development solutions. This session will demonstrate how Visual Studio Database Development Tools can ease database managements, deployment and version control integration. New features of 2010 will be covered as well as database unit testing and data generation. Developers will learn how database can be part of their Visual Studio solutions and how easy it is to deploy database objects with other projects.
SessionID: 30377
There Is a Better Way to Back Up Your SQL Servers
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Islam Gomaa
Title: There Is a Better Way to Back Up Your SQL Servers
Abstract:
SQL Server administrators are looking for a better way to protect and recover SQL Server databases. In this session Islam is going to present how to back up your SQL Server efficiently using System Center Data Protection Manager 2010, he will show cases on how to backup advanced SQL Server configuration such as SQL Server clustering, SQL Server mirrored databases, log shipping or Simple recovery model” configurations.
SessionID: 30445
Don't Panic, DBAs! Databases on VMware made easy.
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Expanded Horizons
Speaker: Janis Griffin
Title: Don't Panic, DBAs! Databases on VMware made easy.
Abstract:
More and more companies are virtualizing with VMWare, and databases are the next logical step. This presentation will explore the fundamentals of monitoring databases running in a VMWare environment because it can be much different than when running on a physical machine. You will learn business and technical benefits of virtualization, master new terms and concepts, pick up useful planning tips and tricks, and cover best practices for maintaining optimum performance in a VMWare environment.
SessionID: 30446
Looney Tuner? No, there IS a method to my madness!
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Janis Griffin
Title: Looney Tuner? No, there IS a method to my madness!
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
SessionID: 31065
XML in SQL Server. Why bother?
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Expanded Horizons
Speaker: Jean Rene Roy
Title: XML in SQL Server. Why bother?
Abstract:
SessionID: 31069
What is MS Sync. Framework
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Expanded Horizons
Speaker: Jean Rene Roy
Title: What is MS Sync. Framework
Abstract:
SessionID: 31765
Architecting Microsoft SQL Server Availability in
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Michael Lato
Title: Architecting Microsoft SQL Server Availability in
Abstract:
The addition of virtualization support has changed the way architects and DBAs need to look at availability in the SQL Server world. How does Hyper-V Live Migration or vMWare's vMotion work in conjunction with existing SQL Server availability technologies like log shipping, database mirroring, or replication? As you architect your SQL Server infrastructure virtually, what do you need to know to ensure that you help provide the best solution using available technologies? Through demonstration using a scenario-based approach, learn when and how to use virtualization availability features and Windows Failover Clustering in combination with SQL Server technologies and the impact of combining them. See how Live Migration does not cover you in al
SessionID: 31766
Discovering the Delta: SQL Server to SQL Azure
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Development
Speaker: Michael Lato
Title: Discovering the Delta: SQL Server to SQL Azure
Abstract:
Brain hurting from technology overload? The endless talk about cloud? Private cloud, public cloud, Windows Azure, SQL Azure, Office 365, Cloud is everywhere! When it comes to SQL though, there’s good news - if you know SQL Server, you already know 90% of SQL Azure. In this session, you’ll learn the differences between SQL Server and SQL Azure and how you can use your existing SQL knowledge to start creating solutions in the Cloud.
SessionID: 31935
Obliterate Excessive Blocking and Deadlocking
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Administration
Speaker: Michael Swart
Title: Obliterate Excessive Blocking and Deadlocking
Abstract:
Your databases are getting bigger and busier and you need to make the most out of the hardware you have. On your servers, excessive locking can often cause timeouts and database traffic jams! In this session I explore steps you can take to address unexpected locking issues. I also explain what steps to take to avoid contention in the future. Lots of examples taken from experience.
SessionID: 32673
Streamline development with VS build contributors
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Development
Speaker: Robert Schoedel
Title: Streamline development with VS build contributors
Abstract:
While many teams are now using Visual Studio for database project development, few have begun to take advantage of build contributors. Build contributors represent a powerful technology that is particularly adept at responding to changes in the database project. This technology can enable integration scenarios which might otherwise be difficult or time-consuming, such as automatically updating documentation or installation scripts. In this session, you will understand how build contributors are enabled, and see this technology in action.
SessionID: 32674
Seven solutions for highly expensive queries
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Development
Speaker: Robert Schoedel
Title: Seven solutions for highly expensive queries
Abstract:
SessionID: 32806
SSIS for the faint of heart
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Scott Stauffer
Title: SSIS for the faint of heart
Abstract:
Scott's gentle introduction to SQL Server Integration Services (or SSSIS) will primarily be demonstrating how to you can use this tool in the real world to get work done. READ: very little PowerPoint time. SSIS is a high performance ETL solutions introduced in SQL Server 2005 to replace SQL Server's DTS functionality. ETL? It's okay, Scott will briefly cover some of these concepts too. Relax, sit back and learn how to simplify your "Extract, Transform, and Load" processes.
SessionID: 32867
Manage Your Legacy Applications with Windows Power
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Expanded Horizons
Speaker: Sean Kearney
Title: Manage Your Legacy Applications with Windows Power
Abstract:
Using Windows Powershell presents us with many of options never seen before. You can easily execute SQL Queries to manage legacy systems, Manipulate console and Vbscript applications, and extend Applications run via webproxy as well as built in Regex.
This session is intended shatter the myth that using Poweshell means trashing the legacy.
SessionID: 33833
Exploring SSAS data folder
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Business Intelligence
Speaker: Vidas Matelis
Title: Exploring SSAS data folder
Abstract:
SessionID: 34678
Query Plans
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Development
Speaker: John Huang
Title: Query Plans
Abstract:
This is the session help developers to interpret the query plans, understand frequently seen operators and properties in the plan. At the end, it will show how SQL Server estimates the cost of operators and how SQL Server make decisions to choose a plan out of numerous alternatives.
SessionID: 34680
Multi-threading TSQL
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Development
Speaker: John Huang
Title: Multi-threading TSQL
Abstract:
Can T-SQL be run in multi-threaded manner? Yes, this session will explain how to use TSQL to implement multi-threading application, including process control, resource access, execution ordering, synchronization, semaphore, etc. If you are looking for a solution to turn your processes to run in parallel, you should not miss it.
SessionID: 34681
Indexes and Data Access
Event Date: 17-09-2011 - Session time: 00:00:00 - Track: Database Development
Speaker: John Huang
Title: Indexes and Data Access
Abstract:
Are you interested to know how SQL Server utilize indexes for data accessing, modification, joins and aggregates, and why an index cannot be utilized? This is what we are going to talk about -- from index internal to stragegies.