Tag Archives: Microsoft SQL Server
-
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?
10April 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 -
Change the size of the grid results view in SSMS
3March 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 