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

PASS Virtual Meeting

Speaker: 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

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

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

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

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

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

Meeting URL: JOIN MEETING

Add to Outlook

Description:

In this session, you’ll… Read more

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

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

SQL Lunch # 7 – Top Tablix Tips

Speaker: Jessica Moss

Topic: Top Tablix Tips

Add to Outlook:  Add to Calendar

Description:

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