PhyData DBA


Blogs

Get SQL Server Configuration using T-SQL

By

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

By

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

By

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

Read the latest Blogs

Forums

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