2014-05-12
2,124 reads
PhyData DBA
Mastering Dimensions of Time
A method to create and populate Date and Time dimension tables for a data warehouse project.
2014-01-21
9,212 reads
Blogs
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...
Forums
Are all learning resources just rote memorization?
Title says it all, recently got frustrated prepping for GCP's ACE with Qwiklabs because...
Upgrade SQL and OS of legacy
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
Hi All , I need to run powershell script which is located in other...
Ask SSC