What is your why? – T-SQL Tuesday #111
In this T-SQL Tuesday post, I answer Andy Leonards question of "Why do you do what you do"? It comes down to I automate what I can so that...
2019-02-12
11 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
CLR Strict Security in SQL 2017
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,531 reads
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
30 reads
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
21 reads
T-SQL Tuesday #110 – Automate All the Things
Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...
2019-01-08
177 reads
T-SQL Tuesday #110 – Automate All the Things
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
8 reads
Advent of Code 2018 – Day 4 (Repose Record)
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,433 reads
Advent of Code 2018 – Day 2 (Inventory Management)
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,832 reads
TSQL-Tuesday #109 – Influence Somebody
Influence Somebody
Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were...
2018-12-12
158 reads
TSQL-Tuesday #109 – Influence Somebody
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
8 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers