Database Normalization in SQL with Examples

• by gourishankar

• SQLServerCentral

• T-SQL

Gouri Shankar provides an overview of normalizing a database.

Leveling up Core Skills: A Pattern for Launching an Internal Training Initiative

• by Julia Hayward

• SQLServerCentral

• Career

Today, Julia Hayward explains how Redgate is leveling up core skills.

General Purpose Tier for Azure SQL Database

• by Additional Articles

• MSSQLTips.com

Five years ago, there were a limited number of ways to deploy and use the SQL Server engine in the Azure Cloud. Today, there are many different services available.

Record responses for the State of Database DevOps report

• by Additional Articles

• Redgate

• DevOps and Continuous Delivery (CI/CD)

The fourth annual State of Database DevOps report is now available for download. Kendra Little announces the launch in her latest blog. Check out the first high level findings of the report here.

Handling Aggregations on a Poorly Designed Database

• by aveek22

• SQLServerCentral

• Aggregates
• T-SQL

When the database design is not great, you may have to write some creative queries to get what you need.

The Importance of Testing

• by Grant Fritchey

• SQLServerCentral

• Testing
• Unit Testing

Today, Grant Fritchey talks about why testing early is so important.

The Dangers of using Float or Real Datatypes

• by Additional Articles

• Redgate

• float

Floating point datatypes accommodate very big numbers but sacrifice precision. They are handy for some types of scientific calculations, but are dangerous when used more widely, because they can introduce big rounding errors.

Using SQL Server RAND Function Deep Dive

• by Additional Articles

• MSSQLTips.com

Dr. Dallas Snider, a MSSQLTips author, mentioned that SQL Server RAND() function could generate random values uniformly distributed from 0 through 1, exclusive. He generated random numbers from the normal distribution with a specific mean and standard deviation.

A New World of Data

• by Louis-Davidson-(@drsql)

• SQLServerCentral

• Database Weekly

I started in the early days of SQL Server, when having a gigabyte of disk storage was unheard of, much less a gigabyte of RAM. My watch has more storage space than the mainframe we replaced with an early version of SQL Server years ago. The technical possibilities and amounts of data we are capable […]

A quick search without an index

• by Alex Chamchourine

• SQLServerCentral

• T-SQL

Alex Chamchourine explains how he managed to find a row in a billion row table without an index.