Are IT Certifications Still Relevant?
Steve talks about certifications today, after watching a video that showcases the benefits of why they are good for your career.
2024-05-08
290 reads
Editorials
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
262 reads
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
111 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
110 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
171 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)
316 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
194 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)
448 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)
431 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
216 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers