Roland Alexander was an application developer for the first half of his 20+ year career in IT – then he came over to the Dark Side of SQL Server development, and is now diving headfirst into the deep end of the DBA pool. This blog is about his observations, discoveries, trials, and tribulations, and he hopes you enjoy reading it, learn a thing or two, and (hopefully) teach him a thing or two while you’re at it.


Get SQL Server Configuration using T-SQL


As a SQL architect or database administrator, it is required to know how to...

SQL Server – Retrieve Physical Cores, Physical and Virtual CPUs, and Processor type information


Today's post describes SQL queries to get the following information about the processors of...

SQL Server - How to comma-separated values into different columns


This article will demonstrate the method to store comma-separated values into different columns using...

Read the latest Blogs


Are all learning resources just rote memorization?

By nikarsena

Title says it all, recently got frustrated prepping for GCP's ACE with Qwiklabs because...

Upgrade SQL and OS of legacy

By sqltester1

Hi All, We are planning to upgrade both SQL and OS of legacy versions....

How to run a different account using SQL Job to execute powershell script

By WhiteLotus

Hi All , I need to run powershell script which is located in other...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers