Tips & Tricks
Changing the DPI Resolution with Snagit
I am in the process of finishing up a book on ConfigMgr and SSRS report writing, and my publisher requires all screenshots to be 300 DPI. For those to what to see the book it has been release already System Center Configuration Manager Reporting Unleashed. This book...
Cleaning-up My Hard Drive
Back in October I tweeted that my hard drive was down to 89.9 MB free!! In this blog post I’ll tell you how I cleaned it up. Here’s a bit of background. I wanted to test Windows 10, so I did everything possible to clean-up my hard drive. I removed my offline files, I...
Importance of Page Sizing in SSRS Report When Designing
I review a lot of SQL Server Reporting Services (SSRS) reports and one of the most common problems I encounter is Page Sizing in SSRS Report. What does this mean? Well in short it means when when a report is export or save, it will become all chopped up. To solve this...
Decommissioning a Domain Controller Using Windows Server 2012
In my last post, I performed an FRS to DFSR migration in order to fix up some AD and GPO issues. Soon after that migration, one of the Domain Controllers (DCs) needed to be patched up. I installed all of the updates that were required, but as it turned out, there were...
Enabling the Ruler within BIDS or SSDT
The ruler feature within SQL Server Data Tools (SSDT) and SQL Server Business Intelligence Development Studio (BIDS) (post SQL 2005) being disable by default is one of my pet peeves! Whenever I use BIDS or SSDT I have to enable the ruler and I find this very...
Query to Find the Number of Operating Systems by PC Type
In the TechNet forum, I was asked about how to query for the Number of Operating Systems (OS) by virtual machine and by computer type (desktop, laptop, or server). I thought this information might be useful for everyone, so I’m sharing my query. The results will be...
What does the acronym you use, say about you?
Lawful Good Neutral Good Chaotic Good MEMCM ConfigMan or CfgMan or CfgMgr SMS Lawful Neutral True Neutral Chaotic Neutral MCM ConfigMgr CM Lawful Evil Neutral Evil Chaotic Evil MECM SCCM SCCMCB What does the acronym you use, say about you? The other day I posted a...
What does the acronym you use, say about you?
Lawful Good Neutral Good Chaotic Good MEMCM ConfigMan or CfgMan or CfgMgr SMS Lawful Neutral True Neutral Chaotic Neutral MCM ConfigMgr CM Lawful Evil Neutral Evil Chaotic Evil MECM SCCM SCCMCB What does the acronym you use, say about you? The other day I posted a...
Remote Error in PBRS Demystified: Everything You Need to Know to Get Started
When you work a lot on reports in either Power BI Report Server (PBRS), at some point you are bound to get errors that basically say: go to the server to see the real error OR enable remote errors. It’s not a big deal to go to the host server and run the report in...
How to Create Cascading Prompts
Prompts are extremely useful because with a prompt you can limit what is displayed within a report. You can get even more granular results when you add a second or a third prompt. Adding additional prompts, however, can lead to some minor inconveniences and unintended...