SQL Server transaction log architecture
The transaction log file for a SQL Server database critical for for maintaining database integrity. In this article, Greg Larsen explains SQL Server transaction log architecture.
2021-06-30
SQL Server
Creating and Maintaining a SQL Code Snippet Library
How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then write them out as individual code snippets, for use in SQL Prompt, SSMS or your programmer's clipboard.
2021-06-28
Running SQL Clone on an Azure VM with Azure File Storage
How to use SQL Clone in the Azure Cloud, installing it on an Azure Virtual Machine, storing a copy of your SQL Server database as an 'image' on an Azure File Share, and then deploying multiple clones to another Azure VM or to a remote machine.
2021-06-25
Move SQL Server Files for Master Database
In this second part of this article we look at how to move the SQL Server master database files to a different location.
2021-06-21
SQL Server performance tuning: Nine best practices
SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance tuning.
2021-06-16
How to Find Unused Databases in SQL Server
In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.
2021-06-14
The four best features to look out for in SQL Monitor
In this blog, David Yard at Kingston Technology shares his favorite SQL Monitor features and how they’re helping him to make sure their large SQL Server estate performs at its best.
2021-06-11
SQL Server Resource Governor Game
Learn about the SQL Server Resource Governor and how it can be used to manage your SQL Server workloads via this game format that can help your team gain better insights.
2021-06-09
Redgate Streamed: Embracing technology trends for database success
Innovating in the database is crucial for success, and we’re seeing new trends impact the database, like cloud migration, SRE, and the growing need for big data and tools to support growing estates. On 23 June, Redgate Streamed brings you organizations who have implemented these database technology trends, including speakers from Google, Microsoft, and AWS, who will share their success stories and tips for embracing technology changes.
2021-06-07
DBA in training: SQL Server high availability options
DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.
2021-06-07
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers