-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: January 2019

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 were optimizing some queries. One of the queries had a dynamically coded IN clause. In this case, I like to use a string splitting routine to split the IN… Read more

1 comments, 1,866 reads

Posted in A Discussion of SQL Server-Related Topics on 21 January 2019

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 email notification of a new T-SQL Tuesday announcement post didn’t send that email until yesterday. That applet is just one example of things that I use to “Automate All… Read more

5 comments, 118 reads

Posted in A Discussion of SQL Server-Related Topics on 8 January 2019