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)
337 reads
Kevin3NF
- Interests: Cycling, family, sci-fi, DBA stuff
How old are those stats?
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)
315 reads
Server Review Essentials for Accidental and Junior DBAs—Daily Server Checks (Part 1)
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
56 reads
Server Review Essentials for Accidental and Junior DBAs—Prepping for Server Reviews
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)
469 reads
TIL: Backup-DbaDatabase
(This post comes from one of our Junior DBAs – @SQLDork) I’m learning how to use dbatools. Today’s command: Backup-DbaDatabase I’m using the 64-bit PowerShell ISE (running as administrator),...
2021-04-26 (first published: 2020-04-27)
560 reads
Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 4)
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)
329 reads
Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 3)
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)
339 reads
Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 2)
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
43 reads
Server Review Essentials for Accidental and Junior DBAs—Client Onboarding (Part 1)
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
39 reads
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
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)
387 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers