Manage

Manage

Learn to apply best practices and optimize your operations.

• Exception handling best practices in SQL Server 2005

  SQL Server 2005 brings you TRY/CATCH, a new T-SQL feature that helps find and address errors before they reach application code. Get best practices for working with the new feature. Continue Reading

• Basic ADO.NET data objects

  Basic ADO.NET data objects are runtime data-access types that have ADODB counterparts. Learn more in this chapter. Continue Reading

• Applying transactions to multi-table updates

  The SqlTransaction object provides clients with the ability to commit or roll back updates to SQL Server base tables. Here are steps to execute ADO.NET transacted updates. Continue Reading

• ADO.NET Typed DataSet objects

  Learn the differences between DataSets and disconnected Recordsets, then get methods for generating ADO.NET objects with VS 2005 and SQL Server 2000 or 2005. Continue Reading

• SQL Server example: Heavy insertion process from OLTP and triggers

  This example demonstrates why and how to avoid locks when inserting a large amount of data from a file to a table row by row in Microsoft SQL Server. Continue Reading

• SQL Server trigger example: INSTEAD OF triggers vs. AFTER triggers

  This example demonstrates when it's best to use INSTEAD OF triggers and when to implement AFTER triggers in Microsoft SQL Server.Continue Reading

• Designing and implementing triggers in Microsoft SQL Server

  Learn tips on SQL Server trigger design, including how to boost performance by grouping commands.Continue Reading

• SQL Server trigger example: One trigger vs. two for the same logic

  This examples explores if adding functionality to an existing trigger improves performance or if it's better to create a new SQL Server trigger.Continue Reading

• SQL Server trigger example: Nested triggers in SQL Server

  This example shows how to use triggers to summarize data for a table in Microsoft SQL Server that is heavily updated.Continue Reading

• Why use triggers in Microsoft SQL Server?

  The problem with triggers is they can't be seen. Learn how triggers work and get design considerations for SQL Server triggers.Continue Reading

• Efficient indexing for performance

  Some databases allow different types of indexing. Get an overview of index types and efficient indexing in this book excerpt?Continue Reading

• How to apply indexes in the real world

  The way an index is applied is generally dependent on the function of the table for which the index is created. Learn how to apply indexes in this book excerpt.Continue Reading

• Writing efficient queries

  Database model tuning comes with one big stipulation. Find out what it is in this book excerpt.Continue Reading

• Filtering with the WHERE clause

  There are many points to keep in mind when building efficient filtering for faster execution of SQL code. Read about them in this book excerpt.Continue Reading

• Database modeling exercises

  Test what you've learned in this 'Building Fast-Performing Data Models' chapter with this collection of exercises.Continue Reading

• When not to use indexes

  One of the most important questions is when should you create an index. This book excerpt will help you find the answer.Continue Reading

• Part 2: Cursor advantages

  When and why should you consider using cursors? Contributor Hilary Cotter spotlights cursor advantages.Continue Reading

• Part 1: How cursors work

  T-SQL cursors are like skyscraper window washers traveling up and down the skyscraper to stop at each window. Here Hilary Cotter explains exactly how cursors work.Continue Reading

• Part 3: Cursor disadvantages

  Cursors have been called memory hogs, poor performers and various other unflattering names. Contributor Hilary Cotter explains the cons of cursors.Continue Reading

• Part 4: Cursor example

  Contributor Hilary Cotter reviews a poorly rewritten cursor.Continue Reading

• Pitfalls of using T-SQL cursors

  Cursors have a bad reputation: They're considered poor performers, resource hogs and a favorite tool of every inexperienced DBA. But they do have a place. Contributor Hilary Cotter explains how cursors work and their pros and cons.Continue Reading

• Top five T-SQL stored procedures

  From finding columns and tables to executing code from a file, Brian Walker's top five stored procedures will offer the simple tricks you need to get routine tasks done.Continue Reading

• T-SQL code to create stored procedures

  Contributor Brian Walker provides the code you need to create six system stored procedures to support a surrogate key architecture.Continue Reading

• What are surrogate key values

  Contributor Brian Walker emphasizes that surrogate key values have no intrinsic meaning in this feature.Continue Reading

• Managing Tables Using Object Explorer

  Learn how to create tables belonging to your new database in this excerpt from the book SQL Server 2005: A Beginner's Guide.Continue Reading

• Managing Databases Using Object Explorer

  Object Explorer allows you to inspect objects in a server and manage your server and databases. Get started in this excerpt from SQL Server 2005: A Beginner's Guide.Continue Reading

• Introduction to SQL Server 2005 Management Studio

  Get started understanding and working with SQL Server 2005 Management Studio in this excerpt, from the book SQL Server 2005: A Beginner's Guide.Continue Reading

• Using Management Studio with the SQL Server Database Engine

  Learn how SQL Server Management Studio works in this excerpt from the book SQL Server 2005: A Beginner's Guide.Continue Reading

• Authoring Activities Using SQL Server Management Studio

  SQL Server Management Studio gives you an authoring environment for all types of queries. Read more in this excerpt from SQL Server 2005: A Beginner's Guide.Continue Reading

