Knowledge is power. We love to share it.

News related to Mono products, services and latest developments in our community.

Goran

How to prevent data loss during delete/update in SQL Server

04/22/2013 By Goran 0
Rated 2.00, 16 vote(s). 
Bookmark and Share
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.
Goran

Custom colors for chart report items in SQL Server Reporting Services 2008

07/17/2012 By Goran 1
Rated 2.56, 16 vote(s). 
Bookmark and Share
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.
idrazic

Different ways of importing data into SQL Server

03/31/2012 By idrazic 1
Rated 1.86, 28 vote(s). 
Bookmark and Share
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.
Goran

SQL Server 2008 – Date&Time tips and tricks

03/15/2012 By Goran 0
Rated 2.46, 13 vote(s). 
Bookmark and Share
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. 
Goran

Drill down in SQL Server Reporting Services 2008

11/06/2011 By Goran 11
Rated 2.95, 19 vote(s). 
Bookmark and Share
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.