My submissions to PASS Summit 2010

Well, I have finally completed my submissions to the PASS Summit. Hopefully, if I can get some of my topics picked up then I can get my company to sponsor this year. I am thinking about adding another submission for an all day event for One Day Data Warehouse with SQL Server 2008 R2 to basically demonstrate building a data warehouse from front to back with all the bells and whistles  involved. Let me know if this sounds good or if there is another topic you have been dying to see.

I have included some comments on these as I have presented on the topics before but as many of you know, I don’t like giving the exact same presentation twice so these would be revamped with newer and cooler demos and ideas.

Of course, I am not above shamelessly plugging my presentations. So anyone out there that would like to see these at PASS just send an email off to them:)

Also, if there are any PASS chapters  or SQL Saturdays out there that would like to see these or other similar presentations then drop me a line. I cannot promise that I can make every one but I will try get it on my schedule!

Cheers,
AJ

* This one is generally well received because I provide some handy advice as well as some scripts that can be used to automate and also report on you SQL Server environment.

Automate Your DBA World With Powershell

Approval Status: Proposed

Track: Enterprise Database Administration and Deployment

Session Type: Regular session

While SQL Server 2008 provided a myriad of tools to assist the DBA in managing large numbers of database instances, most companies do not have the funds to implement full Enterprise Edition deployments. Luckily, Microsoft has provided us with a platform to write our own custom scripts to do just about anything within our environment. This session will concentrate on showing DBAs how they can leverage Powershell to perform task automation and reporting within their database environments both large and small.

* A cool one because I actually set up an AJ ITunes type web page and use FILESTREAM to house the music. I was told by one college student at an earlier event that I was ‘Off the hook with this demo’…see IT people can be cool too.  🙂

Handling FILESTREAM in SQL Server 2008 R2

Approval Status: Proposed

Track: Enterprise Database Administration and Deployment

Session Type: Regular session

SQL Server 2008 introduced the concept of the FILESTREAM support. Most DBAs whom have been around for a while have in one instance or another supported streaming applications by use of the VARBINARY(MAX) datatype in order to store file information within the database architecture. However, this has drastic limitations as the RDBMS are not typically set up to deal with data that is not accessible in terms of pages and extents. FILESTREAM support adds a new paradigm to the database platform by marrying the database system with the NTFS file system in order to overcome these old obstacles. In this session, we will delve into FILESTREAM support, Remote Blog Storage, what it takes to implement, and some of the extremely cool things that you can do with this new power.

* This is a really good demo for the developer. I am constantly amazed at how many people try to reinvent the wheel with a custom implementation when Microsoft has one baked into the product.

Monitoring Data Changes the Microsoft Way with Change Data Capture

Approval Status: Proposed

Track: Application and Database Development

Session Type: Regular session

Most modern enterprise database environments require some measure of auditing their data. Previously, the DBA would need to put together a complicated web of triggers and history tables in order to properly track data changes. Now in SQL Server 2008, Change Data Capture allows the DBA to readily enact a very straight-forward method for tracking the changes and understanding easily how they took place. In this session, we will examine how to set-up, configure, use, and administer the Change Data Capture process in your environment.

* This is an excellent under the cover look at replication. I show that it is really a pretty simple process to understand and how you can use that knowledge to customize solutions. This is one of those ‘AJ you can’t do that?!’ kind of demonstrations where I will show you how to do all kinds of quirky things that your business users may ask of you.

SQL Server Replication Demystified

Approval Status: Proposed

Track: Enterprise Database Administration and Deployment

Session Type: Regular session

Replication is often one of those black box features where if you are using the wizard in a standard implementation then you are fine. Yet, what do you do when you have to do something like transactional replication across non-trusted domains. In this session, we will discuss the internals of replication, how it works, and what you can do to manage your implementations more effectively by understanding what going on underneath the covers

* This is one of the all day events. Every time I give a SSRS demo the place is packed and I actually had one guy in Chicago tell me ‘I haven’t been this excited about reporting since RPG!’….what’s worse is that I know what he means! So this would be an all day event where I actually demonstrate how to go from setup to Enterprise platform in a single day. Hopefully this one gets through because it will be wicked!

SQL Server Reporting Services 2008 R2 Unleashed!

Approval Status: Proposed

Track: BI Client Reporting and Delivery Topics

Session Type: Pre/Post-Conference session

SQL Server Reporting Services has been around for a number of years now and the 2008 R2 release provides DBAs and Developers with a truly enterprise class reporting platform. If your company has not embraced Reporting Services fully yet then now is the time! Come and see how to install, configure, and administer the Reporting Services environment as well as how to develop and deploy your own reporting solutions.

* This is an awesome presentation for the database administrator, especially in large scale environments with lots of developers. I show how to reign in those puppies with a little policy based management with a dash of resource governor! 

Take Control with Resource Governor and Policy Based Management

Approval Status: Proposed

Track: Enterprise Database Administration and Deployment

Session Type: Regular session

A large majority of a modern DBA’s workload consists of managing their policies and resources on their system in order to ensure that they are being followed and resources are accessible when needed. SQL Server 2008 provides both Policy Based Management(PBM) and Resource Governor, which allows the DBA to discretely manage system policies and resources in a very structured way. In this session, we will show you how to configure, monitor, and administer these features to help lower your anxiety levels while increasing your system’s availability.