Products

All products


Storing sp_configure settings in a stored procedure   Recently updated !

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

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

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

Get-Certificate usage for Web Server

The documentation for the powershell cmdlet Get-Certificate only use generic examples. In this post, let’s see the Get-Certificate usage for Web Server. In our scenario, you have an Enterprise CA whose service is published under the name ‘My Company SubCA I’. You also have duplicated the Web Server template under […]