In today’s fast-paced landscape, where agile development and cloud-native platforms dominate, data modelling might seem like a relic of the past.

Don't

by Steve Jones

SQLServerCentral

Career Growth

Are you more positive or negative when you approach a problem?

How Implicit Transactions Hurt SQL Server Performance Without You Knowing

by Chandan Shukla

SQLServerCentral

Uncategorized

Learn about implicit transaction and why you might not want to enable this setting.

Memories of Andrew Clarke, by Simon Galbraith

by Additional Articles

SimpleTalk

Misc

Simon Galbraith, co-founder of Redgate and one of the creators of Simple Talk, remembers Andrew Clarke

Be Wary of Data

by Steve Jones

SQLServerCentral

Data Quality

We should all be careful assuming that data implies facts.

DIY Database Clones

by Tonie Huizer

SQLServerCentral

This article explores the 'shadow copy' and 'disk virtualization' services built into the Windows operating system and explains a basic solution demonstrating how the technology is used to copy the data and log files for a live SQL Server database into an 'image', from which we can create multiple, lightweight copies, or clones, of the original database.

Why Indexes are Important Beyond Faster Execution of Queries

by Saravanan Venkatesan

SQLServerCentral

Learn how indexes can help you with more than just querying data.

SQL EXISTS Use Cases and Examples

by Additional Articles

MSSQLTips.com

T-SQL

I’ve seen the SQL EXISTS keyword in Microsoft SQL Server T-SQL code and don’t understand it well. What does it do? How do I use it? Are there best practices around SQL IF EXISTS?