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.
Optimizing Your Cube's Schema
This article written by Don Church discusses how to optimize your cubes schema, its worth a read.
Microsoft Sets New World Record
Find out how SQL Server 2000 surpassed its previous number one result for the SAP Sales and Distribution benchmark.
SQL Server Licensing Resources
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 deal with the licensing aspects of using SQL Server.
SQLMatcher Added to Freeware Library
SQLMatcher allows the user to compare Microsoft SQL Server DDL scripts. SQLMatcher is available in two different forms. The standard freeware version has just been made available for download on SQLServerCentral.com. The professional version is also available for download and purchase.
RAC v2.0 released
RAC is a native utility for MS Sql Server 2000 designed exclusively for data
manipulation.RAC can perform complex tasks while minimizing the need for complex
sql.RAC offers many computational options and has report writer features.RAC comes with a easy to use gui for novice users.
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers