CLR Strict Security in SQL 2017

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

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)

2,221 reads

CLR Strict Security in SQL 2017

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

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

T-SQL Tuesday #110 – Automate All the Things

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...

2019-01-08

139 reads

T-SQL Tuesday #110 – Automate All the Things

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

From a DBA's perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.
The post T-SQL Tuesday #110...

2019-01-08

1 reads

Advent of Code 2018 – Day 4 (Repose Record)

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

Advent of Code 2018 – Day 4
As I explained in a recent post, I’m participating in this year’s Advent of Code...

2018-12-25 (first published: 2018-12-05)

2,415 reads

Advent of Code 2018 – Day 2 (Inventory Management)

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

Advent of Code 2018 – Day 2
As I explained in yesterday’s post, I’m participating in this year’s Advent of Code challenge,...

2018-12-21 (first published: 2018-12-04)

1,815 reads

TSQL-Tuesday #109 – Influence Somebody

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

Influence Somebody
Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were...

2018-12-12

150 reads

TSQL-Tuesday #109 – Influence Somebody

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

Influence Somebody Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were hit Sunday by a snowstorm… I had 7?...

2018-12-12

Advent of Code 2018 – Day 6 (Chronal Coordinates)

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

Next,  Advent of Code 2018 – Day 6
As I explained in a recent post, I’m participating in this year’s Advent of...

2018-12-07

230 reads

Advent of Code 2018 – Day 6 (Chronal Coordinates)

• by Wayne Sheffield

• A Discussion of SQL Server-Related Topics

Next,  Advent of Code 2018 – Day 6 As I explained in a recent post, I’m participating in this year’s Advent of Code challenge, with the twist of doing...

2018-12-07