alzdba

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

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,074 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: )

528 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: )

284 reads

Technical Article

Intervention system for runaway jobs

Some of my developers had created jobs that executed VB applications that never ended. Aparently they could not figure out when, why and what was going wrong. They could not repro the situation.Now I've created this litle system so the users can assign max elaps times for their jobs. These jobs will then be intercepted […]

You rated this post out of 5. Change rating

2003-03-04

467 reads

Blogs

Creating an Empty Repo in GitHub–#SQLNewBlogger

By

I saw someone struggling with getting started with a Visual Studio project and Azure...

Product Review: DataVeil

By

If you’re looking at data masking tools, I recently was able to review the...

The Last Price Bump for the Data Community Summit

By

This week the cost of the PASS Data Community Summit jumps up to full...

Read the latest Blogs

Forums

Partition Large Tables needed

By sqlguy80

Hello Gurus, I have  a requirement and need to implement the solution quickly. SQL...

Deleting the Standby file

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deleting the Standby file

If You Build It, Will They Use Linux?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item If You Build It, Will...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers