It doesn’t seem like it was that long ago that my company’s IT department was bracing for a major new line of work. Back in the mid 1990s, we were going full steam into client-server technology. At ...

Last time we discussed creating a script that can retrieve configuration settings from a list of SQL Servers and placing that data into a SQL Server table. Now, let's take a look at another technology ...

Microsoft’s Active Directory has enabled Group Policy since Windows 2000. Policies can be set once then applied continually to hundreds or even thousands of machines within a network enabling central ...

Microsoft deprecates SSRS, PBIRS and SSAS management packs for SCOM, ending support in 2027. The move signals a shift from on-prem SCOM extensions toward cloud-based SQL Server monitoring. IT teams ...

In SQL Server 2005 we were given the Surface Area Configuration tool to assist us in terms of security. The idea was to help us reduce the “surface area” of the SQL Server from a security point of ...