One of these tasks may be the need to backup all databases on your server. This is not a big deal if you have a handful of databases, but using T-SQL is a much simpler and faster approach.

The database principal owns a schema in the database, and cannot be dropped. Fix error no 15138

Here is one of the script which I refer whenever I faced situation about restoring the database at point in time

This blog will contains articles on many technologies specially on database and c#

List of dates between two dates.

COUNT of Rows and Columns in selected database for all tables

SQL SERVER – Find Last Day of Any Month – Current Previous Next

The clustered index IS the data. The KEY to the clustered index defines the way that the data is ordered. A nonclustered index is duplicated data. This duplicated data can be used to help reference...

The blog illustrates how to access all databases and the Tables on a SQL Server programmatically.

Here you will learn about PARSE() function in SQL Server.

Split a String into more then one value by using any delimiters.

FOR ALL TABLE SET Foreign Keys to add ON DELETE CASCADE

Connecting SQL Server Analaysis Services Engine

Adventure Works deployment issue in SQL Server Analysis Services

Deployment issue in SQL Server Analysis Services

Installing AdventureWorks database for SQL Server 2008R2 version

SQL Tips

Triggers are fire by the database when specific types of data manipulation commands are performed on specific table or tables.

Paging Can improve your performance in ASP.NET application.

What is difference between Stored procedure and Functions? Stored procedures: