SQL Server Migration from 2008 R2 to 2016

fci-architecture

Take a read about real-live experience coming from SQL Server migration project I participated in. We migrated from SQL ...

Automatic Memory Management for SQL Server Failover Cluster Instances

automatic-memory-management

One of the challenges while using Failover Cluster Instances (FCI) is to manage the memory of the SQL server in case of ...

Copy large table from one database to another in SQL Server

Arithmetic overflow error

Copy table in SQL Server? It's not big deal, one would say. There are plenty of options You can chose from to copy from ...

Manage puppet agent on Windows

puppet.conf

As you may already know puppet works in server - agent architecture. Hence, you will most likely maintain one or more ...

Assign puppet nodes to environments via ENC

Puppet-logo

How to assign puppet nodes to environments is one of the first things to consider when introducing puppet to your ...

Puppet external facts for Windows

puppet-facts

Puppet external facts. What's that? How to collect and manage them in a Windows environment? Probably, facts are one of ...