Who’s making your log file grow in SQL Server?

Determining what T-SQL query or SQL Server client application is the source of log file growth is an often asked question. “Old” SQL DBAs would sometimes refer you to KB 317375 which unfortunately is no longer hosted as a Microsoft KB Article, but sadly infinitely loops on one new Docs […]

Repository Adventures In SQL Server

Windows updates history list

Here are the links to the KB articles listing the security and monthly updates for every Windows Server OS: Windows Server 2008 Windows Server 2008 R2 Windows Server 2012 Windows Server 2012 R2 Windows Server 2016 Windows Server 2019

Installing the WebDav client on Windows Server 2016

As many remote storage solutions now provide a WebDav access (from Sharepoint to Nextcloud), having the ability to natively upload and download files from a WebDav Server on Windows Server 2016 may be useful. As opposed to the previous versions, you do not need to install the Desktop Experience feature […]

Microservices architecture best and worst practices

Regularly, the IT world discovers the alpha and omega patterns that should solve all the software or hardware problems. Recently, Microservices has been a trend and of course it is time to list the microservices architecture best and worst practices. In a youtube video “Avoiding Microservice megadisasters”, Jimmy Bogard outlines […]

Storing sp_configure settings in a stored procedure

All SQL Server DBAS are familiar with sp_configure to change the instance global settings. However when you need to modify temporarily those settings from within your code, such as storing sp_configure settings in a stored procedure, the process can become awkward You need to store the configuration setting you change […]

instmdb sql file excerpt

visual studio community 2017 web page screenshot

Trial period reset of Visual Studio Community Edition 15

Although Visual Studio Community Edition is supposed to be free, you are required after 30 days by the graphical interface to have an account on Microsoft’s online services to continue to use the product. The trial period reset of Visual Studio Community Edition can however be easily achieved by editing […]

‘MEDIALAYOUT’ in SQL Server ConfigurationFile.Ini 5

While trying to install new instance of SQL Server using command line and the ConfigurationFile.ini unattended answer file, you may receive the following error message : MEDIALAYOUT in SQL Server ConfigurationFile.Ini Don’t waste your time searching in different documentations about the allowed keywords for the configuration file. This error means […]

SQL Server Logo

SQL Server Logo

Your SQL Server installation is either corrupt or has been tampered with 2

When receiving this error message: ” Error : Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall then re-run setup to correct this problem, it is likely you are trying to start SQL Server as a regular binary or as […]