Monthly Archives: March 2020
-
Error handling protip: @@Error resets after the next command
Leave a commentMarch 30, 2020 by Kenneth Fisher
The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run …
Continue reading -
Why you should never use default string lengths.
Leave a commentMarch 25, 2020 by Kenneth Fisher
TL;DR; You probably don’t know what you’re going to get. Even if you do know the person maintaining your code …
Continue reading -
DROP IF EXISTS
Leave a commentMarch 23, 2020 by Kenneth Fisher
It’s amazing the things that SQL can do these days. It’s also amazing how many of them I’ve managed to …
Continue reading -
There needs to be a win
Leave a commentMarch 19, 2020 by Kenneth Fisher
A while back a company I worked for had two teams. One was a development team and the other was …
Continue reading -
Using SQL Server on Azure Virtual Machines to ease your way into the cloud
Leave a commentMarch 17, 2020 by Kenneth Fisher
When it comes to migrating applications to Azure, there are a number of paths available. But if you’re migrating on-premises …
Continue reading -
Change the size of the grid results view in SSMS
2March 4, 2020 by Kenneth Fisher
After my post last month about configuring your tools I’ve been on a make my life easier kick and one …
Continue reading -
SQL Homework – March 2020 – Database Configurations.
Leave a commentMarch 2, 2020 by Kenneth Fisher
A little while back we tried configuring the instance. Sometimes though, instance settings are a bit heavy handed, so this …
Continue reading
SQL Studies 