Integration Task to gather API data using PowerShell

At the time of writing there isn't a SQL Server Integration Services (SSIS) task that will collect JSON or XML formatted data directly from an API call. There are various add-ons and products that are available however, it is straightforward to achieve this using PowerShell and since you are likely to use PowerShell to automate other tasks on [...] Read more

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

< 1 2 3 4 5 6 7 >