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
634 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
690 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,656 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,159 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
869 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,680 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,559 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