SQL Server on Linux – External Memory Pressure with 2019 CTP2
In this blog post we’re going to revisit how SQL Server on Linux responds to external memory pressure. This is a very long post, and it ends with me...
2018-10-13
4 reads
Blog Posts
Azure Cosmos DB Free Trial – walk through of Gremlin API for Graph
After the 2018 Microsoft Ignite event, Microsoft announced a free trial of Azure Cosmos DB. For those who are eager...
2018-10-12 (first published: 2018-10-01)
2,448 reads
I’m Speaking – Denver Dev Day Fall 2018
Denver Dev Day Fall 2018 is a free event organized by volunteers and hosted at the Microsoft campus in the DTC. It’s a full day to learn from industry...
2018-10-12
9 reads
It’s a wrap – SQL Saturday Denver #774
SQL Saturday Denver #774 has come and gone. It’s hard to believe how quick things went – well there were a...
2018-10-12
373 reads
The Developer’s Guide to Azure–A Good Overview
Someone sent me a link a few weeks back about a free book from Microsoft. It’s the Developer’s Guide to...
2018-10-12 (first published: 2018-10-03)
2,479 reads
Auto-Scaling Azure SQL DB
When I was presenting my Azure SQL Database session at DataRelay (used to be SQLRelay) I was asked (over coffee)...
2018-10-11
963 reads
Power BI Dashboards, Reports, and Datasets with the SQL Chefs
This week I had the opportunity to learn about dashboards, reports, and datasets in Power BI using the best kind...
2018-10-11 (first published: 2018-10-02)
2,994 reads
The SQL Agents’ view of SQL Server
I recently came across a really odd issue with the SQL Agent, there were two agent jobs attached to one...
2018-10-11 (first published: 2018-10-02)
2,857 reads
Which is faster? IN (list) or IN (SELECT FROM Temp)
If you’ve done much with IN (list) then you’ve realized that it basically translates out to
col=val1 OR col=val2 OR...
2018-10-11
2,484 reads
Adaptive Joins and Join Hints
At a recent all-day seminar on query performance tuning I was asked a question that I didn’t know the answer...
2018-10-10 (first published: 2018-10-01)
2,723 reads
Blogs
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,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
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