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. It also installs stored procedures and runs them, if that’s what you desire. Go ahead and play with it. I’ll wait. There was some positive interest on Twitter, for which I am very grateful, and
-> Continue reading The free SQL to Excel Export tool

Does SQL Server 2019 run on Ubuntu 18.04 LTS?

Yes. Here’s the proof from an output of SELECT @@VERSION:

Here’s a screenshot of me running mssql-cli on the Ubuntu Server virtual machine in question. SQL Server 2019 (CTP 2.3) is running on 18.04.2 LTS. Is it supported by Microsoft? Not right now. The official documentation still requires Ubuntu 16.04, and the release channel
-> Continue reading Does SQL Server 2019 run on Ubuntu 18.04 LTS?

Canadian SQL Saturday speaking events

I am pleased to announce that I will be speaking at two separate SQL Saturdays in March and April of this year. The first event is in Victoria (the capital city of British Columbia, located on Vancouver Island), and the second is in Edmonton, the capital city of Alberta. I will be presenting the same
-> Continue reading Canadian SQL Saturday speaking events

Proposed SQL Server defaults: disable priority boost

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 if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to enabled Set max server memory (MB) to a
-> Continue reading Proposed SQL Server defaults: disable priority boost

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 cost threshold for parallelism to 50 Disable lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to enabled Set max server memory (MB) to a
-> Continue reading Proposed SQL Server defaults: disable lightweight pooling

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 cost threshold for parallelism to 50 Disable lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to enabled Set max server memory (MB) to a
-> Continue reading Proposed SQL Server defaults: cost threshold for parallelism

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 buffer pool as a way to leverage the best performance from computing hardware. Temperature Before we dive deeper into the buffer pool, I wanted to briefly mention data access terminology. A common metaphor for accessing
-> Continue reading When the buffer pool isn’t just in memory

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 year from 27 February to 2 March 2019. My session is called An overview of SQL Server 2019 for the busy DBA / developer. Here is the abstract: SQL Server 2019 is a major new
-> Continue reading Speaking at SQLBits in March 2019

integrated circuit

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 dive too deeply into the buffer pool, we need to remind ourselves of a few fundamentals of how computers process and store information, as that relates to how the buffer pool operates. A computer is
-> Continue reading How does the buffer pool work?

dbForge Studio logo

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 feature from v18.0 onward. When releasing a new version of a product, Microsoft has the luxury of referencing usage statistics, and obviously this is an underused feature of SSMS. I was a little disappointed at
-> Continue reading Database modelling in a post-SSMS world: dbForge Studio