Get SQL Server Configuration using T-SQL
As a SQL architect or database administrator, it is required to know how to get SQL Server configuration using T-SQL. This post will share
2022-01-28
351 reads
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 a SQL Server instance: 1. The total number of ph
2022-01-28
207 reads
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 SQL Server(T-SQL) query.
2022-01-28
519 reads
T-SQL Query to change Integration Services Catalog (SSISDB) database Master Key encryption password
Learn how to change the Master Key encryption password for an SQL Server Integration Services Catalog (SSISDB) database in SQL Server.
2022-01-28
103 reads
SQL Server agent jobs without notification using T-SQL
This article will describe how to get a list of SQL Server agent jobs without notifications using T-SQL . Read more here
2022-01-28
184 reads
Using T-SQL to Answer Date-Related Calculations
There are many interesting questions related to date calculations. For example, I have seen the following questions Give a date, find the first Tuesday day of the previous week/month/quarter,...
2022-01-28
226 reads
Daily Coping 27 Jan 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-01-27
54 reads
Parsing scripts with ScriptDOM
In the last post I wrote about what ScriptDOM is and why it is useful. From this post, I will explain how it can be put to use. What...
2022-01-28 (first published: 2022-01-27)
134 reads
Fixing a giant or running a SQL Server project deployment with Temporal tables
(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a 50-foot tall alien robot, whom he eventually befriended, he didn't know about a very special...
2022-01-27
582 reads
Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed
2022-01-27
119 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
Inventory Snapshot for missing Period
Hello, We maintain an inventory table that captures monthly snapshots of item inventory levels....
Azure SQL Hyperscale Unveiled
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
What is the worst part about existing monitoring solutions?
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers