Manage
Learn to apply best practices and optimize your operations.
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
In-place versus side-by-side upgrade
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
What are the features of a database management system?