Window Function Basics - PARTITION BY
This article looks at the basics of the OVER() clause and how the PARTITION section works.
2023-12-08
11,631 reads
Emmitt Albright
Comparing Two Execution Plans
This is a short look at a technique that I discovered recently in Management Studio (SSMS). The technique is to compare two graphical execution plans in the tool to understand what they are doing and how two different queries might affect a particular system, both with the image and with the properties' data behind the […]
2023-11-24 (first published: 2021-03-30)
10,876 reads
Randomizing the Day Inside a Month Using T-SQL
This article shows how you can randomize dates in T-SQL, but keep the month and year the same while the day varies.
2022-06-24
1,758 reads
Using Coalesce to Clean Up Reports
One of the lesser used functions is COALESCE(), used to allow you to return one value from a list of those that are potentially NULL. This short pieces gives a few examples where this is useful?
2021-08-16
4,381 reads
A Quick Start to Running Python Code in SQL Server
With the addition of Python to Machine Learning Services in SQL Server 2017, you can now execute your Python code inside of SQL Server.
2020-11-13 (first published: 2019-04-18)
37,551 reads
Creating a Serverless Database in Azure
Learn how you can create a database in the serverless tier in Azure.
2020-06-29
9,842 reads
Fixing MLS Python Services to Load the Runtime
Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]
2019-10-24
8,502 reads
Key Rotation in TDE
Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some protection and auditors like to see physical protection features being used. It's […]
2019-08-29
15,790 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Alamat kantor BCA KCU THAMRIN Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota...
BCA KCP Dewi Sartika Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah...
BCA KCP Pondok Bambu Telp/WA.0851°8812°0691
BCA KCP Pondok Bambu Telp/WA.0851°8812°0691 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers