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.

Monday morning comic 2018-05-21

by Daniel Janik

Confessions of a Microsoft Addict

I decided to poke fun at ORM tools again this week. Hope you enjoy.

2018-05-21

307 reads

I’m speaking: SQL Saturday Los Angeles 06-09-18

by Daniel Janik

Confessions of a Microsoft Addict

Hello California! I’m headed your way and will be speaking at SQL Saturday #773. The full schedule is live and...

2018-05-14

239 reads

Monday morning comic 2018-05-18

by Daniel Janik

Confessions of a Microsoft Addict

Here’s the first issue of a new Monday morning comic series. Hopefully some of you all get a giggle.

2018-05-14

343 reads

SQL Ops Studio extension development : Starting an adventure

by Daniel Janik

Confessions of a Microsoft Addict

I’ve been in technology a long, long time (more than 2 decades). Over the years, I learned Access which took...

2018-04-26

1,193 reads

SQL Tuning: Finding statements for missing indexes

by Daniel Janik

Confessions of a Microsoft Addict

Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and...

2018-04-20

613 reads

Query tuning: Apply yourself

by Daniel Janik

Confessions of a Microsoft Addict

It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to...

2018-04-16 (first published: 2018-04-06)

3,415 reads

SSMS now has a vulnerability report

by Daniel Janik

Confessions of a Microsoft Addict

Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look...

2018-03-29

431 reads

The best overlooked addition to SQL 2016

by Daniel Janik

Confessions of a Microsoft Addict

Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the...

2018-03-07

369 reads

Classifying your data in Azure SQL DB for GDPR

by Daniel Janik

Confessions of a Microsoft Addict

Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio...

2018-03-06

427 reads

How to classify your data for GDPR

by Daniel Janik

Confessions of a Microsoft Addict

The right to be forgotten. It’s a concept that sounds great for people who are concerned about their personal information...

2018-03-05

502 reads

Blogs

Database AI Agents: The Read-Only Rule

Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...

Creating a SQL Stored Procedure to Load a SCD2

By DataOnWheels

This is a blog that I am writing for future me and hopefully it’ll...

Funny Money: #SQLNewBlogger

While wandering around the documentation looking for some Question of the Day topics, I...

Read the latest Blogs

Forums

Backup Availability Group

Please I am hoping for some feedback Specifications: Windows Server 2022 SQL Server 2022...

How Do the Experts Become Experts?

By Kathi Kellenberger

Comments posted to this topic are about the item How Do the Experts Become...

Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment

By Massimo Preitano

Comments posted to this topic are about the item Stairway to Reliable Database Deployments...

Visit the forum

Question of the Day

Secure Communications

As of June 2026, what is the best version of TLS to use with SQL Server?

See possible answers