The DBAccountant
Are DBAs going to be responsible for financial accounting for cloud resources as a part of their job? Steve has a few thoughts today.
2024-05-06
35 reads
Editorials
Take Care
The world seems to be proceeding through some stuff at the moment. IT and our industry as a whole, equally seems to be going through some stuff. As such, allow this oldster to offer some advice: Take care of yourself. I know, I'm the same, you may have responsibilities for others. You need to take […]
2024-05-04
45 reads
The On-Call Load
Today Steve asks about on-call responsibility for you and how you view this as part of your job, or in your job search.
2024-05-03
43 reads
Action Over Knowledge
A big part of success is making an effort. Steve discusses the need to do things and not passively let life pass you by.
2024-05-01
105 reads
Why Early Code Review is Important for Database Deployments
Today, Kendra Little talks about code reviews and why they should be done early.
2024-04-29 (first published: 2020-02-07)
299 reads
One more reason to use foreign key constraints
Since the title might be considered a bit vague, I don’t want you to wade through the article to figure it out. I will spare you the typical clickbait introduction, with me telling you what a foreign key constraint is, and why it and all the other constraint types provided by relational engines are useful. […]
2024-04-27
133 reads
Good Luck is Needed with Old Versions
Today, Grant talks about reasons that companies don't upgrade.
2024-04-26 (first published: 2020-02-11)
434 reads
Toilets and Your Systems
Today, Grant Fritchey compares a disaster caused by a toilet to technical debt in IT.
2024-04-24 (first published: 2020-02-24)
416 reads
Seagull Management
Management is important to ensuring the success of a team. Steve talks about an anti-pattern that is often used by poor managers.
2024-04-22
162 reads
Do you listen to music when you work?
I want to make this a participation topic. When you are working, do you listen to music or do you need quiet? And if it isn’t music, do you do something else? TV, movies? For me, it is almost always music. As I write my first Database Weekly newsletter editorial in a few months, I […]
2024-04-20
110 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
Multiple processes accessing the same table. some to write others to read / Lock
Dears, Hope this message finds you well We have a log table which is...
The Backup File Extension
Comments posted to this topic are about the item The Backup File Extension
Ingest and Retrieve data from an ADX Cluster Using Python
Comments posted to this topic are about the item Ingest and Retrieve data from...
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers