Tag: SQL

SCCM – Shrink the SQL Server Reporting Services log and change the maxsize

The default maxsize value of the ReportServer logfile (ReportServer_log.ldf) is 2 TB. If you haven’t changed that value and your disk size is lower then 2 TB (which is very common) you will eventually fill up that entire disk space. When that happens you need to shrink the logfile before you are able to reduce…



SCCM – Application installation summary report

This post will describe how to create an application installation summary report in SCCM. This is a great tool to have when you’re for example doing a health check of your applications and different versions of them. The report is built in Microsoft SQL Server Report Builder and you can see the final result on…



OS deployment using same MAC address for multiple clients

OS deployment using the same staging dock for multiple clients is a bit of an issue, and there are many different solutions to the problem but all have their downsides. I did a quick search and found two probable candidates to tackle. UUID staging The idea is to exclude staging docks using a registry value…



Microsoft SQL Server AlwaysOn Failover Cluster Instances

Det är nästan alltid rekommenderat och en mycket god idé att placera sina databaser på en Microsoft SQL Server som i någon form är högt tillgänglig. Det är tyvärr ganska vanligt att till exempel databaser för Citrix XenApp, XenDesktop och Microsoft Remote Desktop Services hamnar på en SQL Express eller annan SQL Server som inte…