SQL – Backup Report
The simple query to find the database backup status
The select statment consists of
ServerNamedbnameBackupStartDateBackupFinishDateBackupAgeSizestatusTypeThe query will only run from sql 2005...
2014-03-05
773 reads
Prashanth Jayaram
INVENTORY – SQL- SSAS – SSRS – Excel Output – Email
Inventory
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-03-03
1,405 reads
INVENTORY – SQL- SSAS – SSRS – Excel Output – Email
Inventory
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-03-03
622 reads
PowerShell – Export SQL Data to Excel with Powershell
SQL Server Export to Excel with Powershell is very useful for all sorts of activities – ETL and reporting are some...
2014-02-28 (first published: 2014-02-24)
5,044 reads
PowerShell – SSRS Inventory – Automatic – Excel File – EMAIL
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-27
2,046 reads
PowerShellGUI Tools – Disk,Memory and Process – Modules
I’ve created a script which gives details of Disk, Memory and Process and its represented graphically.
Here, the scripts are enclosed in...
2014-02-20
1,725 reads
Top 10 Process Listing By Memory Consumption – GUI Tool
This Powershell GUI tool is used to list Top 10 memory consumption process of a given computer[local /Remote]. In the...
2014-02-07
956 reads
PowerShell – SQL Inventory – Automatic – Excel File – EMAIL
Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...
2014-02-04
2,073 reads
PowerShell – Memory Details GUI Tool
This Powershell Memory GUI tool is used to fetch memory information from a computer. In the screen that follows, enter...
2014-01-31 (first published: 2014-01-27)
2,661 reads
PowerShell – Program List – 32/64 Bit – Local/Remote Machies
This Powershell script list all the installed application on both 32 and 64 bit applications, particularly useful for people managing...
2014-01-20
1,061 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Changing the AG Listener
Comments posted to this topic are about the item Changing the AG Listener
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers