Database Normalization in SQL with Examples
Gouri Shankar provides an overview of normalizing a database.
Leveling up Core Skills: A Pattern for Launching an Internal Training Initiative
Today, Julia Hayward explains how Redgate is leveling up core skills.
General Purpose Tier for Azure SQL Database
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
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
When the database design is not great, you may have to write some creative queries to get what you need.
The Dangers of using Float or Real Datatypes
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
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
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
Alex Chamchourine explains how he managed to find a row in a billion row table without an index.
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
BCA KCU PLUIT No. Telp:083831617937
Whatsapp.083831617937 Jl. Pluit Selatan 200 Jakarta Utara, DKI Jakarta, Indonesia 14450
BCA KCU TANJUNG PRIOK No. Telp:083831617937
Whatsapp.083831617937 Jl. Enggano 22-23 Jakarta Utara, DKI Jakarta, Indonesia 14310
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers