What is a Relational Database Management System
This article covers the relational database system evolution and covers terms used in relational models such as relation, tuple, attribute, domain, schemas, and key.
A Need for Monitoring without Administration
A recent hack through a network monitoring system is scary, but Steve thinks that we ought to not require these systems to have privileged access.
Stairway to U-SQL Level 18: Populating a Data Lake with PowerShell
Learn how PowerShell can be used to manage files and folders in your Data Lake.
DBA in training: Know your server’s limits
Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.
Maintaining a Database Build Script with SQL Compare
Phil Factor explores a lesser-known capability of SQL Compare, which is to help you maintain a 'traditional', well-documented, single file build script, for creating the current version of the database during development.
Spoofing Data Convincingly: Text Data
Learn how to generate some convincing data for your development databases.
The Devil is in the Details
The story of an engineer solving a problem is a good one that shows technical skills and a passion for the work.
Import Excel Data into SQL Server with PowerShell
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
What’s most important to you when dealing with database software?
Take part in this short exercise (no more than 5 minutes) by letting us know what matters most to you when considering, purchasing, or using database software. As a thank you, you can also enter our prize draw at the end for a chance to win a $150 Amazon gift voucher.
Do *not* place TEMPDB on a local disk in a SQL failover cluster
What happens with tempdb on a local disk in a cluster? Read on to see that you will not get a failover if the local disk fails
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
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...
Forums
Inspection And Auditing | FARE Labs Pvt. Ltd.
At FARE Labs Pvt. Ltd., our inspection and auditing services focus on precision, quality...
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers