Articles

SQLServerCentral Article

Understanding SQL Server PARTITION BY with Examples

Introduction When developers first learn SQL aggregation, they usually start with the GROUP BY clause. It works well for summary reports because it combines multiple rows into a single result for each group. For example, you can calculate total sales per region or average salary per department. The limitation of GROUP BY appears when you […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2026-06-05

4,768 reads

SQLServerCentral Article

Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform

Data build tool (dbt) is an open-source command line tool that helps engineers transform data using SQL scripts.  However, there are limitations to what can be done with the Structure Query Language (SQL).  That is where dbt Python models can be used to perform complex tasks.  A dbt Python model is a function that reads […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-06-03

2,852 reads

SQLServerCentral Article

Using Containers to Avoid Installing SQL Server

I got a new laptop recently and instead of installing SQL Server, I decided to try and use containers to see how well this works. This article looks at how I got this working relatively quickly. The short list of things I did is: Install Docker Desktop Create a location for data/logs/etc. Create a docker-compose […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2026-06-02 (first published: )

7,437 reads

SQLServerCentral Article

Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now

SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(10)

You rated this post out of 5. Change rating

2026-05-29

7,412 reads

SQLServerCentral Article

Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform

Data build tool (dbt) is an open-source command line tool that helps analysts and engineers transform data within their warehouses.  It already assumes that data is extracted and loaded into raw tables.  The dbt core framework is written in Python with the translations defined as a combination of SQL scripts, Jinga Template Language, and YAML […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-05-27

1,328 reads

Blogs

A New Word: Semaphorism

By

semaphorism – n. a conversational hint that you have something personal to say on...

SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates

By

This week I was at PASS Data Community Summit in Seattle, and I attended...

Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents

By

(This is the third post in a three-part series on how AI is changing...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

Kantor Resmi BCA KCU MALANG Telp:0821°755°5651

By layanan_Bca88

Telp/Wa 628217555651 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur...

People Matter

By Grant Fritchey

Comments posted to this topic are about the item People Matter

Visit the forum

Question of the Day

Adding Bits I

I have a table, dbo.bittest, where I am testing an application response. This has this structure:

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, 'true')
GO

See possible answers