Posts

Showing posts from October, 2018
Image
Have you ever wondered how MySQL and PostgreSQL are different? Take a look at the mapping that I have made for myself:  https://www.mssqltips.com/sqlservertip/5745/compare-sql-server-mysql-and-postgresql-features/ I would be happy to see comments posted for this blog and add more things to the mapping. Yours Maria  P.S. The ranking screenshot was taken from db-engines site:  https://db-engines.com/en/ranking/relational+dbms  

Discover how SQL Server can use Python to access any NoSQL engine

Image
Many companies these days keep their data assets in multiple data stores.  Many companies that I have worked at have used other database systems alongside SQL Server, such as PostgreSQL instances, Redis, Elasticsearch or Couchbase. There are situations when the application, that uses SQL Server as their main database, needs to access data from another database system. Some datastores have ODBC/JDBC drivers so you can easily add a linked server. Some datastores do not have ODBC/JDBC drivers. Want to learn how to to access noSQL platforms with SQL Server and Python? Read my article here:  https://www.mssqltips.com/sqlservertip/5738/discover-how-sql-server-can-use-python-to-access-any-nosql-engine/ Happy NoSQLing Maria