It's the Engineers
The staff that build your systems are more important than your choice of technology.
Database DevOps: Standardize, Automate, Monitor & Protect
See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.
Getting results using less T-SQL
There is usually more than one way to write a query. In this article, Edward Pollack explains a few ways to write simpler T-SQL code.
Moving on but not far
During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing […]
Job Interviews: What is Normalization?
Do you know how to answer normalization questions in an interview? Steve Jones gives you a few ideas and recommends you brush up on your knowledge.
Change Management and Leadership Alignment
Successfully implanting change in an organization requires buy-in from leadership. Rohan Kapoor explains what’s needed to get leadership alignment.
Flyway and Simple Source Control
How to integrate Flyway database development with Source control, so that you can track what changes were made and who made them as well as which objects changed between versions, and how.
The General Database Platform
It seems that many people who choose NoSQL platforms still need relational features. Steve speculates on why.
[Re-post] Tackling the Challenges of Hybrid Estates
It's an oldie but a goodie: Redgate Advocate Grant Fritchey takes us through how best to manage hybrid estates. Read on to find his expert recommendations.
Blogs
Scaling PowerShell – Lessons from a Technical Interview
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
Installing Old Versions of PowerShell Modules with Their Dependencies
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers