I recently had the pleasure of installing Microsoft SQL Server on Linux – Ubuntu Server. This was a very straight-forward installed and just works. The following steps are what were taken to install and configure this server. My Setup: Ubuntu 17.10 Server – VMware Template Network Connectivity SQL Server Management Studio 17 – Testing connectivity […]
Tag: SQL Server
The following will give you information about an Microsoft SQL Server instance which you may find helpful in determining the version, edition and number of cpu’s assigned to a SQL server. In my case I am using Microsoft SQL Server 2014 Express but this will work on all versions of Microsoft SQL Server SELECT […]
This weekend I am working on a SharePoint 2010 to 2013 upgrade. One of the steps; the beginning steps I will do is set the databases I am upgrading into read only mode to prevent users or automated process from upgrading the database during the upgrade window. Now I could have taken the system offline […]
First Open SQL Server Management Studio (SSMS). You may need to run as Administrator Right click the Databases folder and select attach from the menu. Click Add and select the mdf file. Click Ok, and then Click Ok again. You will get an error at this time because SSMS could not find the corresponding ldf […]
One of my customers had an issue where they failed to open a connection to a particular database they had been testing. The error read: ‘the database e:somepathsomefolderjermsmit.mdf’ cannot be opened because it is version 611. The server supports version 655 and earlier. A downgrade path is not supported. This issue is caused because you […]
“It’s so logical and so simple. Fat is the backup fuel system. The role it plays in the body is that when there’s no carbohydrate around, fat will become the primary energy fuel. That’s pretty well known.” – Robert Atkins Recently I have been working with my dB Administrator to get some DR backups to our […]