Productivity For The Data Pro
Productivity is hard to measure when your work has no definite structure like a typical office job. You may operate...
2018-02-27
458 reads
MarlonRibunal
- Twitter: @MarlonRibunal
- Website: https://marlonribunal.com
Database Maintenance Without Breaking The Bank
Database maintenance does not have to be expensive. There are free tools out there that will make your life easier. Of...
2018-02-22 (first published: 2018-02-13)
3,158 reads
Waiting Tasks Reveal Pain Points
Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I...
2018-02-14 (first published: 2018-02-06)
2,623 reads
Layman’s Guide to Performance Tuning
Performance tuning is one of those things that is hard to get right when you do not have an established...
2018-02-08 (first published: 2018-01-30)
3,516 reads
My Favorite SQL Prompt Features
SQL Prompt from Redgate Software is one of the tools that I cannot live without. Well, that’s probably an exaggeration...
2018-02-02 (first published: 2018-01-23)
2,995 reads
How To Split Table Partitions Automatically
Table partitions can bring a lot of benefits to the manageability and performance of your SQL Server – that is if...
2018-01-16
926 reads
My Tech Reading List to Start the Year
My bold learning goals call for adequate preparation and proportionate action. Before plunging into the challenge, I need to get...
2018-01-12 (first published: 2018-01-02)
1,785 reads
SQL Operations Studio As Monitoring Dashboard
Microsoft as a company has entered a new phase of innovation under the leadership of their CEO Satya Nadella. In...
2018-01-09
560 reads
My Learning Goals for 2018
A couple of weeks ago, the SQL Server community had their last T-SQL Tuesday of the year – 97th since 2009...
2017-12-26
744 reads
Book Review: High Performance SQL Server
As SQL Server professionals, we sometimes encounter some issues that we haven’t seen before or have seen already but forgot...
2017-10-03
387 reads
Blogs
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...
Beginner’s Guide: Create a File Organizer CLI Tool in Rust
Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...
Forums
How Many Can Be the Greatest
Comments posted to this topic are about the item How Many Can Be the...
How to process images and analyze charts with AI
Comments posted to this topic are about the item How to process images and...
Patching the Patch
Comments posted to this topic are about the item Patching the Patch
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