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.

Not SQL: Taking a stand against scammers

by Daniel Janik

Confessions of a Microsoft Addict

If you’ve read my blog you’ll probably know that I don’t like our lack of forward thinking when it comes...

2017-05-03

542 reads

Query tuning 101: What’s a probe residual?

by Daniel Janik

Confessions of a Microsoft Addict

Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a...

2017-04-26 (first published: 2017-04-17)

3,347 reads

DBA 101: Comparing two SQL plans

by Daniel Janik

Confessions of a Microsoft Addict

Simple post today: How to compare two plans in SSMS.
This task is a task that is often done by a...

2017-04-18 (first published: 2017-04-14)

2,060 reads

Way Off-topic: Why cutting the cord was right for me

by Daniel Janik

Confessions of a Microsoft Addict

FYI: This one is way off topic so don’t expect to find any fancy SQL tips here.
I did it. I...

2017-04-14

499 reads

T-SQL Tuesday: Finding issues with your query plan

by Daniel Janik

Confessions of a Microsoft Addict

This is my first time blogging with a T-SQL Tuesday topic. If you follow my blog you’ve probably noticed that...

2017-04-11

497 reads

Wait Stats, Here and gone again?

by Daniel Janik

Confessions of a Microsoft Addict

Microsoft recently introduced a handy new feature to query plans: waitstats. That’s right, you can get actual runtime waitstats for...

2017-04-05

509 reads

New SSMS bug?

by Daniel Janik

Confessions of a Microsoft Addict

It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory...

2017-03-22

640 reads

DBA 101: Unique Constraint vs Unique Index

by Daniel Janik

Confessions of a Microsoft Addict

Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to...

2017-03-21 (first published: 2017-03-03)

3,579 reads

DBA 101: File growth

by Daniel Janik

Confessions of a Microsoft Addict

Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that...

2017-03-03

482 reads

DBA 101: What you may be missing with “Missing indexes”

by Daniel Janik

Confessions of a Microsoft Addict

If you’ve read my blog, I’m sure by now you know that I have no love for GUI tools. I...

2017-02-15 (first published: 2017-02-08)

3,382 reads

Blogs

Installing and Configuring containerd as a Kubernetes Container Runtime

By Anthony Nocentino

This post shows you how to install containerd as the container runtime for Kubernetes...

It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11

By Randolph West

In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...

Car Update October 2026

This month I want to look at a few of the things I’ve seen...

Read the latest Blogs

Forums

Alamat Telp BCA KCP Citra 2 Ext +62 838-4945-0961

By layanan 24jam BCA

Wa:083849450961 Ruko Citra Garden II, EXT Blok BE 01 A / 01 & 02,...

Alamat BCA KCP Duta Gardenia +62 838-4945-0961

Wa:083849450961 Ruko Duta Garden, Duta Gardenia I Blok B2-B3, RT.001/RW.008, Jurumudi Baru, Kec. Benda,...

Layanan Resmi BCA KCU A. YANI Telp:0821°8200°203

Telp/Wa 628218200203 Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282

Visit the forum

Question of the Day

SQL Server Vector Support II

With regard to SQL Server 2025's Vector support, what is an embedding?

See possible answers