When I try to connect to a remote instance of SQL Server Integration Service from Management Studio in my workstation, I receive an "Access Denied" error message. My Windows account is a member of the db_ssisadmin role in the msdb database of this server
Sometimes things that seem complicated are much easier then you think and this is the power of using T-SQL to take care of repetitive tasks. One of these tasks may be the need to backup all databases on your server. This is not a big deal if you have a
In my last article, I talked about how you can use an FTP task in SSIS to download files from an FTP server. But what if the file you have downloaded is an XML file and you need to import this data from the XML file into a SQL Server table? In this tip we
In-Memory OLTP is a new feature in SQL Server 2014 for OLTP workloads to significantly improve performance and reduce processing time when you have plentiful memory and multi-core processors. In this tip we look at some examples as to how to get started w
In part 1 of this tip, we introduced the concept of the approval workflow in Master Data Services (MDS) 2016 using change sets. The second part will focus on how an administrator can inspect a change set and how to approve or reject it.
How can you enhance the Power BI Q & A functionality? Are there any advanced techniques to make the data interaction any easier? I need ways to enhance the accuracy and efficiency of Power BI Online Q & A queries.
Our company’s entire IT infrastructure is growing rapidly, but our SQL Server environment is growing exponentially faster. My team needs to make sure we have consistency across our SQL Server instances. One of our needs is to execute the same code across
Fixing error the configuration of endpoint data encryption is incompatible between replicas and the endpoint connection will fail. The current configuration is listed below with following order: the name of replica, role of replica, encryption and algorit