Suppose you want to or need to know anytime your SQL Server is experiencing blocking where queries are being blocked and it may or may not escalate to a...
2019-04-30 (first published: 2019-04-17)
1,562 reads
# Assuming you have list of servers in servers.txt, each server name in its own line
$ComputerNames = get-content servers.txt
# Method 1 - Using the Get-Counter cmdlet#...
2018-10-08
966 reads
# Assuming you have list of servers in servers.txt, each sever name in its own line
$ComputerNames=get-content servers.txt
Get-WmiObject -Query "select * from win32_service where...
2018-10-08
201 reads
Do you think you need to use commercial tools like SQL Diagnostic Manager, SQL Sentry, Spotlight etc.. ? Or do you think...
2018-10-07
419 reads
Here is a DMV script to check whether a or any database has the auditing configured and running, along with...
2018-09-18
495 reads
Do you ever wonder if there are any databases in your environment that may just be there but not being...
2018-09-18
166 reads
I was entrusted with a new database for a critical application that was having general performance issue and the CPU...
2018-05-10
1,504 reads
Scenario:
I was at a new client, with their previous and only DBA / DEVELOPER/ MASTER OF ALL of 8 years all...
2018-05-10
8,698 reads
You may and should have monitoring in place to monitor state of your servers, services, jobs, critical and not critical...
2018-04-27
758 reads
If you are a DBA, especially Infrastructure DBA, Production DBA or Operations DBA then you don't necessarily always know what...
2018-04-26
379 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...
Hi everyone My SSIS package does a bulk insert of csv files into a...
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
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;
GO See possible answers