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 9

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 3

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

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 […]

Free Disk space on Windows drive

Starting with Windows 2012 (R2), it is no longer necessary to install the desktop experience to remove the different file versions left update after update. The following command can be used:

Options used here are: StartComponentCleanup: removes superseded and unused system files from a system ResetBase: all superseded versions […]

Architecture for the cloud vs. on-premises

The “Architecture for the cloud vs. on-premises” theme has been too often polluted by sales, marketing and guts-opinions sometimes based on IT urban legends. In this post, we’ll try to take a picture of the landscape and see how the work habits should change… or remain the same. The Netflix […]

Visual C++ Build Tools silent installation 2

With the release of Visual Studio 2017, the creation of offline distribution files in order to achieve the Visual C++ build tools silent installation has become easier than in previous versions. The key parameter is the –layout switch which allows to specify where you want to store the offline files. […]

Start Stop service rights to non administrators

LIke any other object in the Windows world, services are objects, you can therefore give users rights on them. Let’s see for example how to allow start stop service rights to non-administrators. In order to change the permissions to a service, you’ll need an account who has rights to change […]

Powershell criticism: Part 2

In a previous post, we looked at some powershell oddities when it comes to Credential use. In this “Powershell criticism: part 2”, let’s look at some language construction irritating way to express things shortly, when doing nested enumeration. As a language used by system administrators, you’ll use Powershell in two […]

Powershell criticism part 1

In a Tweet, Jeffrey Snover was asking if the community had anything to say to make Powershell better. This kind of tweet may not be very easy to answer in 280 characters, but if you take time to think about it, it interrogates the way you’re using the language. Did […]