SQL Server overview

MUST READ Tutorial: Learn SQL Server basics from A-Z TUTORIAL - If you're new to SQL Server of simply want a refresher on some fundamentals, check out this tutorial on topics from security and performance to SSIS and using native tools. 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. Tutorial: SQL Server Integration Services (SSIS) best practices TUTORIAL - Learn the best practices for SQL Server Integration Services (SSIS) in this tutorial, from migrating DTS packages to SSIS debugging, maintenance and programming in SQL Server. 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. Tutorial: SQL Server indexing tips to improve performance TUTORIAL - Significantly improve your SQL Server performance through this tutorial on proper indexing choices. Learn how to design high performing indexes and tune your existing SQL indexes.

EXPERT TECHNICAL ADVICE: 1 - 3 of 69

	The sqlcmd utility in SQL Server 17 Dec 2008 TIP - The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures.

	How to create a SQL inner join and outer join: Basics to get started Submitted By: SearchSQLServer.com | 03 Dec 2008 TIP - Learn the basics to create a SQL inner join and SQL outer join. Get examples on how to use them for a customized result set querying more than one table.

	How to configure storage in SQL Server DB with more writes than reads Submitted By: SearchSQLServer.com | 25 Nov 2008 TIP - Learn how to configure SQL Server database storage with higher disk writes than disk reads. Set up a RAID 10 array, cache configuration and file disk layout.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER OVERVIEW

REFERENCE & LEARNING: 1 - 3 of 44

	Top 10 SQL Server Tips of 2008 SearchSQLServer.com | 16 Dec 2008 THE YEAR IN REVIEW - Get the top 10 SQL Server tips of 2008 on topics such as clustered index design, log shipping setup, date/time data conversions and many other aspects of SQL Server.

	Tutorial: Performance tuning SQL Server via queries, indexes and more Steve Cimino, Assistant Editor | 09 Dec 2008 TUTORIAL - Get the basics for tuning SQL Server performance with this tutorial on queries, indexing, storage, memory and any errors or issues that can cause SQL Server slowdown.

	Tutorial: SQL Server indexing tips to improve performance SearchSQLServer.com | 03 Dec 2008 TUTORIAL - Significantly improve your SQL Server performance through this tutorial on proper indexing choices. Learn how to design high performing indexes and tune your existing SQL indexes.

	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

	E-Guide - Best Practices for Sharepoint Server 2007 Backup and Disaster Recovery Published by: AvePoint, Inc. | 07 Jan 2009 EDITORIAL RESOURCE GUIDE - This informative E-Guide, brought to you by SearchWinIT.com and AvePoint, highlights best practices for SharePoint Server 2007 backup and disaster recovery.

	Is JD Edwards EnterpriseOne Right for Your Business? Published by: Oracle Corporation | 07 Jan 2009 IT BRIEFING - JD Edwards EnterpriseOne is a comprehensive and highly integrated suite of core business applications including things like financials, manufacturing, distribution, supply chain management, human capital management and so forth.

	E-Guide - How to Backup Sharepoint Server 2007 Published by: AvePoint, Inc. | 19 Dec 2008 EDITORIAL RESOURCE GUIDE - In this E-Guide, brought to you by SearchWinIT.com and AvePoint, explore an overview of the SharePoint backup and restore utility.

	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)