SQL Server Reporting Services 2008 introduced several new features.  One key feature was the inclusion of the Gauge Controls.  I was recently asked to provide a real-world example of the Linear Gauge Control.   After doing a little reading and testing of the linear control I chose my path.  I started… Read more

Read more

A new feature of SQL Server 2008 is Table-valued parameters (TVP).  This feature will allow Developers and DBAs to pass tables as parameters to stored procedures.  You cannot pass a variable table or temp table, you can only pass a Table Type, which is an alias data type or a… Read more

Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate. Unfortunately I received the following error:

The permissions granted to user ‘MachineName\SomeUser ‘ are insufficient for performing this operations.

This confused me a bit since my account was an administrator.… Read more

At most large companies one business requirement is that all reports have the same look and feel.  This may vary by department, but there is typically some level of standardization amongst the business entities.  In most cases there is a header and footer template that needs to be seen… Read more

After several tries I think we finally have it working.  If you were unable to attend the last two SQLLunches, go to www.SQLLunch.com and go to the Archived November meetings.  They are both available for your viewing.  If you have any questions or comments about the SQL Lunch, please send… Read more

When partitioning was first introduced in SQL Server 2005, I thought what a great idea.  However, when I started reading Books Online I thought, this is going to be a big Pain in the you know what.  After reading Kimberly’s article, Partitioned Tables and Indexes, I was convinced of… Read more

Meeting URL: Join Meeting

Click the above Meeting URL around 11:30 AM CST on 11/16/2009 to join the meeting

Date: 11/16/2009

Time: 11:30 AM

Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=NHHGB9&role=attend

Presenter: Patrick LeBlanc, currently the Sr. Database Administrator for Lamar Advertising. I have worked as a SQL Server DBA for the past… Read more

This past Tuesday night I had the honor of speaking to a small group of college students who are all members of the Association of Information Technology Professionals (AITP). This was my third opportunity speaking to a group of college students and my second time speaking to an AITP group.… Read more

If you are in the Baton Rouge Area stop by and join our user group meeting this evening.  The details are below:

Topic:
Introduction to MDX

Date:
Wednesday, November 11, 2009

Speaker:

Barry Ralston

Barry is currently Vice President for Technical Solutions with Birmingham-based ComFrame Software. Since joining ComFrame in… Read more

Data Compression was introduced in SQL Server 2008.  This feature helps compress data inside the database, thus potentially reducing the size of the database.  In the article titled, Data Compression:  Strategy, Capacity, Planning and Best Practices, the author outlines several pertinent details regarding the implementation of this new feature. … Read more

Well if you attended PASS, you already know that I am changing jobs.  I recently accepted a position with Pragmatic Works.  I am honored to have the opportunity to work with Brian Knight and his staff over at Pragmatic Works.  For me this is somewhat of a career change.  Most… Read more

Meeting URL: Join Meeting

Click Here to Add to Outlook Calendar

Click the above Meeting URL around 11:00 AM CST on 10/12/2009 to join the meeting

Date: 11/9/2009

Time: 11:30 AM

Meeting URL: https://www.livemeeting.com/cc/usergroups/join?id=95MQQM&role=attend

Presenter: Kevin Kline: Kevin is the Technical Strategy Manager for SQL Server Solutions at Quest Software.… Read more