Azure. Business Intelligence. SQL Server. Nerd Stuff.
As you can see we have two tables, with the same values. Joining on these tables is no problem at all. Simple, right? Well, take a look at what happens when we try to join on the column containing the NULL values....
There are a number of ways that you can calculate dates using T-SQL. A common practice is to find the first day of the week which can be accomplished easily by using the following function. SELECT DATEADD(wk, DATEDIFF(wk,0,GETDATE()), 0) However,...
More often than not an execute SQL task in SSIS will do the trick. If not, then the data flow will accomplish whatever objective is set out. Occasionally those can become cumbersome in a package to accomplish something simple. In...
by Bradley Schacht · Published January 17, 2010 · Last modified October 13, 2015
This past week I ran into an issue where I needed to use a .dbf destination in my SSIS package. All was going well; I set up the destination and pressed the preview button to make sure everything was great,...
by Bradley Schacht · Published December 21, 2009 · Last modified October 13, 2015
The first step in setting up a report server is getting Reporting Services installed. There are a few differences between the process for 2005 and 2008. On the installation side, if you do not have the IIS setting configured before...
by Bradley Schacht · Published December 18, 2009 · Last modified October 13, 2015
After my first day of SSIS training my boss walked into the office and said to me, “how was the first day of class”. To which I responded, “great!” Then asked me, “so what is the difference between the control...
by Bradley Schacht · Published December 16, 2009 · Last modified October 13, 2015
If your like me, then you may have a little OCD and need everything to be completely organized in your environment. BIDS has been annoying me in this respect lately. I am working on creating a data warehouse and will...
I recently created a maintenance plan for our server to backup all the databases on a daily basis. In the cleanup step I set it to delete backups older than 7 day. I let the plan run for a week...
You may need to do an update on joined tables to get a more conditional update. For instance, I have a Student table as well as an AcademicStatus table. The Student table contains all the students (profound, I know) and...
by Bradley Schacht · Published November 20, 2009 · Last modified October 13, 2015
Have you ever opened your report server only to find a blank section of nothing-ness where your reports should be? The solution to your problem is more than likely in the permissions. The easiest fix for this situation is to...
