2020-07-21
88 reads
Editorials
A Dedicated Space
Today Steve looks at one possible future of offices, which might be something we own.
2020-07-20
168 reads
Digging Into Internals
There are plenty of experts that look to teach you about query tuning and the internals of query execution in SQL Server.
2020-07-18
164 reads
Your Data After Life
Today Steve thinks about what to do when planning for your digital assets after you pass.
2020-07-17
362 reads
Carefully Giving Normal Users Security Permissions
When we need to delegate work to less privileged users, Steve has an idea.
2020-07-16
195 reads
2020-07-15
162 reads
2020-07-14
119 reads
Beating the Cloud Vendors
Can you run a system better than cloud vendors? You should know and be able to prove it.
2020-07-13
140 reads
Controlling Intelligent Query Processing Features
I always look forward to new T-SQL features and optimizer enhancements with every new version of SQL Server. Starting in 2017, Microsoft came up with a set of features called Intelligent Query Processing (IQP). These features work to improve performance without changing any code. If you’d like to learn more about these features, take a […]
2020-07-11
819 reads
Moving away from an RDBMS
Today Steve looks at an article the migrates a relational model to CosmosDB.
2020-07-10
706 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
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
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
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