Editorials

SQLServerCentral Editorial

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 […]

5 (1)

You rated this post out of 5. Change rating

2024-05-12 (first published: )

45 reads

SQLServerCentral Editorial

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 […]

5 (1)

You rated this post out of 5. Change rating

2024-05-04

100 reads

SQLServerCentral Editorial

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. […]

You rated this post out of 5. Change rating

2024-04-27

148 reads

Blogs

T-SQL Tuesday #174 – My Favorite Interview Question

By

This month is a great topic to me. I think growing and improving your...

T-SQL Tuesday #174: Job Interview Questions

By

Once upon a time, I used to think of difficult technical questions to ask...

Power BI: Refreshable Excel Files in PBI Service

By

Ever since Excel made its debut in the 1980’s, it has been used as...

Read the latest Blogs

Forums

Help on grouping to sets of rows in my sql data

By Mond

Hello I need help on writing this query. This is what i need. I...

SSIS Connecting to Azure SQL Managed Instance w/ MFA

By tjcavins

We've been testing out Azure SQL Managed Instance and created SSIS packages to run...

Summarizing Raw Sales Data with Group Summaries and Final Summary

By Paul Stasny

Greetings, I need to transform data returned in a query from several tables as...

Visit the forum

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