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

How to be a successful innovator

Let’s say you have some obscure list of career goals for the year and one of those is to be a champion of innovation. I’m sure many of you reading this have probably run across goals like this before. I see a lot of people struggle with larger companies and… Read more

0 comments, 121 reads

Posted in Confessions of a Microsoft Addict on 9 November 2017

Always update your views

I last posted about changing a table without changing a view that represents the table and how this may affect the view.

In today’s quick post I’d like to show another issue brought about by not maintaining your views.

In case you missed the last post you can find it… Read more

1 comments, 129 reads

Posted in Confessions of a Microsoft Addict on 3 October 2017

Don’t forget to drop your views

I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created a “history” table. This was before temporal tables came out in SQL.

The history table and associated table were paired together so when a change is made to an account… Read more

4 comments, 2,488 reads

Posted in Confessions of a Microsoft Addict on 25 September 2017

SQL Server: The danger of large data types

Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.

Watch towers go on the corners, barracks go somewhere over there,… Read more

1 comments, 192 reads

Posted in Confessions of a Microsoft Addict on 22 September 2017

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,253 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,480 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, 222 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, 223 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,581 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, 163 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,566 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, 139 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, 75 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, 92 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, 92 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, 85 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, 95 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,777 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, 82 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,639 reads

Posted in Confessions of a Microsoft Addict on 14 July 2017

Older posts