Tag Archives: Microsoft SQL Server
-
Call to action: What do you own?
2April 29, 2020 by Kenneth Fisher
You restored that database, did you remember to change the owner or is it still you? How about that job …
Continue reading -
What is (local)?
Leave a commentApril 27, 2020 by Kenneth Fisher
When connecting to a SQL Server instance sometimes you’ll see (local), localhost or even just a single period (hard to …
Continue reading -
Is there an easy way to tell what pricing tier my Azure SQL DB/DW is using T-SQL?
3April 22, 2020 by Kenneth Fisher
I ran into an interesting problem today. I needed to find out the pricing tier of an Azure SQL DB …
Continue reading -
What is the datatype SQL_VARIANT
3April 16, 2020 by Kenneth Fisher
The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. …
Continue reading -
Has this login been used recently?
3April 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 -
SQL Homework – April 2020 – Continuity planning.
3April 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 -
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
