Tag Archives: Configuration

SQL Server Configuration on Windows Server Core Edition

You can’t run SQL Server Configuration Manager on a Windows Core server – no UI. You can’t run SQL Server Configuration Manager on another server and direct it to point to your server running Windows Core. But what you can … Continue reading

Posted in Uncategorized | Tagged , | 2 Comments

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