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
405 reads
Prashanth Jayaram
Mssql-cli Command-Line Query Tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-05-11
896 reads
SQL Server: Database snapshots vs Database backups
In the article, we’ll walk through the concepts to understand database snapshots, and their benefits and limitations. This article will...
2018-05-04
2,292 reads
SQL Server database Backup and Restore strategies
One of the most important roles of a database administrator is to constantly protect the integrity of the databases and...
2018-04-26
554 reads
Overview of SQL Server Backup Types
SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this...
2018-04-19
529 reads
Default and Custom Widgets in SQL Server Operations Studio
There are already a number of articles and blog posts that reveal the benefits of the SQL Operations Studio tool. The...
2018-04-16 (first published: 2018-04-04)
2,056 reads
Understanding database recovery models in SQL Server
A recovery model is a database configuration option that determines the type of backup that one could perform and provides...
2018-04-11
774 reads
SQL Server 2017 on Linux in the Azure portal
SQL Server 2017 now is considered as a hybrid database enterprise solution as it expands its market and is ported to...
2018-04-06
390 reads
SQL Server DevOps Tools
This article is part of the SQL Server Tools series, aimed at giving you an idea of the available tools and techniques...
2018-03-28
1,009 reads
SQL Server Data Management Life Cycle
This is the second article in the “Backup and Restore (or Recovery) in SQL Server” stairway series (see the full...
2018-03-21
314 reads
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers