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.
Downgrading SQL from Enterprise Edition to Standard for ConfigMgr
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
ConfigMgr Reporting Services Point with complex SQL
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
SQL Reporting with custom pagination and Excel named worksheets
< 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