Quintessential Or Elegant
This editorial addresses the need to write the most effective and efficient code for our solutions
Amazon's Aurora: A Distributed SQL Database Alternative For MySQL Applications
SQL-based distributed Cloud Relational databases aren't new, but Amazon's Aurora offers an alternative to SQL Azure, and, being MySQL-compatible, provides the obvious route to the cloud for hosted LAMP web applications.
Using a column name in a COUNT function
Putting a column name in a COUNT() function may not always give you what you are looking for.
How to get ETL Horribly Wrong
ETL ( Extract, transform, load) doesn't have to be like a spell on hell. To make a success of ETL systems, you need the freedom and ability to make graceful U-turns when you detect a mistake in architecture or configuration: to fix the root problem rather than to merely tackle the symptoms. Feodor lists the eight most common root causes of failure in ETL systems, and how to fix them.
Database ownership and TRUSTWORTHY
Database ownership is an old topic for SQL Server pro's. Check this simple lab to learn the risks your databases can be exposed to.
You Better Learn to Work at Scale
We are managing more and more systems and databases all the time. To Steve Jones, that means we must be able to work at scale.
Using T-SQL to Perform Z-Score Column Normalization in SQL Server
In data mining, we sometimes need to perform techniques such as Z-score normalization on numeric data type columns to prevent one column from skewing or dominating the models produced by the machine learning algorithms. Dallas Snider explains how to perform this in SQL Server with T-SQL code.
Why Developers Need to Understand Execution Plans
If you can examine and understand execution plans, you can achieve better understanding of the database system and you will write better database code. Grant Fritchey shows you how.
Data Mining Part 23: Security
In this chapter we will talk about security recommendations for SQL Server Data Mining.
Data Mining Part 23: Security
In this chapter we will talk about security recommendations for SQL Server Data Mining.
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?