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,358 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
386 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
307 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
326 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
329 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
881 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
541 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
393 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
890 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
491 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers