Category Archives: SQL

T-SQL Tuesday #62 – Healthy SQL

 SQL Health Checks Healthy SQL is an important topic… I’ve gotten involved in a number of SQL health checks and would like to share some of the key methodology, metrics investigated and tools/utilities used. There are at least two main … Continue reading

Posted in SQL, SQL Server, SQL Server 2012, SQLTuesday | 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 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 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

Creating a Linked server from SQL 2005/2008 to SQL 2012

Resolved an interesting issue today, where a client needed to create a linked server from SQL 2005/2008 to SQL 2012. Received the infamous login failed ‘NT AUTHORITY\ANONYMOUS’ error. This typically means that the target SQL Server needs to have a … Continue reading

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

SQL 2012 and System Center 2012 R2 Guide released

  Had a chance to review this guide and give it very high marks for setting up SQL for the various System Center products. The fact he calls out formatting SQL drive partitions at 64KB is huge and often missed … Continue reading

Posted in ConfigMgr, SQL, SQL Server, System Center 2012 R2 | Leave a comment

SCCM 2012 computer information query

I was recently asked to create a query based on the following requirements: On Windows XP systems only, provide the following information for each system: 1.      Processor speed and type 2.      Memory 3.      Total disk space, free space 4.      IP … Continue reading

Posted in ConfigMgr, SQL, SSRS | 5 Comments

SQL Server file system

Quick tip… any drive that you use for SQL Server data or log files should be formatted as NTFS 64K size. SQL will give you better performance at the file level… I’m thinking of writing a post of best practices … Continue reading

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

SQL Query to Analyze OS Counts

Since I started my new job, I’ve been implementing ConfigMgr 2012 in a number of sites. This simple query has proven useful to get a reasonably accurate count of installed systems, after the initial system discovery is run. Useful to … Continue reading

Posted in ConfigMgr, SQL | Leave a comment