-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Confessions of a Microsoft Addict

Daniel Janik has been supporting SQL Server for 18 years as a DBA, developer, architect, and consultant. He spent six years at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has spoken at several SQL Saturday events across the US and Caribbean and regularly speaks at PASS local chapters.

Archives: August 2017

SQL Server: SARGability

SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know. I plan to do a few blogs on this topic and today marks the first.

What is a Search Argument?

Simply put a SARG is a portion of… Read more

2 comments, 200 reads

Posted in Confessions of a Microsoft Addict on 31 August 2017

SQL Server vs Oracle: Substring

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… Read more

2 comments, 1,537 reads

Posted in Confessions of a Microsoft Addict on 23 August 2017

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… Read more

0 comments, 153 reads

Posted in Confessions of a Microsoft Addict on 16 August 2017

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.

Comparing a column with NULL and replacing with another value is really simple. There are… Read more

3 comments, 1,523 reads

Posted in Confessions of a Microsoft Addict on 16 August 2017

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.

Finishing out the week  I’d like to return to dates and discuss how each platform can create a… Read more

3 comments, 112 reads

Posted in Confessions of a Microsoft Addict on 11 August 2017

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.

Thankfully, someone smart came up with a way to… Read more

1 comments, 69 reads

Posted in Confessions of a Microsoft Addict on 10 August 2017

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

There are a couple different ways to get the top rows in SQL Server. You can either do this by… Read more

0 comments, 83 reads

Posted in Confessions of a Microsoft Addict on 9 August 2017

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.

End of Month

Getting the end of the month is a really important task for any report writer or… Read more

1 comments, 76 reads

Posted in Confessions of a Microsoft Addict on 8 August 2017

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.

Both of these systems use SQL, which is a language used… Read more

1 comments, 71 reads

Posted in Confessions of a Microsoft Addict on 7 August 2017