-->
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: July 2017

Need to output CSV, TSV, or other?

Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017 we get a new native function to do exactly that. Specify a delimiter and you get a delimited list.

SQL 2016 brought us a native function for parsing a CSV… Read more

1 comments, 108 reads

Posted in Confessions of a Microsoft Addict on 31 July 2017

Learning through gaming a SQL Server tale

I’ve been teaching my 17 yr old SQL Server and other various topics. I have quite a bit of experience training technology and speaking but it never fails; after about 5 minutes his eyes glaze over and he nods and “umhums” and then starts checking his phone.

 

Maybe technology… Read more

3 comments, 1,802 reads

Posted in Confessions of a Microsoft Addict on 31 July 2017

Off Topic: Dream Car Garage: 6 Cars, $250k

I was reading Brent’s blog today and decided to make my own $250k dream car garage list. Mostly because I think about this topic a lot and probably spend way too much time researching cars I’ll never own. But you never know!

 

I wanted to differ a bit from… Read more

3 comments, 96 reads

Posted in Confessions of a Microsoft Addict on 18 July 2017

How to display more text in SSMS

Today’s blog post is going to be a short one but can be very helpful if you’re new to SQL Server. From time to time you may find the need to use the text result instead of the default grid result. You can change this by using CTRL-T for text… Read more

0 comments, 2,662 reads

Posted in Confessions of a Microsoft Addict on 14 July 2017