Steve Thompson

ConfigMgr 2012 Database Collation clarification

sthompson — Thu, 12 Jan 2012 19:19:29 GMT

As a point of clarification, database collation as stated in the current documentation http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLDBconfig...(read more)

Editing CM12 reports in the ConfigMgr console with SQL Server 2008 R2

sthompson — Tue, 20 Dec 2011 23:36:24 GMT

Presently, if you have installed ConfigMgr 2012 with SQL Server 2008 R2, and attempt to edit a report from the console, you will get an error message that...(read more)

MMS 2012 – Content Survey

sthompson — Tue, 22 Nov 2011 16:43:10 GMT

From a recent email, please take the time to respond and let this group know what you content you want to see for sessions. Anything SQL related like custom...(read more)

Generate a list of Configuration Manager reports from Reporting Server

sthompson — Mon, 21 Nov 2011 17:05:13 GMT

Have you ever needed to product a list of reports and report descriptions from Reporting Services? Use the following SQL to retrieve this information from...(read more)

ConfigMgr 2012 Release Candidate is here

sthompson — Thu, 27 Oct 2011 22:40:30 GMT

The release candidate is now here for download . Note the official name is now; System Center 2012 Configuration Manager. You can read more about it here...(read more)

What is old, then new again? ODBC

sthompson — Tue, 11 Oct 2011 22:18:05 GMT

Read the following blog entry, found this to be very fascinating. http://blogs.msdn.com/b/sqlnativeclient/archive/2011/08/29/microsoft-is-aligning-with...(read more)

2011 Microsoft MVP Award

sthompson — Sat, 01 Oct 2011 22:00:03 GMT

Received my 2011 MVP award today. It is both an honor and a privilege to be awarded MVP in ConfigMgr for another year. This is a great community and I...(read more)

How to display Weekday in an SSRS report

sthompson — Fri, 29 Jul 2011 17:30:42 GMT

Recently, I needed to display the weekday in a column heading. It turns out is was a little more complicated than specifying a function to extract...(read more)

SQL Query - Show Server Up time in ConfigMgr

sthompson — Thu, 21 Jul 2011 21:34:40 GMT

Here is a fairly common request, show me the uptime for for servers. This is handy to determine whether or not a server or servers has rebooted since...(read more)

Microsoft Assessment and Planning Toolkit 6.0 Released!

sthompson — Thu, 21 Jul 2011 18:25:37 GMT

Overview The Microsoft Assessment and Planning Toolkit (MAP) is an agentless, automated, multi-product planning and assessment tool for quicker and easier...(read more)

SQL Server 2008 R2 Service Pack 1 Released

sthompson — Wed, 13 Jul 2011 20:38:34 GMT

Note: This release is not yet officially supported for ConfigMgr 2007, once the product team completes their compatibility testing they will announce support...(read more)

SQL Server memory and performance tuning for ConfigMgr

sthompson — Tue, 12 Jul 2011 18:59:24 GMT

A few years ago I wrote a blog on tuning SQL Server memory to work with ConfigMgr and SQL Server. How do I tune SQL Server memory for optimal performance...(read more)

Using Custom code in Report Builder

sthompson — Mon, 11 Jul 2011 22:26:58 GMT

As mentioned in an earlier post , it is possible to add custom code to Report Builder and BIDS (Business Intelligence Developer Studio). There are...(read more)

Cumulative Update package 7 for SQL Server 2008 R2

sthompson — Fri, 08 Jul 2011 15:44:22 GMT

In case you missed it, Cumulative Update package 7 for SQL Server 2008 R2 was released on June 16, 2011. We ran into a few SSRS 2008 R2 performance issues...(read more)

SSRS 2005 to 2008 migration issue

sthompson — Thu, 30 Jun 2011 18:23:23 GMT

Just found an issue with an SSRS project migration from SQL Server 2005 to SQL Server 2008 R2. First the report, newly converted to SSRS 2008 failed...(read more)