Sessions
This page lists the sessions that have been submitted for the next Rock & Roll
Code Camp. Would you like to be a presenter?
Please enter your sessions here. We hope you will offer sessions on topics that
you are passionate about! (note just before code camp we shut this down, contact us if you have a last minute session to add)
Sat 4:00 p
Exploring the DAC and everyone's favorite feature the DACPAC
Room: 127
Level: 200
Denny Cherry
Data Tier Applications or DACs (yes we know that DAC doesn't stand for Data Tier Application, but there already was a DTA) are a new way to think about and manage your databases. Instead of thinking of a database as just a database you can now manage your databases as applications setting usage thresholds based on the application needs for alerting and monitoring. Alo...
Read More...
Tags: SQL Server | DAC
Interested: 10
Sat 1:30 p
SQL Azure
Room: 127
Level: 200
Lynn Langit
SQL Server in the Cloud - what's in, what's not and what will be - why, how, what and when. C'mon over and Lynn will explain and demo your data on SQL Azure.
Read More...
Tags: Windows Azure | SQL Server | SQL Azure
Interested: 19
Sat 4:00 p
SQL Design Patterns
Room: 150
Level: 200
Craig Hubert | Jim Bears
Patterns gained popularity in the object-orientated community since the Fowler and the Gang Of Four, but declarative languages, like SQL, have had little-to-no coverage of how these patterns can be applied. Understanding SQL design patterns is a crucial skill every SQL developer should use providing common solutions to complex problems.
Read More...
Tags: TSQL | SQL Server | SQL Architecture | SQL | Design Patterns | Best Practices | ANSI
Interested: 25
Sun 10:15 a
SQL Server 2005 - Designing a Unit Test Plan for a Database
Room: 150
Rick Martinez
In this session, you will learn the key design practices for designing a unit testing plan for a database so that you can quickly pinpoint where to focus your attention when problems arise. A unit test plan is the building block for creating a performance baseline and a benchmark strategy.
Read More...
Tag: SQL Server
Interested: 31
Sun 9:00 a
SQL Server 2005 - Developing Applications for Notification Services
Room: 150
Rick Martinez
In this session you will first see how to create Notification Services instances. Then, you will learn how to define Notification Services events and event providers and configure the Notification Services generator and distributor. After looking at how to test your Notification Services application, you will see how to create subscriptions and how to optimize your notification solution.
Read More...
Tag: SQL Server
Interested: 14
Sat 8:45 a
SQL Server 2005: Importing data from Excel- First the hard way then the easy way.
Room: 127
Level: 100
allan rubio
Learn how to import data from Excel using the import wizard. You will also learn how to streamline the process by using a "secret" script- no more click, click, click to import your data.
Read More...
Tags: SQL Server | Import Data
Interested: 18
Sat 12:15 p
SQL Server Integration Services Configuration and Deployment
Room: 127
Bret Stateham
SSIS Packages have an extremely flexible configuration model that makes it possible for packages to behave differently as they move through your dev, qa, and production environments. In this session well cover how to use package configurations to get the most out of SSIS.
Read More...
Tags: SSIS | SQL Server Integration Services | SQL Server
Interested: 24
Sat 2:45 p
SQL Server panel discussion
Room: 127
Level: 100
Lynn Langit | Andrew Karcher | Bret Stateham | Jen Underwood | Steve Hendricks | Jon Saltzman | Ben Aminnia | Denny Cherry | Thomas Mueller
In this panel discussion SQL Server experts/users will talk about several SQL Server topics.
Read More...
Tags: SSRS | SSMS | SSIS | SSAS | SQL Server | RDBMS | DBA | BI
Interested: 17
Sat 1:30 p
SQL Server Reporting Services - What's new in SQL 2008 R2
Room: 150
Level: 200
Andrew Karcher
With the upcoming release of SQL Server 2008 R2 there are a bunch of new features for SQL Reporting Services.
Read More...
Tags: SSRS | SQL Server | business intelligence
Interested: 16
Sat 10:00 a
SQL Server XML Primer
Room: 127
Level: 200
matt galaviz
Learn the fundamentals on working with the XML data type in SQL Server. This session will demonstrate basic querying and modifying of an XML type variable or column.
Read More...
Tags: XPath | XML | SQL Server
Interested: 29
Sun 12:30 p
Storage For the DBA
Room: 127
Level: 300
Denny Cherry
One of the biggest issues in database performance centers around storage. It’s also one of the hardest places to troubleshoot performance issues because storage engineers and database administrators often do not speak the same language. In this session, we’ll be looking at storage from both the database and storage perspectives. We’ll be digging into LUNs, HBAs, the fabric, as well as RAID Groups. In addition to theory, we’ll be looking at an actual EMC SAN so that we can translate what we Read More...
Tag: SQL Server
Interested: 19
Sat 4:00 p
The Rad MVC CodeCamp Server
Room: 129
Level: 300
Nuri Halperin
In this open session, we’ll introduce RAD MVC CodeCamp server. This open source server is built ground up to provide everything the current ASP.NET code camp website offer and much more. See how taking an agile approach, and leveraging latest .NET, MVC and Entity Framework brings together a feature rich product in no time flat!
Read More...
Tags: SQL Server | MVC 2.0 | MVC | Entity Framework | C# | Agile
Interested: 4
Sun 1:45 p
There's more to know about storage?
Room: 127
Level: 400
Denny Cherry
That's right there is. As a followup session to the "Storage for the DBA" session which I’ve done at a few code camps now. This time we will broaden the look to cover some of the different options that different storage providers are using to design their storage; as well and the pros and cons for each of these. From there we'll move into some of t...
Read More...
Tags: Storage | SQL Server
Interested: 8
Sun 10:15 a
Unleash the Power! - Self Service BI with PowerPivot
Room: 127
Level: 200
Andrew Karcher
PowerPivot gives users the power to create compelling self-service BI solutions, facilitates sharing and collaboration on user-generated BI solutions in a Microsoft SharePoint Server 2010 environment.
Read More...
Tags: SQL Server | PowerPivot | business intelligence
Interested: 8