Category
- AWS – Database (7)
- Helper SQL (16)
- Oracle 12c New Features (10)
- Oracle Internal (53)
- Oracle Performance (4)
- Oracle to (22)
- Oracle to PG migration (38)
- postgresql (23)
- SQL Developer (1)
- SQL Server Learning (22)
- SQLite Learning (1)
-
Join 91 other subscribers
Top Posts & Pages
- Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration
- How to clear screen in PostgreSQL or psql terminal for Mac and Windows
- How to Connect to Oracle Database Through SSH Tunnel Using SQL Developer.
- How to Pad Strings in SQL Server-LPAD/RPAD
- The Differences Between the SUBSTR Functions in Oracle and PostgreSQL: What You Need to Know
- About me
- Postgres boolean data type casting: Unleashing the power of true and false.
- PL/pgSQL Conversion Gotchas: Cursors and Last Fetch.
- PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type.
- Key PostgreSQL Extensions Every Developer Must Know When Migrating from Oracle.
Archives
- May 2024 (1)
- April 2024 (3)
- March 2024 (1)
- February 2024 (1)
- December 2023 (1)
- October 2023 (1)
- June 2023 (1)
- May 2023 (1)
- April 2023 (1)
- February 2023 (1)
- January 2023 (3)
- November 2022 (1)
- July 2022 (1)
- January 2022 (1)
- December 2021 (2)
- November 2021 (1)
- September 2021 (3)
- August 2021 (1)
- May 2021 (1)
- May 2020 (2)
- April 2020 (7)
- February 2020 (1)
- December 2019 (1)
- November 2019 (5)
- October 2019 (4)
- September 2019 (3)
- August 2019 (2)
- March 2019 (2)
- January 2019 (2)
- September 2018 (2)
- April 2018 (1)
- June 2017 (1)
- May 2017 (3)
- April 2017 (4)
- March 2017 (1)
- January 2017 (3)
- December 2016 (10)
- November 2016 (6)
- October 2016 (1)
- August 2016 (1)
- June 2016 (2)
- May 2016 (1)
- February 2016 (1)
- January 2016 (1)
- November 2015 (3)
- September 2015 (1)
- April 2015 (1)
- January 2015 (2)
- December 2014 (5)
- November 2014 (11)
- April 2014 (2)
- March 2014 (1)
-
Recent Posts
- Conversion Gotchas: Implicit Conversion in Oracle to PostgreSQL Migration May 3, 2024
- PL\pgSQL Conversion Gotchas : Functions with Out parameter and return type. April 23, 2024
- PL/pgSQL Conversion Gotchas: Cursors and Last Fetch. April 12, 2024
- PL/pgSQL Conversion Gotchas: How to Handle Conflicting Variables. April 10, 2024
- Why I Love psql – PostgreSQL Terminal. March 5, 2024
- Uncovering and Exploring ROW Constructors in PostgreSQL. February 27, 2024
- Key PostgreSQL Extensions Every Developer Must Know When Migrating from Oracle. December 16, 2023
- PostgreSQL 16 Feature : Sub-Query Aliases and its usage in Code Conversion. October 2, 2023
- Analytical Functions: Count of Distinct in Oracle vs. PostgreSQL June 2, 2023
- Subtle Art of Code Conversion in Oracle to PostgreSQL Migration. May 13, 2023
- Maximizing PostgreSQL’s Charms: A Pattern for Indexes and Skewness When Migrating from Oracle April 2, 2023
- Get the most out of PostgreSQL using psql with must known features. February 14, 2023
Blogs I Follow
- My Big Data World
- kossip - by the people behind Ameyo: On technology and beyond
- Talk Tech With Sonakshi :)
- Learn. Share. Repeat.
- Ardent Performance Computing
- PgCraftsman
- Nivlesh's Blog
- SQL coding questions
- Database Technologies & Cyber Security Platform
- Oguri's blog
- 0BAD-C0DE
- bdt's blog
- Data Warehousing with Oracle
- JingsBlog
- SQL Undercover
- Shraddha's Blog
- Hypnagogic Hallucinations
- SQL with Manoj
- 🛩️ Shane Borden's Technology Blog
- seanstuber
Tag Archives: sql server
Generate Script for Foreign key’s in SQL Server.
During conducting one of the Proof Of Concept around “InMemory“, we had to disable foreign key to use Migration wizard provided by SSMS. Before disable, we had to create script for all foreign key for multiple tables in Database and … Continue reading
Posted in Helper SQL, SQL Server Learning
Tagged alter, create, disable, drop, enable, foreign key, query, script, SQL, sql server
Leave a comment
Aliasing Table in Oracle and SQL Server and interesting difference.
Sometimes we assume things to work and not test it, but it surprise you and give you a reason to learn. We have a product that works on top of both Oracle and SQL Server, hence we are bound to … Continue reading
Posted in Oracle Internal, SQL Server Learning
Tagged alias, ORA-00933, oracle, sql server
1 Comment
CHAR Datatype and ConCat in Oracle and SQL Server.
Char is a Fixed length data type, provided by database to stored Character Data. It will allocate fix bytes as per length specified for CHAR datatype and will pad with Space for remaining chunks. With Variable declare as CHAR(20), Byte … Continue reading
SQL SERVER# : Get last possible time for a DAY.
During one of SQL requirement, was trying to form Range of Years for executing a DML in small batches as per YEAR. But due to missing last possible end time, we were not able to manipulate some records. For instance … Continue reading
Posted in Helper SQL, SQL Server Learning
Tagged DATEADD, last time of day, MS, sql server
Leave a comment
FIXED length character storage and NULL in SQL Server.
Most of us must be aware of CHAR datatype and its fixed length storage pattern. If we declare CHAR(32) and store only 4 bytes character ‘ABCD’, It will pads up remaining bytes (28 bytes). Ultimately, whole bytes is consume for … Continue reading
SQL Server : Value Constructor Insight.
We all must be aware of VALUE Clause for Inserting values specified, in current blob we will explore different ways other then Insert were we can have use VALUE as handy.! 1. Generating Dummy Data! we can use Value to … Continue reading
SQL Server : ExecuteNonQuery shows incorrect rows affected.
For one of client as per functionality we were invoking a SQL Server procedure using ExecuteNonQuery method. Within procedure we had a DML statement performing update and on rows affected as return from ExecuteNonQuery performing further functional stuff. In one … Continue reading
Posted in SQL Server Learning
Tagged ExecuteNonQuery, NOCOUNT, rows affected, sql server
Leave a comment
SQL Server : Get Numeric part from a varchar/string.
Found question to fetch only numeric information from a string/varchar in some of blogs, so thought let try and share my attempt. Implement logic: 1. Using Recursive With clause, segregated each and every character as separate row. 2. Using Regex … Continue reading
Date Generator in SQL Server using Recursive With Clause.
During one of performance analysis, identified lofty insert statements populating static tables with Date information. As part of one of functionality, we were generating dates and applying necessary function on it within date range specified. As part of performance improvement, … Continue reading
Posted in Helper SQL, SQL Server Learning
Tagged date, date generation, function, sql server
Leave a comment
#SQLSERVERLearning : Order By Learning.
Most of folks feel , both(Oracle-SQLServer) are traditional RDBMS database and should or need to work some what “SIMILAR”. But, But when we actually start working on core with queries, development and tuning.We identified a lot of difference between any … Continue reading
Posted in SQL Server Learning
Tagged Distinct, inline views, order by, sql server, Top, XML Path
1 Comment