SQL wildcards are used when searching for data in a database. They can substitute one or more characters when working with string types.

This tutorial will show you how to restore MS SQL database a backup on a new server. I presume you have backup file already.

This is the fourth part of MS SQL backup maintenance plan tutorial, and continues from Create MS SQL Shrink Databases Task one.

This is the third part of MS SQL backup maintenance plan tutorial and continues from Create MS SQL Back Up Database Task.

This is the second part of MS SQL backup maintenance plan tutorial. Here we will discuss how to create and setup MS SQL Back Up Database Task.

Probably one of the worst things that can happen is to loose data especially a database which is dynamically changed.

Basically stored procedures are functions that you can create in a database and use multiple times. Using stored procedures is considered a good practice and holds many advantages.

This tutorial is about how to create, update and delete views in MS SQL 2008. In SQL views are basically virtual tables based on the result of some SQL statement.

The UNION, EXCEPT and INTERSECT operators can be used to provide a single result set from multiple SQL queries.

This how-to is about how to create database diagrams using MS SQL Server Sometimes the best way to visualize data is by using a diagram.

This tutorial is a part of our MSSQL tutorials section and it is about Using Common Table Expressions in MSSQL.

This tutorial will show you how to change/update/reset the password on the 'sa' account from the graphical interfaces of MSSQL Server 7.

This tutorial will show you how to change the password from the command line on MSSQL Server or MSDE.