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»

Update SQL Always On Cluster with ConfigMgr and Powershell

How to update a cluster with a cluster-ignorant tool I’ve recently been tasked to create a process to patch SQL Always On Availability Groups (I guess calling it a cluster is not really accurate?!) with just the tools I had available, no new implementation of stuff. This meant to do a proper patching cycle (Operating System AND SQL) with graceful failovers of SQL roles from one node to the other, no data loss. So, quick inventory; what did I have? ConfigMgr 2012 R2 PowerShell Phew, PowerShell, you can do a lot with PowerShell. ConfigMgr, mhhh, ConfigMgr can do Software Updates and execute stuff on machines when it is told to … Continue reading

Read More»

Deploy a Required Task Sequence to All Systems and Keep Your Job!

One of the shortcomings of ConfigMgr is how easy it is to reimage your environment. With one wrong click, you could find yourself updating your resume on a personal computer because all the work ones are reimaging… For my MMS session with Trevor Sullivan on Powershell events, I wrote a script to save yourself from deploying task sequences to the...

Read More»

DCR – A quick glimpse of how many Updates are in multiple Software Update Groups

Have you ever needed to quickly see how many ConfigMgr Software Updates are in a large number of Software Update Groups? You can use PowerShell easily enough, but you are in the ConfigMgr console every day, shouldn’t this information be available in the console? If you want to see it, please vote up this DCR request on Connect. DCR –...

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»

SCCM 2012 R2 – Driver Packages (Specific driver packages to specific devices)

Players, When it comes to driver packages and deploying Windows to multiple hardware variants using the same task sequence, every man and his dog has a way of doing it. Some of us like to be precise and other don’t mind how this is configured as long as all the drivers are on the DP and they get onto machines one way or another … So, lets pretend that we want to be a little more specific with drivers and we don’t like “Auto Deploy” as we have taken the time to create individual driver packages for each hardware variant. Here is some guidance on how to deploy specific driver packages to specific devices via the task sequence. 1. We need to know what the model name is for the specific machine/s first. So open command prompt (or PowerShell if you want to look cool) and type WMIC Computersystem GET Model you should get…

Read the complete blog: http://thedesktopteam.com/blog/heinrich/sccm-2012-r2-driver-packages-specific-driver-packages-to-specific-devices/

Read More»

My Sessions at the Midwest Management Summit

I am really honored to have been a speaker at the first ever Midwest Management Summit (aka the new MMS), that took place November 10th – 12th in Minnesota.  This event was the who’s who of systems management and did not disappoint.  There were over 100 sessions delivered in three days by 50+ experts (which included 32 Microsoft […]

Read More»

New Intune Capabilities

  Awesome new Intune capabilities. The new Intune standalone features include: Enhanced user interface for Intune administration console Ability to restrict access to Exchange on-premises email based upon device enrollment Bulk enrollment of devices using a single service account Lockdown of Supervised iOS devices and devices using Samsung KNOX with Kiosk mode Targeting of policies […]

Read More»