Tag Archives: Configuration

SQL Server Configuration on Windows Server Core Edition

Posted on October 13, 2019 by thomasrushton

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 , | 5 Comments

Skype for Business – SQL Server Frustrations

Posted on August 1, 2017 by thomasrushton

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

Posted on January 14, 2017 by thomasrushton

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

Posted on November 2, 2011 by thomasrushton

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