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.
Cyber Security Monthly News - January Summary 2019
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.
Inside the Transaction Log file using fn_dblog() and fn_full_dblog()
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..
Learn with Coeo at SQL Bits
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.
Securing connections to SQL Server with TLS
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 during customer..
Executing Packages with SSIS Scale Out
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.
Getting Started with SSIS Scale Out
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.