Nr: 22
SQLSaturday #22 - Pensacola 2010
SessionID: 28507
Introduction to SharePoint 2010 BI and PowerPivot
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2175 - SSIS
Speaker: Adam Jorgensen
Title: Introduction to SharePoint 2010 BI and PowerPivot
Abstract:
SessionID: 28754
Full Text Searching - A Guide for DBAs Devs
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2142 - MS TECH
Speaker: Robert Cain
Title: Full Text Searching - A Guide for DBAs Devs
Abstract:
Users have become familiar with the simple search capabilities of tools like Microsoft Live Search and Google. Did you know you can give your users the same ability to search their data with SQL Server? And it's as easy as 1-2-3! Come and learn the how to setup and use full text searching with SQL Server.
SessionID: 28971
Rapid Dimensional Prototypes with PowerPivot
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2171 - DEV 2
Speaker: Barry Ralston
Title: Rapid Dimensional Prototypes with PowerPivot
Abstract:
This session will share with attendees a methodology for rapid dimensional modeling and protyping user interfaces with PowerPivot for Excel.
SessionID: 29156
Best Practices Every SQL Server DBA Must Know
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2142 - MS TECH
Speaker: Brad McGehee
Title: Best Practices Every SQL Server DBA Must Know
Abstract:
The focus on this session is on describing best practices every SQL Server DBA needs to know. These are foundational best practices that, if not followed, could have a significant negative effect on the performance and availability of their SQL Servers. As such, this session is targeted towards those who have less than one year’s experience. This session focuses on key fundamentals, such as: Installing Upgrading SQL Server; SQL Server Configuration; User Data and Log File Management; Database Configuration Settings; Configuring Critical Maintenance Jobs; Setting Up Alerts for Critical Errors; Security Basics; Implementing a Backup and Restore Strategy; Creating a Disaster Recovery Plan; Testing; Monitoring; and Documentation.
SessionID: 29159
of Pensacola Junior College
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2176 - SECURITY
Speaker: Brad McGehee
Title: of Pensacola Junior College
Abstract:
SessionID: 29284
Zen Coding
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2171 - DEV 2
Speaker: Brian Rigsby
Title: Zen Coding
Abstract:
The philosophy, the mindset, the attitude of a professional, principled, disciplined software developer
SessionID: 29304
CMS using Kentico, ASP.NET, and SQL Server
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2169 - DEV 1
Speaker: Bryan Soltis
Title: CMS using Kentico, ASP.NET, and SQL Server
Abstract:
Dynamic, continuously changing data drives the internet. Companies are constantly modifying their content to deliver relevant and focused information to their users. A CMS-driven site allows for site owners to keep up with the pace of technology quickly and efficiently. The Kentico CMS Content Management system is a powerful, robust .NET platform for delivering dynamic, content-driven sites. This presentation will be an overview of the Kentico CMS system, an in-depth presentation of content updates using the system, integration of other .NET technologies, SQL Server databases.
SessionID: 29336
Introduction to SQL Server Integration Services
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2175 - SSIS
Speaker: Bradley Schacht
Title: Introduction to SQL Server Integration Services
Abstract:
This session will get you past the learning curve of SSIS. Covers creating an end to end package that covers many of the concepts in SSIS. This session will be great for anyone who is a beginner to SSIS.
SessionID: 29429
SharePoint 2010 Management with PowerShell
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2171 - DEV 2
Speaker: Cody Gros
Title: SharePoint 2010 Management with PowerShell
Abstract:
SharePoint 2010 includes hundreds of PowerShell cmdlets for managing your SharePoint 2010 environment. This session will first provide you with the basics of using PowerShell and then dive into using PowerShell to mange SharePoint 2010. You will learn everything from scripting out deployments to managing sites using PowerShell. This session will also show SharePoint administrators how to automate common SharePoint tasks.
SessionID: 29500
Introduction to Change Data Capture
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2172 - DBA
Speaker: Chris Skorlinski
Title: Introduction to Change Data Capture
Abstract:
This sessions provides a walk through of Microsoft's newest SQL Replication feature called Change Data Capture (CDC). Sessions covers overview of CDC, setting up CDC and using various CDC functions to retrieve list of data changes. CDC is often used by data warehouse applications to retrieve list of SQL insert and updates for a given time window.
SessionID: 29572
SharePoint Mashup: Internal Data for External Life
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2169 - DEV 1
Speaker: Cory Loriot
Title: SharePoint Mashup: Internal Data for External Life
Abstract:
SessionID: 29624
Accelerating SQL with Solid State Technology
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2172 - DBA
Speaker: Sumeet Bansal
Title: Accelerating SQL with Solid State Technology
Abstract:
This session will address:
- On overview of solid state technology options for SQL Server
- Why solid state makes a difference?
- An comparison of the different types of NAND Flash-based products and the advantages and disadvantages of each:
a. Disk-based SSDs
b. Onboard/Embedded PCI Express devices
c. Host-based PCI Express devices
- Customer proof: Wine.com case study
SessionID: 29701
GOD, good object design
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2169 - DEV 1
Speaker: Daniel Rosales
Title: GOD, good object design
Abstract:
Come learn how to effectively use UML in your everday implementations. As VS2010 boasts UML support right from within the IDE with an array of UML compliant diagrams, we will stick to the whiteboard and avoid the technology. This is meant to force us to think through a problem together as a team and arrive at a common understanding. If there is time left, Danny will open up the IDE and actually implement whatever design the team arrived at. Come learn UML notation and more importantly, good object design!
SessionID: 30117
SSIS 2008 - Profiling Your Data
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2175 - SSIS
Speaker: Eric Wisdahl
Title: SSIS 2008 - Profiling Your Data
Abstract:
Many data integration and ETL projects run over budget and past deadlines because the quality of the data was not known prior to the proposal. This session will attempt to show the users how to get to know their data better through an in depth look at the new data profiling task as well as the data profile viewer in SSIS 2008.
SessionID: 30835
Intro to Windows Azure
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2142 - MS TECH
Speaker: Joe Healy
Title: Intro to Windows Azure
Abstract:
SessionID: 30912
SQL Server Locking Blocking Made Simple
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2176 - SECURITY
Speaker: Joe Webb
Title: SQL Server Locking Blocking Made Simple
Abstract:
SessionID: 31049
Opening the Tacklebox on VS2010
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2142 - MS TECH
Speaker: Joe Healy
Title: Opening the Tacklebox on VS2010
Abstract:
Joe will cover several new features of VS2010.
SessionID: 31204
SQL at the “Speed of Light” with Fusion-io
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2172 - DBA
Speaker: Karla Landrum
Title: SQL at the “Speed of Light” with Fusion-io
Abstract:
Check back.
SessionID: 31289
Enforcing Compliance With Policy-Based Management
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2176 - SECURITY
Speaker: Ken Simmons
Title: Enforcing Compliance With Policy-Based Management
Abstract:
As the demand for data keeps growing and security and compliance keep tightening, the role of the DBA has become an increasingly critical part of maintaining compliance within the organization. This session will cover real world examples you can use with Policy-Based Management to ensure you have the proper server configuration and security settings in place along with the appropriate encryption and auditing options for your environment.
SessionID: 31299
Understanding and Preventing SQL Injection Attacks
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2176 - SECURITY
Speaker: Kevin Kline
Title: Understanding and Preventing SQL Injection Attacks
Abstract:
SQL Injection attacks are one of the most common hacker tricks used on the web. Learn what a SQL injection attack is and why you should be concerned about them. Through demonstrations, witness different types of SQL injection attacks, how to find them, and how to block them so you know your environment is secure.
SessionID: 31301
SQL Server Internals and Architecture
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2176 - SECURITY
Speaker: Kevin Kline
Title: SQL Server Internals and Architecture
Abstract:
- What’s different about 32- and 64-bit systems?
- What are the various areas of memory inside of SQL Server?
- How are queries handled behind the scenes?
- What does SQL Server do with procedural code, like functions, procedures, and triggers?
SessionID: 31329
Location Aware Applications Using SQL Server 2008
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2169 - DEV 1
Speaker: Kevin Grohoske
Title: Location Aware Applications Using SQL Server 2008
Abstract:
SessionID: 31415
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2176 - SECURITY
Speaker: Devin Knight
Abstract:
In this session, you will learn how to split your measure group data in to more manageable pieces using partitions to speed up cube processing time. Then designing aggregations on your partitions will be discussed including how to create aggregations using Usage Based Optimization (UBO) to speed up query time.
SessionID: 31462
C# Ninjitsu
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2169 - DEV 1
Speaker: Chris Eargle
Title: C# Ninjitsu
Abstract:
C# is no longer a purely object-oriented language. It is no longer just an imperative, class-based, component oriented discipline. It is also a generic, declarative, functional discipline.
I will introduce new principles in the context of the classic object-oriented and SOLID principles and show you how to master the C# language to be more declarative, more fluent, and more functionally cohesive.
SessionID: 31549
Debug TalkAbout
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2171 - DEV 2
Speaker: Marc Matthews
Title: Debug TalkAbout
Abstract:
SessionID: 31649
Introduction to Microsoft® Silverlight™
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2169 - DEV 1
Speaker: Vincent Mayfield
Title: Introduction to Microsoft® Silverlight™
Abstract:
SessionID: 31650
Building Scalable ASP.NET Applications
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2169 - DEV 1
Speaker: Vincent Mayfield
Title: Building Scalable ASP.NET Applications
Abstract:
Most ASP.NET Developers are able to build ASP.NET Applications. However, few understand the principles of building scalable Enterprise Applications that are deployable in a Network Load Balanced or Clustered Server network configuration. This seminar targets advanced developers who desires to understand the considerations required in designing and building a scalable ASP.NET Applications. Topics covered in this seminar include: The NLB and Clustered Network Topology, Handling State, Inproc versus SQL Server State Management, Sticky Sessions, Programming Considerations, Database Considerations, and Statistics.
SessionID: 32131
Introduction to Transactional Replication
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2172 - DBA
Speaker: Troy Gallant
Title: Introduction to Transactional Replication
Abstract:
SQL Server replication allows DBAs to distribute data to various servers throughout an organization. Some reasons to employ replication include load balancing, offline processing redundancy. Transactional replication in particular can offer a very flexible solution where data frequently changes. This session will discuss the basics of planning and implementation of a solid transactional replication solution.
SessionID: 32280
CDC + SSIS = SCD
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2172 - DBA
Speaker: Patrick LeBlanc
Title: CDC + SSIS = SCD
Abstract:
SessionID: 32467
Can you control your reports?
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2175 - SSIS
Speaker: Ryan Duclos
Title: Can you control your reports?
Abstract:
SSRS, ASP.NET
SessionID: 32535
From Zero to BI in 10 Minutes
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2142 - MS TECH
Speaker: Rushabh Mehta
Title: From Zero to BI in 10 Minutes
Abstract:
SessionID: 32619
DBA Repository Update 2010 Using SSIS and SSRS
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2175 - SSIS
Speaker: Rodney Landrum
Title: DBA Repository Update 2010 Using SSIS and SSRS
Abstract:
SessionID: 32911
SQL Server 2008 Resource Governor
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2176 - SECURITY
Speaker: Shawn McGehee
Title: SQL Server 2008 Resource Governor
Abstract:
Working with limited resources in the hardware and software fields can be troubling for a DBA. Making things work smoothly when sharing servers among many applications can be a difficult and time consuming task. With SQL Server 2008 a new feature has been given to the DBA world that can make the process much easier. We will take a look at the resource governor from the ground up in this session and build a solution to alleviate some of the issues that come with sharing hardware using SQL Security, Windows Active Directory Security and more.
SessionID: 32937
The Modern Resume: Building Your Brand
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2142 - MS TECH
Speaker: Steve Jones
Title: The Modern Resume: Building Your Brand
Abstract:
Steve Jones, founder of SQL Server Central talks about how to update your resume to fit into today's modern world, and take advantage of the tools offered by blogging, social networking, and more.
SessionID: 32938
Basic SQL Server
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2142 - MS TECH
Speaker: Steve Jones
Title: Basic SQL Server
Abstract:
Learn the basics of SQL Server if you are new to working with the product. This high level technical session will introduce the basics of database design, objects in SQL Server, security, and queries as well as an overview of how the product is structured from an IT perspective.
SessionID: 33225
Silverlight 4 - What's the differences?
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2171 - DEV 2
Speaker: Steven Lane
Title: Silverlight 4 - What's the differences?
Abstract:
In this session we will be examining Silverlight 4 - yes I said Silverlight 4. The focus of this meeting will be on what new features are available.
Some of the new features that we will take a look at are the Printing API, COM interop, RichTextArea Control and many more.
All of this in a 90 minute presentation, what more could you ask? Depending on time we will them explore the Silverlight Toolkit and sources that are available for further information.
SessionID: 33276
ADO.NET Entity Framework v4 - Part 1
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2176 - SECURITY
Speaker: Sven Aelterman
Title: ADO.NET Entity Framework v4 - Part 1
Abstract:
The first version of the ADO.NET Entity Framework, included in .NET Framework 3.5 SP 1, had several shortcomings. Microsoft has been busy working on the V4 release of the Framework and Entity Framework, to be released with Visual Studio 2010. This session will take a look at how the Entity Framework v4 can be used to develop N-Tier business applications and highlight some of the shortcomings that were fixed and some that haven’t been fixed yet.
SessionID: 33277
ADO.NET Entity Framework v4 - Part 2
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2175 - SSIS
Speaker: Sven Aelterman
Title: ADO.NET Entity Framework v4 - Part 2
Abstract:
The first version of the ADO.NET Entity Framework, included in .NET Framework 3.5 SP 1, had several shortcomings. Microsoft has been busy working on the V4 release of the Framework and Entity Framework, to be released with Visual Studio 2010. This session will take a look at how the Entity Framework v4 can be used to develop N-Tier business applications and highlight some of the shortcomings that were fixed and some that haven’t been fixed yet.
SessionID: 33498
Common TSQL Programming Mistakes
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2142 - MS TECH
Speaker: Kevin Boles
Title: Common TSQL Programming Mistakes
Abstract:
We are going to examine a variety of oopsies MANY developers fall prey to - some obvious, some fairly subtle and some down right sneaky! Lots of code examples with the bad AND good code presented.
SessionID: 33587
Loops, Lookups, and Splits: SSIS Beyond the Basics
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2172 - DBA
Speaker: Tim Mitchell
Title: Loops, Lookups, and Splits: SSIS Beyond the Basics
Abstract:
SessionID: 33648
SQL Source Control: Poor man's data dude.
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2171 - DEV 2
Speaker: Tim Costello
Title: SQL Source Control: Poor man's data dude.
Abstract:
SessionID: 33724
A PowerShell Cookbook for DBAs
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2175 - SSIS
Speaker: Trevor Barkhouse
Title: A PowerShell Cookbook for DBAs
Abstract:
This introduction to PowerShell is different than most. Instead of starting with a full treatment of the language, you will receive a brief overview then a collection of "recipes," stand-alone PowerShell scripts that automate various administration tasks for SQL Server 2000, 2005, and 2008. You will learn by example, and quickly realize why investing a little time into learning PowerShell will make your job a great deal easier.
SessionID: 34492
Introduction to DMVs in SQL 2005/2008
Event Date: 05-06-2010 - Session time: 00:00:00 - Track: Room 2172 - DBA
Speaker: William Assaf
Title: Introduction to DMVs in SQL 2005/2008
Abstract: