Daniel Janik

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.

Don’t forget to drop your views

by Daniel Janik

Confessions of a Microsoft Addict

I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created...

2017-10-02 (first published: 2017-09-25)

2,786 reads

SQL Server: The danger of large data types

by Daniel Janik

Confessions of a Microsoft Addict

Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data...

2017-09-22

403 reads

Offtopic: Lifehack: Old tech has many purposes

by Daniel Janik

Confessions of a Microsoft Addict

For those that don’t know, I live in Texas. Been here all my life. There are two main things north...

2017-09-15 (first published: 2017-09-11)

1,618 reads

SQL Server: SARGability part 2

by Daniel Janik

Confessions of a Microsoft Addict

In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post...

2017-09-12 (first published: 2017-09-07)

1,753 reads

SQL Server vs Oracle: Substring

by Daniel Janik

Confessions of a Microsoft Addict

Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases...

2017-09-05 (first published: 2017-08-23)

6,614 reads

Thank you for Microsoft MVP

by Daniel Janik

Confessions of a Microsoft Addict

My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification....

2017-09-02

369 reads

SQL Server: SARGability

by Daniel Janik

Confessions of a Microsoft Addict

SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know....

2017-08-31

2,433 reads

SQL Server vs Oracle: How to replace NULL values

by Daniel Janik

Confessions of a Microsoft Addict

It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real...

2017-08-28 (first published: 2017-08-16)

8,361 reads

Learning through gaming a SQL Server tale

by Daniel Janik

Confessions of a Microsoft Addict

I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience...

2017-08-18 (first published: 2017-07-31)

2,410 reads

I’m speaking: SQL Saturday Orlando (Oct 7th 17)

by Daniel Janik

Confessions of a Microsoft Addict

It’s been a while since I’ve done a SQL Saturday and I’m happy to be joining the folks in Orlando...

2017-08-16

297 reads

Blogs

Spark Connect Dotnet November 2024 Where are we?

All Spark Connect Posts Introduction There have been quite a few changes in the last...

A New Word: Ochisia

ochisia – n. the fear that the role you once occupied in someone’s life...

Create a Numbers Table in Power Query

By Koen Verbeeck

This is a quick blog post, mainly so I have the code available if...

Read the latest Blogs

Forums

Pivot Help

Hi Guys I need help pivoting the following SELECT [ID],[code_name],,[retail_price] FROM products 1 |...

Writer methods in PowerQuery (LOL)

I'm using PowerQuery in Excel on my desktop. (Yeah, I know you can do...

Need help with GROUP BY...

Here's my data... I am trying to return total days in status for each...

Visit the forum

Question of the Day

The Density Vector

When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?

See possible answers