Etiketler » SQL Server

Creating a Time Dimension Using T-SQL Script

Date dimension has been so common that probably almost each data warehouse model contains it. But time dimension is not that frequently used. It is generally used in the scenarios whereby you want to get insights out of your data based on some timestamps. 482 kelime daha

Sql Server

How To Change The Server Name Which Hosts SQL Server Instance?

Recently I changed the name of one of my test VM to production VM. The renaming process also needs to be done inside of the SQL Server. 209 kelime daha

SQL Server

How To Change The SQL Server Name Where Logins Associated With Linked Server Are Present. Or How To Fix Error : Msg 15190 – There are still remote logins or linked logins for the server

In many cases SQL server has Linked server and logins associated with it. In such cases, if you attempt to drop the old server name for renaming SQL server, then you will get below error. 190 kelime daha

SQL Server

How To Change The SQL Server Name Where Remote Logins Are Present. Or How To Fix Error: Msg 15190 – There are still remote logins for the server

If the SQL Server has the Remote Logins, then at the time of changing the SQL Server name you will receive below error.

Server: Msg 15190, Level 16, State 1, Procedure sp_dropserver, 
Line 44 There are still remote logins for the server 'SERVER A' 165 kelime daha
SQL Server

Create your first SQL Database Project in Azure Data Studio

Are you already working with SQL Server Database projects? Do you think that SSDT is the only option to develop those projects?

SSDT was the only option but since a few weeks, there is a new extension for… 870 kelime daha

SQL Server

Getting the most out of Oracle with Polybase & SQL Server 2019

Getting data out of Oracle database can be a real pain, but what if there was a way to leverage the toolset around SQL Server to do it? 1.309 kelime daha

SQL Server

Creating data files in Azure Blob Storage for SQL Server database with Powershell

Storing SQL Server database files in Azure blob storage is a great solution for all the databases that are often migrated between instances, servers, virtual machines, or would have been divided between instances. 587 kelime daha