SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Confessions of a Microsoft Addict

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.

Archives: September 2016

I’m speaking at SQL PASS 2016 (Speaker Idol)

It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience the abstract process is a true pain. I submit each year and the feedback on my abstracts has not been all that helpful.

As an example I got feedback on… Read more

0 comments, 594 reads

Posted in Confessions of a Microsoft Addict on 29 September 2016

A really simple bug with SSMS

If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know what I mean when I say “Bugs are not a new thing”.

Some bugs are earth shattering others are an annoyance and some just make you chuckle. Luckily this simple… Read more

0 comments, 431 reads

Posted in Confessions of a Microsoft Addict on 28 September 2016

Splitting CSV strings in SQL 2016

Up until SQL Server 2016, we had to write our own functions to split a CSV string into a table list. This was accomplished by writing a table value user defined function.

These functions are sprinkled all over the web and for the most part two examples are given. One… Read more

1 comments, 2,271 reads

Posted in Confessions of a Microsoft Addict on 8 September 2016

Join me and Kalen Delaney today for 24HOP

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

If you’ve never heard of “24 Hours of Pass”, it’s a 24 hour event that for a wide range of SQL Server topics featuring many different speakers. Read more

0 comments, 302 reads

Posted in Confessions of a Microsoft Addict on 7 September 2016