My name is James Anderson and I am a SQL Server production DBA in the south of the UK. I have been working with databases since 2008. The first RDBMS I worked on was Paradox and I never want to see it again. I quickly moved to using T-SQL in SQL Server 2005. I have worked on every version of the product since. I enjoy query tuning and server optimisation. I detest transactional replication.

All authors

All authors

Blogs

Check Azure SQL DB Space Used

By

A couple of days ago I was doing some cleaning on some Azure SQL...

Use a slicer to filter a visual based upon a measure in Power BI

By

Have you ever wanted to filter a visual by selecting a range of values...

Deleting Stale Local Database Git Branches with SSMS–#SQLNewBlogger

By

I wrote a post recently about pruning branches in git. That’s part of the...

Read the latest Blogs

Forums

SSRS Web Service URL - getting rid of HTTP

By cphite

Not sure if this is the place to ask, but will give it a...

SQL Server software and windows version compatibility level

By Abhishek

Is there a specific platform or website where I can verify the compatibility between...

Truncate tables where Referential Integrity exists

By Perry Whittle

Comments posted to this topic are about the item Truncate tables where Referential Integrity...

Visit the forum

Question of the Day

Post Restore Tasks for the Resource Database

I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?

See possible answers