- Essential Knowledge
- News
- Tips
- Expert Advice
- Definitions
- All
Email Alerts
-
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. Learning Guide
-
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 S... Tutorial
-
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. FAQ
-
Creating CLR database objects
Get an overview of the process to manually create a CLR database object. Then go further and learn how to use the Visual Studio 2005 Professional, Enterprise, and Team System Editions, which all have tools that help create CLR database objects as wel... Tutorial
-
CLR assemblies in SQL Server 2005
If you're familiar with ADO.NET, you may wonder exactly how CLR database objects connect to the database. Find out in this chapter excerpt, along with how to code to create a SQL Server assembly. Tutorial
-
CLR aggregates
The CLR aggregate is another new type of .NET database object that was introduced in SQL Server 2005. Learn more in this chapter excerpt. Tutorial
-
Debugging CLR database objects
One significant feature found in the integration of .NET Framework, Visual Studio 2005, and SQL Server 2005 is the ability to debug the CLR database objects that you create. Find out more in this chapter excerpt. Tutorial
-
CLR architecture
The .NET Framework CLR is very tightly integrated with the SQL Server 2005 database engine. In fact, the SQL Server database engine hosts the CLR. This gives SQL Server 2005 several distinct advantages over the .NET integration that's provided by DB2... Tutorial
-
Developing CLR database objects: 10 tips, 10 minutes
The integration of the .NET Framework's Common Language Runtime (CLR) with SQL Server 2005 is arguably the most significant new development featured in the SQL Server 2005 release. In this book excerpt, you'll learn about capabilities to create datab... Book Excerpt
-
CLR stored procedures
Stored procedures are one of the most common database objects that you'll want to create using one of the managed .NET languages. One of the best uses for CLR stored procedures is to replace existing extended stored procedures. Learn the best methods... Tutorial
- See More: Essential Knowledge on Microsoft SQL Server 2005
-
Microsoft reiterates promise of SQL Server 2005 SP3
SQL Server 2005 database administrators and managers will be happy to know that a third service pack will be here shortly. Article | 21 Oct 2008
-
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... Column | 26 May 2006
-
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... News | 20 May 2006
-
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 prod... Interview | 04 May 2006
-
SQL Server 2005 SP1 ships
SQL Server 2005's database mirroring functionality is finally here with the release of SQL Server SP1. Article | 19 Apr 2006
-
Microsoft releases CTP for SQL Server SP1
Community preview of SP1 for SQL Server 2005 includes new features, fixes. Article | 17 Mar 2006
-
SQL Server 2005 Database Mirroring primer
@18437 Since SQL Server 2000, you have been able to create a standby server using replication, log shipping and backup and restore -- but now Microsoft has introduced a built-in tool that enables automated failover. Database Mirroring is a new featur... Interview | 21 Feb 2006
-
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... Interview | 24 Jan 2006
-
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. Article | 29 Nov 2005
-
Free download expands features for SQL Server 2005
The November SQL Server 2005 feature pack from Microsoft provides interoperability and backward-compatibility tools. News | 23 Nov 2005
- See More: News on Microsoft SQL Server 2005
-
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. Tip
-
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. Tip
-
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 optio... Tip
-
Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
Understanding date/time data types in SQL Server can be difficult, especially when you add TIMESTAMP into the mix. In this tip, you'll learn how data is stored within DATETIME and SMALLDATETIME and get an overview of the TIMESTAMP data type -- as it'... Tip
-
How to configure Database Mail in SQL Server 2005 to send mail
Sending mail via SQL Server has become a much more reliable process. Here, SQL Server expert Roman Rehak explains how to configure Profiles and Accounts within the Database Mail architecture for sending and monitoring email. Tip
-
How to use rank function in SQL Server 2005
SQL Server 2005 T-SQL includes a set of functions that let you rank the rows in your result set. SQL Server expert Robert Sheldon defines and gives examples of how to use the four ranking functions: ROW_NUMBER, RANK, DENSE_RANK and NTILE. Include one... Tip
-
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... Tip
-
SQL Server high availability when upgrading to SQL Server 2005
The pursuit of minimal downtime is complex when upgrading an Active/Active cluster to SQL Server 2005/Windows Server 2003. In part three of this series, SQL Server expert Matthew Schroeder outlines the stages for migrating a database to a transition ... Tip
-
Create a computed column in SQL Server using XML data
In this tip, SQL Server expert Robert Sheldon demonstrates how to create a function that runs the XQuery expression and then use that function within your computed column definition. Tip
-
Using the OUTPUT clause for practical SQL Server applications
The OUTPUT clause returns results of all the rows affected by an INSERT, UPDATE or DELETE command' has provides many options for simplifying your T-SQL code. In some scenarios, it can even eliminate the need for triggers. Learn how to use the OUTPUT ... Tip
- See More: Tips on Microsoft SQL Server 2005
-
Troubleshoot Web service issues in SQL Server 2005 Reporting Services
Learn why your Web service in SQL Server 2005 Reporting Services (SSRS) is not responding. You could be missing Reporting Services configurations. Ask the Expert
-
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. Ask the Expert
-
Troubleshoot SQL Server 2005 temporary table performance problems
Learn how to troubleshoot SQL Server 2005 temporary table performance problems when a stored procedure execution time is slower than usual. Ask the Expert
-
Performance tuning for SQL Server 2005 and Exchange running on SBS
To avoid performance problems when running multiple instances of SQL Server 2005 with Exchange on Windows SBS, refer to these expert best practices. Ask the Expert
-
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. Ask the Expert
-