• Management Studio Exercises

  Wrap up your lesson on SQL Server 2005 Management Studio with a few exercises to test what you learned, excerpted from SQL Server 2005: A Beginner's Guide.Continue Reading

• A typical data warehouse design review

  W.H. Inmon offers a thorough list of steps for a typical data warehouse design review in this excerpt from his book "Building the Data Warehouse," courtesy of Wiley.Continue Reading

• Data Warehouse Design Review Checklist

  To ensure a quality data warehouse, you need a thorough design review. This chapter from the W.H. Inmon book "Building the Data Warehouse," offers steps for an effective review.Continue Reading

• Restore basics: How to restore SQL Server using Enterprise Manager

  To restore a SQL Server database you have two basic options. Edgewood Solutions' Greg Robidoux explores the first of two in this SQL Server restore series.Continue Reading

• SQL Server 2005: A Beginner's Guide: Chapter 2, 'SQL Server Management Studio'

  Get lessons on working with SQL Server 2005 Management Studio in this collection of excerpts from the book "SQL Server 2005: A Beginner's Guide".Continue Reading

• Quick steps: Viewing index information using sp_helpindex

  Get a routine to view index information in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation.Continue Reading

• Quick steps: Rebuilding all indexes using DBCC DBREINDEX

  Learn how to rebuild indexes in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation.Continue Reading

• Quick steps: Creating an indexed view

  Learn how to create an indexed view in SQL Server 2000 in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation.Continue Reading

• Creating an index with Index Tuning Wizard

  Get steps to create an index with Index Tuning Wizard in this book excerpt from "MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation."Continue Reading

• Stored procedures: Create and delete constraints and indexes

  This collection of six stored procedures will help you create and delete constraints and indexes.Continue Reading

• Why use surrogate keys

  Contributor Brian Walker explains the benefits of using a surrogate key database architecture, such as stability, performance, simplicity and consistency.Continue Reading

• A surrogate key architecture

  Contributor Brian Walker offers a surrogate key architectur that will allow you to perform many powerful operations on the database schema or the data itself.Continue Reading

• DDBMS (distributed database management system)

  A DDBMS (distributed database management system) is a centralized application that manages a distributed database as if it were all stored on the same computer.Continue Reading

• Vulnerable stored procedures

  Learn about security vulnerabilities in SQL Server Stored procedures in this excerpt from "The Database Hacker's Handbook: Defending Database Servers" by David Litchfield, Chris Anley, John Heasman and Bill Grindlay.Continue Reading

• How SQL Server hackers cover their tracks

  Learn how a SQL Server attacker can cover their tracks in this excerpt from "The Database Hacker's Handbook: Defending Database Servers" by David Litchfield, Chris Anley, John Heasman and Bill Grindlay.Continue Reading

• SQL injection

  Learn about SQL Server injection in this excerpt from "The Database Hacker's Handbook: Defending Database Servers" by David Litchfield, Chris Anley, John Heasman and Bill Grindlay.Continue Reading

• System-level SQL Server attacks

  Learn about system-level SQL Server attacks in this excerpt from "The Database Hacker's Handbook: Defending Database Servers" by David Litchfield, Chris Anley, John Heasman and Bill Grindlay.Continue Reading

• Time delay SQL injections

  Learn about time delays in this excerpt from "The Database Hacker's Handbook: Defending Database Servers" by David Litchfield, Chris Anley, John Heasman and Bill Grindlay.Continue Reading

• EDM (Electronic Document Management)

  EDM (Electronic Document Management) is the management of different kinds of documents in an enterprise using computer programs and storage.Continue Reading

• Ten merge replication tips and tricks

  From schema and parameter changes to wrapping and limiting merge agents, SQL Server MVP Hilary Cotter offers various tricks to help you get the best performance from your merge replication efforts.Continue Reading

• 15 SQL Server replication tips in 15 minutes

  This list of tips and tricks will help you enhance your replication techniques. It is broken up into three groups: performance, monitoring and miscellaneous.Continue Reading

• Managing messages

  Learn how to manage messages from within SQL Server in this excerpt from "SQL Server 2000 for experienced DBAs" by Brian Knight.Continue Reading

• Performance counters

  Learn about SQL Server performance counters in this excerpt from 'SQL Server 2000 for experienced DBAs' by Brian Knight.Continue Reading

• Transactional replication

  Excerpted from the McGraw-Hill/Osborne Media book SQL Server 2000 Administration, this tip explains how transactional replication works by sending changes to the subscriber as they happen.Continue Reading

• Snapshot replication

  Excerpted from the McGraw-Hill/Osborne Media book SQL Server 2000 Administration, this tip explains why snapshot replication is the simplest to set up and understand.Continue Reading

• Best practices for backing up the master, model, and msdb databases

  Continue Reading

• In-place versus side-by-side upgrade

  Continue Reading

• Upgrading SQL Server, part I: Overview and project planning

  First of a series detailing the SQL Server upgrade process from the technical, logistical and business perspective.Continue Reading

• Enterprise Manager database size reports

  Continue Reading

• What are the features of a database management system?

  Continue Reading