Are Data Breaches Inevitable?
Steve examines the idea that we might all have a data breach at some point.
How to Safely Remove a SQL Server Data File Without Downtime
Learn how to safely remove a SQL Server .ndf data file without any downtime using DBCC SHRINKFILE (EMPTYFILE). This hands-on tutorial walks through real-world Azure-based setup, data redistribution, and storage cleanup — ideal for DBAs managing enterprise SQL Server environments.
SQL ASCII Function Use and Examples
The ASCII function is used to return the ASCII value for the first character in a string.
Evergreen SQL Server
Microsoft talks about evergreen SQL, where you never need to patch your database.
Stairway to Transaction Log Management in SQL Server, Level 2: A Brief Overview of Transaction Log Architecture
In order to make it easier to understand truncation, space reuse and fragmentation in the log file, Tony gives a brief explanation of how the transaction log works.
Your SQL Server Needs Spring Cleaning, Too.
First things first: pick up that filthy keyboard, take it over to the trash can, turn it upside down, and give it a good, vigorous shake.
Data Analyst AI tool
See how ChatGPT can be used to analyze a dataset, produce charts, and train a model.
Evaluating the Randomness of SQL Server Random Number Functions
Microsoft provides T-SQL developers with three functions (rand, newid, and crypt_gen_random) for generating random numbers. Each of these functions is effective at returning random values, but feature sets associated with each function make them best suited to different use cases. This tip’s Solution section presents an overview of common use cases for random numbers in SQL Server along with references to learn more about random numbers in SQL Server.
How Do You Know You Are Right?
I spend a significant amount of time working alone at my desk. I write articles, edit them, and share my opinions. However, I am constantly concerned about being wrong. How can I overcome this feeling? If this were a live session, I would eagerly listen to the answers to this question. Since it isn't, I […]
Database DevOps Recommendations
DevOps and databases aren't always considered compatible, but that is changing. DORA now has recommendations for database changes on their site.
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
BCA KCU SUKABUMI Telp_Cs:0821°8200°203
Whatsapp:628218200203 Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat 43111
BCA KCU Karawang Telp_Cs:0821°8200°233
Whatsapp:628218200233 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang, Jawa Barat...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers