Category: SQL Server

Building Custom Tasks for SQL Server Integration Services
Building Custom Tasks for SQL Server Integration Services
Ebooks

Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you’ve already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom… READ MORE

Recover database encrypted modules code with dbatools
Recover database encrypted modules code with dbatools
Blog Posts

This article “Recover database encrypted modules code with dbatools” was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments I read about it, mainly why people still use WITH ENCRYPTION when it’s simple to overcome this when we have the right permissions. SQL Server offers an option to encrypt the code of your modules when using the WITH… READ MORE

Interacting with SQL Server 2019 Big Data Clusters
Interacting with SQL Server 2019 Big Data Clusters
Blog Posts

Just a very quick post with lots of pictures 🙂 SQL Server 2019 Big Data Clusters are still in private preview and I’m currently running with version CTP 2.1. However, I wanted to share some of the exciting new features we can expect from this latest big data tech in terms of tools, management and monitoring… READ MORE

Latest on the ESPC Community
Latest on the ESPC Community
Blog Posts

Grow and enhance your skills with the European SharePoint, Office 365 & Azure Community. Joining the ESPC Community, gives you access to the online resource centre at sharepointeurope.com, providing the best, free content on SharePoint, Azure and Office 365. Topics covered include Microsoft Teams, SharePoint, SharePoint Framework, Office 365 Groups, OneDrive, PowerApps & Flow, Security,… READ MORE

Introduction to MySQL High Availability Stack
Introduction to MySQL High Availability Stack
Ebooks

Introducing InnoDB Cluster by Charles Bell teaches you about the building blocks that make up InnoDB Cluster such as MySQL Group Replication for storing data redundantly, MySQL Router for the routing of inbound connections, and MySQL Shell for simplified setup and configuration, status reporting, and even automatic failover. You will understand how it all works… READ MORE