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.
Grant Fritchey Reviews Minion Reindex
Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.
Time for Learning
How do you find time for learning? More importantly, Steve Jones asks if you find time for actual use of your knowledge.
Finding Encrypted Data in a SQL Server Database
The easiest way to determine if there is encrypted data in a database is to get that information from whoever wrote the application. Aside from that, there are a few things you can look for which would suggest that you have encrypted data in a given database.
Which Problem Are You Solving?
This week Steve Jones talks a bit about problem solving and how you should approach the issue.
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers