Proposed SQL Server defaults: disable lightweight pooling
A few months ago I suggested that the following settings should be the default for most SQL Server instances. Set...
2019-02-20
322 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
Proposed SQL Server defaults: cost threshold for parallelism
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set...
2019-02-13
174 reads
When the buffer pool isn’t just in memory
Last time we looked at the four major components of a computer system, and then looked at the SQL Server...
2019-02-06
190 reads
Speaking at SQLBits in March 2019
I have been selected to speak for a second time at SQLBits, which is being hosted in Manchester UK this...
2019-01-30
229 reads
How does the buffer pool work?
Today we’ll begin taking a look at the buffer pool in SQL Server and how it’s normally used. Before we...
2019-01-23
191 reads
Database modelling in a post-SSMS world: dbForge Studio
A few months ago, Microsoft announced that SQL Server Management Studio (SSMS) will no longer include the visual Database Diagrams...
2019-01-16
227 reads
Back to the future
It’s January 2019 as I write this. I realized that I started on my journey with SQL Server in 1998,...
2019-01-09
224 reads
AzCopy finally gets a sync option, and all the world rejoices
I consider Blob Storage to be the gateway drug to Azure, because it’s a really easy way to get going...
2019-01-02
236 reads
Giving thanks in 2018
It’s the last post of 2018, and in years past I’ve recapped the year that has just been. This is...
2018-12-26
190 reads
Infrastructure matters, even in the Cloud
I am still amused by terminology in the Information Technology field. Words like “Kubernetes,” “containers,” and the BASIC keywords PEEK...
2018-12-19
273 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers