Microsoft SQL Server 2005
New & Notable
Microsoft SQL Server 2005 News
-
May 26, 2006
26
May'06
SQL Server DBMS' growing popularity is no coincidence
SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of using SQL Server over other proprietary and open source options.
-
May 04, 2006
04
May'06
Q&A;: What's new in SQL Server 2005 SP1
SQL Server 2005 Service Pack 1 offers DBAs production-ready Database Mirroring, SAP NetWeaver Business Intelligence support, Full-Text support and additional features to ease the pains of fully utilizing the new DBMS. We recently asked Microsoft product and program managers to discuss the new features and any relevant issues that arose during the Community Technology Preview. The following is our Q&A; interview with Microsoft product and program managers Michael Raheem, Tim Tow, Herain Oberoi and Grant Culbertson.
-
January 24, 2006
24
Jan'06
Q&A;: Making the jump to 64-bit SQL Server 2005
Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the expensive Itanium line of processors, and SQL Server's client tools were not compatible with 64-bit platforms. SQL Server 2005, on the other hand, offers new options to harness the power of 64-bit architectures -- and the problems that made 64-bit less desirable in the past are all but gone. If you're considering purchasing new hardware for SQL Server 2005 installations, take a serious look at the capabilities and price points of today's 64-bit systems.
SQL Server MVP Adam Machanic offers some points to consider in this Q&A.;
-
November 29, 2005
29
Nov'05
Free version of SQL Server 2005 tops list of downloads
The five most popular picks on Microsoft's SQL Server downloads site include its free SQL Server 2005 Express, MSDE 2000 and the most recent service packs for SQL Server 2000.
Microsoft SQL Server 2005 Get Started
Bring yourself up to speed with our introductory content
-
SQL Server Service Broker Tutorial and Reference Guide
Discover the basics of the SQL Server Service Broker, including a general overview on how this addition to SQL Server works. Continue Reading
-
Export SQL Server data to an Excel file using SSIS and Visual Studio
Here are seven steps for transferring SQL Server 2005 data to a MS Excel spreadsheet. In this book chapter from the "Beginners Guide to SQL Server Integration Services Using Visual Studio 2005" by Jayaram Krishnaswamy, you'll learn how to design an SSIS package using Visual Studio and export data from a SQL Server table to Excel. Continue Reading
-
Upgrading to SQL Server 2005 FAQs
We've compiled a list of frequently asked questions to address your SQL Server 2005 upgrade issues, including working with DTS packages, copying databases, creating passwords and installing different SQL Server versions on one machine. Continue Reading
Evaluate Microsoft SQL Server 2005 Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
-
SQL Server tools don't appear in menu after SQL Server 2005 install
After installing SQL Server 2005, the SQL Server tools may not appear in the start menu. Our expert explains how to troubleshoot this problem. Continue Reading
-
Five sqlcmd features to automate SQL Server database tasks
Make your life easier with the sqlcmd tool in SQL Server 2005 that automates administration and maintenance via scripting. In this tip, you'll get five useful features and examples to execute sqlcmd commands, such as for utilizing and populating variables, improved error handling and restoring a database. Continue Reading
-
New T-SQL features in SQL Server 2005
Have you experienced the new T-SQL features in SQL Server 2005? SQL Server database administrator Eric Johnson outlines four of its hottest development features: error handling, ROW_NUMBER function, DDL triggers and CLR. Continue Reading
Manage Microsoft SQL Server 2005
Learn to apply best practices and optimize your operations.
-
Five steps for a successful backup of a stored procedure in SQL Server
Follow these steps to use Management Studio for SQL 2005 for a successful SQL Server stored procedure backup. Continue Reading
-
Should you upgrade to SQL Server 2005 or SQL Server 2008?
Even though SQL Server 2005 was released almost three years ago, many companies haven't upgraded yet. With last week's release of SQL Server 2008, it's time to put some serious thought into an upgrade. SQL Server expert Roman Rehak examines the options: to follow the sequential upgrade path or skip SQL Server 2005 altogether. Considerations include licensing costs, database size, benefits of the new features and confidence – or lack thereof – in the newest version. Continue Reading
-
Manage traces in SQL Server 2005 Analysis Services with XMLA commands
SQL Profiler is an efficient tool for tuning and troubleshooting Microsoft Analysis Services 2005, that is, unless you're managing numerous instances. In this tip, you'll learn how to use XMLA to automate tracing to monitor MSAS. Here's what you need to know to create, alter and delete traces with ease. Continue Reading
Problem Solve Microsoft SQL Server 2005 Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
-
SQL Server consolidation: Why it's an optimization technique
SQL Server consolidation -- a.k.a., the fix for SQL Server sprawl -- provides ease of management, improved availability and lower licensing costs. Continue Reading
-
Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
Retrieving a hierarchy with recursive relationships in SQL can get difficult to manage -- very quickly. Learn how to easily implement this type of relationship with a parent-child dimension using Microsoft's Analysis Services MDX. Continue Reading
-
SSIS error message due to installation problem on SQL Server 2005
If you are receiving an error message in SQL Server Integration Services (SSIS), your problem might be with the installation of the SQL Server 2005 client tools. Continue Reading