Tags » 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. 83 more words

Sql Server

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. 339 more words

Sql Server

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… 415 more words

Sql Server

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. 321 more words

Sql Server

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. 346 more words

Sql Server

Perform Failover testing Postgresql replication

On this article i will show the failover testing postgresql replication with repmgr, repmgr already configure automatic failover, reference from this article

Begin failover

Stop service postgresql on master node… 1,272 more words


Setup a Simple Transactional Replication lab

At work we lost our super star DBA some months back, and though he is sorely missed, this has created opportunities for me to grow in my SQL Server knowledge. 1,402 more words