Nr: 36
SQLSaturday #36 - Wheeling 2010
SessionID: 28900
Automate SQL Server Administration with PowerShell
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Development
Speaker: Allen White
Title: Automate SQL Server Administration with PowerShell
Abstract:
Most administrative functions consist of repetitive sequences of tasks which just take time. PowerShell is a powerful scripting environment which allows an administrator to automate those repetitive tasks, providing better results to the organization while saving the administrator time, and ensuring that the tasks get done properly every time. This session will give an introduction to PowerShell and demonstrate a number of scripts which help SQL Server administrators effectively manage their environments.
SessionID: 29293
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: SQL Server
Speaker: Bronwyn Altizer
Abstract:
SessionID: 29765
Intro to WCF Data Services and OData
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Development
Speaker: David Hoerster
Title: Intro to WCF Data Services and OData
Abstract:
Exposing your data to client applications is a common requirement across most applications; however, there are many ways to accomplish this. Each application seems to implement it a different way which leads to inconsistency across your application spectrum. With the release of the .NET Framework 3.5, Microsoft has introduced WCF Data Services (was ADO.NET Data Services) which is a collection of classes and standards to allow you to expose your data consistently and securely to your client applications. We'll focus on WCF Data Services in .NET 4, in which Microsoft has beefed up the offering, and also the data protocol known as OData.
SessionID: 30751
Fundamentals of SQL Server Internals
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: SQL Server
Speaker: Jeremiah Peschka
Title: Fundamentals of SQL Server Internals
Abstract:
"Want to know what makes SQL Server tick? Ever wonder what SQL Server is doing when you run a query? Ever wonder which parts of SQL Server are responsible for specific functionality? Want to know what a HOBT is? I can’t promise answers to every question, but I can set you on the path to knowledge about the inner workings of SQL Server.
Session Goals
After this session, attendees will:
Know how to query SQL Server to gain insight into its internal state
Understand the primary components of SQL Server and how they relate
Apply their understanding of internals to daily queries to improve application and database performance"
SessionID: 30752
A Dynamic World Demands Dynamic SQL
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Development
Speaker: Jeremiah Peschka
Title: A Dynamic World Demands Dynamic SQL
Abstract:
Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.
Learn how to work effectively with diverse inputs.
Learn how to avoid common pitfalls of dynamic SQL.
Develop an understanding of real world uses for dynami
SessionID: 30894
Encryption in SQL Server
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: SQL Server
Speaker: Joe Kuemerle
Title: Encryption in SQL Server
Abstract:
Learn to protect data in your application by leveraging the built in encryption functionality in SQL Server 2005/2008 by taking a brownfield application and bringing it up to modern standards. Topics covered will include column level data encryption, providing lookups of encrypted data, basics of key management and the transparent data encryption capabilities of SQL Server 2008.
SessionID: 30895
Developers….Are We Just a Commodity?
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Development
Speaker: Joe Kuemerle
Title: Developers….Are We Just a Commodity?
Abstract:
It’s a contracting market. Companies are reducing costs across the board. With outsourcing and off-shoring achieving success, how can today’s in-house developer prove his value to the business? Technical expertise is valuable to product and technical management. However, it’s the developer’s understanding of the business and his role in generating revenue that’s invaluable. This presentation explains various techniques developers can use to increase their business savvy, proving they are providing value and not just an expense.
SessionID: 30921
Introduction to Silverlight
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Development
Speaker: John Hidey
Title: Introduction to Silverlight
Abstract:
This session will walk you though building your first Silverlight data driven application.
SessionID: 31054
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Beginner
Speaker: Joe Harford
Abstract:
It’s no secret that social networking is here to stay. Rather than shutting down all social networking at work organizations should put policies, procedures and training in place for responsible tweeting, blogging, etc. These policies should include responsible ways to use the media rather than abuse it. Included in this presentation will be ways to structure your policies. These methods will help your organization use social networking to promote your brand and educate consumers about new products and services.
SessionID: 31100
Introduction to Data Warehousing
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Beginner
Speaker: John Sterrett
Title: Introduction to Data Warehousing
Abstract:
If you are interested in learning how Analysis Services, Integration Services and Reporting Services can provide Business Intelligence this meeting is for you. We will start with the basic concepts of data warehousing including key terms and definitions. Next, we will cover some sample business cases while we walk through the process of designing a data warehouse. Once this session is complete you will be able to develop your first cube.
SessionID: 31101
LUNCH - 1st Floor Ballroom
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: SQL Server
Speaker: John Sterrett
Title: LUNCH - 1st Floor Ballroom
Abstract:
Lunch will be provided by Panera. We will have box lunches.
SessionID: 31102
Lunch Provided by Panera
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Development
Speaker: John Sterrett
Title: Lunch Provided by Panera
Abstract:
Lunch Provided by Panera - 1st Floor Main Ballroom
SessionID: 31103
Lunch Provided by Panera - 1st Floor Ballroom
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Beginner
Speaker: John Sterrett
Title: Lunch Provided by Panera - 1st Floor Ballroom
Abstract:
Lunch is provided by Panera. We will ahve box lunches.
SessionID: 31626
SSRS Interactive Reports
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Beginner
Speaker: Matt Van Horn
Title: SSRS Interactive Reports
Abstract:
I will show how to take advantage the interactive features of SQL Reporting Services to allow your users to drill down from summaries to the details that drive them. Address some of the simple to implement features that can make your existing reports much more useable to your end users. Topics to be covered include: Graphing, Interactive Sorting, Grouping, and Drilldown Reports.
SessionID: 31627
Intro to SQL Reporting Services 2008
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Beginner
Speaker: Matt Van Horn
Title: Intro to SQL Reporting Services 2008
Abstract:
SessionID: 33655
Designing a Highly Available SQL environment
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: SQL Server
Speaker: Tim Beamer
Title: Designing a Highly Available SQL environment
Abstract:
SQL Server is the database engine supporting the Line-of-Business applications that run your business, so how do you make sure it is always up and providing those critical services? This session will look at several alternatives for designing and implementing a highly availble architecture for your SQL environment. Options will be presented to give a range of availability scenarios based on Service Level Agreements, as well as budget.
SessionID: 33656
Building and Executing a Disaster Recovery Plan
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: SQL Server
Speaker: Tim Beamer
Title: Building and Executing a Disaster Recovery Plan
Abstract:
Nobody wants to have a catastrophic event, but bad things happend to good datacenters. Whether it's 42 inches of snow, 18 inches of rain, extended power outage, whatever, your business needs to be able to operate. We'll start at a general level in terms of how to build your DR plan and then drill specifically into what you need to do to restore database services to an operational state. We'll draw on information from the High Availability session and add additional color commentary on what the most important things are to consider when building, and most importantly testing your DR plan.
SessionID: 33850
How to enlist SSRS to enhance your application’s
Event Date: 01-05-2010 - Session time: 00:00:00 - Track: Development
Speaker: Von Scarberry
Title: How to enlist SSRS to enhance your application’s
Abstract: