SQL errors and other failures fixed from the trenches
Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.
2008-10-20
3,381 reads
Articles
SQL Server Sanity: Maintain Healthy Transaction Logs for Easy Data Recovery
Learn how executing frequent backups and maintaining healthy transaction logs in SQL Server leads to quick recovery. Failing to do so can mean having to re-enter a lot of data.
2008-10-20
3,238 reads
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
2008-10-18
509 reads
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
2008-10-18
66 reads
Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
2008-10-18
76 reads
Who was that Affinity Masked Man?
Getting the number of processor cores that SQL Server is using is not as straitforward as it could be. Enter the affinity mask, bitwise operations and good old fashioned computer science.
2008-10-17
4,034 reads
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
2008-10-17
782 reads
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
2008-10-17
516 reads
Introduction to New Data Warehouse Scalability Features in SQL Server 2008
This paper introduces the new performance and manageability features for data warehousing across all these components. All these features contribute to improved scalability.
2008-10-17
2,632 reads
Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation
Part 1 of this series discussed how to prepare for SQL Server cluster installation on a two-node Windows Server 2003 cluster. This installment explains how to install SQL Server Database Engine on the cluster using the Integrated Installation option.
2008-10-17
2,079 reads
Blogs
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers