Tips & Tricks
Does SQL Server Database Compatibility Level Matter?
Not long ago, I was dealing with a performance problem involving a very simple SQL Server query. To give you an idea about what I mean, this query took over six hours to complete! This didn’t make any sense to me especially when its “twin” query took only 25-seconds...
Why is Using a SQL Server Alias for Column Names Important?
Here’s the error message that I kept getting, “Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.” Within the detailed part of the error message it said, “An item with the same key has...
What Are the Four-Part Names of a SQL Server Object?
The purpose of this blog post is to help you identify the four possible parts of a SQL Server object. System Center Configuration Manager (SCCM) reports are created by querying the SCCM database. Most often SQL Server Reporting Services (SSRS) is used to display SCCM...
Installing W3 Total Cache and Amazon CloudFront on WordPress
By now you have read in my blog post set about why HTTPS and Content Delivery Network (CDN) are important for websites. I’ve also discussed the importance of cookie free domains and showed you how I tested the performance of my website, how to order an SSL...
Signing-Up for Amazon CloudFront
By now you know that my plan was to setup Content Delivery Network (CDN) to use the Microsoft Azure CDN service. Unfortunately over a four-month period I could never get Microsoft Azure and CDN to work together, so I turned to Amazon CloudFront.Long story short, in...
How to Order Your SSL Certificate
In my on-going blog post set on HTTPS and CDN and how to increase security and website performance, this is the first post that requires you to do some work! I’m going to show you how to order your SSL Certificate. It might seem odd that I’m asking you to get your SSL...
v_GS_NETWORK_ADAPTER_CONFIGURATION verse v_Network_DATA_Serialized
While working on my article What is Parsename and 4 Part Version String?, I was looking at my IP address of many of my system and notice that they have both IP v4 and IP v6 address. This is NOT generally a problem as I almost never include IP address in a report, but...
v_GS_NETWORK_ADAPTER_CONFIGURATION verse v_Network_DATA_Serialized
While working on my article What is Parsename and 4 Part Version String?, I was looking at my IP address of many of my system and notice that they have both IP v4 and IP v6 address. This is NOT generally a problem as I almost never include IP address in a report, but...
How to Backup BitLocker Recovery Key to AD
Recently, I was helping someone troubleshoot and issue with BitLocker and is storing its key within AD. In other words, to help troubleshoot this issue, we needed to ensure that we could manually backup BitLocker recovery key to AD. They asked how do you do that?...
How to Write a WQL Query
You know I always like to help those who try to help themselves. While reading Reddit post entitled SCCM Collection missing machines... the person was looking for all computers that follow a particular naming convention. Their results were not that they expected. This...