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.
Tag: DBA
I’m speaking: SQL Saturday Orlando (Oct 7th 17)
It’s been a while since I’ve done a SQL Saturday and I’m happy to be joining the folks in Orlando again this year. I spoke there a couple years ago and had a great time so I’m sure this will not disappoint.
If you happen to be headed to the Orlando, FL area in October, you’ll want to check out this totally FREE SQL Server training event. There are a lot of great speakers and plenty of awesome topics!
For more details check out my session here:
A DBA’s guide to whole stack performance troubleshooting
http://www.sqlsaturday.com/678/Sessions/Details.aspx?sid=66517
and the SQL Saturday Orlando schedule here:
http://www.sqlsaturday.com/678/Sessions/Schedule.aspx
I hope to see you there!
SQL Server vs Oracle: How to replace NULL values
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.
SQL Server vs Oracle: Convert string to date
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.
SQL Server vs Oracle: Pagination
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.
SQL Server vs Oracle: Top N rows
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.
SQL Server vs Oracle: End of Month
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.
SQL Server vs Oracle: Date formatting
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.
Reading the log on SQL for Linux
The SQL Server errorlog is a really helpful place to find all sorts of fun facts about your SQL Server instance. As last checked today (6/29/2017) the latest CTP build seems to have problems reading the log.
DBA 101: Tuning lookups
Sometimes it helps to go back to the basics and indexing is always a great topic. SQL Server has a wide variety of indexes; but, today we’re going classic and talking about Non-clustered indexes.
