Using the Aggregate Transform - SQL School Video
MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
Are Your SQL Server Application Queries Wasting Memory
I am running an application that issues queries directly to the database from within its source code. I've noticed that the database server will get low on available memory and that CPU activity is higher than I'd like. What could be the problem?
Data Vices
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
Data Vices
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
Data Vices
Steve Jones asks about what you might change about yourself at work for this Friday's poll.
The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
Just Keep Going and Going and Going
The upgrade treadmill might hit you in ways that you didn't expect.
Just Keep Going and Going and Going
The upgrade treadmill might hit you in ways that you didn't expect.
SQL Server 2008 Upgrade Technical Reference Guide
This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.
SQL Server Matrix Workbench
In this workbench, Robyn Page and Phil Factor decide to tackle the subject of Matrix handling and Matrix Mathematics in SQL. They maintain that 'One just needs a clear head and think in terms of set-based operations'
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