Tuesday, February 12, 2019

Scripting out procs and user defined functions with PowerShell

›
I decided to take SonarCube for a spin to run some static code analysis. In order to do that I needed some code that I can display here wi...
Monday, February 04, 2019

After 20+ years in IT .. I finally discovered this...

›
Originally I was not going to write this post, but after I found out that several other people didn't know this I figured what the heck,...
33 comments:
Tuesday, January 08, 2019

Print.. the disruptor of batch deletes in SQL

›
Someone had an issue where a batched delete script was not deleting anything. I looked over some code in our repository and noticed two pa...
3 comments:
Friday, January 04, 2019

Proactive notifications

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Thursday, January 03, 2019

Cursors and loops

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Tuesday, January 01, 2019

SQL Server Maintenance

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed,...
Friday, November 23, 2018

Happy Fibonacci day, here is how to generate a Fibonacci sequence in SQL

›
Image by  Jahobr - Own work , CC0 , Link Since today is Fibonacci day I decided to to a short post about how to do generate a Fibona...
Wednesday, September 26, 2018

A little less hate for: String or binary data would be truncated in table

›
The error String or binary data would be truncated is one of the more annoying things in SQL Server. You would insert some data and you wou...
1 comment: