How Much Code Can You Review?
Code reviews are a part of many developers' lives, but is there a limit to what you can do effectively?
The Basics of Using GENERATE_SERIES()
This article shows how GENERATE_SERIES can be used with a few practical examples and a warning on parameters.
Alternatives To SQL Server 2022 Built-in function GREATEST
If you haven’t already heard, SQL Server 2022 introduced a new built-in system function called GREATEST. Simply put, it is to a set of columns, variables, expressions etc. what the MAX function is to a set of values (i.e., rows) of a single column or expression.
SQL Athena Introduction - How it works, Use Cases and Advantages
Learn about Amazon Athena, how it works, why you would use it, and some of the advantages of Athena over traditional relational databases.
Confidence
Today, I want to blog about something I have only limited knowledge of … confidence. Okay, I understand what confidence is, and I have seen it before in the real world and not just in biographical movies. In fact, I have met quite a few highly confident people. In almost every case, it was immediately […]
Different Ways to Populate the List of Tables
This article shows how you can query different types of tables, based on certain criteria that may be important to you. A good list of basics for any database administrator that will help you find tables in your database.
How Effective Is Your Data Load Monitoring in SQL and Python?
Learn how you can use monitor your data warehouse load process with Python code and a structured process.
Using SQLite with Flutter
Learn how you can build a basic Flutter application that interacts with a SQLite database.
Power BI Workspace Permissions and Roles
What are the Power BI workspace permissions and roles and how are they used?
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Alamat kontak resmi BCA KCP Dewi Sartika Telp:0817866887
WhatsApp:0817866887 Jl. Dewi Sartika No.58, Balonggede, Kec. Regol, Kota Bandung, Jawa Barat 40251
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Question of the Day
Creating a JSON Document IV
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers