PowerShell- Monitoring Group Of Services on Group of Servers with Alternate Credential
This post explains how to monitor a multiple services on a group of servers with alternate credentials.
This script will allow...
2014-07-03
697 reads
PowerSQL By Prashanth Jayaram
PowerShell – Perfmon Counters into CSV File – Multiple remote servers
Introduction
This script can be used for exporting specified performance counter values from multiple remote target servers to CSV file. The...
2014-06-10
1,531 reads
PowerShell – Perfmon Counters into CSV File – Multiple remote servers
Introduction
This script can be used for exporting specified performance counter values from multiple remote target servers to CSV file. The...
2014-06-10
627 reads
PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL
This script is used to discover all the server information and captures disk drive utilization details. The drive details are...
2014-05-21
1,202 reads
PowerShell – OS Inventory and Disk Info – Consolidated Excel File – EMAIL
This script is used to discover all the server information and captures disk drive utilization details. The drive details are...
2014-05-21
562 reads
SQL – List All Tables, Space Usage Info & Other Details
One of the OP requested in the forum to find all table details of any database. The details which includes Number...
2014-05-01
1,079 reads
SQL – List All Tables, Space Usage Info & Other Details
One of the OP requested in the forum to find all table details of any database. The details which includes Number...
2014-05-01
570 reads
PowerShell-Input-Validation Scripts
Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...
2014-04-28
2,003 reads
PowerShell-Input-Validation Scripts
Input values are validated using various mechanisms. let’s start by examining how you would validate input parameters in Windows PowerShell...
2014-04-28
760 reads
SQL – Find encrypted objects using sql_modules or Powershell
sys.sql_modules catalog view which got introduced from SQL 2005 onwards. The sql_modules which includes the objects of type P, RF, V, TR, FN, IF, TF,...
2014-04-14
821 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams n;See possible answers