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...
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. After digging a bit I found a very simple solution. Right-click on the Visual Studio icon or the Business Intelligence Development Studio icon and click Properties . Then go to the ...
I have read several articles about deploying SSIS packages. Most focus on using the deployment wizard or simply copying the files and their dependent properties onto the server. For companies with a small number of SSIS packages the later appears to be the method of choice. Recently, I was asked if there was a way to accomplish this without leaving Business Intelligence Development Studio (BIDS). To deploy a package from BIDS complete the following steps: 1. Open your SSIS package in BIDS: 2. On...
SQL Lunch # 5 – Looping Logic in SSIS Speaker: Tim Mitchell Topic: Looping Logic in SSIS Meeting URL: JOIN MEETING ADD TO OUTLOOK CALENDAR Description: Software developers have long taken for granted the ability to run iterative processes by using loop structures in their code. For SSIS developers, these same structures are available through the For Loop and the For Each Loop controls. In this session, we'll review each of these containers and demonstrate how they can be used for repetitive proc...
Topic An Overview of Business Intelligence Location: At Lamar Advertising Wednesday, December 2, 2009 6:00 PM - 8:00 PM Sponsored by: EMC Presenter Brandon McMillon Brandon McMillon is a Senior Solutions Principal at EMC. He has 10 years of experience at Microsoft, working on the Visual Studio & Windows development teams. He was also a Chief Software Architect for a Microsoft Gold Partner before coming to EMC. Abstract: This talk will first examine the current marketplace for Business Intell...
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 with the following report: The data in the report can be reproduced using the stored procedure provided at the end of the posting. As you can see the report contains Sales data from each country. Looking...
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 user-defined type. So how do you use it? The first step is to create a Table Type. See the following script: USE AdventureWorks2008 GO IF EXISTS ( SELECT * FROM sys . types WHERE name = 'CountryCodes' AND schema_id = SCHEMA_I...