End of the World as We Know It!

By Garth Jones In an October blog post, I talked about getting rid of my last Windows Server 2003. Within that blog post I also talked about my friend @pierreroman who gave a presentation at TechEd North America 2014 called, “DCIM-B367 It’s the End of the World As You Know It… Windows Server 2003 End of Life: Infrastructure Migration.” You...

Read More»

Remember to Vote for January’s Free SSRS Report

The report choices in this month’s poll are: Computer Software Update Details by Classification OR Count of Keyboard Layouts. Make sure to VOTE HERE for your favorite report! a) The Computer Software Update Details by Classification report will show you an overall count of the number of software updates by classification for a particular PC. Using three different report parameters,...

Read More»

Collection Metric Dashboard is December’s Free SSRS Report

Make sure to get your copy of this month’s free SSRS report by emailing Info AT Enhansoft today! Remember Collection Metric Dashboard is only free in December. The Collection Metric Dashboard report will show you the action taken (Create, Edit, Delete) by the System Center Configuration Management (CM) team in managing the lifecycle of packages over a series of months....

Read More»

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 fragmentation and impact performance. Better settings for Autogrowth are a minimum growth size of 512MB […]

Read More»

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) MMS Minnesota 2014 (Minneapolis) http://mms.mnscug.org/ Have created a number of blog entries focused on SQL […]

Read More»

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 a real life example. For monitoring, here are a few options: – System Operations Manager […]

Read More»

Help Choose Enhansoft’s Next Free SQL Server Reporting Services (SSRS) Report for the Month of January

The report choices in December’s poll are: Computer Software Update Details by Classification OR Count of Keyboard Layouts. VOTE HERE! a) The Computer Software Update Details by Classification report will show you an overall count of the number of software updates by classification for a particular PC. Using three different report parameters, you can select the PC name, the software...

Read More»

December’s Free SQL Server Reporting Services (SSRS) Report is Collection Metric Dashboard

Thank you to everyone who voted in November’s poll! With 77% of the vote Collection Metric Dashboard becomes December’s free SSRS report. Email Info AT Enhansoft for your copy today! This report is only free in December. The Collection Metric Dashboard report will show you the action taken (Create, Edit, Delete) by the System Center Configuration Management (CM) team in...

Read More»

Configuring SQL Server memory for ConfigMgr 2012

A common SQL Server configuration error is allowing SQL Server to use all available memory. Te default “Maximum server memory (in MB)” setting (highlighted) allows SQL Server use ALL available memory. For the most part, SQL does a good job of managing the available memory, however, best practice is setting a maximum available memory. For […]

Read More»

Last Chance to Vote for December’s Free SSRS Report

At the moment Collection Metric Dashboard is ahead with 78% of the vote, but if you would like to see List of PCs by Office Edition Type (Office 2003) become December’s free report, then make sure to vote today, and ask your friends and family to vote too! VOTE HERE!  The following is a short summary about each of the...

Read More»