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.

A really simple bug with SSMS

by Daniel Janik

Confessions of a Microsoft Addict

If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know...

2016-09-28

552 reads

Splitting CSV strings in SQL 2016

by Daniel Janik

Confessions of a Microsoft Addict

Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table...

2016-09-15 (first published: 2016-09-08)

2,751 reads

Join me and Kalen Delaney today for 24HOP

by Daniel Janik

Confessions of a Microsoft Addict

I’m excited to be monitoring Kalen’s session on concurrency. The session is today and is titled “Locking, Blocking, Versions: Concurrency...

2016-09-07

356 reads

When should I use a CTE?

by Daniel Janik

Confessions of a Microsoft Addict

If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d...

2016-08-27

782 reads

I’m speaking at SQL Saturday 563 in Dallas

by Daniel Janik

Confessions of a Microsoft Addict

This will be my second time speaking at SQL Saturday in Dallas. My first was last year and it was...

2016-08-25

443 reads

Using PowerShell to find Processor issues & more

by Daniel Janik

Confessions of a Microsoft Addict

One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second...

2016-08-18 (first published: 2016-08-11)

2,162 reads

I’m speaking at SQL Saturday 553 in Oklahoma City

by Daniel Janik

Confessions of a Microsoft Addict

This will be my first time speaking in Oklahoma on 8/27 in Oklahoma City. I’ve been to several customers there...

2016-08-16

521 reads

Inside the mind of a c# developer

by Daniel Janik

Confessions of a Microsoft Addict

I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different...

2016-08-10

635 reads

Off-Topic: Phone number spoofing. Why is this still a thing?

by Daniel Janik

Confessions of a Microsoft Addict

A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial...

2016-07-29

921 reads

SQL Server 2016 FK operator bug?

by Daniel Janik

Confessions of a Microsoft Addict

I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....

2016-07-29 (first published: 2016-07-25)

2,039 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

PostgreSQL 19 Is Late

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PostgreSQL 19 Is Late

Hyperscale Replicas V

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas V

A Heavy Heart

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Heavy Heart

Visit the forum

Question of the Day

Hyperscale Replicas V

I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?

See possible answers