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,158 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,914 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,589 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,408 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,651 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
901 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,984 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,127 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,502 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,592 reads
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
statistics callection intervel in query store ?
Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed...
Rounding Off issue in SQL Server
I am using Microsoft SQL Server 2022 (RTM-CU17) (KB5048038) - 16.0.4175.1 (X64) Microsoft Corporation...
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers