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

Views in SQL Server 2019 with SSMS – SQLServerCentral

WebIn SQL Server, a view is a virtual table with contents that you define by means of a query. The structure of a view is similar to a table. The contents of a view …

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 in …

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

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

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

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

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

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 area i hope …

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

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

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

is it possible to convert Hashbyte back to string

WebWe have unique key in table which is hashbye sha1. This value is combination of multiple columns from a different table. one of the records is a problem …

Category: Health Go Health

Immune Systems, User Groups, Changing Jobs – SQLServerCentral

WebI've been off-line except for hints here and there for the last couple of weeks due to fighting off an illness. One thing I've learned about working with youth, especially …

Category: Health Go Health