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,171 reads
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,927 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,604 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,435 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,673 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
917 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,997 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,145 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,518 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,605 reads
Blogs
It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
Car Update October 2026
By Steve Jones
This month I want to look at a few of the things I’ve seen...
SQL Server 2016 Has Reached End of Support. Now What?
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Forums
PostgreSQL 19 Is Late
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Hyperscale Replicas V
Comments posted to this topic are about the item Hyperscale Replicas V
A Heavy Heart
Comments posted to this topic are about the item A Heavy Heart
Question of the Day
Hyperscale Replicas V
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers