alzdba

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

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,794 reads

Technical Article

help to tighten use of  cmdshell  or sp_start_job

-- The goal is to avoid the use of sp_start_job in an application. So we have the application use RAISERROR to activate the job.--  1) because you can only start jobs you own--  2) we don't want to open the cmdshell to everyone--  3) we want control regarding jobs that run on our server.--  4) […]

5 (1)

You rated this post out of 5. Change rating

2007-05-31 (first published: )

2,158 reads

Technical Article

Detect invalid FK-data after using "WITH NOCHECK"

In situations where FK's have been created using the "WITH NOCHECK" option you can get into troubles because the FK-data is not checked ! (so there may be invalid data in the FK-column !)E.g. ALTER TABLE [dbo].[mytable] WITH NOCHECK add constraint [FK__USED_RESO__Actio__1162CF5F] FOREIGN KEY ( Action_Type ) REFERENCES [dbo].[Action_Types] ( Action_Type ) BOL states "... […]

You rated this post out of 5. Change rating

2007-05-29 (first published: )

539 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,743 reads

Technical Article

VB.Net support from your SQLServer DBA

Once devs are pushed toward using parameters, they get confused as to why their sp is not reused and has many compilations when in use.The reason is most of the time, that the parameters are defined with a wrong datatypemapping in the application or have different datatypes in a # of applications.I use this proc […]

You rated this post out of 5. Change rating

2006-02-16 (first published: )

301 reads

Blogs

Back in the EU

By

I flew to Amsterdam last night and hopefully by the time this publishes I’ll...

The Feedback Multiplier: How Leaders Can Turn Input into Innovation

By

In every organization there is a hidden currency more valuable than capital, more enduring...

Setting up SQL Server S3 Object Storage Integration using MinIO with Docker Compose (Updated for SQL Server 2025)

By

Update for SQL Server 2025: This post and the GitHub repo have been updated for...

Read the latest Blogs

Forums

Flexible Laptop on Rent in Noida for Students & Businesses

By SRITTECH

Looking for laptops without heavy investment? Laptop on rent in Noida is ideal for...

how to use a variable in a CASE statement?

By water490

hi everyone I am getting an error when I add a variable to a...

How to Use SQL Server Features to Cut Web App Latency in Half

By Muhammad Adnan

Comments posted to this topic are about the item How to Use SQL Server...

Visit the forum

Question of the Day

The New SQL Server 2025 Data type

In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?

See possible answers