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
21 reads
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
40 reads
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
96 reads
Today, Kendra Little talks about code reviews and why they should be done early.
2024-04-29 (first published: 2020-02-07)
295 reads
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
132 reads
Today, Grant talks about reasons that companies don't upgrade.
2024-04-26 (first published: 2020-02-11)
433 reads
Today, Grant Fritchey compares a disaster caused by a toilet to technical debt in IT.
2024-04-24 (first published: 2020-02-24)
415 reads
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
161 reads
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
2024-04-19 (first published: 2020-01-21)
469 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers