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 […]
The use of Install-Module and Update-Module has become a routine task for many Powershell administrators these days. Lately if you applied those commands, you may have received warnings and errors even from well-known sources. Messages include: If you look at the resource or the web site, the package stills exists […]
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
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 […]
When using self-signed certificates, and accessing your web contents with the Firefox browser, you may get a strange error message SEC_ERROR_INADEQUATE_KEY_USAGE This may happen in self hosted instances of YunoHost for example. Whereas the contents is properly displayed in all other browsers, you cannot add any exception in Firefox and […]
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 […]
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 […]
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 […]
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 […]
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 […]
