SQL 2014 Security Updates

It has been a busy time. I've moved house, moved country and moved jobs. Things have happened fast but the dust is starting to settle and I'll soon get into a swing of posting more often. A few things of note for February 2020, other than the Covid 19 virus, were: SQL Security update. There was a SQL Security Update in February for SQL 2014. [...] Read more

SSIS and your SFTP options

The SQL Server intergration Services (SSIS) has always had a FTP task but it is odd that it has never had an SFTP task (up to 2017). SFTP is the Secure File Transfer Protocol using the Secure Shell SSH. There are third party SFTP tasks that can be deployed to your Server running SSIS but the simplest way to use SFTP is through an execute process [...] Read more

SSAS: Multidimensional to Tabular in minutes

On a development box I have SQL Server Analysis Services (SSAS) installed and had tested a multidimensional model. Now I need to test another project which is a tabular model. As you probably know, you can only have one Analysis Service running on each database instance and it has to be either Multidimensional mode or Tabular mode or SharePoint [...] Read more

Depricated feature: Database Mirroring

You may come across legacy SQL Server boxes from 2005 onwards that are configured using database mirroring to provide a High Availability (HA) database for an application or website (BTW - this was written in 2019 and I still see SQL 2000 out in the wild!!). I would strongly recommend moving the Distaster Recovery (DR) strategy to use Availability [...] Read more

Using Jekyll on Microsoft via the bash shell.

As mentioned in my previous post, I am using Docker more frequently on Windows 10. If you need a Linux shell then the Ubuntu bash shell from the Windows Store is a really handy tool and often much faster than using Docker. In particular, this is a far more convenient way for me to install and run Jekyll on my Windows laptop without needing to [...] Read more

1 2 3 4 5 6 7 >