SQL Server Migration from 2008 R2 to 2016

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 ...
Read More

Automatic Memory Management for SQL Server Failover Cluster Instances

One of the challenges while using Failover Cluster Instances (FCI) is to manage the memory of the SQL server in case of failover. In general, most SQL Server configurations do not require much attention to memory management beyond the initial configuration. However, Failover Cluster Instances (FCI) architecture is very different from others. ...
Read More

Copy large table from one database to another in SQL Server

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 this error message sound familiar to You? I bet the answer is ...
Read More