SQL Server Code,Tips and Tricks, Performance Tuning
A blog about SQL Server, Books, Movies and life in general
Saturday, March 16, 2019
Use sys.configurations to find features that are enabled but perhaps not used
›
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,...
Monday, February 18, 2019
Calculating Sexy Primes, Prime Triplets and Sexy Prime Triplets in SQL Server
›
The other day I was reading something on Hackernews and someone posted a link to a Sexy Primes wikipedia article. I looked at that and th...
1 comment:
Thursday, February 14, 2019
Finding rows where the column starts or ends with a 'bad' character
›
A coworker came to me asking me for some help. He had some issues trying to convert some data from a staging table to numeric. I asked him t...
Tuesday, February 12, 2019
Using SonarQube, SonarQube Scanner and the sonar-tsql-plugin to run static code analysis
›
In the previous post Scripting out procs and user defined functions with PowerShell , we scripted out some procs and functions from the Adve...
‹
›
Home
View web version
