(Anuj Khadloya) This article helps to add paging to any ASP.NET/WinForms grid. The benefit of using this method is it doesn’t fetch all the data at once, but only the required data from the database, thus improving the performance of the page by many folds when the amount of data is large.

(Ashish Kumar Mehta) Microsoft released the final version of SQL Server 2008 R2 Express Edition on April 21, 2010. SQL Server 2008 R2 Express Edition continues to ship in 4 different packages. One can download Microsoft SQL Server 2008 R2 Express Edition from the following link. In this article we w

(Arshad Ali) SQL Server provides several system meta data functions which allow users to get property values of different SQL Server objects/securables. Although you can use the Catalog views or Dynamic Management Views to get the information, sometimes the system meta data functions simplify the pr

(Vijay Rodrigues) SQL Server Management Studio provides a way to monitor events, such as replication agent events, using alerts. SQL Server includes a set of predefined alerts for replication agents. If you would like to start the monitoring for replication agent failures, please follow below steps.

(Ken Simmons) I rely on Database Mail to send notifications for SQL Server Agent job failures. Is there a way to ensure that the mail will be delivered if something were to happen to the operators in msdb database?

(Adam Machanic) In this post I set out to determine whether ISNULL is faster than COALESCE, even though I admitted that I didn’t particularly care about the results:

(Pinalkumar Dave) I recently received an email that contains a question from one of my readers. I have already replied the answer to his email, but I would still like to bring it to your attention and ask if you think I could have done any better with the example I gave.

(Zhiming Xue) I recently helped move data from a small SQL Sever 2000 database to SQL Server 2008 from one hosting environment to a different hosting environment. I tried several approaches and fortunately found one that worked well. You can find the detail in the post.

(Eric Johnson) So you decided to set up log shipping in order to establish a failover server, but what’s next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the event of a real disaster, there are several other components on your SQL Server that you

(Gregory A. Larsen) If you are using SQL Server Reporting Services much, then you probably have moved a number of reports into one RS folder or another. You most likely have done this using the deploy process within a Business Intelligence Development Studio project or used the “Upload” button withi