alzdba

  • Interests: family, mantrailing / dogs, riding my motorbike, volleyball

SQLServerCentral Article

Logon monitoring in SQL Server and Azure Managed Instances - Adopting Extended Events

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 […]

5 (5)

You rated this post out of 5. Change rating

2021-10-29

3,410 reads

SQLServerCentral Article

Getting SQLAgent to Respond Faster

One limitation of SQLAgent is that granularity to which you can schedule jobs: every minute. Sometimes there are things that you would like to happen more frequently, like alerting. Johan Bijnens brings us a technique for getting your SQL Agent to respond to alerts in as little as every 10 seconds.

You rated this post out of 5. Change rating

2007-08-16

5,678 reads

SQLServerCentral Article

Adventures With Service Broker

Service Broker is one of those new SQL Server 2005 features that doesn't get much press, but is extremely interesting from a software architect perspective. The much talked about service oriented architecture (SOA) can make use of Service Broker and new author Johan Bijnens brings us a look at this subsystem.

You rated this post out of 5. Change rating

2007-04-16

9,537 reads

Blogs

The 5 Best SQL Course for Beginners – Reviews and Guide

By

In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Read the latest Blogs

Forums

Error of No Corresponding Begin Tran not getting simulated

By saum70

Hello, I have come across this peculiar problem. This stp is called every begin...

Scripting out AG code with Powershell

By Brandie Tarvin

I'm trying to script out an availability group in SQL and found this neat...

Reorganising field in a table

By richardmgreen1

Hi all   We've got some tables where the field order is .... odd....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers