Knowledge is power. We love to share it.

Making database backups prior to update/delete operations is the only way that ensures painless recovery of mistakenly deleted data. Here are a few tips that could save some time and money in the process.

If you are reading this post, you probably came here searching for a solution that will always assign the same color to an item in SQL Server Reporting Services 2008, based on your custom parameters. I will show you how to custom-color the items in a way that each item is shown in the same color, each time report is being run.

In today's article, I'll post a very interesting function. It calculates the number of minutes between two points in time. Did I hear you say "Lame, I can use DATEDIFF function for that!!!"? Well, what my little function does, other than calculating minutes between two points in time, is that it works for a given "time window" and DATEDIFF in it's default form is not enough for that.

In this article, I will show you a couple of SQL code snippets related to Date&Time in SQL Server 2008, including date formatting and comparison scripts. I hope you will find them useful. 

SQL Server Reporting Services offers a lot of functionality out-of-the-box. There are times, however, when you need to understand some of the subtleties of the report designer to get the right results. This time we will learn how to implement a drill down feature to navigate through large chunks of data.

This tutorial will teach you how to write a custom SQL Server function for parsing delimited strings. It is particullary useful if you are passing a parameter that contains multiple string values to be used as a filter for “IN” expression in SQL.