Crazy Interviews
Today Steve has a few thoughts about some of the nightmare interview processes tech workers are going through.
2024-05-13
121 reads
Editorials
Honeybee Swarms
I love honeybees. This will be my seventh year as an amateur beekeeper, and aside from family or data, there are few other topics that I could easily spend an afternoon talking to you about. They’re amazing creatures. This past winter I had to move my beehives temporarily to the apiary of a friend. With […]
2024-05-12 (first published: 2024-05-11)
35 reads
Multiple Display Productivity
How many monitors do you need? Steve notes that having multiple ones seems to be a standard these days for tech workers. Do more make you more productive? Answer the poll today.
2024-05-10
85 reads
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
209 reads
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
102 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
100 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
68 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
115 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)
307 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
147 reads
Blogs
I like KQL and I like managing my test data – are they mates?
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
Full-Text Search in SQL Server: A Comprehensive Guide
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
Reading JSON Data with Python
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Forums
Summarizing Raw Sales Data with Group Summaries and Final Summary
Greetings, I need to transform data returned in a query from several tables as...
Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Script to Merger duplicate indexes
Hello, I am trying to firgure out how to merge duplicate indexes using a...
Question of the Day
The Query Traceflag
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers