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
777 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,411 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
625 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,060 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,052 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,731 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
963 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,079 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,667 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,065 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