-
Has this login been used recently?
Leave a commentApril 8, 2020 by Kenneth Fisher
I get asked this every now and again, along with the companion When was the last time this login was …
Continue reading -
#PowershellBasics: Using environment variables ($env:ProgramFiles)
Leave a commentApril 6, 2020 by Kenneth Fisher
The other day Kendra Little (blog|twitter) mentioned that she was trying to get a command in Powershell working. Specifically one …
Continue reading -
SQL Homework – April 2020 – Continuity planning.
Leave a commentApril 1, 2020 by Kenneth Fisher
Normally for April 1st I’d try to post something a bit more lighthearted but with the state of the world …
Continue reading -
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
1March 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
Live, Learn, Share
