What’s new in SQL Server 2017
SQL Server 2017 is considered a major release in the history of the SQL Server life cycle for various reasons....
2018-08-15
1,367 reads
Prashanth Jayaram
SQL Server – Stairway to Database Backup-and -Restore, (and Recovery)- Complete Guide
It’s a time to turn the corner from “DBA” to “DBA specialist”. This in-depth guide explores the importance of database...
2018-07-26
396 reads
Know more about SQL Server database backups, restores, and recovery: Q& A – Part 1
Let’s deep dive and review each of the database backup command topics to get a better understanding of what it...
2018-07-25
318 reads
Know more about SQL Server database backups, restores, and recovery: Q& A – Part 2
In this article, you’ll see the Q&A about the database restore and recovery internals. To learn a lot about SQL...
2018-07-25
334 reads
Know more about SQL Server MSDB log store for database backups, restores, and recovery: Q& A – Part 3
In this article, we’ll see the how the backup-and-restore meta-data tables store the information in the MSDB database. How do...
2018-07-25
339 reads
Backup and Restore operations with SQL Server 2017 Docker containers using SQL Operations Studio
In this 18th article of the series, we’ll discuss the concepts of database backup-and-restore operations with SQL Server 2017 Docker containers...
2018-07-19
890 reads
Understanding Data Sharing in SQL Server Docker Containers
This article talks about shared volumes and the preferred mechanism for data persistence using the Docker containers. This article covers...
2018-07-16
550 reads
SQL Server : Understanding Backup and Restore operations using Docker Containers
In this article, we will discuss the concepts of database backup-and-restore operations on SQL Server Docker containers. This is certainly...
2018-07-12
401 reads
SQL Server In-Memory Optimized database backup and restore in action
A SQL Server backup and restore strategy is an essential process to safeguard and protect critical data. The vital role...
2018-07-06
895 reads
Introduction to Docker and Docker Toolbox
The article gives some knowledge about getting started and utilizing Docker containers. The focus is all about understanding Docker and...
2018-07-02
498 reads
Blogs
Catching Up On SQLOrlando
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers