Monthly Archives: December 2014

Blog 2014 Year In review

Thank you for the support and comments through the year! > The WordPress.com stats helper monkeys prepared a 2014 annual report for this blog. The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about … Continue reading

Posted in Uncategorized | Leave a comment

Installing a Service pack for SQL Server cluster

Recently, I installed an SQL Server service pack and a CU update for a client. Here are my notes. SQL Server 2012 was presently running the RTM build. The plan is an upgrade to SQL Server 2012 SP2, then SQL … Continue reading

Posted in SQL Server, SQL Server 2012 | 2 Comments

Why you should not use remote SQL Server with ConfigMgr 2012

  As a senior consultant, long time administrator of SMS/ConfigMgr and former SQL Server MVP, I have some strong opinions on this subject. These opinions are based on years of actually designing, implementing and using the product. And, observing when … Continue reading

Posted in ConfigMgr, SQL, SQL Server, SQL Server 2012 | 3 Comments

Microsoft Senior Systems Engineer Needed – Dallas, TX

Microsoft Senior Systems Engineer Needed Softchoice – Dallas, TX Anyone with System Center skills in the Dallas, TX area looking for work? Softchoice has a great opportunity: https://www.linkedin.com/jobs2/view/13441840 Contact me for more information: steve (dot) thompson (at) softchoice (dot) com

Posted in Softchoice, Uncategorized | Leave a comment

Why default database Autogrowth settings are bad

File Autogrowth – Never, never use the default database Autogrowth settings. As in the next screen shot, the tempdb default for the primary file is 1MB and the Log is 10%. Allowing these default settings will lead to excessive file … Continue reading

Posted in ConfigMgr, SQL, SQL Server, SQL Server 2012 | 3 Comments

T-SQL Tuesday giving back to the community

  Read an interesting post here: http://www.sqlservercentral.com/blogs/discussionofsqlserver/2014/12/02/t-sql-tuesday-61-giving-back/ and thought, why not? 🙂   Allow me to reflect a little; in 2014, I’ve had the opportunity to present SQL Server related content at: TechEd 2014 (Houston) IT/Dev Connections 2014 (Las Vegas) … Continue reading

Posted in ConfigMgr, MVP, SQL Server, System Center 2012 R2 | 1 Comment

What is PSR?

Not sure if I’m the only one that had not heard of this tool. PSR is the Problem Steps Recorder, included with Windows 7 & Windows 8.  This will be really useful for recording interactive sessions, particularly for documentation From … Continue reading

Posted in Uncategorized | 2 Comments

How to monitor Windows Server memory usage

In the last blog entry: Configuring SQL Server memory for ConfigMgr 2012 I’ve covered how to configure SQL Server to not monopolize Server memory. Thought it would be useful to further define how to monitor the memory usage and provide … Continue reading

Posted in SQL Server, SQL Server 2012 | Leave a comment

Configuring SQL Server memory for ConfigMgr 2012

A common SQL Server configuration error is allowing SQL Server to use all available memory. The default “Maximum server memory (in MB)” setting (highlighted) allows SQL Server use ALL available memory. For the most part, SQL does a good job … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2012 | 1 Comment