Data Engineering – Learn from the experts
-
Script Default Databases
Default Database is one of the most important parameter when we detach the database. If we don’t have the track of default db for logins then it might be a problem when you use an application. Consider you are planning to move a user database from X: drive to Y: drive and your application login…
-
Detach User Databases
I started side by side upgrading SQL 2000 to SQL 2005, at that time I need to detach all the user databases from the source server and need to attach the same in destination server. Source server has almost 80 user databases and I feel bored to detach all the database one by one which…
-
Backup Script with Retention
Introduction: SQL Backup script is available all over most of the online resources. I couldn’t find a script to take care of retention also, so Im writing this script as procedure to take care of retention too. This script will take full backup of all the databases.
-
SQL Server Configuration Settings
Introduction: This article brings you the allowable configuration options in SQL Server which includes options that are new to SQL Server 2008 also. The options can be used to tune, optimize and maximize the performance of the system in variety of ways. But careful planning and examination should be done before you implement the change.…
-
Database Mail
Introduction: Database Mail is a new feature that comes with SQL Server 2005. It was very difficult to configure and send mails with the SQL mail feature in SQL Server 2000. In fact SQL mail had lot of prerequisites and had few problems known and unknown. With SQL server 2005 Database mail had got a…
Got any recommendations?