Articles

SQL Server has extensions to allow one to call COM based objects from within the server using T-SQL. While this is an interesting feature, it's may not be the best way to structure your applications due to performance reasons. New author Zach Nichter of ScalabilityExperts.com brings us an analysis of different ways of writing out to a file from within SQL Server. Read on to see the most efficient method of generating files on your server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2006-11-10 (first published: 2005-02-07)

44,016 reads

Discuss

Think ANSI Standard SQL Is Fully Portable Between Databases? Think Aga

by Additional Articles

DevX

System Development Life Cycle

The same ANSI Standard SQL query can run against identical data on SQL Server and Oracle and return different results. So just because your application issues ANSI standard SQL, don't assume it's portable.

2006-11-09

2,041 reads

Discuss

Data Validation Sample

by Additional Articles

sqlserverdatamining.com

Data Mining

This video sample shows how the clustering algorithm can be used to automatically validate data.

2006-11-08

2,184 reads

Discuss

Using Excel 2007 with Analysis Services

by Brian Knight

JumpStartTV

Analysis Services (SSAS)

In this presentation, you'll see how you can use Excel 2007 to view data and create quick reports against data in Analysis Services. Then, you'll see how to conditionally format the data and apply rules to the data.

2006-11-08

2,621 reads

Discuss

SQL Server 2005 Transactional Replication Agents

by Additional Articles

InformIT

Replication

SQL Server 2005 replication agents are configured optimally out of the box, but occasionally you might need to alter the default behavior by tweaking the agent's parameters. SQL Server 2005 exposes some parameters through graphical interface that were available only from command line or through agent job steps in previous releases. Baya Pavliashvili encourages you to learn the new options available with each replication agent and how to fine-tune these options for your applications.

2006-11-07

2,281 reads

Discuss

Step-by-Step Guide: Installing SQL Server 2005 Reporting Services

by Additional Articles

Redgate

Administration

Working with a new piece of technology can be intimidating. Not having the technology installed correctly can only lead to more difficultly. This guide outlines steps to properly install SQL Server 2005 Reporting Services and the current service pack to get you going in the right direction.

2006-11-06

3,793 reads

Discuss

The CV Detectives

by Additional Articles

Redgate

State of the Business

You may find this shocking, but some IT people lie on their CV. Richard Morris offers a rare glimpse into the dark underworld of the people tasked with rooting out the CV fraudsters.

2006-11-03

3,591 reads

Discuss

Who Do You Want To Hire?

by Steve Jones

SQLServerCentral.com

Miscellaneous

Most of us don't get to make hiring decisions, whether we're interviewing or helping to interview someone. However we often have input on new employees. Steve Jones brings us some thoughts on helping to make the hiring decision.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-11-02

6,326 reads

Discuss

Toying with template parameters in SQL Server 2005

by Additional Articles

Builder.com

Administration

If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.

2006-11-02

2,522 reads

Discuss

SoftArtisans OfficeWriter:Reporting Services Integration

by Jonathan Spink

SQLServerCentral.com

Product and Book Reviews

A new product from SoftArtisans makes it easy for Reporting Services users to work in their familiar Word and Excel environments. Longtime author Jonathan Spink brings us a review of this software.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-11-01

4,446 reads

Discuss

Articles

Writing to a File Using the sp_OACreate Stored Procedure and OSQL: The

Think ANSI Standard SQL Is Fully Portable Between Databases? Think Aga

Data Validation Sample

Using Excel 2007 with Analysis Services

SQL Server 2005 Transactional Replication Agents

Step-by-Step Guide: Installing SQL Server 2005 Reporting Services

The CV Detectives

Who Do You Want To Hire?

Toying with template parameters in SQL Server 2005

SoftArtisans OfficeWriter:Reporting Services Integration

Blogs

The end of an era – why I chose not to renew my MVP

PowerShell Strikes Back: A New Script

Claude Desktop

Forums

Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform

QUOTENAME Behavior

Running script without having permission to Function

Question of the Day

QUOTENAME Behavior