The CLR
The CLR was one of the highly touted additions to SQL Server 2005, and one of the reasons for its long development cycle. Steve Jones comments on why it hasn't been that widely used.
2008-05-12
34 reads
Articles
Tuning the Performance of Backup Compression in SQL Server 2008
ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not
2008-05-12
2,214 reads
Boycott
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
2008-05-11
36 reads
Boycott
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
2008-05-11
31 reads
Boycott
Steve Jones asks for some opinions on how to approach the new timeframe of software releases.
2008-05-11
31 reads
From DBA to DBAA
Most of us DBAs have worked on our career to get where we are. A DBA is usually a second or third step in IT and we we've looked to advance our understanding of technology. Jeffrey Yao now brings us a new level of database work to which we may aspire.
2008-05-09 (first published: 2007-07-12)
15,685 reads
Worst Practices - Not Using Primary Keys and Clustered Indexes
Two weeks ago Andy started his wildly successful series on Worst Practices. This week he continues that series discussing why failing to use primary keys and clustered indexes are worst practices. Agree or disagree, read the article and join the discussion. One thing you'll have to admit, reading an article by Andy is a lot more interesting than reading Books Online!
2008-05-09 (first published: 2003-11-10)
66,641 reads
Scalability and Goal Testing for Developers
Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.
2008-05-09
2,508 reads
The Differences Between SQL Server 2000 and 2005
What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.
2008-05-08 (first published: 2007-05-15)
110,772 reads
Using XML to pass Multi-Select parameters from SSRS to SQL Server
How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.
2008-05-08
9,711 reads
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