Take a read about real-live experience coming from SQL Server migration project I participated in. We migrated from SQL Server 2008 R2 standalone servers into SQL Server 2016 in Failover Cluster Instances (FCI). Watch the full presentation – Polish language only! Intro The environment is a private cloud dedicated to one application using SQL Server …
Puppet external facts What’s that? How to collect and manage them in a Windows environment? External facts are pieces of information that can be used by Puppet to determine the configuration of a system. External facts can be sourced from a variety of sources such as scripts, databases, or APIs. Probably, facts are one of …
WinHTTP WinHTTP (Windows HTTP Services) is a set of programming interfaces that allows developers to create HTTP-based applications on the Windows operating system. It is used to communicate with HTTP servers, such as web servers, and can be configured to use a proxy server to access the Internet. Here is a code snippet that You …
Puppet on Windows To use Puppet on a Windows machine, you will need to install the Puppet agent software on the machine. This can be done manually or by using a package manager like Chocolatey. Once the Puppet agent is installed, you will need to configure it to connect to a Puppet Master server, which …
Splunk Splunk is a software platform that is used for analyzing, monitoring, and visualizing machine-generated data. It allows users to retain data for a specified period of time, which is known as the data retention time. The data retention time is the length of time that data is stored within the Splunk platform before it …
Copy large table 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 one table to another. But what about copy of the very large table from one database to another? Arithmetic overflow error converting IDENTITY to data type int Does …