Blog / Topic

SQL & Reporting

SQL Server and Reporting Services for systems management.

23 posts

• SQL
• SQL 2008 R2
• SQL 2014
• SRS

20152

• 10-15Hotfix: SQL Server Management Studio and Server Manager crashing
• 01-09ConfigMgr 2012: Quick Model Count in SQL

20143

• 12-09System Center 2012 Configuration Manager: New site install with SQL 2014 = Not Supported
• 07-23ConfigMgr 2012: SQL Maintenance Plans and Index Optimization Recommendations
• 03-05SQL Server: Cannot Connect to WMI Provider

20132

• 12-04ConfigMgr 2012 : Unable to Import Drivers After Moving SQL Files
• 06-07SQL Server Backup Recommendations for Configuration Manager

20123

• 04-26ConfigMgr 2012 Database Requirements
• 03-25List of Computers from an Active Directory User Security Group
• 02-02System Center 2012 Configuration Manager Database Requirements - 4/26/2012

20115

• 12-21Editing CM12 reports in the ConfigMgr console with SQL Server 2008 R2
• 08-19ConfigMgr-Update Driver Source Paths SQL Query
• 05-19Beginners Guide to Writing SCCM Reports
• 02-22Configuration Manager–Configuring SQL Reporting Services (SRS)
• 02-22Configuration Manager-Reporting Services Access Denied When Running R3 Power Management Reports

20104

• 10-08SQL Query To Show Program Flags
• 09-16ConfigMgr–Prerequisite Checker-SQL Server Sysadmin Rights Bug
• 07-02ConfigMgr SP1/SP2 Now Supports SQL 2008 R2
• 06-09Free Microsoft Books For Download

20094

• 08-26SQL query to identify missing SMS/ConfigMgr boundaries
• 08-18Finding the OU of a system in SMS/ConfigMgr
• 04-22Creating a Collection Query based upon Hardware Inventory
• 04-22Creating a Collection Query From SQL