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 when working with string and doing concatenation. Without respecting them…
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 everyone is familiar with it. And the most critical issue…

Read more
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 for Power BI are coming unexpectedly even Microsoft has announced…
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 are: SQL Server follows the ANSI/ISO SQL-92 specification on how…

Read more
Azure

Azure Data Studio

Azure Data Studio, formerly known as SQL Operations Studio, is a tool for basic SQL Server querying and administration on Windows, Mac-OS, and Linux. That it can be executed on other platforms then Windows is the main point why it was created and it’s the logical evolution of SQL Server…
T-SQL

Specifying FILEGROUP in SELECT * INTO

SQL Server 2017 and SP2 for SQL 2016 bring small enhancement of SELECT .. INTO clause which offers more possibilities on how to solve some DBA head-scratching situations. It’s possible to specify FILEGROUP where the new table will be created. Till now it was only in the PRIMARY filegroup which…
SQL Server

IDENTITY_CACHE and gaps in identity values chain

SQL Server 2016 brings a lot of new configuration options at the database level (DATABASE SCOPED CONFIGURATION) instead of at instance level only. SQL Server 2017 adds to this list another new option. It’s called IDENTITY_CACHE and allows us to adjust if the IDENTITY values generator will use cache or…

Read more