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.

Data import is one of those tasks that are performed on a daily basis. This post describes three different approaches for importing data into the SQL Server database.

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.