SQL Server Administration

	SQL Server availability To have a highly available SQL Server data center, means implementing methods to minimize downtime. What SQL Server failover technologies do you rely on? Articles discuss RAID options, replication, database mirroring and overall best practices for SQL Server High Availability.
	SQL Server backup and recovery Having a reliable and well-tested backup and recovery procedure is essential to protecting your SQL Server data when things go wrong. Get help establishing, maintaining, testing and verifying your backup and restore plan from the best practices found here.
	SQL Server security Protect your SQL Server databases with this expert advice. SQL Server security topics include SQL injection, how to lock down SQL Server and how to meet compliance laws. Improve database security practices with software security tools, code hardening, encryption and more.
	SQL Server performance and tuning To ensure your SQL Server databases and applications run at their full potential, you must continually identify performance problems and quickly address bottlenecks. From testing and monitoring to indexing and troubleshooting, find a resource to help improve SQL Server performance.
	SQL Server clustering SQL Server clustering means reliability for production database environments. Clusters help run a highly available SQL Server, but setup and design decisions take involve planning. These tutorials guide you toward the right cluster configuration choices and cluster-build process.
	SQL Server DW/BI Check out these resources for successful SQL Server data warehousing and business intelligence (DW/BI). Learn how to work with BI Development Studio, Analysis Services, Reporting Services and more. Also improve your SQL Server development environment with articles on DTS and also SSIS.
	SQL Server replication Implementing and maintaining replication is not a simple task, particularly if you have numerous database servers that need to be involved in various types of replication -- but there are benefits to replicating your SQL Server databases. Read up on replication methods.
	SQL Server database design and modeling Having an accurate and up-to-date data model will help you create high-performing applications from the get-go and better meet the needs of end users. Get the tips and tools you need for creating your data model and designing an effective database.
	SQL Server installation You have a lot to keep in mind when installing SQL Server -- hardware requirements, clustering, default collation, file locations, number of instances, service accounts, etc. Get help preparing for your SQL Server installation in this section.
	SQL Server integration/interoperability Many businesses store data across heterogeneous database servers or in various storage systems, formats and locations. You often need to resolve these dissimilarties for the data to be used. Get help overcoming SQL Server integration and interoperability issues here.
	SQL Server OLTP Online transaction processing (OLTP) environments allow you to operate applications that typically have large number of customers or clients making short transactions -- and performance tuning quickly becomes a top-of-mind concern. You'll find OLTP tips and expert advice in this section.

	SEE ALSO - Topics Related to SQL Server Administration:  SQL Server Development, SQL Server Platform, SQL Server Management Issues