DSA Futures

Use these scripts to create attach and detach statements for SQL Server

This Article is about Creating a SQL user using T-SQL Statements. The script will also grant the user db_datareader and db_datawriter role.

The syntax below will cycle the errorlog. The are more then one way to do this, this is just the one I like, and it works.

Fast Native SQL Backup syntax using stripes

Identify the Process ID of a SQL Server Instance

Indexes in databases, SQL Server or mySQL --USE Them!!!-- If there is not an index on the column, the server has to search Every page of the table for the item you are looking for. This is called scanning. On a table, especially columns with text in them, this is very, very expensive, and can take quite a while.

The steps to move any database file in SQL Server are similar, however, not the same. System database files require a couple additional steps.

Query the recovery model of SQL Server 2000 or SQL Server 2005 databases using the following queries.

Tempdb create date is a record of the last time SQL Server is started. This query gets the start date from the tempdb create date.

Return the SQL Server Identity Value Just Inserted

The SA account on a SQL Server should not be used as a user, application, or developer account. That is to say, it's intent was "System Administrator", and that's where it should be left at.

This script will change the owner of all the SQL Server jobs to sa. Get a list of the current job owners. Modify the script to change the job owner to the one you want.

Set SQL Server Recovery Model. The SQL Server recovery model is database specific. Change [?] to the name of the database. Use the sp_MSforeachdb system stored procedure to change the recovery model of all the databases at once.

SQL Server 2005 build list. Updated with Cumulative Update 16 for SP2 and CU 6 for SP3, published on SQL Server Centeral by Steve Jones

SQL Server 2000, 2005, 2008 database backup script

Microsoft Launches Preview of SQL Server Database Publishing Wizard

This Query will provide database sizes for all databases on a SQL Server

SQL Server index, a structure within SQL that is used to quickly locate specific rows within a table.

How to unlock SQL Server 2005 when your locked out of the SQL Server. Even if the builtin\administrators account is removed.

This t-SQL script will retrieve SQL Server database backup history for the last week.

Query SQL Server Job History by Date

5 Awful Truths About Money, How To Set Up LiveZilla, How to Connect to a SQL 2005 Server When You Are Completely Locked Out, Our Journey To Debt Freedom, Google Wave App Available For The iPhone, 50 + Scholarships for Space Studies, Purdue's Hotseat, How to Avoid Financial Mistakes in College