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»

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»

How to list SSRS Report permissions

  Have you ever needed to know which groups or users have access to your reports? Use the following query to get a comprehensive list of who has access to what. USE ReportServer GO select u.UserName, r.RoleName, r.Description, c.Path, c.Name from dbo.PolicyUserRole pur inner join dbo.Users u on pur.UserID = u.UserID inner join dbo.Roles r […]

Read More»

SCCM 2012 R2 – Who dun it?! What have your admins been doing?

Players, A client of mine started slowly but surely getting more and more of his staff to start using SCCM 2012 R2. I created some custom RBA for his team, but as soon as I left … it seemed that some of the guys got lazy and just started adding people into the administrators group … So some admins had access over stuff in SCCM that they really should be allowed to touch … Long story short … some collections were deleted (by accident) and we needed to understand why and by whom. The guy wasnt in trouble, we just needed to identify who the admin was, so we can train them on how to manage collections correctly. Now there are many ways of doing this … My client wanted the “easiest way possible” to see “who dun it” in SCCM. So, there are actually some inbuilt reports in SCCM that…

Read the complete blog: http://thedesktopteam.com/blog/heinrich/sccm-2012-r2-who-dun-it-what-have-your-admins-been-doing/

Read More»

SCCM 2012 R2 SQL Query Issues

Players, A client of mine had a issue with a custom SCCM query we created to find malicious software, he wanted to edit it, something went wrong and the console crashed. So we wanted to delete it and start again as we had the query backed up anyway. When we tried to delete it, we got a random error message and it simply wouldn’t move. So we ripped it out of SQL, here’s how we did it. Connect to your SCCM Database (CM_Sitecode), 1. Expand tables2. then right click “dbo.queries” and edit the to 200 rows3. Selected “Custom Query NAME”  then right click and then delete it. You’re also able to edit the query should you need to for SQL it self. Enjoy

Read the complete blog: http://thedesktopteam.com/blog/heinrich/sccm-2012-r2-sql-query-issues/

Read More»

ConfigMgr 2012: SQL Maintenance Plans and Index Optimization Recommendations

Posted in CM2012ConfigMgrSCCMSQL

Recently caught some emails going around about recommended backup and maintenance plans as it relates to ConfigMgr. Also plenty of discussions around whether or not addition index optimization is required beyond the built-in Rebuild Indexes task that can be configured as part of the built-in Site Maintenance task.  As far as what I recommend and […]

Read More»

SQL Server 2012 SP2 released

  Download here: http://www.microsoft.com/en-us/download/details.aspx?id=43340  List of bugs that are fixed: http://support.microsoft.com/kb/2958429Filed under: SQL, SQL Server, SQL Server 2012

Read More»

Where to Find User Name Data in Configuration Manager, Part 2

By Garth Jones In my last blog post, I talked about how there are three places to find user name details and how they are inventoried. In this blog post I will talk about how best to leverage each of them. Here’s a quick refresher of where to find the user name data by using the following three queries: v_GS_COMPUTER_SYSTEM...

Read More»