Intro In 2008 I wrote an article called “Scope: The drastic caveat with Logon Triggers.” Ever since, we have been using Event Notifications to capture logins for our SQL Server instances. Issues were only very rare, usually on servers that had an extreme load of many connections. In such a case, we stopped this continuous monitoring and […]
2021-10-29
4,507 reads
Howto restore master database on a Clustered SQL Server 2019 Instance
2021-04-08
4,484 reads
Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.
2014-12-08
4,563 reads
Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.
2012-05-21
4,612 reads
Why should any SQLserver administrator, DBA, or Developer be interested in Powershell? Johan Bijens presents a few reasons today.
2011-12-06
7,713 reads
2011-09-05 (first published: 2007-01-25)
3,859 reads
To see the frequency of alerts in use, you can reset their fire count.
Restart count from zero for all alerts using the propre stored procedures.
2009-12-22 (first published: 2003-01-14)
468 reads
2009-08-03
3,099 reads
In this article, Johan Bijnens shows how logon triggers can bite you in the back.
2008-12-15
9,061 reads
2008-09-10
4,464 reads
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
I am in the process of migrating from MySQL to SQL Server. I have...
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...
Good morning to all. I am a novice when it comes to SQL so...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers