How to Change Always On availability group mode
This topic describes how to change the availability mode of an availability replica in an Always On availability group in SQL Server by usin
2022-01-17
31 reads
Blog Posts
Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)
Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves writing and teaching a lot. The […]
The post Learn some critical SQL Security with the...
2022-01-17
37 reads
Looking at Activity Queue Times from Azure Data Factory with Log Analytics
I’ve been working on a project to populate an Operational Data Store using Azure Data Factory (ADF). We have been seeking to tune our pipelines so we can import...
2022-01-17 (first published: 2022-01-06)
194 reads
The SQL NULLIF function
NULLIF is a SQL function that is used to compare two columns. Use NULLIF to compare two columns and return NULL if they are equal to each ot
2022-01-17
22 reads
Troubleshoot SQL Server Backup Error Msg 3132, Level 16
This blog troubleshoots SQL Server Error Msg 3132, Level 16, State 1 while backing up SQL Database.
2022-01-17
40 reads
Troubleshoot SQL Server Backup Error Msg 3231, Level 16, State 1
When you are experiencing SQL Server Error Msg 3231, Level 16, State 1 while backing up SQL Database, it is important to troubleshoot the er
2022-01-17
473 reads
Troubleshoot SQL Server Error for backups–: Msg 3136, Level 16
Is it possible to use COPY_ONLY backup for restoring differential backups? No, if you try to do so, SQL Server raises error Msg 3136, Level
2022-01-17
58 reads
Azure Data Explorer – Using KQL Magic inside Azure Data Studio
One of my previous blogs looked at using the free resources that Microsoft provides to link to an Azure Data Explorer Cluster and start using Kusto Query Language. In...
2022-01-14
19 reads
Daily Coping 14 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-14
14 reads
Getting Started with KQL
I saw an episode of Data Exposed with my good friend, Hamish Watson. He talked about KQL (Kusto Query Language) being the next query language you need to learn....
2022-01-14 (first published: 2022-01-03)
962 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Grogol Muwardi Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Dr. Muwardi I No.44, Grogol, Kec. Grogol petamburan, Kota Jakarta Barat, Daerah...
BCA KCP Kemanggisan Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Kemanggisan Utama Raya No.37, Kemanggisan, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus...
BCA KCP Pasar Puri Indah Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers