Could not register the Service Principal Name (SPN)

Recently I checked my SQL Server Error Logs. Quite some interesting information in my opinion, however I also found this message: Date  25-7-2017 18:26:41 Log  SQL Server (Archive #3 – 25-7-2017 18:34:00) Source  Server Message The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/SQL01.contoso.lan:NAV ] for the SQL Server service. Windows… Read More Could not register the Service Principal Name (SPN)

Move LDF, MDF or NDF file in SQL Server 2016 using Alter Database

In my previous post I explained how to move a certain database file with ATTACH/DETACH. There is another better option which I would like to share with you.: Let’s say you need to move the NDF file. The first thing to do is to alter the database. Specify the new path of the NDF file like… Read More Move LDF, MDF or NDF file in SQL Server 2016 using Alter Database

Move LDF, MDF or NDF file in SQL Server 2016 using Attach/Detach

As a DBA or even NAV Admin this topic is very important. In my other post (Physical Database Structure of a Dynamics NAV SQL database) I explained database files and their file extensions. Let’s say you need to move the logfile because of certain reasons like diskspace. The first thing to do is to Detach… Read More Move LDF, MDF or NDF file in SQL Server 2016 using Attach/Detach

Work smarter with SQL Server Management Studio

Do you work with the ‘Microsoft SQL Server Management Studio’ regularly. Let’s say at a weekly basis? Then please read on as I have some useful information for you which saves you time and eases your activities. When you start the ‘Microsoft SQL Server Management Studio’ you are actually excecuting ‘C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe’… Read More Work smarter with SQL Server Management Studio

An update to SQL Server Management Studio is available

Recently I’ve been getting the message ‘An update to SQL Server Management Studio is available’: This message pops up in my system tray. Ofcourse great information! However the message always comes at a time I don’t have the opportunity to update. My first question was: how to control the auto update feature? The steps: Start… Read More An update to SQL Server Management Studio is available