Tag Archives: Configuration

Skype for Business – SQL Server Frustrations

Scenario The environment is new and secure. Assumptions: You are a DBA who knows how to build WSFCs and AGs. If you need help with that, then you’re in the wrong place for this post. The Windows 2016 / SQL … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Setting SQL Server Maximum Memory

One of the dafter defaults in SQL Server is the Maximum Server Memory (MB) – set to a value of 2147483647. Who has a server with 2PB RAM? Give me a call if you do – I want to have … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | 2 Comments

The Perils of Downsizing Third Party Systems

The request came in to virtualise a SQL Server / SSAS / web reporting system that was provided by a third party. An initial attempt to do this was performed by p2v-ing the existing servers. Everything seemed to be fine … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | 1 Comment