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: September 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,716 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, 337 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,532 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,665 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, 341 reads

Posted in Confessions of a Microsoft Addict on 2 September 2017