Shutting Down Coping Tips
It’s been nearly 3 years of Daily Coping Tips here at the Voice of the DBA. I started these when the pandemic hit and the world shut down. I’ve...
2023-03-01
38 reads
Documentation vs Automation
Originally, I was going to write a post on troubleshooting SQL Server. This is because I’m writing up and reviewing a lot of documentation at my current job. I’ll...
2023-03-08 (first published: 2023-03-01)
455 reads
Adding a Computed Column–#SQLNewBlogger
Recently I needed to add a computed column to a table and realized that I didn’t remember the syntax. This short post show how to do this. Another post...
2023-03-10 (first published: 2023-03-01)
424 reads
Daily Coping 1 Mar 2023
Today’s coping tip is to call a friend to catch up and really listen to them Actually a friend pinged me to ask about a call recently. I made...
2023-03-01
19 reads
30 Interview Questions for a Database Administrator and Developer
This blog post summarizes the type of technical questions I would ask candidates for a Microsoft SQL Server data platform administrator and database developer role.Hopefully this helps both candidates...
2023-03-08 (first published: 2023-02-28)
1,313 reads
Daily Coping 28 Feb 2023
Today’s coping tip is to thank three people you feel grateful to and tell them why. This is something I tend to do privately, thanking people who’ve impacted my...
2023-02-28
16 reads
Understanding the TOGAF 9 Foundation Exam
When I teach the ISACA Certified Information Systems Auditor (CISA) course, one of the things I walk candidates through is how the test is structured and how much each...
2023-03-06 (first published: 2023-02-28)
297 reads
A Corporate Wellness Day
Today is the corporate Wellness Day at Redgate. It’s a day off for almost everyone in the company, unless they have something that can’t get moved. A few support...
2023-02-27
79 reads
What Happens on Azure SQL Database?
Last week I posted the results from using Extended Events to snoop on what happens inside an AWS RDS database. This week, I’m taking a look at what happens...
2023-03-06 (first published: 2023-02-27)
431 reads
Tales From The Field Weekly Wrap Up for the Week of 02-20-2023
Hello Dear Reader! We had a beautiful weekend here in Florida. Spring is in the air, mainly because the temperature is ranging between 85 to 90 degrees Fahrenheit. This...
2023-02-27
23 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
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