Skip to content
  • Home
  • About
  • Resources
  • Twitter
  • LinkedIn
Search
Close

SQL TECH BLOG

Tag: Oracle

SQL Server vs Oracle: Substring

August 23, 2017August 23, 2017 Daniel Janik2 Comments

Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases for a while, I’m sure you’ve had to parse a string and while you’d think these are the same they work a little different and I think Oracle may surprise you a bit.

Read More »

SQL Server vs Oracle: How to replace NULL values

August 16, 2017September 13, 2017 Daniel Janik3 Comments

It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real pain. Don’t worry though there’s a simple solution. Simply replace the NULL value with another.

Read More »

SQL Server vs Oracle: Convert string to date

August 11, 2017August 8, 2017 Daniel Janik3 Comments

Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked at date formatting, end of month, top rows, and pagination.

Read More »

SQL Server vs Oracle: Pagination

August 10, 2017August 7, 2017 Daniel Janik1 Comment

Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing large amounts of data to the application and expecting the application code to figure out which rows it needed to display.

Read More »

SQL Server vs Oracle: Top N rows

August 9, 2017August 9, 2017 Daniel JanikLeave a comment

In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are for retrieving the top number of rows.

Read More »

SQL Server vs Oracle: End of Month

August 8, 2017August 5, 2017 Daniel Janik1 Comment

Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from some time and has only just recently appeared in SQL Server.

Read More »

SQL Server vs Oracle: Date formatting

August 7, 2017August 14, 2017 Daniel Janik1 Comment

Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the other? I’ve decided to start a series comparing these two RDBMS giants and the first topic is date formatting.

Read More »

Welcome to SQLTechBlog.com. We are dedicated to posting high quality news and blogs concerning Microsoft SQL Server.

I'm speaking!

  • 2016-06-11 | SQLSaturday #528 | Curacao
  • 2016-07-14 | Query Plan Analysis | MSSQLTips Webcast
  • 2016-08-06 | SQLSaturday #515 | Baton Rouge
  • 2016-08-13 | SQLSaturday #550 | San Antonio
  • 2016-08-27 | SQLSaturday #553 | Oklahoma City
  • 2016-09-24 | SQLSaturday #563 | Dallas
  • 2016-10-26 | PASS Summit 2016 | Seattle
  • 2017-04-20 | PASS NTSSUG | Dallas
  • 2017-10-07 | SQL Saturday #678 | Orlando
  • 2018-06-09 | SQLSaturday #773 | Los Angeles
  • 2018-06-23 | SQLSaturday #766 | Houston
  • 2018-08-11 | SQLSaturday #749 | Baton Rouge

Other Blogs I like

  • Shane O'Neill
  • SQLKitten.com

Follow me

  • View @SQLSME’s profile on Twitter
  • View sqlsme’s profile on Instagram
  • View danielcjanik’s profile on LinkedIn

Subscribe

RSS Feed

Follow SQL TECH BLOG on WordPress.com

Recent Posts

  • Azure Purview Best Practice: Naming your scans
  • Using PyApacheAtlas to import SQL Server extended properties to Azure Purview
  • AWS Community Builders #AWSCommunity
  • Running SQL Server in Google Cloud Platform
  • Living in the new normal as a data engineer

Tags

#ThanksToAll Administration AWS Azure Best Practice bug? Career Clippy Compliance Data Catalog DBA Development Gaming gdpr Linux Management Studio Monday comic Monitoring Off Topic Oracle PASS Performance Purview Query Plans Query Tuning security Speaking SQLOpsStudio SQL Saturday sql server SQL Server 2016 SQL Server 2017 Storage Tools

Categories

  • Administration
  • Arduino
  • AWS
  • AWSCommunity
  • Azure
  • Azure Data Factory (ADF)
  • Azure Data Studio
  • Career
  • Comic
  • Compliance
  • DBA
  • Development
  • Gaming
  • GCP (Google Cloud Platform)
  • Google
  • Governance
  • Help Wanted
  • IoT
  • Learning
  • life
  • Linux
  • Migration
  • MSDOS
  • Off Topic
  • Oracle
  • Performance
  • PowerShell
  • Purview
  • Python
  • Query Plans
  • Query Tuning
  • security
  • Speaking
  • SQL Saturday
  • sql server
  • SQLOpsStudio
  • Storage
  • Sustainability
  • Thank you
  • Tools
  • Uncategorized

Archives

  • August 2021
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • February 2020
  • May 2019
  • February 2019
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
Blog at WordPress.com.
Back to top
  • Follow Following
    • SQL TECH BLOG
    • Join 67 other followers
    • Already have a WordPress.com account? Log in now.
    • SQL TECH BLOG
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar