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.
Steve Jones continues his series on string manipulation. This articles examines the issues of quotes when implementing dynamic SQL.
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.
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
Do you know if your SQL Server is really running at its best? To...
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers