Articles

External Article

How to identify when a database was restored, the source of the backup and the date of the backup

After restoring a database your users will typically run some queries to verify the data is as expected. However, there are times when your users may question whether the restore was done using the correct backup file. In this tip I will show you how you can identify the file(s) that was used for the restore, when the backup actually occured and when the database was restored.

2009-10-27

4,162 reads

Technical Article

Troubleshooting Reporting Services

Marcin Policht continues his discussion of implementing Reporting Services on SQL Server 2005 Express Edition. In this article, we will turn our attention to troubleshooting methods that can be employed to identify and resolve problems affecting reporting functionality and performance.

You rated this post out of 5. Change rating

2009-10-26

2,719 reads

Blogs

Methodology for dealing with bad data in production

By

Pinal Dave wrote up his methodology for what to do when you discover bad...

How to Provision an Azure SQL Database

By

Aside from spinning up a SQL Server instance container, the free Azure SQL Database...

Claude finds two cryptographic weaknesses (but the sky isn’t falling)

By

If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...

Read the latest Blogs

Forums

Why SQL Server Database Attach fails and how to repair it

By Nisarg Upadhyay

Comments posted to this topic are about the item Why SQL Server Database Attach...

Fixing P1 Queries

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fixing P1 Queries

BIT_COUNT() IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT() IV

Visit the forum

Question of the Day

BIT_COUNT() IV

In SQL Server 2025, I run this code:

select bit_count('A')
What is returned?

See possible answers