PhyData DBA


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


restore SSAS Database on a share - file system error when opening file

By iz

Hi fellow DB colleagues In our company we explore ways to store SSAS multidimensional...

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....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers