T-SQL

Removing decimal places from a number without rounding

ROUND() is a well-known function in SQL Server. Most of us know only that two parameters can be used like ROUND(99,95, 2). This will do standard mathematical up/down rounding of numbers in the first parameter for the number of decimal…
Azure

Backup and restore database in Azure Storage Account

Creating backups of user databases from an on-premise environment to Azure Blob Storage is an easy task. You need to configure Storage Account in Azure where your database backups will be sent. Then you can reference this newly created storage…
T-SQL

Concatenating strings in T-SQL

It may look like an easy task to concatenate string in T-SQL at the first look. But it still has some hidden points where beginners are failing most of the time. There are a few very important things to remember…
Azure

Linked Server from on-premise to Azure SQL Database

If there is a need to move data between local SQL Server instances (on-premise) and Azure SQL Databases we can use Azure Data Factory. But it isn’t the ideal solution all the time: it’s paid in some scenarios and not…
BI

Power BI Report Server release schedule

Who is using Power BI Report Server in regular production with many users creating and publishing reports in Power BI Desktop is facing one crucial issue: there is regular monthly release for Power BI desktop but releases for Report Server…
T-SQL

Comparing strings with trailing spaces

There is all the time confusion in developer’s daily job how exactly is SQL Server handling padding spaces before and after strings in comparison and data persistence. Time to make it more clear now. Few most important things to remember…