CLR Strict Security in SQL 2017
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
The...
2019-01-21
38 reads
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
The...
2019-01-21
38 reads
SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!
The...
2019-01-21
46 reads
Locking down CLR
I recently ran into SQL 2017’s new CLR Strict Security. I was working with a client where we...
2019-02-06 (first published: 2019-01-21)
6,726 reads
There is one truth that I can say about technology with an absolute certainty: It’s going to change. Get your...
2019-01-21
180 reads
You need a lot of hard work for success!2018 was a good year for me in a lot of areas...
2019-01-21
261 reads
This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.
Related Posts:
Failed to Create the Audit File December 31, 2017
Quick Permissions...
2019-01-21
27 reads
Something I have written about more than a handful of times is the need to audit. When people think about...
2019-02-05 (first published: 2019-01-21)
2,604 reads
Sometimes you need a table that is read only. You don’t want anyone to be able to write to it...
2019-02-05 (first published: 2019-01-21)
2,687 reads
Part of query memory grants, part 4! This post will cover the wait type RESOURCE_SEMAPHORE briefly, but the focus is...
2019-01-21
1,238 reads
Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If...
2019-01-21
219 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