Kendra’s Top 3 Tips for Working Remotely
A guest editorial today from Kendra has a few tips for working from home.
2024-04-15 (first published: 2020-03-12)
1,331 reads
Down Tools Week 2020 (10 minute video/podcast episode)
In this episode of Dear SQL DBA, I talk about how Redgate runs "Down Tools Week," what I'm working on as part of the project, and how this has...
2020-08-21 (first published: 2020-08-06)
223 reads
Things That Shouldn’t Be Normal in Database Development (28 minute video/podcast episode)
Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I...
2020-08-11 (first published: 2020-07-30)
756 reads
Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)
I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.
In this episode I share...
2020-07-27 (first published: 2020-07-16)
967 reads
How to Spell and Capitalize tempdb for SQL Server
No matter what I write in this post, some of y'all are going to tell me I'm wrong. That's inevitable, because I'm writing about tempdb: a database so complex...
2020-07-24 (first published: 2020-07-15)
652 reads
Why I’m Learning Git via the Command Line Interface
Today Kendra discusses the advantages of using a command line interface for Git.
2020-01-16
472 reads
The Case for Considering Git
Today we have a guest editorial from Kendra Little that looks at choosing a version control system as you adopt a Database DevOps software development process.
2019-04-19
578 reads
2019-03-05
914 reads
Why Redgate is Running a Database Development Disasters Contest?
Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.
2019-02-14
308 reads
2019-01-21
156 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