SQL Server and Docker Containers.

It has been possible to run the Linux version of SQL Server in a Docker container for a couple of years now. This is a nice way to have a clean and simple development database on your laptop that can be easily turned on and off when required. The SQL 2017 Linux edition had many unsupported features but is still a great way to have a local SQL [...] Read more

Removing User-Created Statistics

In the past I have inherited databases that have a large number of user defined statistics the table. The statistics name structure suggests that they were added by the performance analyser from a much earlier version of SQL Server. The existence of user-created statistics raises a warning in the excellent sp_Blitz SQL Health check scripts from [...] Read more

Azure Automation and SQL Serverless

Back in October 2018 I wrote about automating an Azure development environment, in particular turning off the development machines when not in use and switching them on ready for the work ahead. For development databases it now looks like this can now be achieved using Azure SQL DB Serverless. This blog post from Brent Ozar explains all. It would [...] Read more

Problems with One Drive synchronisation.

This has happened to me a few times on laptops running the latest version of Windows 10. One Drive is built into the operating system and occasionally stops synching with the cloud and I'm not sure what is causing the issue. I suspect (but have never successfully reproduced the issue) that it is caused when there is an update to One Drive during [...] Read more

Automation in Azure. Example script to avoid weekends.

Since writing this entry, new features in Azure from June 2019 can provide similar functionality - see the following post for more details. Using virtual machines (VMs) on Microsoft’s Azure platform are charged by the hour. Non-critical, test or development servers can be switched off when not in use, saving you money, especially if you are using [...] Read more

< 1 2 3 4 5 6 7 >