Browsed by
Category: SQL

Scanning SpeedPASS and Raffle Tickets

Scanning SpeedPASS and Raffle Tickets

So you come back from organizing an awesome SQL Saturday, and now there are these admission tickets and raffle tickets waiting for you to be scanned. I am just in the post-processing of my first SQL Saturday as the main organizer and I was already wondering if there is an efficient way to do this. And there is! So for everybody who will be in the same boat, I hope you can save some time with this method as well….

Read More Read More

Using SSAS dimension data with different labels

Using SSAS dimension data with different labels

In relation to my article about using date pickers to filter SSRS cube data, I have been asked a few times how it would be possible to use one set of parameters to select the date range that points to dimension data from different cubes.For example, I have a report that pulls data from two different cubes. In the one cube, the main time dimension is called “Date”, and in the other cube there is a time dimension that is…

Read More Read More

Various SQL date formats to use with SSIS, SSAS and/or SSRS

Various SQL date formats to use with SSIS, SSAS and/or SSRS

While designing data warehouses, SSIS packages, etc., like myself you’ve probably ran into the issue of having to format different date and time values that ends up in a long string of SQL code or expressions in SSIS. The purpose of this post is to collect some links to various pages where these kind of date and time formatting can be found. Getting only date part of a datetime field First of all, the function that I used the most…

Read More Read More

Report on your reports

Report on your reports

When you deploy your SSRS reports, you might want to know about how they perform. Or maybe your reports perform allright, but there might be improvements on how the end users can be presented with the reports even faster. Also, you might have deployed a bunch of reports that nobody reads but they’re just sitting there… To get insight into these things, the ReportServer database has a few tables that contain log records of your reports. First of all, by…

Read More Read More

Refresh local cache for IntelliSense

Refresh local cache for IntelliSense

I have come across many situations where I had a SQL Server query window open and I changed something in my table definitions. This resulted in not being able to use the IntelliSense on those new columns or tables. In SQL Server Management Studio, you can refresh the IntelliSence cache by pressing Ctrl+Shift+R, or go to Edit – IntelliSense – Refresh Local Cache: It takes a second or two when the query has been updated, but at least you can…

Read More Read More

Monitor your SQL database size and disk space

Monitor your SQL database size and disk space

I faced the challenge of retrieving information about the size of different databases on different servers and the disk space left on the server. Basically I wanted to find a way how I can retrieve this data periodically so I could monitor the growth of the databases and the disk space left. I decided to create an SSIS package from this that loops through the servers and databases to get the information out of it from one single package. In…

Read More Read More

Group small values into an “other” category in a Reporting Services chart

Group small values into an “other” category in a Reporting Services chart

The following chart is a simple pie chart from the Adventure Works SSAS cube (Analysis Services) where I show the reseller’s gross profit by product in the United States. As you can see, it’s trying to squeeze in all the products into the pie chart with very small numbers for a lot of products. But what to do when you are only interested in the products that are selling the best? So basically I would like to show the top…

Read More Read More