Tips & Tricks
Error: 40 – Could Not Open a Connection to SQL Server
I’m working on a project to create a SQL Server reporting database; basically it’s a clone of the ConfigMgr database for querying and reporting only. This server will act as a secondary database server where all reporting can be offloaded here and not affect the main...
How to Install SQL Server Integration Services Tools
I’m working on a project to clone a SQL Server database (aka the ConfigMgr database) because a customer wants all querying and reporting off-loaded from the main ConfigMgr database server. Instead of using SQL Server Replication we’re going to use SQL Server...
How to Recover a CAS using a Primary Site Server
There’s a long story about why I had to recover my Central Administration Site (CAS), but I’ll save you the trouble of hearing about it! The short story involves me helping a customer setup the SQL Server replication of their CAS database. I helped them with this...
How to Compact and Shrink the Size of a VHD File
In a recent blog post, How to Expand a Disk within a VM That Is Using a VHD File, I showed you how to expand a VHDX file in logical disk size. I did this because I had a problem with the auto-growth of my SQL Server logs. Now that this problem is fixed, I want to...
Why Can’t I Access My SSRS Site Remotely?
While I was troubleshooting a Software Updates (SU) issue (there’s a long story here that I will skip!) I ran into an access issue with my SQL Server Reporting Services’ (SSRS) site. I wondered, "Why can't I access my SSRS site remotely?". This blog post will talk...
How to Define the Size of a SQL Server Database
In a couple of recent blog posts I talked about two ways to prevent the SQL Server database from running out of disk space because of transaction logs, and what I did when I discovered that my SQL Server Reporting Services (SSRS) database was using a ridiculous amount...
What is a 4-part version numbers?
The problem of querying 4-part version numbers has long been a problem. I have seen many solutions, but none are 100% fool proof, until now. But what is a 4-part version numbers? This article will go into details to explain 4-part version numbers and how SQL Server...
What is a 4-part version numbers?
The problem of querying 4-part version numbers has long been a problem. I have seen many solutions, but none are 100% fool proof, until now. But what is a 4-part version numbers? This article will go into details to explain 4-part version numbers and how SQL Server...
How to Enable BitLocker Recovery Information to Active Directory
While working on another blog on troubleshooting BitLocker, How to Manually Backup BitLocker Recovery Key to AD (coming out next week). I found out that I have not enabled these steps within my own LAB AD. For completeness, I thought that I would document how to store...
Why are my SSRS Chart Sorting Z-A?
As I write this blog, I’m working on a chart that has labels on it. I almost never add chart labels, instead I used an attached table with matching colors to show which values matches which line within the chart. But for this chart, it made sense to add labels to it....