Random Number Generator in SQL using Marsaglia Polar
How can we build a random number generator using Marsaglia Polar method in SQL Server without the use of external tools?
2025-12-01
How can we build a random number generator using Marsaglia Polar method in SQL Server without the use of external tools?
2025-12-01
Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]
2025-11-28
8,463 reads
Before SQL Server 2025, if you want to store JSON data in Microsoft SQL Server or Azure SQL DB, and you want fast queries, the easiest way is to:
2025-11-28
This article presents a way to discover those tables that are unused over a period of time, along with suggestions on how to get rid of these tables.
2025-11-26 (first published: 2025-10-15)
15,488 reads
This tutorial will discuss using variables with SQL DECLARE along with various examples.
2025-11-26
Learn about filtered indexes in SQL Server, how they work, and how they can help improve performance.
2025-11-24
5,577 reads
Short story: what the title says.
2025-11-24
Learn about unlogged tables and how they work in PostgreSQL.
2025-11-21
5,855 reads
JSON is a complex data type used for representing objects with various properties. With JSON you follow the key-value pattern where the key is a string and the value can be of different data types. What are some common ways to work with JSON in SQL Server?
2025-11-21
SQL Server 2025 has been released to GA. Read about the new version in this piece by Bob Ward.
2025-11-19 (first published: 2025-11-18)
17,330 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby. Baru, Kota...
WhatsApp:0817819444 Jl. Brawijaya 79, Dusun Muncar Baru, Tembokrejo, Kec. Muncar, Kabupaten Banyuwangi, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers