MS SQL Server Agent

SQLServerCentral Article

Create an HTML Report on the Status of SQL Server Agent Jobs

  • Article

SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential to regularly monitor the status of SQL Server jobs. One way to do this is […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2023-05-03

8,369 reads

Technical Article

MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

  • Script

This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2022-02-22 (first published: )

7,780 reads

Blogs

Performance tuning KubeVirt for SQL Server

By

Following on from my last post about Getting Started With KubeVirt & SQL Server,...

T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future

By

I haven’t posted in a while (well, not here at least since I’ve been...

Keeping MS Docs Up to Date

By

One of the things that I like about the SQL Server docs (MS Learn...

Read the latest Blogs

Forums

Change Tracking – Troubleshooting

By Phil Parkin

I have change tracking configured in several databases, in QA and production environments, and...

is there a no code way to limit an ssis extract from excel to the 1st 21 rows?

By stan

is there a no code way to limit an ssis extract from excel to...

Pivot but preserve all rows on Aggregate column

By getsaby

Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...

Visit the forum

Question of the Day

What is the PRODUCT

In SQL Server 2025, what does this return? 

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers

See possible answers