I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM. I'm working as a Database Architecture, Database Optimizer, Database Administrator, Database Developer. Providing the best articles and solutions for different problems in the best manner through my blogs is my passion. I have more than six years of experience with various RDBMS products like MSSQL Server, PostgreSQL, MySQL and currently learning and doing research on BIGData and NoSQL technology. -- Hyderabad, India.
SQL Server 2016 introduced an STRING_SPLIT function to split a string by passing different types of delimiters. Previously, Database developers were doing a string split operation using manual string operation. I also prepared a similar […]
The feature of Contained Databases introduced with SQL Server 2012 and SQL DBAs are using this feature for those databases which are frequently required to move between SQL Server Instances. If you don’t know about […]
In the previous article, I shared a small note on SQL Server 2012 Contained Database. In this script, I am sharing a script to enable Contained Database at an instance level. Without enabling this option, […]
SQL Server 2012 introduced a feature like Contained Database which stores all the metadata information of your database in itself; it is not storing into a master database. If you defined your database as contained […]
In this post, I am providing a solution to split a string by using a different type of delimiters in PostgreSQL. Splitting a string is a very common requirement for all PostgreSQL Database Developers. I […]