SQL Server

Oops…I Broke the SQL Server

Simon Kingaby SQL Server, Sys Admin , , , ,

So this happened.  In an attempt to give my SQL Server Instance access to more memory, I set the Max Memory to zero, expecting that to mean infinite.  No luck, SQL Server Management Studio (SSMS) set the max memory to 16MB instead and broke the instance.  I could not do anything more in SSMS because … Continue reading Oops…I Broke the SQL Server

SQL Server 2014 Installation

Simon Kingaby SQL Server , , ,

Last week I upgraded our Development box to SQL Server 2014.  Since this was a clean Dev box I had the choice of upgrading from SQL Server 2012 or doing a remove-install.  I figured that rather than leave all the detritus of the prior installs and versions of Data Tools, I would do a remove-install. … Continue reading SQL Server 2014 Installation