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

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

FIRST_VALUE vs. Min: #SQLNewBlogger

By

I had mentioned some new T-SQL functions for SQL Server 2022 and a commenter...

Read the latest Blogs

Forums

Wahrung der Integrität der Prüfungsumgebung

By sergioblog066

Störsender für Prüfungssignale im Konferenzraum: Wahrung der Integrität der Prüfungsumgebung In der heutigen Zeit...

Subqueries II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Subqueries II

Distributed Monoliths

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distributed Monoliths

Visit the forum

Question of the Day

Subqueries II

What is wrong (if anything) with this code?

SELECT *
 FROM Sales.SalesOrderHeader AS soh 
 WHERE customerid IN (SELECT soh.CustomerID FROM Sales.Customer AS c WHERE soh.CurrencyRateID = 1 ORDER BY c.ModifiedDate)

See possible answers