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 38

	Track changes to SQL Server 2000 and 2005 with one simple utility Submitted By: Michelle Gutzait | 02 Apr 2008 TIP - SQL Server triggers have limits when tracking changes. Use scripts in this utility to monitor SQL Server 2000 and 2005 for new objects, logins and databases.

	Tips for scheduling and testing SQL Server backups Submitted By: Denny Cherry | 31 Mar 2008 TIP - Learn how to schedule backups in SQL Server and SQL Server Express using SQL Server Agent, BACKUP DATABASE command, maintenance plan and Task Scheduler.

	SQL Server tempdb best practices increase performance 26 Mar 2008 TIP - Get increased SQL Server tempdb performance with these best practice settings for physical files, storage arrays, statistics updates and indexing temp tables.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER OVERVIEW

REFERENCE & LEARNING: 1 - 3 of 28

	SQL Server PerfMon counters for access methods and buffer manager Kevin Kline, SQL Server MVP | 28 Apr 2008 SCREENCAST - SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.

	SQL and SQL Server Tutorial and Reference Guide SearchSQLServer.com | 21 Apr 2008 LEARNING GUIDE - This Back to Basics SQL tutorial and reference guide provides a great starting point and foundation for learning SQL or brushing up on your skills.

	Monitor SQL Server disk I/O with PerfMon counters Kevin Kline | 02 Apr 2008 SCREENCAST - In part 3 the SQL Server PerfMon counters screencast series, get the optimal values when monitoring performance counters for physical disk reads and writes and disk queue length.

	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

	Microsoft Dynamics™ CRM Integration into the Contact Center Published by: AMC Technology | 09 May 2008 WHITE PAPER - This technical integration brief explains how the Microsoft Dynamics CRM application can be integrated into a contact center, including both general technical details of call center integration, as well as how to use vendor certified software f...

	100+ Year Old Wholesale Grocer Uses CONNX to save Millions on Enterprise Systems Replacement Costs Published by: CONNX Solutions | 08 May 2008 CASE STUDY - Explore how a data access and integration solution saved one of North America's oldest wholesale grocers from replacing its ten year old distribution system and spending up to five million dollars on a brand new enterprise solution.

	Real World SQL Implementations Published by: Hewlett-Packard Company | 10 Apr 2008 WHITE PAPER - Homeplans, part of Move, is a leading provider of pre-drawn home designs. This case study explains how Homeplans used HP PolyServe Software for Microsoft SQL Server to improve availability, decrease risk, and simplify administration.

	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 2005 (Yukon), SQL Server upgrades and patches, SQL Server 2008 (Katmai)