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,166 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,923 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,601 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,423 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,668 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
911 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,993 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,138 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,511 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,600 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Preserving Data
Comments posted to this topic are about the item Preserving Data
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers