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

841 reads

Technical Article

Navigating Your Test Data Challenges: Insights and Solutions

Join Redgate on May 1st for an insightful webinar cohosted with analyst firm, Bloor Research, featuring independent Senior Analyst Daniel Howard and Redgate's Steve Jones. Discover the biggest test data challenges, the latest approaches like AI synthetic data generation, and how effective test data management can benefit your entire organization. Don't miss out on this opportunity to gain valuable insights and solutions.

You rated this post out of 5. Change rating

2025-04-30 (first published: )

Blogs

A New Word: Lookaback

By

lookaback– n.  the chock of meeting back up with someone and learning that your...

Azure Vulnerability Assessments

By

Regarding managing databases in the cloud, security should never be an afterthought. That’s where...

Speaking at the NYC Lunch and Learn–May 23

By

In a couple of weeks, I’ll be in New York City for the Redgate...

Read the latest Blogs

Forums

Deleting a Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deleting a Database

Data Analyst AI tool

By Daniel Calbimonte

Comments posted to this topic are about the item Data Analyst AI tool

Removing Log Shipping

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing Log Shipping

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers