SQL 2008 - SSMS

Scope: The drastic caveat with Logon Triggers.

In this article, Johan Bijnens shows how logon triggers can bite you in the back.

What is the result ? (SQLServer 2005)

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.

Generate Create FK-indexes

Generate create statements for missing FK indexes, based on DRI

How to handle lost LF/CR when copying [code]

A quick workaround from a longtime community member that helps you prevent the LF/CR from being lost if you copy scripts from the code tags in your posts.

SQL Server and SOX

The Sarbanes-Oxley act has changed many IT jobs, usually requiring more work and documentation. Johan Bijnens brings us a list of some things his team has had to do to comply with SOX regulations.

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.

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

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