Sometime we come across a situation where we need the ZIP code of an address but the raw data from operational systems is coming as
Category: SQL Server / DBA
Converting base64 Encoding to String format in SQL
You might have seen at various places, images being represented as normal ASCII characters…those are nothing but the image’s binary data encoded into ASCII format.
SQL Script to Check Partition Information in a SQL Server Database
Few months ago, we talked about how to partition a table in SQL Server database. Let us now look at a script that you can
A Practical Guide to Deal With JSON Data in SQL
As promised in the previous post while talking about Azure IP ranges and service tags, I mentioned that I will be writing next post to
Did You Know…That 0% Cost in SQL Query Plan is Not Actually 0%
This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept
Artificial Intelligence (AI) Feature(s) in SQL Server/Azure SQL Database
As shown in the previous post that Artificial Intelligence has become or if not convinced yet then let’s say that is becoming an integral part
sp_MSforeachdb: Hidden Gem of SQL Server
Almost every DBA or anyone who has got a good exposure of working with SQL must have used this procedure i.e. sp_msforeachdb. This is a
SQL Script to Check Row Count of Each Table
Need to check row count of each table in the database in an efficient manner? Here is the query that you can simply copy and
Most Common Issue in Restoring Azure SQL Database bacpac File to Local Database Instance
If you have ever tried to bring your Azure SQL Database data to local instance through .bacpac file then there are high chances that you
Did You Know…Locking is Normal in SQL Server
This post is a part of the series “Did You Know” whereby the purpose is to share some quick key point of a particular concept
Azure SQL Database Maximum Concurrent Requests
Whether this is SQL Server on-premise or Azure SQL Database, maximum number of requests which can be processed by database engine simultaneously is limited by
DATETIME vs. DATETIME2 in Azure SQL Server: How Easily A Husband Explains This to Wife
We all know that DATETIME and DATETIME2 both data types are available in Azure SQL Database or in general, SQL Server database. Let us see
How to Disable Temporal Behavior or System-Versioning on SQL Server Tables
You may need to suspend the system versioning temporarily or disable the temporal behavior completely if it is no longer needed. Let us see all
Azure Cost Optimization With Reserved Capacities
One of the primary benefit of hosting our resources over cloud is the control that we get over the incurred cost. We can always manage
Azure SQL Database Hyperscale Tier – Our Upgrade Story
If you are not familiar with Azure SQL Server Database’s Hyperscale tier, you can read previous posts (Azure SQL Database Hyperscale Tier and Azure SQL