Database administration guru's guide
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. The site will 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 technologies, there is plenty of material available online but they lack expert advices on what is the best method to do same thing you have been doing as a DBA for years.
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)
Oracle DBA (Oracle Database Administrator)
MySQL DBA (MySQL Database Administration)
Latest SQL DBA Articles
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.
Most Important Tasks of DBAs (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
Database analysis
Database Designing
In each organization DBA role can be changed according to the needs and technology of database system.
SQL Server 2008 for database administrator (DBA) 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. In SQL Server enviorment majority of developers wear dba hat too, this means both should enjoy all the new features of SQL Server 2008.
- 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
Create SQL Server database
T-SQL Code to create database
Create database DATABASE_NAME