SQL Server DBA

Microsoft SQL Server DBA

Monday, March 22, 2010 7:52:31 PM

574 Views

All Training Areas

Find links and hints to resources for creating tables, indexes, triggers, constraints, dts packages, scheduled jobs, back ups, replication, and database restorations.

Data Definition Language (DDL)
Data Definition Language (DDL) are the statements used to create, alter and delete (DROP) databases and database objects such as tables, views and indexes.
	Tables and Views
	Data Types
	Referential Integrity

SQL Server Security
SQL Server security functionality includes highly-granular authentication, authorization and validation mechanisms; strong encryption; security context switching and impersonation; and integrated key management.
	Users and Logins

Full-Text Search Administration
Full-text search allows fast and flexible indexing for keyword-based query of text data stored in a SQL Server database. In contrast to the LIKE predicate, which only works on character patters, full-text queries perform linguistic searches against this data, by operating on words and phrases based on rules of a particular language.
* The editors are constructing topics for Full-Text Search Administration.

Integration Services
SQL Server Integration Services (SSIS) is a platform for building high performance data integration solutions, including extraction, transformation and load (ETL) packages for data warehousing. Integration Services includes graphical tools and wizards for building and debugging packages; tasks for performing workflow functions such as FTP operations, for executing SQL statements, or for sending e-mail messages; data sources and destinations for extracting and loading data; transformations for cleaning, aggregating, merging, and copying data.
	Data Transformation Service (DTS)
	Import / Export

Analysis Services
SQL Server Analysis Services (SSAS) provides online analytical processing (OLAP) and data mining functionality for business intelligence solutions. Analysis Services combines the best aspects of traditional OLAP-based analysis and relational-based reporting. It provides a rich set of data mining algorithms to enable business users to mine their data looking for specific patterns and trends.
* The editors are constructing topics for Analysis Services.
Reporting Services
SQL Server Reporting Services is a server-based reporting platform that is used to create and manage tabular, matrix, graphical and free-form reports that contain data from relational and multi-dimensional data sources such as SQL Server, Analysis Services, Oracle or any .NET data provider (ODBC or OLE DB).
* The editors are constructing topics for Reporting Services.

Back-up and Restore
One of the fundamental tasks of a SQL Server database administrator (DBA) is to perform database backup on a daily basis and to perform database restore as needed. Database backup is part of disaster recovery procedure that should be in place in any data centers housing SQL Server databases.
* The editors are constructing topics for Back-up and Restore.
Replication
Replication is used to copy and distribute or replicate data and database objects from one database to another and then synchronize these databases to maintain consistency. The three types of replication are snapshot, transactional and merge replication.
	Snapshot Replication
	Transactional Replication
	Merge Replication
	Database Synchronization