2024-01-22
346 reads
2024-01-22
346 reads
2022-07-20
466 reads
2019-09-05
648 reads
Learn how to load an external certificate into SQL Server to encrypt your backups.
2019-04-25
4,615 reads
You may need to drop and recreate your certificates after migrating from SQL 2012 to SQL 2016+
2018-07-23
3,017 reads
2015-02-25
1,478 reads
How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.
2010-06-21
11,480 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