What is a container anyway?
Recently there was a thread on Twitter which established that a lot of IT people didn’t know the difference between virtual machines and containers. |???????|| CONTAINERS || ARE NOT...
2019-06-19
127 reads
Born SQL with Randolph West
Speaking at PASS Summit 2019
I am delighted to announce that I have been selected to speak at the largest Microsoft Data Platform conference in the world, PASS Summit 2019, in Seattle WA, USA....
2019-05-22
21 reads
Proposed SQL Server defaults: max server memory
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling...
2019-05-15
114 reads
The easy way to handle UTF-8 in a .NET application when dealing with SQL Server 2019
A short post this week. On a mailing list recently, someone noticed that a .NET application writing to SQL Server did not have the expected behaviour with UTF-8 collation...
2019-05-08
20 reads
A short Azure SQL Database Edge explainer
On Thursday 2 May 2019, Microsoft announced a new edition of SQL Server, targeting Internet of Things (IoT) edge devices. That means SQL Server can now run almost anywhere....
2019-05-03
225 reads
The case of scalar UDF inlining, where context is everything
I have a shorter post this week, but I reckon it’s an interesting story. As part of the new Intelligent Query Processing improvements introduced in the upcoming SQL Server...
2019-05-01
43 reads
Using a home-grown Azure Blob Storage solution for SQL Server backups
I’m here for the small organizations, the shops that can’t afford expensive solutions to maintain their environments. I’m here for them because that’s me: the one-person consultancy. I’ve built...
2019-04-10
20 reads
It’s a UNIX system. I know this.
Jurassic Park was a great film. Steven Spielberg brought technology into the film era in a major way with computer generated dinosaurs and some now-classic film lines, many of...
2019-04-03
42 reads
SQL Server on Linux – feature change in Pacemaker 1.1.18
Heads up for SQL Server on Linux folks using availability groups and Pacemaker. Pacemaker 1.1.18 has been out for a while now, but it’s worth mentioning that there was...
2019-03-27
20 reads
The free SQL to Excel Export tool
Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....
2019-03-20
666 reads
Blogs
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
dataMinds Connect 2025 – Slides & Scripts
You can find all the session materials for the presentation “Indexing for Dummies” that...
Forums
Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
DBCC CHECKIDENT
Comments posted to this topic are about the item DBCC CHECKIDENT
Distributed Availability Group Health: T-SQL and Zabbix
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Question of the Day
DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers