Do your Foreign Keys Hate You?
We all love our databases. We trust everything they do! How could we not? It's our baby.... well, probably not....
2013-11-07
304 reads
DBA On The Go
How to find empty tables in SQL Server : Quick Tip
These quick tips are short and sweet. They are nothing more than an explanation and some code. If you have...
2013-11-06
444 reads
SQL Saturday Dallas
I've been to five SQL Saturdays so far and this was my first year to attend the Dallas conference. Therewere...
2013-11-06
396 reads
Blogs
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Forums
disable remote access
If I configure remote access to 0 on my servers, am I right in...
Creating Maintenance plan to run annually
What is the best way to set the schedule of a maintenance plan or...
Crosstabs and Pre-Aggregations - Reporting on Steroids by Jeff Moden
The LA Data Platform User Group had a necessary speaker cancellation for the group...
Question of the Day
How Many Can Be the Greatest
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers