Category: DBA
-
Linked Server – Part 1
What is Linked Server? Linked server is a concept in SQL Server to access external data sources. This external data sources can be Access, Oracle, Excel, SQL Server or almost any other data system that can be accessed by OLE or ODBC. Where it is used?? A linked server configuration enables SQL Server to execute…
-
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…
-
DBCC Commands
Introduction: Any SQL Server DBA does some maintenance or the other to the SQL Server instances and/or the databases. The maintenance tasks might include using some utility, scripts, third party software, TSQL, etc. The most used among them are the DBCC commands. This article brings in the list of commands available and those that are…
-
Mirrored Backups
Mirrored backup is a feature available in SQL Server 2005 Enterprise Edition and Development Edition. Mirroring a media set increases backup reliability by adding redundancy of backup media which effectively reduces the impact of backup-device failing. While taking backup of database, same backup is taken on multiple media or locations.