Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2009

Linear Gauge Control: A Practical Use

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

0 comments, 817 reads

Posted in SQLDownSouth on 30 November 2009

SQL Server 2008: Table-valued parameters

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

0 comments, 373 reads

Posted in SQLDownSouth on 24 November 2009

SQL Server 2008: Table-valued parameters

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

5 comments, 938 reads

Posted in SQLDownSouth on 24 November 2009

Deploying Reports on Windows 7

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

0 comments, 497 reads

Posted in SQLDownSouth on 23 November 2009

How to Create a Reporting Services 2005/2008 Template

 

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

13 comments, 8,199 reads

Posted in SQLDownSouth on 20 November 2009

SQL Lunch Recordings Now Available

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

2 comments, 463 reads

Posted in SQLDownSouth on 18 November 2009

Article of the Week – Kimberly L. Tripp (Partitioned Tables and Indexes)

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

2 comments, 784 reads

Posted in SQLDownSouth on 16 November 2009

Today’s SQL Lunch – Integrating Table Valued Parameters with Reporting Services 2008

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

2 comments, 695 reads

Posted in SQLDownSouth on 16 November 2009

How did I become a DBA

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

6 comments, 347 reads

Posted in SQLDownSouth on 12 November 2009

Baton Rouge SQL Server User Group

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

0 comments, 212 reads

Posted in SQLDownSouth on 11 November 2009

Article of the Week – Sanjay Mirsha (Data Compression)

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

1 comments, 308 reads

Posted in SQLDownSouth on 10 November 2009

New Job with Pragmatic Works

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

6 comments, 319 reads

Posted in SQLDownSouth on 9 November 2009

Today’s SQL Lunch – Understanding and Preventing SQL Injection with Kevin Kline

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

2 comments, 264 reads

Posted in SQLDownSouth on 9 November 2009