Technical Article

SQL Server 2000 Report Pack for Microsoft Exchange

The SQL Server 2000 Report Pack for Microsoft Exchange is a set of 13 Microsoft SQL Server 2000 Reporting Services reports that work with a Microsoft Exchange sample reporting database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

Technical Article

Optimized ADO.NET

This article contains guidelines compiled by examining the .NET implementations of shipping .NET applications and analyzing the common performance mistakes that we found. The guidelines discuss selecting .NET objects and methods, designing .NET applications, retrieving data, and updating data.

Technical Article

SQL Server 2000 Report Pack for Microsoft CRM

The SQL Server 2000 Report Pack for Microsoft CRM is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with the Microsoft CRM 1.2 sample database.

With the Report Pack, you have the choice of using the sample reports either as-is or as templates for designing new reports using the SQL Server Reporting Services Report Designer.

SQLServerCentral Article

Exchange from SQL Server

SQL Server allows data access from many sources, probably any that you could want. Some, however, are easier than others. Have you ever tried to update information in Exchange from SQL Server? Not that easy, but new author Steve Boriotti has written code as well as a short article on how you can make this happen.

SQLServerCentral Article

Are you innovating?

Andy has some examples of not very high tech solutions that involve some technology behind the scenes, but the binding factor was that someone had to see the problem first, and it wasn't one of those show stopper type problems. It's not about SQL, but we think it is on topic.

Blogs

Advice I Like: Pyramid Schemes

By

If someone is trying to convince you it’s not a pyramid scheme, it’s a...

Using Prompt AI for a Travel Data Analysis

By

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

Read the latest Blogs

Forums

Database file shrink issue.

By Tac11

Hi experts, I have a 3+ TB database on a 2019 sql server which...

The North Star for the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The North Star for the...

Multiple Escape Characters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Escape Characters

Visit the forum

Question of the Day

Multiple Escape Characters

In SQL Server 2025, I run this code (in a database with the appropriate collation):

SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned?

See possible answers