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. 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. 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." Learning Guide: SQL Server tools LEARNING GUIDE - Whichever SQL Server hammer or nail you may be looking for, there's a good chance you'll find an overview of it in this Learning Guide.

EXPERT TECHNICAL ADVICE: 1 - 3 of 66

	Avoid cursors in SQL Server with these methods to loop over records Submitted By: SearchSQLServer.com | 17 Nov 2008 TIP - Avoid using a SQL Server cursor for looping over records row by row. Alternate methods use temp tables instead of SQL cursors that slow down performance.

	Solve SQL Server errors and more from the DBA trenches -- part 2 Submitted By: SearchSQLServer.com | 13 Nov 2008 TIP - Solve SQL Server errors and other problems including primary filegroup out of space, failed SQL Server logins and trouble bringing a SQL database online.

	FAQ: Troubleshooting SQL Server Reporting Services Submitted By: Steve Cimino, Assistant Editor | 03 Nov 2008 FAQ - Troubleshoot SQL Server Reporting Services (SSRS) issues such as configuration, report designs and importing and exporting report data using Excel.

	VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER OVERVIEW

REFERENCE & LEARNING: 1 - 3 of 41

	Tutorial: Learn SQL Server basics from A-Z SearchSQLServer.com | 06 Nov 2008 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.

	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.

	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

	Business Process Automation in Healthcare Published by: Microsoft Corporation India Pvt Ltd | 18 Nov 2008 WHITE PAPER - Solutions are available from Microsoft and partners to accelerate the development of standards-based, integrated healthcare solutions for both providers and insurance plans.

	Business Process Automation in Retail Published by: Microsoft Corporation India Pvt Ltd | 18 Nov 2008 WHITE PAPER - BPA solutions provide the tools, technologies, and infrastructure to automate complex business processes end to end in order to help increase competitive advantage and deliver tremendous value and visibility to business.

	Sharepoint E-zine Vol.4: Balancing SharePoint Governance Published by: SearchWinIT | 18 Nov 2008 EZINE - SharePoint has built-in features that allow site owners to create site maps without any custom coding at all.

	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)