top of page
rajendra gupta
Jan 28, 20221 min read
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
618 views0 comments
rajendra gupta
Jan 28, 20221 min read
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
1,196 views0 comments
rajendra gupta
Jan 28, 20221 min read
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.
3,622 views0 comments
rajendra gupta
Jan 28, 20221 min read
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.
620 views0 comments
rajendra gupta
Jan 28, 20221 min read
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
760 views0 comments
rajendra gupta
Jan 27, 20221 min read
Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and scale, built for globally distributed
242 views0 comments
rajendra gupta
Jan 27, 20221 min read
Display dates between two input dates using SQL DATEDIFF function in SQL Server
SQL Server has a very useful function called DATEDIFF. This function is used to calculate the difference between the two dates. Read more he
2,628 views0 comments
rajendra gupta
Jan 25, 20221 min read
T-SQL query to change the job owners for all jobs owned by a specific login
Many SQL Server DBAs manage jobs through the SSMS GUI and do not know about the underlying T-SQL scripts being run. This blog shows how to u
4,263 views0 comments
rajendra gupta
Jan 25, 20222 min read
Identify When your SQL Database Was Last Used - SQL Server
I've seen several questions on the forums asking how to find out whether the SQL database is in use or not? Let's answer in this article.
17,239 views4 comments
rajendra gupta
Jan 19, 20221 min read
T-SQL Query to find Supported Compatibility Level Values in SQL Server
The question came up on the forum - how do I find all the possible values for a specific compatibility_level in SQL Server? Let's check .
936 views0 comments
bottom of page