Database Management and Administration

NEWS: 1 - 2 of 2

	Ensuring SQL Server data integrity SearchSQLServer.com | 13 May 2005 ARTICLE - Ensuring SQL Server data integrity on many fronts is covered in this step-by-step guide.

	Step-by-Step Guide: How to patch SQL Server SearchSQLServer.com | 21 Mar 2005 ARTICLE - This first guide in a two-part series on SQL Server patch deployment will help you track down those pesky servers before getting them properly patched.

	VIEW ALL NEWS ON DATABASE MANAGEMENT AND ADMINISTRATION

EXPERT TECHNICAL ADVICE: 1 - 3 of 557

	Using traces in SQL Server Profiler Submitted By: SearchSQLServer.com | 12 Nov 2009 TIP - A SQL Server Profiler trace can provide critical information on a problem query in a matter of seconds. Learn how – and when – to run the application.

	Meet compliance requirements with improved database security practices Submitted By: SearchSQLServer.com | 05 Nov 2009 TIP - Small but consistent changes are the trick to securing your SQL Server database and maintaining compliance with the latest industry rules and regulations.

	Securing the server and database in SQL Server Submitted By: SearchSQLServer.com | 30 Oct 2009 TIP - Hardening SQL Server at the database and server levels is crucial to a secure environment. Learn why in part two of our SQL Server security series.

	VIEW ALL EXPERT TECHNICAL ADVICE ON DATABASE MANAGEMENT AND ADMINISTRATION

REFERENCE & LEARNING: 1 - 3 of 24

	Top 10 SQL Server development tips of 2008 Steve Cimino, Assistant Editor | 07 Jan 2009 THE YEAR IN REVIEW - From converting date/time values into character types to retrieving XML data values with XQuery, these were the top 10 SQL Server development topics of 2008.

	SQL Server queries with DMVs for examining bottlenecks Hilary Cotter | 26 Jul 2007 STEP-BY-STEP GUIDE - Here, you'll find queries incorporating Dynamic Management Views (DMVs) that display information on some of the common SQL Server performance bottlenecks.

	Detect performance bottlenecks with these tools Hilary Cotter | 26 Jul 2007 STEP-BY-STEP GUIDE - Detect performance bottlenecks in SQL Server with these four tools: Task Manager, System Monitor, SQL Profiler and Dynamic Management Views (DMVs).

	VIEW ALL REFERENCE & LEARNING ON DATABASE MANAGEMENT AND ADMINISTRATION

DOWNLOADS: 1 - 1 of 1

	Podcast: SQL Server high availability options Published by: SearchSQLServer.com | 27 Aug 2007 PODCAST - In this podcast series, you'll get the basics and best practices for each SQL Server high availability option including database mirroring, replication and log shipping.

	VIEW ALL DOWNLOADS ON DATABASE MANAGEMENT AND ADMINISTRATION

	SEE ALSO - Topics Related to Database Management and Administration:  Data Warehousing and Business Intelligence, Database Development, SQL Server for the 'Reluctant' DBA