Articles Posted in the " TSQL Tuesday " Category


  • TSQL Tuesday #93 -Do Not Drive During Interview

    TSQL Tuesday #93 -Do Not Drive During Interview

    I thank Kendra Little (b|t) for hosting TSQL Tuesday #93. Topic for this month Interviewing Patterns & Anti-Patterns. What advice do you have for people preparing for or going through an interview?.

    TSQL2SDAY-300x300

    After initial phone screening I went for in person interview. I was scheduled to meet 5 interviewer. Last person in the list was the manager to whom I will report if I work there. Things went very well with the first 4 interviewer. I was looking forward to meet the manager. I was told the manager is not onsite and they will connect …



  • TSQL Tuesday #88 -Communication is the Key

    TSQL Tuesday #88 -Communication is the Key

    I thank Kennie Nybo Pontoppidan (b|t) for hosting TSQL Tuesday #88. Topic for this month is daily database related WT…….

    TSQL2SDAY-300x300

    Last week I was setting up a collection of wait statistics with five minutes interval using a while loop. I was wrapping up Paul Randal’s (b|t) code from this blog post in a loop and persisting in a table to analyze later.

    I made it a habit in my career to have my peers review my code. I sent my code to one my colleague and asked him to review. Meantime …


  • TSQL Tuesday #79 -JSON Support in SQL 2016

    TSQL Tuesday #79 -JSON Support in SQL 2016

    I thank Michael J Swart (b|t) for hosting TSQL Tuesday #79. Topic for this month is to write about SQL Server 2016. This is my first time joining in TSQL Tuesday and I am excited about it.

    TSQL2SDAY-300x300

    In my workplace we use MongoDB besides SQL Server. MongoDB save documents in binary form of  JSON called BSON. Our developers are excited to see JSON support in SQL 2o16.  I will give some simple examples about JSON support in SQL Server 2016.  Readers need to be aware that SQL Server is not supporting native JSON type.  In …