Qa.sqlservercentral.com

Daily Sql Server Health Check – SQLServerCentral

WEBThe scripts will create the following tables and items. SCRIPT 1: Step1_Daily_Sql_Health_Check_Create. SCRIPT 2: …

Actived: 9 days ago

URL: https://qa.sqlservercentral.com/scripts/daily-sql-server-health-check

Automating SQL Server Health Check (SQL Server 2005)

WEBThis article explain how to automate SQL Database server health checks, exactly what an ideal DBA desires.

Check health and status of Availability Group using DMVs

WEBSQLPals , 2018-04-26. -- Health and status of WSFC cluster. These two queries work only if the WSFC has quorum. SELECT ag.name agname, ags.*. FROM …

Category: Health Go Health

SQL Server Monitoring Using Free Tools – SQLServerCentral

WEBYou can monitor the health and activity of your instances and databases using SQLFacts, a FREE suite of tools for SQL Server database engineers. Please refer …

Category: Health Go Health

Microsoft Purview new data governance features – SQLServerCentral

WEBStarting last week is a rollout of the public preview of a new and fully reimagined Microsoft Purview data governance solution. Data governance has become …

Category: Health Go Health

Performance Tuning Using Free Tools, Part 2 – SQLServerCentral

WEBYou can improve your databases using SQLFacts, a FREE suite of tools for SQL Server database engineers. Please refer to an earlier article for a general …

Category: Health Go Health

Speaking on Consolidated Essential Performance Health Check …

WEBon june 8th 6.30 pm, i will be presenting “consolidated essential performance health check using powershell” @ at san francisco data platform user group, if you are …

Category: Health Go Health

Change the Maintenance Plan Owner – SQLServerCentral

WEBStep 1. Execute the below statement to check the current details of the entire maintenance plan configured on SQL Server. Use MSDB. go. select * from …

Category: Health Go Health

Deadlock Graph from the xml from system_health extended event

WEBHow to get the Deadlock Graph from the xml extracted from system_health extended event. I'm using SQL Server 2008R2 SP2, and when I try to open the xdl file it …

Category: Health Go Health

T-SQL Tuesday #129 – Let’s Build a Time Capsule

WEBIt is time for another T-SQL Tuesday! Thank you Tamera Clark (t|b) for hosting this month.This month we are building a Time Capsule.I decided to make mine …

Category: Health Go Health

Speaking on Consolidated Essential Performance Health Check …

WEBSpeaking on Consolidated Essential Performance Health Check using PowerShell - SQLSaturday (Portland)

Category: Health Go Health

SQL Server Database Maintenance Checklist – SQLServerCentral

WEBLast week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at …

Category: Health Go Health

Implementing Stretch Database – SQLServerCentral

WEBFrom SQL Server Management Studio (SSMS), right click the database that holds the table (s) you want to stretch to Azure and select Tasks > Stretch > Enable. Fig. …

Category: Health Go Health

My Stats from 2023 – SQLServerCentral

WEBI’m a data guy, so I decided to drop some numbers in a post. I did this last year, so this one includes a few comparison points. Music. From Spotify Wrapped with …

Category: Health Go Health

Speaking on Consolidated Essential Performance Health Check …

WEBon oct 22nd 4.45 pm, i will be presenting “consolidated essential performance health check using powershell” @ at sqlsaturday, portland, if you are in the …

Category: Health Go Health

I don’t blog anymore, but not because I work at Microsoft

WEBLast year I had a health scare that got my blood pressure at 200-and-something over 100-and-something, soon to be wired up to an IV drip, put through a CT …

Category: Health Go Health

2024- Of ‘quiet quitting’ and ‘life in the hallway’

WEBMy good friend Gina Menorek shared this article from NY Post on the overwhelming exhaustion among tech workers. The article talks of ‘quiet quitting’ – not …

Category: Health Go Health