Generate script to recreate indexes
For me, this particular code to generate a script to recreate indexes has more practical use in a replication environment.
For example, the default replication setting is to exclude the...
2019-04-25
461 reads
Powershell One Liners: Get current cpu utilization on all your SQL Servers
# 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
1,020 reads
Powershell One Liners: Get status of SQL Instances on All SQL Servers
# 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
207 reads
SQL Server monitoring with built-in features
Do you think you need to use commercial tools like SQL Diagnostic Manager, SQL Sentry, Spotlight etc.. ? Or do you think...
2018-10-07
456 reads
Check if any database has auditing configured
Here is a DMV script to check whether a or any database has the auditing configured and running, along with...
2018-09-18
727 reads
Find Orphaned databases in SQL Server
Do you ever wonder if there are any databases in your environment that may just be there but not being...
2018-09-18
175 reads
DMV To List Foreign Keys With No Index
I was entrusted with a new database for a critical application that was having general performance issue and the CPU...
2018-05-10
1,560 reads
How To Audit Data Changes In SQL Server?
Scenario:
I was at a new client, with their previous and only DBA / DEVELOPER/ MASTER OF ALL of 8 years all...
2018-05-10
10,035 reads
How to get alerted anytime SQL Service is restarted?
You may and should have monitoring in place to monitor state of your servers, services, jobs, critical and not critical...
2018-04-27
786 reads
Check health and status of Availability Group using DMVs
-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorumSELECT*FROMsys.dm_hadr_clusterSELECT*FROMsys.dm_hadr_cluster_members
-- Health of the AGsSELECT...
2018-04-26
17,202 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers