A while ago, a coworker (Jon) showed us a presentation over lunch that he had given at the local alt.net user group on the Reactive Extensions for .NET. I was pretty unfamiliar with the subject, but once I got the lowdown from this presentation it was quite clear that this was something I’d need to explore. At the most basic level, the reactive extensions are about setting up your objects to react to something they are subscribed to.

For every instance of SQL Server Reporting Services (2005+) there are two databases, a primary and a TempDB. The primary database holds all of the data for your instance, such as: Users, Folder Structure, Roles, Security, Subscriptions, Data Sources, etc. There a lot of data here that you can use to clean up your Reporting Services instances, or help keep them in order. Also, from my experience the database doesn’t change much from 2005 to 2008, so these should work on both versions.

I saw this blog the other day entitled Why I feel like a fraud and it was something to which I could immediately relate. The author does a good job of explaining about feeling like a fraud, someone who lives in fear of being exposed for not being good enough at what they paid to be good (or expert). And he covers both the positives and negatives. Fortunately, I find that I tend more toward the positive attributes of feeling like a fraud as I rarely stay up late at night worrying about being exposed as such.

It’s that time of year again to make sure we spend all the money in the training budget. Use it or lose it right! So, after a quick look at the upcoming projects on the white board, I decided it was time to upgrade my skill set in the area of BI. I’ve signed up for “Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions”. The class is being taught by Global Knowledge up in Boston for 5 days and covers the following;

Last week I had the pleasure of presenting at a .Net Code Camp on the topic of Unit Testing. A key theme of the session was barriers to adoption and the values we can achieve using this tool. The main barrier to my adoption of Unit Testing was the idea that writing twice as much code would increase the value of my work. Twice as much code, as was pointed out in a response to my post two week’s ago, sounds like higher maintenance costs, higher initial development costs, and a greater opportunity for bugs.

The SQL Community is an important part to everything I do both in work and pleasure. Over the last year, I’ve started to realize that the work aspect to my life could be pushed higher and at the same time, pushed more into a role that benefits the SQL Community. It is always hard to disconnect yourself as a production DBA from the systems that you build and nurture from a failing service into an enterprise worthy service.

![][1] It really was! By the reaction I received from most of the people that I had been talking to for some time now, you wouldn’t have guessed this to be my first PASS but I had the first timer ribbon proudly shown. I can say with great confidence that I was missing out badly over the years. Monday I’m going to take Monday as a shout out to Expressor.

Today at PASS the SQL Server team has publicly announced the first Community Technology Preview of the next version of SQL Server code named Denali. You can download it here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92-9c92-f7e5677d91f9 I have been playing around with Denali for a couple of weeks now and created a couple of posts. Below is a list of the posts, click on each link to get some more information about Denali First look at SQL Server Management Studio Denali

With SQL Server Denali CTP1 come 20 new dynamic management views, this brings the total number of dynamic management views to 155 Here is a list of the new dynamic management views, included is also the type of the dynamic management view DMV Name DMV Type dm_db_objects_disabled_on_compatibility_level_change SQL_INLINE_TABLE_VALUED_FUNCTION dm_db_uncontained_entities VIEW dm_exec_describe_first_result_set SQL_INLINE_TABLE_VALUED_FUNCTION dm_exec_describe_first_result_set_for_object SQL_INLINE_TABLE_VALUED_FUNCTION dm_fts_index_keywords_by_property SQL_INLINE_TABLE_VALUED_FUNCTION dm_hadr_availability_group_states VIEW dm_hadr_availability_replica_states VIEW dm_hadr_database_replica_states VIEW dm_hadr_database_synchronization_states VIEW dm_hadr_instance_node_map VIEW dm_hadr_name_id_map VIEW dm_logconsumer_cachebufferrefs SQL_INLINE_TABLE_VALUED_FUNCTION dm_logconsumer_privatecachebuffers SQL_INLINE_TABLE_VALUED_FUNCTION dm_logpool_consumers SQL_INLINE_TABLE_VALUED_FUNCTION dm_logpool_hashentries VIEW dm_logpool_sharedcachebuffers SQL_INLINE_TABLE_VALUED_FUNCTION dm_logpool_stats VIEW dm_logpoolmgr_freepools SQL_INLINE_TABLE_VALUED_FUNCTION dm_logpoolmgr_respoolsize SQL_INLINE_TABLE_VALUED_FUNCTION dm_logpoolmgr_stats SQL_INLINE_TABLE_VALUED_FUNCTION Unfortunately, when I downloaded this there was no documentation available yet, once documentation is available I will take a closer look at the new dynamic management views in Denali

If you have a stored procedure which returns two result sets up till now there was now way to get the meta data easily about the first result set. Let’s take a look what is new in SQL Server Denali, first create this very simple stored procedure. create procedure prTest as select 1 as a, 'B' as b select 'A' as z, 3 as d Go sys.dm_exec_describe_first_result_set_for_object Run the following query