Beta Release - Please Report Issues
Who is online? 698 guests and 3 members
Member login | Become a member
Add a blog post
home » blogs
I was browsing the Microsoft Learning portal over the weekend and came across the following free or dicounted learning resources for SQL Server. Free Resources: Clinic 6188: What's New in Microsoft SQL Server 2008 for Enterprise Data Platform (1 hour) Clinic 6189: What's New in Microsoft SQL Server 2008 for Business Intelligence (1 hour) Clinic 6190: What's New in Microsoft SQL Server 2008 for Database Development (1 hour) Clinic 6258: New Features Of Microsoft SQL ...
Read More
Recently I was asked to provide a list of all sql jobs on a certain server running between 2 and 3 in the morning. We have quite a few jobs and it would be time consuming to look through each to determine the time of day each runs. So I used the sysjobs, sysjobsschedules tables to return the job name and times the jobs run. There are several jobs related tables in the msdb database: sysjobs sysschedules sysjobhistory sysjobsteps syscategories The table names are pretty self explanatory. The...
When developing reports that use Analysis Services as a data source end user can sometimes be confused about some of the options they see in report parameters. Anytime you have a parameter that allows for multiple values to be selected then you will see a (Select All) option that Reporting Services adds that make for an easy way to check off each item in the parameter dropdown. If you followed most of the defaults when developing you dimensions in Analysis Services you likely also have an opt...
Yesterday, I dealt with a client that was having issues converting his dts packages to SSIS 2008. He was using DTS xChange to convert the packages, but each time he tried to run the migration, he received the following error. "Can not load Tasks. Error : Unable to cast COM object of type 'System.__ComObject' to interface type 'DTS.CustomTask'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{10020904-EB1C-11CF-AE6E-00AA004A34D5}' failed d...
So I finally got through all the SSIS Class Labs including the Group Labs and decided to figure out why I didn't have AdventureWorks2008. I had previously tried to enable FILESTREAM according to some blogs I had read about it but had no success. Maybe I just understand all this a little better now but when I exactly followed these steps right out of the help file it worked for me: 1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and t...
Many times while working with SSIS I have had issues where I would like to add a temp table to a stored procedure that is a source for my SSIS dataflow. One work around for this is create a temp table variable instead. The issue with this is if many rows are in this temp variable the performance can be severely degraded. So the other day I was searching for workarounds and found this link http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65112/ . Here Michael Cape gives a Wack...
Package Configurations in SSIS are key to making your packaged portable across the entire development process. The problem you being to face with configuration files is the quantity that you collect. Recently I was working on a project where we had pacakge level configurations as well as a configuration for each connection. In order to to updates on this would have taken a very large amount of time, especially since I had to make configuration files for dev and production. I opted to go with...
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, you will notice that this returns the date for Monday as SQL Server uses Monday for the start of the week. If your week starts on Sunday or you need to get the date for the previous Sunday you can simply modify the DATEADD part of the query from adding z...
Today I figured I go back to basics with this blog since a majority of the visitors to this site are primarily DBA's and Database Guru's. This may turn into a series but for now we will discuss a bit of a feared power of sql server, and that is the fact that sql server in fact sits on top of the .net framework. This allows it to access its immense power and array of options that one just couldn’t do efficiently using traditional tools, in both the BI Stack and SQL’s T-SQL function library. This ...
During a T-SQL class that I was recently teaching I was asked if a PIVOT could be performed using a Common Table Expression (CTE). In other words, instead of using the method outlined in SQL Server Books Online that uses a derived table, replace the derived table with a CTE. I have never attempted this approach, but I was confident that it could be done. Using the AdventureWorks database I initially wrote a T-SQL PIVOT statement that uses a derived table, which is as follows: USE AdventureWor...
It's fast, easy and free! Submit articles, get your own blog, ask questions & give answers in the forums, and become a better developer, faster.
enter your email address: