PowerSQL – SQL Inventory Generation – Email – High Level Details
Inventory allows anyone to quickly and easily assess any environment. For few servers, answering Inventory questions might not be so...
2013-05-09
1,191 reads
Prashanth Jayaram
PowerSQL – Identify a Head of the Database Blocks and Generate Automated Alert across all listed SQL Instances
This is going to be a simplest way of capturing and sending some useful information via an email of ‘N’...
2013-05-06
734 reads
PowerSQL - List SQL Server instance configuration details and sending an automated email
Reblogged from Prashanth Jayaram :
This article walks through how to list SQL Server configurable and non-configurable instance settings using PowerShell...
2013-05-01
2,899 reads
PowerSQL – Find Size, Name, LastAccess and Last Modified time of all bak files across ALL Servers.
We came across a scenario where database bak files being created from long time which are no more in use...
2013-04-30
1,100 reads
PowerSQL -Recycle SQL Instance (Remote or Local)
We have a scheduled maintenance window to recycle SQL SERVER Instance once in 30 days hence created a PowerShell job where...
2013-04-29
1,390 reads
PowerSQL – Generate Only Index Script of All Tables or Specific Tables
Background of this implementation-As a part of Performance tuning, We noticed huge avg_disk_queue_length on F drive after analysis, we’ve recommended to...
2013-04-24
839 reads
PowerSQL – Database Backup Report across all Servers – Centralized Approach
This topic provides and describes the quickest way to find when and what databases are being backed up recently.Backups are...
2013-04-23
1,052 reads
PowerShell – Get an UNC of a remote folder
To Read/Write/Rename/Copy/Delete a file configured across ‘N’ of servers in the same path, this script is going to be very...
2013-04-22
1,406 reads
SQL – Table data – HTML Format & Email Sending using T-SQL
1) Configure DBMail - In this case the ‘TEST’ profile being created for the demo
2) Create Table – TLOG_Metrics
3) Insert the dumnmy...
2013-04-22
1,642 reads
PowerSQL – Find and Replace string on multiple file of local or remote machine
Copy and Paste the below content in Set-FindandReplaceString.PS1. Please read the instructions carefully. Try to do a dry run on some...
2013-04-17
701 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers