2024-01-03
414 reads
T-SQL
2024-01-01
412 reads
2023-12-27
528 reads
2023-12-21 (first published: 2023-12-20)
537 reads
2023-12-18
389 reads
Searching an Encrypted Column
This article examines the challenges with searches on encrypted data and presents a possible solution that you might use to speed up those queries.
2023-12-15
2,443 reads
2023-12-13
545 reads
SQL GROUP BY Alias - An Oracle feature that would be great in SQL Server
Learn about using an alias in the GROUP BY clause for complex SQL Server code instead of having to rewrite the code in the GROUP BY.
2023-12-13
2023-12-13
281 reads
Window Function Basics - PARTITION BY
This article looks at the basics of the OVER() clause and how the PARTITION section works.
2023-12-08
13,266 reads
Blogs
Lift and shift vs modernizing your data warehouse
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
Power BI Fun With Travels
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
DiskANN Experiment — Exploring Entry Points and Graph Neighborhoods
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Forums
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Choose the Second One
Comments posted to this topic are about the item Choose the Second One
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers