As I work with a particular topic or problem, I often research on the Internet different opinions, white papers, etc. Here is a list of resources that are located both on SQLServerCentral.com and other sites that I have found useful.
The core components to Microsoft XML parser have been updated and released to market. The update contains many bug fixes, new features and enhancements to performance.
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.
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 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, by Lockwood Tech, has been added to the SQLServerCentral.com freeware library. AdminLog is a utility for managing projects, tracking bugs/tasks/assignments, etc.
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.
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 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.
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Hi everyone I am looking at building a query to determine how much time...
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Comments posted to this topic are about the item Hidden Heroes
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers