SQL Server DBA - Oracle DBA - MySQL DBA

Welcome to the SQL DBA website. This website discuss issues related to database administration, development, database modeling, normalization techniques, best programming practices and SQL scripts to help database administrators and developers. The site offer solutions to daily database related problems and much more. The main purpose of this site is to create an online resource center with expert tips on database related technologies.

This website is operated by DBA's and developers who are working with famous database engines (SQL Server, Oracle, MySQL).

Microsoft SQL Server DBA (SQL Server Database Administrator)

MS SQL Server Logo, SQL Server Database Administration - sql server dba


Oracle DBA (Oracle Database Administrator)

Oracle logo database administration - Oracle DBA


MySQL DBA (MySQL Database Administration)

MySQL Database administration, mysql dba - mysql server dba

A Database administrator (DBA) is an individual who is expert with one or more database systems have necessary knowledge to perform database administration tasks, the main purpose of a DBA in any organization is to manage the company data. The most famous database administrators (DBA's) of well known database management systems could be of Oracle DBA, SQL Server DBA, MySQL DBA, DB2 DBA and Sybase DBA. There are many more database engines in market which require full time administration like Teradata, SAP etc. A DBA role is different then database developer, many confuse these two different job roles as one, I guess because in many companies a DBA is also the database developer, data architect etc. wearing many more hats.

Important DBA Tasks (Database Administrators)

  • Data Protection and Recoverability (dba job is designed for this main task)
  • Security of Data and Database System (most important task)
  • Availability of database servers
  • Performance management
  • Data Integrity
  • Database support
  • Development (development dba)
  • Analysis
  • Database Designing

In each organization DBA role can be changed according to the needs and technology of database system.

New in SQL Server 2008 for DBA's and Developers

There are lot of new enhancements coming in SQL Server 2008, many of these new features were already available through third party software vendors but now they are included in SQL Server 2008. Many new features are specific to database administrators / dba and some are designed for developers.

  • Sparse Columns and Column Sets
  • PowerShell Integration
  • Compressed storage of Tables and Indexes
  • Filtered Indexes and Statistics
  • Query Edition Intellisense totally new in SQL Server 2008 
  • Customized database engine auditing
  • Compressed backups
  • Enhanced CONVERT function
  • Configuration Servers to designate one SQL Server as configuration server.
  • Change management tracking.
  • FILESTREAM Storage
  • Hot add CPU (dynamically adding cpu's)
  • Extensible Key Management
  • Transparent Data Encryption
  • Automatic Recovery from corrupt pages.
  • Change data capture
  • Merge statement totally new feature in SQL Server 2008
  • Tabl -Valued Parameters long waited
  • FORCESEEK table hint


Advertisements

MySQL HOSTING
MySQL hosting provider, clustering and replication supported. DBA Services Included.

SQL SERVER HOSTING
Reliable, powerful SQL Server 2008 hosting with ASP.NET on Windows 2008 Servers.

SQL Server DBA

I am a SQL Server DBA with almost 9 years of experience in database technologies.

Once again I am in process of redesigning this website using ASP.NET 4.0 and AJAX. The main purpose of new SQL DBA website is to offer more features and make it easy for me and anyone else to update contents on regular basis.