Skip to main content

What are you doing here?

Hi guys,

if anyone really finds this address it might happen only by an acident. But I assume not by purpose.

I will not try to advertise this blog or do anything else.

This is more a droplocation for information I collected during my daily work as an IT Admin for a bigger company.

I mainly work in a VMWare environment with Windows Servers. So these might be the main topics you find in here.

Anyhow. If you really find something usefull just tell me.

CU maybe in future.

Cheers
Flying C
Labels:

Comments

Post a Comment

Popular posts from this blog

Install Windows Feature with Powershell

I have sometimes situations where I need to rollout a similar setup of Windows Features from a live system to a development system. Therefore the Powershell cmdlt Install-WindowsFeature is very useable. Also in our case the sxs folder is needed. Here my example how we use it: Install-WindowsFeature -ConfigurationFilePath C:\temp\DeploymentConfigTemplate.xml -Source C:\PSEMEAIT\sxs\
Post a Comment
Read more

Change SQL Server 2016 default collation after installation

I have had to change the default collation and the collation of SQL Server 2016 and did not want to re-install. It was a fresh setup but the backup and maintenance stuff was already setup. So I searched for a way to change the collation of SQL Server and the System DBs on an easy way. And luckily I found this blog entry from  Giampaolo TUCCI ( https://www.informaticapressapochista.com/windows/sql-server-2016-change-sql-server-collation-installation/ ). As described there it was in general very easy. ❗ My Server was a fresh install. In other cases do a good Backup in advance before you continue ❗ A downtime is needed as you need to stop SQL Services. So this is the approach: Stop all SQL Services start a cmd and go to the SQL Server BINN directory. Default should be C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn> run the following command: sqlservr -m -T4022 -T3659 -q"SQL_Latin1_General_CP1_CI_AS" After q set the collation you want to...
Post a Comment
Read more