Not In v Not Equal
Is it better to use NOT IN() or <> in a T-SQL query? Ken Johnson had the question put to him and decided to investigate them both. Read about how these two functions perform.
XML Workshop XV - Accessing FOR XML results with ADO.NET
The next installment of Jacob Sebastian's great series on XML looks at how a .NET application might consume XML data returned from SQL Server.
Data Generator Source Adapter
The Data Generator Source is now available for SQL Server 2005 and SQL Server 2008. This component needs little explanation. It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline.
Implementing Table Inheritance in SQL Server
When designing a database, we sometimes come across situations where there are multiple types of entities that we are modeling, but we'd like them to all have certain attributes or relations in common. Using "sub-type" tables is a simple way to implement table inheritance in SQL Server.
Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
Scaling Out
Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?
Custom Report Item - Part I
This article will give a basic introduction of Custom Report Item in SQL Server 2005 Reporting Services.
The Social Contract
How much of a contract for servicing SQL Server should we expect? Has Microsoft broken an implied contract with us?
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers