The Windows Management User Group
The original UK User Group
Established March 2006
A description has not yet been added to this group.
Get this RSS feed
System Center 2012
Tagged Content List
My scripts no longer work after upgrading to SQL 2005
A (long) while ago I wrote some scripts for one of the sites I support, due to various security and bandwidth issue they had I found it easier to use SQL scripts to run certain tasks, the scripts used the xp_cmdshell procedure. xp_cmdshell spawns a windows command shell and passes in a string for...
Mon, Feb 11 2008
Receive an SQL Server 2008 license and reassurance with your exam
FREE Software when you train with Global Knowledge .... Get the expert training you need, to get the most from Microsoft® SQL Server® 2008-and the software-FREE when you enroll and attend select courses. With this expert training, you'll learn to take advantage of the powerful and trustworthy array...
Thu, Jan 29 2009
SQL Query: How to convert a byte value to any other byte-based value
Robert Marshall - MVP
John Nelson (MVP ConfigMgr) has turned out a really cool SQL query, which converts a byte value in to a given unit of measure such as MB or GB. This is useful if you want to express a byte value in GB form for example. If you write SQL queries for your ConfigMgr reports, this is one useful function...
Wed, Jul 8 2009
Identifying, Troubleshooting & Resolving 2300 and 2301 ConfigMgr Distribution Manager status messages with KB978021
Your ConfigMgr sites start to populate with hundreds and thousands of status messages, namely 2300s and 2301s. Hold your horses and do not panic though as Microsoft has addresed this issue with the availability of a patch KB978021 of which more details and the download can be found here . This hotfix...
Mon, Oct 4 2010
Maximum Characters for an Advertisement Name
[Informational] I recently noticed something interesting with the SCCM console and the Database, so I have decided to post it here for everyone's information. Note that this usually does not happen often in most SCCM environments but worth noting nonetheless! So here goes, apparently there is...
Mon, Nov 15 2010
Interactive command prompt under the system context and Server 2008
I had a rather anxious phone call from a DBA friend today He had a production SQL 2008 server running in Window Authentication mode, someone had removed the main admin login. He was getting quite upset as he could not see any possible way to add it back in again, this account was the only account...
Mon, Feb 7 2011
Lab - System Center 2012 Configuration Manager - CAS - Do I need one
Robert Marshall - MVP
Following on from my previous article on System Center 2012 Configuration Manager where I talked about setting up a good test last, we can now move on to whether we need a CAS for the company Configuration Manager is being installed into. You can read this and more fantastic articles from Rob here
Sun, May 20 2012
SQL Installation..OMG..I'm bored..
Hi All, As the title says...I'm installing SQL Server 2008 R2 SP1 CU6 (of course, install SQL 2008 R2, after update to SP1 and later SP1 CU6)...and I'm bored...(and of course...I'm posting it :)) and hopefully, when the installation is done i won't be like this guy: and, PLEASE...
Wed, Jun 6 2012
SMS 2003 - Disk space issue
Hi All, today when I was doing the SCCM/SMS health check, i noticed one of the low level primary sites servers had not send any information to the parent and the communication was "dead" for a few hours when I connected to the server to validate it, i discovered that it had a disk space issue...
Tue, Sep 18 2012
SCCM 2012 - Server Sizing
Hi All, in a previous version of Configuration manager, there was a server sizing, but unfortunately, there is none for the 2012 version... but this is about to change (at least, a bit)... i created a spreadsheet to add the server sizing... i'm using this basically to calculate the sql server database...
Tue, Nov 20 2012
SQL Server Guide for System Center 2012
David Allen MVP
My good friend and colleague Paul Keely just posted a SQL Server guide for System Center 2012 on the TechNet Gallery. Here’s the description of what document covers: “This is a guide to help you make design decisions and maintenance plans for SQL Server 2008 R2 to support System Center 2012. In the guide...
Wed, Jan 23 2013
ConfigMgr Backups–The new way of doing things
Robert Marshall - MVP
Steve Thompson MVP in ECM (ConfigMgr) just wrote up an excellent blog post on how to handle backups in ConfigMgr 2012. We really do advice that you stop using the ConfigMgr built-in Maintenance Task for backing up and switch over to SQL backups. Steve runs us through how to setup a SQL Maintenance Task...
Fri, Jun 7 2013