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.

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

370 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

3,444 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)

9,111 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,424 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

298 reads

SQL Server vs Oracle: Convert string to date

by Daniel Janik

Confessions of a Microsoft Addict

Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked...

2017-08-11

795 reads

SQL Server vs Oracle: Pagination

by Daniel Janik

Confessions of a Microsoft Addict

Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing...

2017-08-10

397 reads

SQL Server vs Oracle: Top N rows

by Daniel Janik

Confessions of a Microsoft Addict

In today’s continuation of the SQL / Oracle series, I thought it’d be nice to show how different the two are...

2017-08-09

293 reads

SQL Server vs Oracle: End of Month

by Daniel Janik

Confessions of a Microsoft Addict

Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from...

2017-08-08

296 reads

SQL Server vs Oracle: Date formatting

by Daniel Janik

Confessions of a Microsoft Addict

Are you a DBA and just inherited a SQL Server or Oracle database? Are you migrating from one or the...

2017-08-07

301 reads

Blogs

Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation

Change is inevitable. What separates thriving organizations from those that falter is not the...

The End of Year Vacation Burn

It’s been a good year for me. With my sabbatical, I felt like I’ve...

Speaking at PASS Summit 2025

In less than one month, I will be speaking not once but twice at...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Powershell script to generate SQL server Inventory in CSV format

By Srinivas Merugu

Comments posted to this topic are about the item Powershell script to generate SQL...

Database Ledger in SQL Server 2022

By Deepam Ghosh

Comments posted to this topic are about the item Database Ledger in SQL Server...

Visit the forum

Question of the Day

Azure SQL Database MAXDOP

When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?

See possible answers