SQL – One Query to fetch SQL Jobs Details of All SQL Version – 2000/05/08/R2
Single Query to fetch complete details of sql jobs and you can run it across different version of SQL [2000/2005/2008...
2013-08-12
8,162 reads
PowerSQL By Prashanth Jayaram
SQL – Find Database File Usage Details – 2000/05/08/R2
This post is to find the database file usage details of all databases of an instance. The query runs on...
2013-08-06
1,920 reads
SQL – Query to find data,log,Total Size and other Useful information of all databases – SQL 2000/2005/2008/R2
I’ve encountered a situation where I need to find out the database file,log file, total size and other useful information...
2013-07-25
4,595 reads
PowerShell – Identify and switch between installed PowerShell Versions
Most of the time we have been used to cmdlets and it’s various features but do not know about the...
2013-07-17
1,414 reads
PowerShell – Get CPU Details and its Usage
This PowerShell script helpful in finding No of Processors, Speed and It’s current usage based on samples being gathered at...
2013-07-11
1,658 reads
PowerSQL – Find OS and Memory Usage Details – Multi Server Script – No Input files
Multi Server script to find OS and Memory details. It doesn’t require a text file as its input but you...
2013-07-09
906 reads
SQLCMD –Quick Copy of Files – Using Robocopy
The requirement is to move the files to different server programatically and hence I’ve decided to use Robocopy in SQLCMD.
Robocopy...
2013-07-05
1,991 reads
PowerSQL – SQL Instance Configuration & Installation Information by Reading Registry Keys
Today I got a chance to retrieve configuration information of sql server 2005 instances. PowerShell provide a facility to read...
2013-07-02
1,133 reads
PowerSQL – Different Approaches to Find Free Space in all disk drives
Different ways to find FreeSpace in all disk drives of a given server
T-SQLUsing WMIObjectCountersAll three methods are explained below
This post...
2013-06-27
1,508 reads
SQL- SP_PROCOPTION – AutoNotification to App Owners – When SQL Instance Restarts
We had a situation where Application owners automatically notified whenever server restarts. The SP_PROCOPTION do have a facility to perform...
2013-06-24
1,597 reads
Blogs
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers