rajendra guptaJan 11, 20221 minEnclose a list of values into single quotes from CSV for T-SQL query for SQL Server databaseEnclose a list of values into single quotes from CSV for T-SQL query for SQL Server database
rajendra guptaJan 11, 20221 minPowerShell Script to configure SQL Server static PortRead the article to use a PowerShell Script for configuring SQL Server static Port
rajendra guptaJan 10, 20221 minT-SQL script to get user session count with client IP addressDownload a T-SQL script for SQL Server that will aggregate the number of active sessions for each unique IP address. This is useful for dete
rajendra guptaJan 10, 20221 minSQL Server Missing Index ScriptIf you ever find yourself in a situation where you're trying to troubleshoot performance on a SQL Server, then it's a good idea to look at