2011-09-05 (first published: 2007-01-25)
3,464 reads
Johan Bijnens
- Interests: family, mantrailing / dogs, riding my motorbike, volleyball
- Twitter: @@alzdba
Reset count for all alerts
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)
400 reads
HowTo prevent BOL getting Online help
Books Online will try to connect to the net and it may get stuck if there is no internet connection.
2008-06-16 (first published: 2008-05-07)
416 reads
2007-12-21 (first published: 2007-10-25)
1,389 reads
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) […]
2007-05-31 (first published: 2004-01-21)
1,984 reads
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 "... […]
2007-05-29 (first published: 2006-10-09)
525 reads
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 […]
2006-02-16 (first published: 2006-02-06)
270 reads
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 […]
2003-03-04
464 reads
Blogs
Daily Coping 21 Sep 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Bulk insert.
In my last post I talked about invoke-sqlcmd. It’s a nice easy way to...
Lambda Architecture in data systems and possible meaning of this name
By Rayis Imayev
(2021-Sep-21) There is one scene in "The Core" movie that I really like when two geophysicists...
Forums
The actual file SQLServerManager15.msc is missing from my computer
I did a fresh install of Windows 10 Pro and loaded SSMS on it. ...
PostgreSQL Date And Time Part 2
Comments posted to this topic are about the item PostgreSQL Date And Time Part...
To Inifinity and Beyond With 1=1
Comments posted to this topic are about the item To Inifinity and Beyond With...
Ask SSC