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
44 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
53 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
48 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
106 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
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
Webinar – Microsoft Fabric for Dummies
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
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...
Forums
Looking for a Recommended Azure SQL Managed Instance Book
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
timeout in vs for ssas tabular deploy is 0 but i still timeout deploying
hi we run 2019 std but i'm testing this on 2016. following some old...
Table variable declared within cursor persists across loop iterations
If you run this code it creates a 2 row cursor loop. Within the...
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