Today I noticed on two of my SCCM 2012 infrastructures that the ReportServer_log.ldf file was extremely large (>100GB). This is quite concerning considering that the actual database is less than 256MB. I have not yet investigated the root cause yet,
SQL Reports Subscription Ownership
We have a number SCCM Reporting Services subscriptions for our automated reporting. Yesterday I had a former team member’s ID removed from SCCM access and today most of the automated reports did not run. When a report subscription is created
SQL 2012, BIDS, and SSDT
With SQL Server 2012 Business Intelligence Development Studio is replaced with SQL Server Data Tools. BIDS = Business Intelligence Development Studio SSDT = SQL Server Data Tools (http://msdn.com/data/tools.aspx) If you customize SQL Reporting Services reports for SCCM 2007 or ConfigMgr