-->
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.

Offtopic: Lifehack: Old tech has many purposes

For those that don’t know, I live in Texas. Been here all my life. There are two main things north Texans worry about from mother nature: Tornados & Hail.

Hail has damaged quite a bit throughout my life. Mainly just cars and roofs but lawn furniture and windows are in… Read more

1 comments, 1,137 reads

Posted in Confessions of a Microsoft Addict on 11 September 2017

SQL Server: SARGability part 2

In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post continues the series and today we’re going to discuss the dangers of functions.

Recently, I’ve seen several customers that have been placing functions around columns in the WHERE clause.… Read more

1 comments, 1,365 reads

Posted in Confessions of a Microsoft Addict on 7 September 2017

Thank you for Microsoft MVP

My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification. At first I thought it was spam and then I did a double take.

It was a thank you from Microsoft and notification that I was awarded MVP for 2017-2018!… Read more

2 comments, 184 reads

Posted in Confessions of a Microsoft Addict on 2 September 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, 153 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,432 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, 133 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,449 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, 82 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, 52 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, 63 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, 55 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, 55 reads

Posted in Confessions of a Microsoft Addict on 7 August 2017

Need to output CSV, TSV, or other?

Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017 we get a new native function to do exactly that. Specify a delimiter and you get a delimited list.

SQL 2016 brought us a native function for parsing a CSV… Read more

1 comments, 54 reads

Posted in Confessions of a Microsoft Addict on 31 July 2017

Learning through gaming a SQL Server tale

I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience training technology and speaking but it never fails; after about 5 minutes his eyes glaze over and he nods and “umhums” and then starts checking his phone.

 

Maybe technology… Read more

3 comments, 1,646 reads

Posted in Confessions of a Microsoft Addict on 31 July 2017

Off Topic: Dream Car Garage: 6 Cars, $250k

I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I think about this topic a lot and probably spend way too much time researching cars I’ll never own. But you never know!

 

I wanted to differ a bit from… Read more

3 comments, 57 reads

Posted in Confessions of a Microsoft Addict on 18 July 2017

How to display more text in SSMS

Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL Server. From time to time you may find the need to use the text result instead of the default grid result. You can change this by using CTRL-T for text… Read more

0 comments, 2,551 reads

Posted in Confessions of a Microsoft Addict on 14 July 2017

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.

This can be a problem when trying to diagnose an issue. Here’s what… Read more

0 comments, 413 reads

Posted in Confessions of a Microsoft Addict on 29 June 2017

1 year of blogging

It’s hard to believe but a full year has now passed as of today. It’s my blogoversery! Can that be a word? Someone hash tag it please.

To date, I have just under 15,000 views and have touched 112 countries around the world! I couldn’t be more excited and wanted… Read more

2 comments, 267 reads

Posted in Confessions of a Microsoft Addict on 22 June 2017

Access to SQL Server is finally coming

Imagine a world where one of the software giants releases their brand new operating system and a new application architecture that doesn’t allow developers to natively connect to a database. Sounds silly right?

It may sound silly but it’s our world. It’s the “right now”.  It started with Windows 8,… Read more

1 comments, 432 reads

Posted in Confessions of a Microsoft Addict on 9 June 2017

Time saving trick for PowerShell and CMD

Real quick and simple post for today. Having grown up with a computer since the 80’s, I can tell you I still love DOS. In fact, I even have MS DOS mobile on my #WindowsPhone.

I have years of experience crafting batch files, playing of BBS sites before the… Read more

0 comments, 316 reads

Posted in Confessions of a Microsoft Addict on 8 June 2017

Older posts