Overview of File-group(s) and Piecemeal database restore operations in SQL Server
So far, we discussed many de-facto details about SQL Server database backup and restore. In this 15th article of the series,...
2018-06-22
749 reads
PowerSQL By Prashanth Jayaram
Overview of SQL Server 2017 Docker containers on Linux machine
SQL Server 2017 is the biggest release and most important releases in the Microsoft product history simply because of the...
2018-06-20
1,405 reads
SQL Server -Database Backup Report using PowerShell and T-SQL
In the previous articles, we discussed several ways of taking backup and testing the restore process to ensure the integrity...
2018-06-14
1,030 reads
Getting Started with Mssql-cli tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-06-12
257 reads
SQL Database Corruption: Causes, Prevention, Fixing Techniques
“I had a Database File and I want to attach this MDF file to SQL Server 2014. However, whenever I...
2018-06-05
260 reads
Backup and Restore Automation using SQLCMD and SQL Server agent
Database administrators are often requested to refresh a database, mostly to create a live copy of the production database to...
2018-05-30
447 reads
SQL Server: Backup and Restore operations using Cloud
This article discusses the concept of SQL Server backup and the various components required to use the Microsoft Azure Blob...
2018-05-29
390 reads
Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler
This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux...
2018-05-31 (first published: 2018-05-22)
2,087 reads
Data Recovery : Page level restore in SQL Server
In this article, we shall discuss the importance of understanding the internals of the page restoration for a database administrator. Most...
2018-05-18
360 reads
Discuss smart database backup in SQL Server 2017
So far, we’ve discussed several phases of backup that starts with planning, creating, strategizing and implementing. In this article, we...
2018-05-15
403 reads
Blogs
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Forums
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Creating JSON I
Comments posted to this topic are about the item Creating JSON I
Expensive CPUs
Comments posted to this topic are about the item Expensive CPUs
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers