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.

SQLServerCentral Editorial

How Do You Know You Are Right?

I spend a significant amount of time working alone at my desk. I write articles, edit them, and share my opinions. However, I am constantly concerned about being wrong. How can I overcome this feeling? If this were a live session, I would eagerly listen to the answers to this question. Since it isn't, I […]

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.

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