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,198 reads
PowerSQL By 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
740 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,910 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,106 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,393 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
847 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,056 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,411 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,648 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
705 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers