T-SQL to check Data and Log Files are on same drive or not
The below query help us in finding the physical existence of data and log files are on same drive or...
2014-01-13
636 reads
PowerSQL By Prashanth Jayaram
T-SQL – Monitoring DiskSpace of Multiple Servers
This post talks about step by step approach to capture the disk space using T-SQL. This is a request from...
2014-01-10
763 reads
SSRS – Identify a scheduled SSRS Report
Initiating subscription is a tedious task in SQL Server Reporting Services. Each subscription in Reporting Services is setup as a...
2014-01-10
692 reads
SQL- Useful links
Useful links – I hope you might like it too..
http://www.sqlskills.com/blogs/paul/sqlskills-holiday-gift-to-you-all-2012-insider-videos/
2014-01-08
623 reads
Powershell – Age of File Report – Local or Remote
Here’s a very quick post by request.I just had a request for searching the file system for files matching certain...
2014-01-08
1,659 reads
PowerShell – Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell
Method 1: Environment Variable
PS:\>$ENV:PROCESSOR_ARCHITECTURE
Method 2: Using Win32_OperatingSystem
ps:\>$computername=’abcd’
ps:\>(Get-WmiObject Win32_OperatingSystem -computername $computername).OSArchitecture
Method 3: Using Win32_Processor
ps:\>$computername=’abcd’
ps:\>Get-WmiObject -Class Win32_Processor -ComputerName $ComputerName| Select-Object AddressWidth
Method 4:[IntPtr]::Size - Gets the...
2014-01-06
2,160 reads
PowerShell- Monitoring Multiple Service on a Group of Servers
I got a request to monitor multiple services and send an email to intended recipients. This post explains how to...
2013-12-04
1,415 reads
Disk Space GUI Tool – Multiple Servers with GridView and Email Output
This tool helps you get the disk space information on the computers of your choice. Either you can type the...
2013-12-03
872 reads
PowerShell – Service Comparison GUI Tool
Service Comparison GUI Tool does comparison of all the services of any given two servers. The output is a grid view...
2013-11-11
1,683 reads
PowerShell – Disk Space GUI Tool
PowerShell – Disk Space GUI Tool - Sharing a useful PowerShell GUI script to check disk drive usage along with a graph.
Copy and...
2013-10-24 (first published: 2013-10-14)
4,562 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
BCA KCP Ancol | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Blok A VI No, Jl. Parang Tritis Raya 3B-3C, RT.8/RW.11, Ancol, Kec. Pademangan,...
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers