Features

Learn about stored procedures, parameters, triggers and how other T-SQL code functions allow for the manipulation of data in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson ...
Continue Reading

Learn how to physically implement supertype and subtype tables and clusters on a SQL Server in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones.
Continue Reading

Find out about data types available in SQL Server 2008 and how to use them, including datetime, string and user-defined data types, in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric...
Continue Reading

Problems with permissions will affect your users, their login abilities and their access to certain aspects of your SQL Server. Troubleshoot all of your SQL Server permissions issues with these FAQs.
Continue Reading

Learn how to use the DISTINCT keyword to eliminate duplicate rows in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn how to use DISTINCT on either single or multiple ...
Continue Reading

Learn how to translate information requests into suitable SQL SELECT statements in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn techniques to create more complicated ...
Continue Reading

Discover sample SQL SELECT statements and result sets in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." These sample databases and SQL statements will help you understand the many ...
Continue Reading

Learn the basics of the SQL SELECT statement in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition." You'll learn how to use SELECT to access almost anything contained in a SQL database, ...
Continue Reading

Making the leap to storage area networks (SANs) will ultimately improve performance in your SQL Server environment. Although SAN admins share responsibility, SQL DBAs must be involved from SAN setup through maintenance. These tips, webcast and ...
Continue Reading

SQL Server PerfMon counters can help troubleshoot and even avoid bottlenecks on your Windows operating system. In part 2 of this screencast series on "PerfMon counters for the SQL Server DBA," SQL Server MVP Kevin Kline walks you through best ...
Continue Reading