It’s been many years since I read that SQL databases should use an NTFS volume formatted with at 64KB file allocation unit size (block size). So long that I didn’t remember why or if it is still considered best/good practice.
At a recent client engagement we discovered that Microsoft SQL Server Enterprise edition was installed on the ConfigMgr Primary Site Server. Technically this is not a problem, but it is only needed if you expect to have more than 150,000
In a new ConfigMgr 2012 R2 SP1 environment the Reporting Services point was proving a bit challenging to install. After setting all of the required permission it was finally happy. Required Permissions On the SQL Server Reporting Services server, an
< div class=”ExternalClass16EB91745BFA419384C0E3307E72D388″> With some guidance from Microsoft TechNet, Edward at StackOverflow.com, and Adam at RedThree, I managed to enhance the Compliance 5 – Computers in a Collection report by separating each computer onto its own page. When exported to