Technical Article

Verify Errorlog

Hi this is my first post on sql....The below procedure will check the current errorlog(past one hour errorlog will be scanned)for the keyword "error" (you can include your own key word) .. If you run the procedure it will look for keyword error in the past one hour... it will be use full for some […]

You rated this post out of 5. Change rating

2007-09-12 (first published: )

730 reads

Blogs

CHOOSE’ing a Beer: #SQLNewBlogger

By

We recently published an article on CHOOSE at SQL Server Central. I thought it...

Don’t Treat Your Data Catalog Like a Data Museum

By

Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...

The trade-offs associated with low-code solutions

By

Low-code solutions often accelerate development and make tasks accessible to people who can’t or...

Read the latest Blogs

Forums

SQL availability group and file server role answering from the same name

By bill-humphrey

Hello, I'm tasked with setting up a 2 node server cluster that will host...

DbaTools With Powershell - Omit The Id Column on CSV Export?

By cajun_sql

I am learning DbaTools in Powershell, and my current project is exporting a CSV...

Visit the forum

Question of the Day

Replacing a Null

What is returned from this code in SQL Server 2022?

DECLARE @value INT = NULL;
SELECT ISNULL(@value, 100.5) AS Result;

See possible answers