SQL Server Simple Recovery Model
The simple recovery model allows you to still take full database backups, but minimizes the use of the transacation log and does not allow transaction log backups.
SQL Server, T-SQL, Development, DBA and Career Resources
Human Created Content by Industry Experts for Developers, DBAs and Analytics Professionals
SQL Server Full Recovery Model
The full recovery model allows you to perform any type of backup on a SQL Server database such as full, transaction log, differential and more.
SQL Server Recovery Models
In this section we look at the different recovery models for databases and how this impacts the types of database backups.
SQL Server Backup Options and Commands Tutorial
In this tutorial we look at things you need to know about backing up your SQL Server databases.
Calculate Running Totals Using SQL Server CROSS JOINs
One challenge you may be faced with is the need to create running totals for query output, whether it be a straight query or for a report. Doing calculations such as this in Excel are pretty straightforward, because each cell can have a different formula
SQL Server Surface Area Configuration for Features Option Selection
I have been put in charge of securing our SQL Server 2005 servers. In a previous tip you discussed how to use some of the options of the Surface Area Configuration tool. I noticed there is also an option to configure settings for Features, but I am not cl
PowerShell Support in SQL Server 2008 with the Invoke Sqlcmd Cmdlet
In my organization we write scripts to perform all sorts of administrative functions on our many SQL Server instances as well as other server products. We are just getting started with using PowerShell and have heard that SQL Server 2008 provides some bu
Manage the size of SQL Server Transaction Logs
I've mentioned on a number of occasions I support an insane (I-N-S-A-N-E) number of databases and SQL Server instances. Doing so makes it difficult to pay as much attention to all aspects of your environment as you may need. In a perfect situation the D
Using Computed Columns in SQL Server with Persisted Values
In this article we look at SQL Server computed columns with persisted values and how to set this up along with some examples.
Gathering status and detail information for SQL Server Full Text Catalogs
I have several Full Text Search enabled databases and these databases contain several catalogs. Very often, I deploy these databases to many servers, so I need to know if these are deployed correctly and also find out as quickly as possible. I need to kn
Introduction to Windows PowerShell for the SQL Server DBA Part 1
I have been hearing about Microsoft's scripting language called Windows PowerShell which is extensively used for administering Windows servers. I want to know how Windows PowerShell can help me as a SQL Server DBA.
Getting additional error messaging information for SQL Server replication
In this tip we look at how to get additional information related to SQL Server replication errors for troubleshooting.
SQL Server 2008 Installation Process (Part 1 of 3)
The company where I work is investigating a migration to SQL Server 2008. I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part t
Using the SQL Server Surface Area Configuration Command Line Tool
In a previous tip on SQL Server security settings using the Surface Area Configuration tool (SAC), you have seen how you can use the tool to configure security settings in your SQL Server 2005 instance. Since I manage multiple instances across multiple se
Security issues when using aliased users in SQL Server
SQL Server has a lot of little features that are nice to use, but sometimes these things come back to get you. One such issue is the use of aliased users. This tip shows you how to find security holes when aliased users are setup in your databases and a
Retrieve Excel Schema Using SQL Integration Services SSIS
We use SSIS to periodically load data into our data warehouse. While much of the data we process is in relational data stores, we do have some Excel spreadsheets that we need to process. In one particular case we load an Excel spreadsheet that is produc
Where is the Surface Area Configuration tool in SQL Server 2008
I just installed a new instance of SQL Server 2008 and I can't find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Database Engine features in SQL Server 2008?
SQL Server function to validate email addresses
When you send e-mail to large lists, validating the e-mail addresses before sending out the e-mail is worth doing to prevent having mail rejection messages clog up your mail server. I had been doing the validation with a T-SQL User Defined Function (UDF)
SQL Server security settings using the Surface Area Configuration tool
I have been put in charge of securing our SQL Server 2005 servers. Are there any tools available that can help me get started? Are any tools available to secure SQL Server independent of the logins and users that I have in place? Do I need to manage SQL S
SQL Server Interview Questions for a Network Administrator
At our organization many folks wear a variety of hats, because we have a small and talented team. Although we have a SQL Server DBA, our Network Administrator also takes care of some of the SQL Server related tasks in our environment. We are looking to
Parameter List for all SQL Server Stored Procedures and Functions
In this tip we look at a simple query you can use to get a list of parameters for all stored procedures and functions in a database.
Updating the Passive Node in a SQL Server 2005 Cluster
Somewhere during the installation of a 3 node Active/Active/Passive clustered environment, the Service Pack and Hot Fix did not get properly updated for just one server of the third node in the cluster. This was discovered after the instance failed over t
How to setup security features for SQL Server
I have been put in charge of securing our SQL Server 2005 servers. Are there any tools available that can help me get started? Are any tools available to secure SQL Server independent of the logins and users that I have in place? Do I need to manage SQL
SQL Server CLR and SQL split functions to parse a delimited string
There are several tips and articles on the internet that discuss how to split a delimited list into multiple rows. This tip shows two approaches to this problem a T-SQL function and a CLR function.