The Amazing Babelfish for PostgreSQL by AWS

Some interesting news in the AWS re:Invent 2020 - Keynote with Andy Jassy . Introduction of the new Babelfish for PostgreSQL , aiming to to offer a new translation capability to run SQL Server apps on Aurora PostgreSQL. One of the main selling points is the capacity to understand SQL Server proprietary dialect t-sql and the Tabular Data Stream (TDS) Protocol Some underlying logic , which has led to the development & introduction of Babelfish for PostgreSQL: 1) Databases are hard to manage which partly has led to the massive uptake on managed RDBMS service. Despite growth in AWS managed... Read more →

How to execute a js file in MongoDB

Question: I have a js file - which iterates through some MongoDB collections - and currently I execute on an adhoc basis using the mongo shell. I now need to schedule this process on a regular basis and researching some effective methods to use? Can you supply some examples \ methods to deploy Answer: I use two main methods to execute external js files . The first method utilises mongo shell & the second method use the MongoDB load function. Using this method gives you flexibility to trigger steps with a scheduler such as Crontab Method 1 : Using the... Read more →

How to use MongoDB column alias in SQL Server SELECT

Question: I am accessing data through a SQL Server Linked Server . The Linked Server is interfacing a MongoDB ODBC - connected to a MongoDB. The MongoDB ODBC connects to the BI Connector - which in turn extracts some collections. When the results are returned using the SQL Server OPENQUERY functionality , the dot nation is used to represent some columns. I want the columns presented without dot notation. How can I return an alias? Answer: When using OPENQUERY command through SQL Server connecting to MongoDB - it will present with dot notation. For Example: select * from OPENQUERY(MongoDB_TEST,'select *... Read more →