In October's news - AI usage continues to spread and evolve, malware attacks SQL 2012 and 2014, and critical security updates for Windows, SQL 2016, and SQL 2017 are released.
As January draws to a close, Microsoft lets in the new year with a CU for 2016 SP1 & SP2 and a hotfix for 2017 CU13 (as below). There are also Windows updates and a variety of stories in the news to take a look at.
In my previous blog post (https://blog.coeo.com/the-real-difference-between-the-select-...-into-and-insert-...-select-statements) I explored the difference between the ‘SELECT … INTO’ and ‘INSERT … SELECT’ and referenced the fn_dblog() function as a tool that can be used to retrieve information..
SQL Bits is a highlight of the year for European data professionals and this February's conference schedule is shaping up to be an exciting one.
Updated: March 2020
Following one of my earlier blog posts about Always Encrypted, I thought I'd stick with the security theme for my latest one. With the General Data Protection Regulation (GDPR) on the horizon, encrypting connections is one of the most common discussion points that comes up..
In my previous post Getting Started with SSIS Scale Out I discussed the use cases for SSIS Scale Out and how to install and configure it. In this post I'll look at how to execute packages in Scale Out, depending on your type of workload and security considerations.
Recently I was asked what my favourite SQL Server 2017 new feature was. The answer was easy, SSIS Scale Out. This is a feature that provides a quick and easy solution to a variety of ETL problems. If your ETL processing looks like one of these scenarios, this could be for you.