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.

Blogs

Basic XML Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Don’t Stop at Just Enabling Read Committed Snapshot Isolation (RCSI)

By

This past week I had a great Client ask an even greater question, and...

Query Compile Time

By

A question that came up recently was how to track the query compile time....

Read the latest Blogs

Forums

Restore WITH RECOVERY freezing on source DB after tail of log backup

By J-M.L

Hello everyone, I've encountered this scenario twice so far and I still don't understand...

SQL SMO property to determine if server is named or default instance

By TangoVictor

I'm using my registered server list to generate a collection of servers in powershell. The...

LATCH_EX when creating a clustered index

By DamianC

Hi   I have a package that runs weekly It has an intermittant problem...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers