Blogs

Site Root

Site Root
A description has not yet been added to this group.
Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: SQL Query: How to convert a byte value to any other byte-based value

    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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Lab - System Center 2012 Configuration Manager - CAS - Do I need one

    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
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: SQL Server Guide for System Center 2012

    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...
  • Blog Post: ConfigMgr Backups–The new way of doing things

    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...