Trigger Happy
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,409 reads
This article looks at using triggers to audit and to prevent the performing of unintended actions.
2018-10-12 (first published: 2016-03-28)
4,409 reads
Script provided to create missing extended properties allowing you to auto generate your database documentation.
2017-11-17 (first published: 2016-02-25)
9,080 reads
Your software has passed all testing phase(s) and it is time to install your database into production. Andy Jones will outline below how he accomplished this task. This article is concerned with an evolving system and how to migrate it to production.
2003-02-04
6,424 reads
Andy Jones recently faced a requirement to load several flat files on a nightly basis. In this article, Andy Jones shows you how he accomplished this and shows plenty of code!
2002-10-31
11,284 reads
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers