My client wanted to upsize an Azure VM running Always On from D-Series to a higher tier G-Series size, but it was missing from the list. Here is what I suggested.
Extract Decimal Part of a Number in SQL Server
To extract decimal part of a number in SQL Server, use ABS(value) % 1. This post compares four methods on positive and negative amounts and explains why the result is sometimes 0. It also covers float columns, digits as whole numbers and trailing zeros.
SQL SERVER – Scripts to Overview HADR / AlwaysOn Local Replica Server
SQL Server expert Dominic Wirth shares a script that gives a utilization overview of the local AlwaysOn replica server: database count and size, by role and group.
SQL SERVER – Rebuild Index Job Failed – Error: 9002 – The Transaction Log for Database ‘PinalDB’ is Full Due to ‘LOG_BACKUP’
A rebuild index job kept failing with error 9002: The transaction log for database ‘PinalDB’ is full due to ‘LOG_BACKUP’. Here is how I found the real cause.
SQL SERVER – SSMS – Enable Line Numbers in SQL Server Management Studio
When I guide a DBA over a screen share, line numbers make it easy to point at the right spot. Here is how to enable line numbers in SSMS.
In-Memory OLTP Migration Checklist in SSMS: Step by Step
The In-Memory OLTP migration checklist shows which tables and stored procedures can move to memory-optimized objects. This post sizes up the tables with T-SQL, walks through the wizard in Management Studio and explains how to read the reports.
Alphabets – SQL SERVER – Retrieving Rows With All Alphabets From Alphanumeric Data
I got an email from one of my blog readers asking for an easy way to identify if a given string contains only alphabets. There can be methods.