Better SQL Server CPU defaults in 2019
SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has added to SQL Server Setup, on...
2019-07-03
166 reads
SQL Server 2019 is still in preview as I write this, but I wanted to point out a new feature that Microsoft has added to SQL Server Setup, on...
2019-07-03
166 reads
Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream support before that. You...
2019-06-26
38 reads
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
117 reads
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
19 reads
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
99 reads
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
18 reads
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
213 reads
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
31 reads
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
18 reads
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
38 reads
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers