Hi,I have VS 2019 installed and I believe I was able to create new SSIS projects locally. Now I don't see the templates when I try to create these projects.What am I missing?Thanks in advance.For every expert, there is an equal and opposite expert. -... ...
Hi ,I was looking for documentation to setup distributed availability group on the Azure VM's , I looked at msdn site but couldn't find anything specific to azure distributed availability groups setup steps .Looking for guidance on distributed AG imp... ...
Hi,As I know there are 2 ways to synch the SSAS cube- 1. Manual way(via DB Synch wizard) 2. XMLA script which can also be automated.I am using both ways randomly to synchronize the ssas cube from source server to destination server.XMLA script is bei... ...
RE: Windows 2000 Enterprise Edition (SP4), SQL Server 2000 Enterprise Edition (SP3), default instance, stand alone server (not clustered or replicated)I have a SQLAgent job that runs weekly to purge data and rebuild the indexes. This job has been fa... ...
RE: Windows 2000 Enterprise Edition (SP4), SQL Server 2000 Enterprise Edition (SP3), default instance, stand alone server (not clustered or replicated)I have a SQLAgent job that runs weekly to purge data and rebuild the indexes. This job has been fa... ...
Is there any API's to get Password Policy for Azure AD user. How to get Azure AD users password policies details like character allowed, characters not allowed, Password restrictions, Password expiry and so on. ... ...
Hi everybodyI have installed a reporting service in my local system and published some reports to share them with Colleague.I set all the accesses in SSRS. The problem is: the ssrs link doesn't even open :the address (which i can brows without proble... ...
https://www.sqlskills.com/help/waits/cmemthread/what's actually "TREAD-safe-memory-object" ? Thread safe is a flag which is put on memory object saying this can be accessed by more than one t... ...
Hi,Currently we have SQL 2012 with Service Broker enabled , which notifies whenever any updates happen to a particular SQL table and notifies Biztalk's WCF-Custom adapter.When we move to Azure PaaS (which does not have SQL Service Broker) , can we re... ...
i have a bitlocker server with SQL Database, one of our PC is requesting a key so i went to the MBAM server to retrieve [been a long time we logged into the server] i could not find the recovery ID and the date in the MBAM is from 2014 to 2017. how d... ...
I couldn't find the forum for Microsoft SQL Server under forum categories. Please help Hello,the forums have moved to Microsoft Q&A site.MS SQL Server is here: https://docs.microsoft.com/en-u... ...
I have an ASPNET .Core application running on a pod in Kubernetes in AKS. The pod's network is an Azure's private network that is linked to my company's on-premise network via VPN. The web application at runtime connects to different SQL Server DB in... ...
Hi All,I created a package in SSISfor executing Power shell Script for this i am using Execute Process Task. Package include password also which is sensitive Parameter.Everything work fine and it run successfully but when Package failed it give error... ...
I need to run an r script on a remote server from MS SQL when executing a stored procedure. xp_cmdshell does not allow this: EXEC xp_cmdshell 'start \\192.168.xxx.xxx.bin\Rscript.exe \\192.168. xxx.xxx.\bin\test_3. R'. Communication with the remote s... ...
Hi.I am using Windows Server 2016. I have created a SSIS package in Visual studio which loads data from Excel and moves to SQL table ( script task functionality using c# )The above functionality works fine when run in Visual studio. Microsoft Visual ... ...
It used to work till v16. Good day ,Activity Monitor works well for me and I was not reported on any such issue from any client, this includes the option "Edit Query Text". In fact in version... ...
Have a publisher with a specific publication that has 1 article, and 4 subscribers. The subscribers are on 3 separate instances with the the same database name(database1) for 3 of the 4 subscribers. I am having an issue with one table having a foreig... ...
Hi,I am experimenting with MDX query recently for work. But I am stuck, wondering if some experts out there can assist.For one of my account tree on geography, if for example, the hierarchy is like this:>Geography >>Europe >>> France >>> Germany >>... ...
Hello Experts,I have SQLite installed in my machine and i have a remote database server.I have installed ODBC drivers of sqlite in my machine and created databases in my machine and i want to sync up with remote database server by using linked server... ...
I have SQL 2017 installed on server 2019 OS, the SSRS role is setup and using the default settings in the RSReportServer.config file.On the server that SSRS is installed I can access the webpage without a issue, on a remote server I am getting prompt... ...