As a Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM /ConfigMgr ) administrator, you...
I want to Learn SQL Querying!
read more
Results for "SQL Query"
How to query a Service status within a SQL query?
A user on Reddit ask How to query a Service status within a SQL query? They wanted to create a SQL...
SQL Query Troubleshooting Tip
Before starting to write a SQL Server Reporting Services (SSRS) report, you need to create a SQL...
How to use PowerShell to query SQL Database?
This question comes up from time to time, where someone want to query MEMCM using WQL and runs...
Using a SQL Server Query to Create a PowerShell Script
This blog post is really meant for those who are better at writing SQL Server queries than at...
Subselect Query for Reports (SQL)
This post is a continuation of my series about how queries are processed. Please start with the...
How to Combine Two Views into one Query
In this blog post, I will show you how to How to Combine Two Views into one Query. The other day,...
Updated-How to Create a SQL Server Computer Account Login
This blog post was originally published in early 2017, but since then newer versions of SQL Server...
How Do I Bulk Upgrade SSRS RDLs from SQL Server 2005 to SQL Server 2008 R2?
I discussed how I needed to update each SQL Server Reporting Services (SSRS) RDL in yesterday’s...
How Do I Enable CLR within SQL Server?
If you take a copy of your System Center Configuration Manager (SCCM) database and put it on your...
Does SQL Server Database Compatibility Level Matter?
Not long ago, I was dealing with a performance problem involving a very simple SQL Server query....
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....