Posts

Showing posts from 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 

My #AWSsummit keynote liveblog

Image
The company I work for,  Perion , chose Amazon Web Services as the main cloud provider for managing and operating our applications. These days I am learning how to manage databases and data related flows in the AWS cloud. Which is the reason I have attended the AWS summit in Tel Aviv today. Today’s AWS summit was the first from the series of AWS summits held in major cities around the world. There were ~ 5000 attendees today, 25 technical sessions and it was sponsored by 33 AWS partners. Most sessions which I have attended today had a lot of sponsor content mixed with technical not-too-deep dive into various AWS services.  Sessions were divided into 5 tracks, led by AWS Solution Architects and Sponsors representatives: Big data & Analytics sessions on data ingestion, data transformation and data analysis using AWS services AI and Deep Learning – sessions on AWS offerings for data enrichment and learning models Innovate – Rapid Application Development services Cloud oper