You want to attach a SQL Server database that does not have the transaction log files and get the following error: "The log cannot be rebuilt because there were open transactions/users when the database was shutdown, no checkpoint occurred to the database, or the database was read-only. This error could occur if the transaction log file was manually deleted or lost due to a hardware or environment failure." In this tip I will help you to successfully attach the transaction log to the problematic SQL Server database.

Remote Data Challenges

by Steve Jones

SQLServerCentral

While working remotely, we still need good security practices and strong data protection.

How to Resolve a Duplicate Key Error in SSAS

by aveek22

SQLServerCentral

Learn how you can fix the duplicated key error in SSAS without editing the source data.

How to Add a Filter to an Existing SQL Change Automation Project

by Additional Articles

Redgate

Kendra Little demonstrates how to create a SQL Compare filter file and save it to a SQL Change Automation project folder, so that it will be used automatically during development.

Technology Makes a Difference

by Additional Articles

SimpleTalk

As the world deals with the Covid-19 pandemic, technology is making some things better for those of us in isolation. We are also better equipped today to fight the disease. Researchers are using artificial intelligence to quickly develop vaccines and treatments.

Configuring Database Alerts for Azure SQL Database

by Deepak Prasad Sahu

SQLServerCentral

Azure SQL database

This article will help us to understand how to monitor Azure SQL Database and set up Azure metric alerts. Even though the database in Azure SQL Database is fully managed by Microsoft, we are still responsible for proper database access and performance. Azure does make it easy for us and it can alert on critical […]

May the Force Be With You

by Steve Jones

SQLServerCentral

humor

Today Steve celebrates Star Wars day.

SQL Server Database Deployment: What Could Go Wrong?

by Additional Articles

Redgate

Phil Factor tackles the questions you were too shy to ask about SQL Server database builds, migrations and deployments.

Storage 101: Data Center Storage Configurations

by Additional Articles

SimpleTalk

In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.

Representing uncertainty in difficult times

by Phil Factor

SQLServerCentral

The Covid-19 pandemic has provided examples of how uncertain data can eventually be presented to the public as certainty. How, as data people, should we represent uncertainty in our data?

How to Attach a SQL Server Database without a Transaction Log and with Open Transactions

Remote Data Challenges

How to Resolve a Duplicate Key Error in SSAS

How to Add a Filter to an Existing SQL Change Automation Project

Technology Makes a Difference

Configuring Database Alerts for Azure SQL Database

May the Force Be With You

SQL Server Database Deployment: What Could Go Wrong?

Storage 101: Data Center Storage Configurations

Representing uncertainty in difficult times

Blogs

The DIY Cost of Masking Test Data For Smaller Organizations

T-SQL Tuesday #196 – Two risky career decisions I made

T-SQL Tuesday #192: What career risks have you taken?

Forums

XACT_ABORT being set to ON by web services

OPENQUERY Flexibility

A Full Shutdown

Question of the Day

OPENQUERY Flexibility