Category Archives: SQL Server 2012

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 | 4 Comments

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

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

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 … Continue reading

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

SQL Server NTFS Cluster Size

If you are using Windows Server drives dedicated for SQL Server database files, did you know that the NTFS cluster size should be 64KB? The reason that SQL Server prefers 64KB NTFS cluster size, this happens to correspond to the … Continue reading

Posted in SQL Server, SQL Server 2012 | 4 Comments

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/2958429

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