Auditing Your SQL Server Environment Part I
Ever been placed into a new environment and couldn't
find an ounce of documentation? This article is the first in a series that will help you make an audit of your new environment
and determine if any SQL Server login does not have a password, has a password the same as the login name or a password that is only one character long.
Improving Text and Image Column Performance
This article is a case study of a performance problem at SQLServerCentral.com with our FAQ area using text columns. This will show you how to use the TEXT IN ROW feature built into SQL Server 2000 to improve the performance of these columns.
SQLServerCentral.com Launches April Contest
SQLServerCentral.com launched it April contest on April 1st sponosored by Lockwood Tech and SQL Server Magazine. Win LockWood Tech's Proc-Blaster Enterprise Edition, SQL Server Magazine, or Admin911 all for helping to build the SQL Server community.
AdminLog Added to the Freeware Library
AdminLog, by Lockwood Tech, has been added to the SQLServerCentral.com freeware library. AdminLog is a utility for managing projects, tracking bugs/tasks/assignments, etc.
Interview with Author Fernando Guerrero
Learn how to make the most out of ADO.NET and SQL Server. Find out how the new .NET Data Provider can boost SQL Server performance.
Non-Continous Replicaton and The LogReader
Last year Andy wrote about turning off the log reader as a way to reduce the overhead on a server, primarily when you have many logreaders running. In this follow up article he talks about the downside of using this technique and how the behavior of the logreader can be "tweaked" to make using non-continuous replication a little less of a headache.
Object Scriptr v1.0 Released as Freeware
Object Scriptr v1.0 for SQL Server 7/2000 by Rac4sql has been released as freeware on SQLServerCentral.com. The product quickly generates creation and drop scripts and insert statements.
SQLServerCentral.com Launches New Discount Area
SQLServerCentral.com today launched its new members only product discount area. The section allows members to purchase SQL Server related products at a deep discount.
.NET Framework Service Pack 1 Released
Microsoft .NET Framework Service Pack 1 provides the latest updates to the .NET Framework. Service Pack 1 is highly recommended for all users of the .NET Framework, including customers of Visual Studio .NET.
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers