DevOps is Really Helpful
Steve Jones talks about the practical benefits of using DevOps to smooth out your software development.
Machine Learning 101: The Mathematics of an Artificial Neural Network
This article (1) demonstrates an artificial neural network as it learns to recognize alphanumeric characters and (2) elucidates the mathematics of the feed-forward/back-propagation algorithm the artificial neural network employs.
Power BI Introduction: Working with R Scripts in Power BI Desktop — Part 3
R is a powerful language for manipulating data and creating visualizations. In this article in the series, Robert Sheldon demonstrates how R can be used within Power BI Desktop to import data and to create visualizations.
Foreign Key Indexes and Binding
Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.
How are you recharging this year?
Steve Jones asks about your plans to get away from work and refresh yourself.
The Query Answers with SQL Server Series
A series of articles based on the Query Answers with SQL Server book.
Data Governance, DevOps, and Delivery
Data governance must be included in DevOps practices. William Brewer explains how to define business policies and standards to ensure compliance with privacy regulations and bring data governance to...
Introducing Microsoft BI Reporting and Analysis Tools
Choose the right BI tool by learning about the different strengths of the Microsoft analysis and reporting tools. Microsoft provides a variety of BI tools that can address key workloads, such as Power BI and Excel. The article discusses the workloads and the tools that best support each workload.
String or binary data would be truncated
This is an error that has plagued SQL Server for a long time. It should be fixed.
Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI
In this tip, you will be walked through a method to calculate MTD, QTD, YTD and running total in Power BI. This method is useful in stock calculations and balance sheet calculations.
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