A Dedicated Space
Today Steve looks at one possible future of offices, which might be something we own.
2020-07-20
166 reads
Editorials
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
159 reads
Your Data After Life
Today Steve thinks about what to do when planning for your digital assets after you pass.
2020-07-17
348 reads
Carefully Giving Normal Users Security Permissions
When we need to delegate work to less privileged users, Steve has an idea.
2020-07-16
193 reads
2020-07-15
157 reads
2020-07-14
115 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
137 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
811 reads
Moving away from an RDBMS
Today Steve looks at an article the migrates a relational model to CosmosDB.
2020-07-10
700 reads
2020-07-09
103 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers