SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: January 2010

Recap - SQL Saturday #32 Tampa

This past weekend I was a presenter in two sessions at the SQL Saturday in Tampa.  First, I just want to say what an event.  The lunch that was served set a new precedence for all of the upcoming SQL Lunches.  We had a sit down meal with silverware and… Read more

0 comments, 492 reads

Posted in SQLDownSouth on 24 January 2010

PASS Virtual Meeting - Zero to Cube in 60 Minutes

PASS Virtual Meeting

Adam Jorgensen

Topic: Zero to cube in 60 Minutes

Date and Time: 1/22/2010 12:00 PM EST

Meeting URL: Join Meeting

Description: Overcome the barriers of traditional training and seminars with this Quick Start to building a cube. This all demo session will get you started and… Read more

1 comments, 668 reads

Posted in SQLDownSouth on 21 January 2010

Speaking at SQL Saturday Tampa and Richmond

Over the next two weekends there will be three SQL Saturday’s held, in Tampa (1/23), Boston (1/30) and Richmond (1/30).  I will have the privilege of not only attending two of the events, but I will be also speaking in Tampa and Richmond.

If you have yet to attend a… Read more

0 comments, 569 reads

Posted in SQLDownSouth on 21 January 2010

Scripting Indexes

I was recently reading a blog posting on BIDN, Scripting Indexes with Filters and schemas.  In the posting the author explained the challenges of trying to script only indexes using SQL Server Management Studio (SSMS).  Moreover, the author adds that there needs to be an option to filter… Read more

0 comments, 1,412 reads

Posted in SQLDownSouth on 15 January 2010

SSRS Data Driven Subscriptions Cryptic Job Names

When you create and schedule a Data Driven Subscription for a SQL Server Reporting Services (SSRS) report a job is created with a very meaningless name.  The name is actually a uniqueidentifier and is stored as such in the dbo.Schedule table in the ReportServer database.  I was recently asked if… Read more

0 comments, 804 reads

Posted in SQLDownSouth on 14 January 2010

MVPs on the SQL Lunch

On January 19th and February 25th the SQL Lunch will have two well known authors, speakers and MVPs presenting at the SQL Lunch.  First on January 19th, Brian Knight will be presenting Scripting in SSIS and if that is not enough Brad McGehee will… Read more

6 comments, 602 reads

Posted in SQLDownSouth on 14 January 2010

SQL Lunch #8 – SSRS Data Driven Subscriptions (Devin Knight)

Join Devin Knight for a SQL Lunch at 12:30 EST today to hear about using the SSRS Data Driven Subscriptions! http://www.sqllunch.com

SQL Lunch # 8 – SSRS Data Driven Subscriptions

Speaker: Devin Knight

Topic: SSRS Data Driven Subscriptions


Add to Outlook


In this session, you’ll… Read more

2 comments, 780 reads

Posted in SQLDownSouth on 12 January 2010

Handling Database Mirror Failover within an SSIS Package

Recently I was asked how to handle a Mirrored Database Failover within an SSIS package.  For those of us that don’t write connection strings and simply use Graphical User Interfaces (GUI) to create the connections, we tend to overlook certain attributes that are available when creating connections to SQL… Read more

1 comments, 2,050 reads

Posted in SQLDownSouth on 7 January 2010

2010 First Quarter Goals

I have been reading several blog postings about 2010 goals. First, I want to applaud all of you for setting goals for the entire year. Moreover, I would like to say that I admire those that can actually achieve their annual goals, like my good friend Steve Jones. Can… Read more

2 comments, 528 reads

Posted in SQLDownSouth on 5 January 2010

SQL Lunch #7 – Top Tablix Tips

SQL Lunch # 7 – Top Tablix Tips

Speaker: Jessica Moss

Topic: Top Tablix Tips

Add to Outlook:  Add to Calendar


SQL Server Reporting Services 2008 introduces the tablix, a combination of a table and a crosstab report. This lesson shows how to set up the tablix, the properties… Read more

0 comments, 1,444 reads

Posted in SQLDownSouth on 4 January 2010