SQL Server overview

MUST READ Top 10 SQL Server Tips of 2007 THE YEAR IN REVIEW - Get the top 10 SQL Server tips of 2007 on topics of SQL Server database design and performance tuning to upgrading to SQL Server 2005 and stored procedures. Top 10 SQL Server Integration Services (SSIS) and DTS tips TOP 10 TIPS - Top SQL Server Integration Services (SSIS) tips from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server 2005. Top 10 T-SQL tips for improved SQL Server development TOP EXPERT TIPS - Find out how to script SQL Server backups, why T-SQL in SSIS has pros and cons and what to do about poorly written T-SQL code that's causing SQL Server performance problems. Top 10 SQL Server indexing tips to improve performance TOP 10 TIPS - We've tallied our most popular tips on the topic of indexes. Weed out valueless indexes, design high performing indexes and query your existing SQL Server indexes. How to construct and use SQL OUTER JOINs optimally BOOK EXCERPT - Learn SQL OUTER JOINs, LEFT, RIGHT and FULL OUTER JOINs for linking tables, in this excerpt from "SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL."

EXPERT TECHNICAL ADVICE: 1 - 3 of 54

	Using DATEADD and DATEDIFF to calculate SQL Server datetime values Submitted By: SearchSQLServer.com | 07 Oct 2008 TIP - Here's how to use DATEADD and DATEDIFF in SQL Server to calculate datetime values in T-SQL queries, modify data and to use within your table definitions.

	Storing and searching for image files in SQL Server 02 Oct 2008 EXPERT ANSWER - Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer.

	Can you shrink your SQL Server database to death? Submitted By: SearchSQLServer.com | 23 Sep 2008 TIP - To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER OVERVIEW

REFERENCE & LEARNING: 1 - 3 of 40

	Supertype and subtype tables in SQL Server SearchSQLServer.com | 16 Sep 2008 BOOK EXCERPT - Learn how to physically implement supertype and subtype tables on a SQL Server in this book excerpt.

	SQL Server and data manipulation in T-SQL SearchSQLServer.com | 16 Sep 2008 BOOK EXCERPT - Learn about stored procedures, parameters, triggers and other T-SQL code functions in this book excerpt.

	Enforcing data integrity in a SQL Server database SearchSQLServer.com | 16 Sep 2008 BOOK EXCERPT - Find out how primary keys, foreign keys and constraints can keep your SQL Server data consistent in this book excerpt.

	VIEW ALL REFERENCE & LEARNING ON SQL SERVER OVERVIEW

NEWS: 1 - 3 of 12

	SQL Server vs. MySQL: Syntax differences, similar GUIs SearchOpenSource.com | 02 Aug 2006 ARTICLE - Discover syntax differences between SQL Server and MySQL, code for a timestamp automation workaround and why it's important to keep your version of MySQL current.

	Dumping Microsoft SQL Server: MySQL, PostgreSQL attract big users SearchOpenSource.com | 27 Jul 2006 ARTICLE - Using open source databases doesn't have to be an all-or-nothing decision. Most will work just fine alongside SQL Server.

	Minding the data and databases SearchDataManagement.com | 20 Jul 2006 ARTICLE - The role of the database administrator can be broad or delineated by specialization. DBAs are constantly at the mercy of the project size, scope and application complexity.

	VIEW ALL NEWS ON SQL SERVER OVERVIEW

WHITE PAPERS

	Eliminate Tape Restores with TimeData CDP Published by: Double-Take Software | 07 Oct 2008 WHITE PAPER - Download this free whitepaper to discover new CDP software that provides a simple and cost-effective way to recover data to any point in time and resume workflow without the pain of recovering from tape.

	Security of Microsoft SQL Server 2008 Improves over Previous Versions Published by: Information Security Magazine | 11 Sep 2008 JOURNAL ARTICLE - The security features in SQL Server 2008 are well thought out and properly implemented, by far the most significant change over its predecessors is its granular data security features: encryption, key management and meta data security enhancements.

Deploying Microsoft® SQL Server™ 2005 with Microsoft Windows Server® 2008 on Dell™ PowerEdge™ Servers and Dell Storage Published by: Dell, Inc. | 27 Aug 2008 WHITE PAPER - This white paper provides an architectural overview and configuration guidelines for deploying Microsoft SQL Server 2005 x64 SP2 with Microsoft Windows Server® 2008 x64 Enterprise or Standard Edition on Dell PowerEdge servers with Dell PowerVault.

	VIEW ALL WHITE PAPERS IN THIS TOPIC

DOWNLOADS: 1 - 1 of 1

	SQL Server backup and restore school Published by: SearchSQLServer.com | 16 Aug 2007 WEBCAST AND PODCAST SERIES - In this SQL Server backup and recovery school, you'll get best practices, basic restore commands and learn SQL Server 2005 features – all via webcasts and podcasts.

	VIEW ALL DOWNLOADS ON SQL SERVER OVERVIEW

BEST WEB LINKS: 1 - 3 of 9

	The Detroit SQL Server User Group The Detroit SQL Server User Group | 05 Apr 2006 BEST WEB LINK - The Detroit Area SQL Server Special Interest Group consists of professionals interested in getting the most out of SQL Server and related technologies. Meetings are held on the second Thursday of every month at 6:00 PM at the ...

	Professional Association for SQL Server PASS | 01 Apr 2006 BEST WEB LINK - PASS is the definitive, global community for SQL Server professionals. It is the first independent, user-run, not-for-profit association committed to providing SQL Server professionals around the world with the resources and ...

	SQL Server World Wide User Group Help Center http://www.sswug.org/ | 22 Jul 2005 BEST WEB LINK - This Web site allows subscribers access to educational webcasts, discussion forums, database news, script manager and e-mail discussion lists

	VIEW ALL BEST WEB LINKS ON SQL SERVER OVERVIEW

DEFINITIONS: 1 - 3 of 14

	SQL Server 10 Jan 2006 WORD - SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft ...

	full-text database 13 Sep 2005 WORD - A full-text database is a compilation of documents or other information in the form of a database in which the complete text of each referenced document is available for online viewing, printing, or downloading. In addition ...

	intelligent database 13 Sep 2005 WORD - An intelligent database is a full-text database that employs artficial intelligence (AI), interacting with users to ensure that returned items (hits) contain the most relevant information possible. This is in contrast to a ...

	VIEW ALL DEFINITIONS ON SQL SERVER OVERVIEW

	SEE ALSO - Topics Related to SQL Server overview:  SQL Server upgrade and migration, SQL Server 2008 (Katmai), SQL Server 2005 (Yukon)