PowerShell- Monitoring Multiple Services On Multiple Servers Using WMI Class -Win32_Service
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
601 reads
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
601 reads
Script to collect and export the mailbox properties from Get-Mailbox and Get-MailboxStatistics cmdlets to a CSV file
This script can be extended based...
2016-01-07
667 reads
During the upgrade to XenApp 7.6 FP3 VDA encountered the following message.
I was wondered on seeing this popup to restart...
2016-01-06
551 reads
We can install MongoDB as a windows service. The steps are given below
Prerequisite –
Install Hotfix kb2731284 on the MongoDB Server...
2016-01-05
1,818 reads
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog.
Here’s an excerpt:
The concert hall at the Sydney...
2016-01-04
330 reads
Stored Procedures are considered most efficient way for calling and retrieving data and hence users always look forward to encapsulate...
2015-12-26
749 reads
SELECT DISTINCT s.Netbios_Name0 AS ComputerName,
s.Operating_System_Name_and0 AS OSName,
pr.Name0 AS ProcessorTypeSpeed,
pr.Manufacturer0 Manufacturer,
pr.NumberOfCores0 Cores,
pr.NumberOfLogicalProcessors0 LgicalProcessorCount,
case when pr.DataWidth0=64 then '64 bit'else'32 bit' end DataWidth,
m.TotalPhysicalMemory0/1024.00 AS MemoryMB,
GS1.TotalVirtualMemorySize0 VirtualMemory,
GS1.TotalVisibleMemorySize0 VisibleMemory,
ip.IPAddress0,
T1.COL AS TotalDriveSize,
LastBootUpTime0,
DATEDIFF(Day,GS1.LastBootUpTime0, GETDATE()) AS [Days since last boot]
FROM v_R_System_Valid s
INNER JOIN v_GS_PROCESSOR pr ON s.ResourceID = pr.ResourceID
INNER JOIN v_GS_COMPUTER_SYSTEM gs ON s.ResourceID = gs.ResourceID
INNER JOIN v_GS_NETWORK_ADAPTER ON s.ResourceID = v_GS_NETWORK_ADAPTER.ResourceID
INNER JOIN v_GS_X86_PC_MEMORY m ON s.ResourceID = m.ResourceID
INNER JOIN v_GS_NETWORK_ADAPTER_CONFIGURATION ip ON s.ResourceID = ip.ResourceID
-- INNER JOIN v_GS_LOGICAL_DISK AS ld ON s.ResourceID = ld.ResourceID
INNER JOIN
( SELECT RESOURCENAME,
col
FROM
(
SELECT DISTINCT TAB.Netbios_Name0 RESOURCENAME,
(
SELECT COL.deviceid0 +' '+ cast(COL.Size0/1024.00 AS varchar(20))+' '
FROM v_GS_LOGICAL_DISK COL
WHERE
COL.ResourceID = TAB.ResourceID AND COL.DriveType0=3
FOR XML PATH ('')
) COL
FROM v_R_System_Valid TAB
)T
where T.COL is NOT NULL
) T1 on T1.RESOURCENAME=s.Netbios_Name0
INNER JOIN V_GS_OPERATING_SYSTEM GS1 on GS1.ResourceID=s.ResourceID
WHERE
s.Operating_System_Name_and0 LIKE '%Windows NT Server%'
AND
ip.IPAddress0 IS NOT NULL AND ip.DefaultIPGateway0 IS NOT NULL
2015-12-11
641 reads
The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot...
2015-08-26
967 reads
declare @table table
(
[Paid Date] date
)
insert into @table
values('20150102'),('20150512'),('20150830'),('20151231'),('20141230')
;WITH Quarters AS (
SELECT Q = 'Q1', MonthBegin = 1, MonthEnd = 3 UNION
SELECT Q = 'Q2',...
2015-03-19 (first published: 2015-03-11)
7,778 reads
Added few more examples
Prashanth Jayaram
On Technet forum, Op was looking for a way to get table cardinality for all databases...
2015-03-17
920 reads
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Dipping my toes into the waters of Azure and of course before I get...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers