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

308 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

345 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,196 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

370 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

430 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

503 reads

Blogs

Getting the SQL Server MCP Server Running

If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

By MarlonRibunal

Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...

Rambling about Data on Wheels – origins, branding, expansion

By DataOnWheels

I have been asked many times about how the name “Data on Wheels” came...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Wahid Hasyim Telp:0817825533

By layanan_Bca88

Hub Via Wa:62817825533 Alamat: Jl. K.H. Wahid Hasyim No.183 A-B, RT.14/RW.6, Kb. Kacang, Kecamatan...

Alamat Kantor BCA KCU Thamrin Telp:0817825533

Hub Via Wa:62817825533 Alamat: Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng,...

Alamat Kantor BCA KCU Scbd Telp:0817825533

Hub Via Wa:62817825533 Alamat: Equity Tower, Ground Floor, Unit D & Lantai 8, Unit...

Visit the forum

Question of the Day

DBCC CHECKDB Limits III

On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?

See possible answers