Articles

External Article

Evaluating the Randomness of SQL Server Random Number Functions

Microsoft provides T-SQL developers with three functions (rand, newid, and crypt_gen_random) for generating random numbers. Each of these functions is effective at returning random values, but feature sets associated with each function make them best suited to different use cases. This tip’s Solution section presents an overview of common use cases for random numbers in SQL Server along with references to learn more about random numbers in SQL Server.

2025-05-12

External Article

Exploring the SQL Server CHOOSE Function

I preface a lot of what I write with whether or not it is for a “practical” use. One of the Simple Talk authors used this function in a forthcoming article. and I realized I hadn’t heard of it before (or I forgot about it… which is not completely unlikely.) The practical use was to generate some data and have at least a little variety to the values.

2025-05-09

SQLServerCentral Article

Modern Streaming Architecture Serverless Pool with Spark Streaming

With the ubiquity of real-time data, organizations need streaming systems that are scalable, easy to use, and easy to integrate into business applications. Structured Streaming is a new high-level streaming API in Apache Spark based on my experience with Spark Streaming. In this article, we show structured streaming data written into Spark Tables and consumed by reporting Analytic for reporting needs.

4.5 (2)

You rated this post out of 5. Change rating

2025-05-02

1,097 reads

Blogs

Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition

By

In my previous post, I showed you how to build a snapshot backup catalog...

Advice I Like: Training Employees

By

Train employees well enough that they could get another job but treat them well...

Creating a Striped Backup Set with AI

By

I needed to test a striped backup, so I decided to ask the AI’s...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Docker Advice for SQL Server in Production

By Vincent92

Comments posted to this topic are about the item Docker Advice for SQL Server...

DevOps is DevOps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DevOps is DevOps

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers