A synonyms in SQL Server are database objects that give an alternative name to the database objects existing locally or on the remote server. Also, they provide an abstraction layer to protect the application from any changes in the base object.Read More
If you deal with SQL infrastructure, especially Microsoft SQL Servers, you deal with SSMS. The SQL Server Management Studio is the default choice for all professionals working with databases. It is not the only option, but it is the leader, backed by Microsoft and equipped with all the necessary SQL Server developer tools.
Still, even with all its advantages, SSMS is not perfection. It needs improvements as it often lacks the necessary or simply helpful functionality. Most SQL specialists inevitably get into situations where SSMS can’t do what they need. Or can’t do it how they want.Read More
SQL Server Transactional Replication is one of the most common Replication techniques used to share, copy, or distribute data to multiple destinations. In this article, we will discuss Replication, various Replication Types, and pay special attention to the Transactional Replication work.Read More
Today’s article comes from a scenario we experienced in practice some time ago. We managed a card transaction system referred to as Postilion, and we had to update the data in a column containing IP addresses as part of the string with a new IP address. This was necessary because the IP address of the server hosting the solution would typically change due to switchover or the data restore to a UAT environment.
The data about the server was stored in the databases, and there was no way to update the same from the application without going row by row. Thus, we had to come up with an efficient solution using the LEN and SUBSTRING (or REPLACE) SQL Server functions.Read More
To insert data into a table having columns with default constraints, we can use the DEFAULT constraint to a default value in a table. This article will cover the following aspects:
- The DEFAULT constraint and required permission to create them
- Adding a DEFAULT constraint while creating a new table.
- Adding a DEFAULT constraint into an existing table.
- Modifying and Viewing the constraint definition using T-SQL scripts and SSMS.
No matter how hard we try to design and develop applications, errors will always occur. There are two general categories – syntax or logical errors can be either programmatic errors or consequences of incorrect database design. Otherwise, you might get an error because of the wrong user input.Read More
What is the right way of using Date Templates in Power BI reports and dashboards? This article will clarify the question and help to understand the usage of Date tables as templates.
But before we dig deeper, let’s refresh the information we are already familiar with.Read More
Automating backend processes in your SQL Server instance is a common task. Whether it is refreshing the statistics, rebuilding indexes, reading or deleting data, other programming frameworks integrating with the RDMS is extremely valuable. This article will consider these types of tasks specifically integrated with Python and various method modules available to do so.Read More
Microsoft has been supporting SQL Server for Linux-based operating systems since the SQL Server 2017 release. The current article will focus on installing one of the popular Linux operating system Ubuntu 18.04 and describe the process step by step. The goal is to install the latest SQL Server 2019 on this operating system. We have to perform each step correctly to configure SQL Server 2019 in your production environment or set up your own lab.Read More