Fixing non-deterministic error when creating indexed view
I discovered a bit of info on working with float values, while creating a hash value that contained a float value, and a date value.
Recent Posts
SQL 2016 - Configuration Manager Not Showing in Start Menu
Didn’t see SQL 2016 Configuration manager in the start menu. Ran a quick search to see if this was a common issue and found an article: Quick Trick Where is ...
DAW Dive 1 - Getting Started - Studio One 3
I’m a geek, software nerd, and a musician. As I’ve been stagnating lately in my musical progression I decided to dive into trying to produce some recordings ...
Setting DBCC 1222 on startup
The following command is run to gain details on deadlocks.
Ableton Live & Lemur Setup (From a Windows User)
Had a chance to look at this program thanks to the generosity of the developer. They had a promotion that ended prematurely and they sent me a license as a g...
Lack for Nothing
The message of this song is one that that has been driving itself home as more and more important to me.
Remote Desktop Workflow Improvements
Remote server management is a fact of life for folks involved with sql server. Since we work so often with remote machines I looked into a few tools that pro...
SSMS - Connection Color with SQL Prompt & SSMSBoost
If you haven’t explored the visual color coding of tabs based on pattern matches with SQL Prompt, I’d suggest you check this out. Earlier iterations of Red G...