Do Full Backups Break Log Shipping?
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you Log Ship are NOT also doing log backups in your SQL Maintenance Plans, Ola Jobs,...
2021-10-22 (first published: 2021-10-15)
323 reads
TLDR: Nope. Keep on doing your full backups. Make sure that any databases you Log Ship are NOT also doing log backups in your SQL Maintenance Plans, Ola Jobs,...
2021-10-22 (first published: 2021-10-15)
323 reads
SQL Server maintains a variety of stats about all sort of performance items. Index usage (or missing indexes) Query performance Corrupt pages Disk IO performance Way more than I...
2021-10-11 (first published: 2021-09-30)
309 reads
Welcome back to the series “Server Review Essentials for Accidental and Junior DBAs.” So far in this series we’ve taken a look at how to set up your work...
2021-07-06
41 reads
Welcome back to our series, Server Review Essentials for Accidental and Junior DBAs, where we’ve been taking an in-depth look at how to get ready to perform regular SQL...
2021-06-28 (first published: 2021-06-16)
459 reads
Let’s take a look at the final few steps of your initial server intake process and get your workflow up and running as you push toward performing regular server...
2021-04-05 (first published: 2021-03-25)
315 reads
The next post of this series is finally ready to fly. I apologize for the delay between posts, but between the rolling blackouts in Texas during the 2021 Snowpaclypse...
2021-03-18 (first published: 2021-03-15)
329 reads
It’s time for the fourth post in my series about performing regular server reviews. In the first post, we took a look at setting up your local environment. The...
2021-02-09
31 reads
Welcome back to my ongoing series about how we perform regular server reviews here at Dallas DBAs, and the tips and tricks I’ve picked up in my first 1.5...
2021-02-03
31 reads
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last week, we took a closer look at the first steps of getting your environment set...
2021-02-03 (first published: 2021-01-27)
380 reads
Welcome to a new year, and a new look at what I’ve learned in my time as a beginner and junior DBA. So, I’ve been in this DBA gig...
2021-01-28 (first published: 2021-01-19)
661 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Untuk nasabah BCA Bisnis, hubungi Halo BCA Layanan KlikBCA Bisnis 0817 877 114...
hubungi Layanan KlikBCA Bisnis 0817 877 114atau WhatsApp di nomor 0817-877114 KlikBCA Bisnis Halo...
Comments posted to this topic are about the item SSRS Reminded Me of the...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers