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 plates. Well over and beyond the sandwich, chips and cookie you will get when attending SQL Saturday in Baton Rouge, but I digress. Thanks to everyone that helped to put on such a successful event. My first session was IRON Chef America SQL. I acted ...
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 SQL Saturday there is time to make to any of these events. These events are free and a lot of fun. Visit the SQL Saturday home page for information about events in your area. For those attending the events in Tampa and Richmond I look...
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 what is scripted. Ironically, a fellow colleague and I experienced a very similar problem and decided to write a small application that should fulfill all of the requirements outlined by the blog posting with th...
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 it was possible to use the Job Name to identify the Report associated with the job. After a little digging I was able to produce the following query, which associates the Job Name with the Report Name: SEL...
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 be presenting an Introduction to Graphical Execution Plans on February 25 th . So if you haven’t attended a SQL Lunch I suggest that you add these events to your calendar. Go to SQLLunch.com and click on the Add To Calendar links for each of these e...
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 Server databases. If you have written connection strings you may already be familiar with the Failover Partner attribute that is available. When using an ADO.NET connection or a Native OLE DB\SQL...
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 you all believe that he ran everyday last year? Congratulations Steve!!. My goals tend to change as the year progresses. As a result, I decided to focus on setting quarterly instead of annual goals. Some may think that I lack ambit...