Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
The primary question is:Are there any methods for using SQL Server standard edition CDC for data synchronization to cloud based non SQL server databases that don't require use of SSIS...
Asked on 11/21/2021 by phinman
2 answerWhat is the most efficient approach of authentication, considering an user based authentication system combined with a token based authentication system? For this question please consider the following tables:create...
Asked on 11/21/2021 by luukvhoudt
1 answerI try to figure out how to improve Postgres 10.6 pg_trgm queries with German umlauts (äöü). In german 'ö' can be written as 'oe'. But beware: not every 'oe' can...
Asked on 11/21/2021
1 answerI need to make a primary-secondary replication for some joomla portals. However, high traffic means that a lot of inserts, deletes and updates happen on the %_session tables, something that...
Asked on 11/19/2021
1 answerHow to backup all functions in pgadmin 4 version 1.6?After executing the below query the backup functions stored in which place?And how to find it?How to know...
Asked on 11/19/2021 by M.Karthika
1 answerContextI have stumbled on an issue in SQL Azure where the Sort-operator is spilling over into TempDB due to poor row estimates.We are querying a master table that is joined...
Asked on 11/19/2021 by Yannick Motton
1 answerWe have migrated our database from a local hosting company to AWS.Now when we run a particular query on AWS it finishes in about a minute (processlist says "sending...
Asked on 11/19/2021 by J-F
1 answerI have the following stored procedure to merged multiple tables into 1 table. The records that im tryin to merge is about 150M. The procedure is quite slow. Here is...
Asked on 11/19/2021 by Edu Cielo
1 answerI have a simple script that should send an attachment using send_dbmail. It works when I exclude the attachment or send a very small file, e.g. 5KB. The...
Asked on 11/19/2021 by Stockburn
1 answerI'm trying to connect to a SQL Server Express server from a Linux Ubuntu 16.04 computer. I Installed all SQL commad line utilities for the linux machine and follow instructions...
Asked on 11/17/2021 by CarlosRPEvertsz
1 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP