SQL Server overview
Home > SQL Server Topics > SQL Server Platform > SQL Server overview
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS   SQL SERVER INFO CENTERS   RESOURCE CENTERS     RSS FEEDS 

SQL Server overview


Want to know about Microsoft's SQL Server database management system? In this overview of SQL Server, all versions are addressed including SQL Server 7.0, SQL Server 2000, SQL Server 2005 and SQL Server 2008.
IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (38) , REFERENCE & LEARNING (28) , NEWS (12) , WHITE PAPERS , DOWNLOADS (1) , BEST WEB LINKS (9) , DEFINITIONS (14)

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)


HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsWebcastsWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts