Skip to content

Category: T-SQL Tuesday

T-SQL Tuesday #156 – Production Grade Code

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this fantastic initiative. This month’s topic has been chosen by Tom Jones (blog, Twitter), “Which quality makes code production grade?“ My Contribution When I first thought about this topic, I didn’t have any clue what to write… Then, I started to think about what I’m always doing while I’m developing and eventually before I publish the code to production.…

T-SQL Tuesday #155: Dynamic Code

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this fantastic initiative. This month’s topic has been chosen by Steve Jones (blog, Twitter), “Where have you used Dynamic SQL for in the past?“ My Contribution In the past 10 years, I have used dynamic SQL several times in specific use cases. In this blog post, I will describe the use cases I can remember. The first time I…

T-SQL Tuesday #154: SQL Server 2022

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this amazing initiative. This month’s topic has been chosen by Glenn Berry (blog, Twitter), “What have you been doing with SQL Server 2022?“ My SQL Server 2022 Journey Near the end of May 2022, SQL Server 2022 Public Preview was announced, a day after I heard, I downloaded the installer and installed SQL Server 2022 locally to play around.…

T-SQL Tuesday #153: The Conference That Changed Everything For Me

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this amazing initiative. This month’s topic has been chosen by Kevin Kline (blog, Twitter), “Tell us the story of how attending an IT conference or event resulted in an amazing career or life opportunity.“ My Story In the past couple of years, I became more active in the data community. First, as an attendee where I visited a couple…

T-SQL Tuesday #151: Coding Standards

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Steve Jones (blog, Twitter) is currently maintaining this amazing initiative. This month’s topic has been chosen by Mala Mahadevan (blog, Twitter), “What are the T-SQL coding rules that are appropriate for where you work and what you do? If there are exceptions to those rules, state them too!“ Applying Coding Standards When executing development with multiple developers, a coding standard is a must-have. Though, having one…

T-SQL Tuesday #150: My First Technical Job

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Currently, Steve Jones (blog, Twitter) is maintaining this amazing initiative. This month’s topic has been chosen by Kenneth Fisher (blog, Twitter), “What was your first technical job?” My first technical Job After finishing University College in June 2013, I started as an Operational Data Analyst for a Belgian online gaming company. The company where I started did not have a data warehouse, nor any automated reporting…

T-SQL Tuesday #149: T-SQL Advice you’d give your younger self

T-SQL Tuesday is the brainchild of Adam Machanic (blog). Currently, Steve Jones (blog, Twitter) is maintaining this amazing initiative. This month’s topic has been chosen by Camila Henrique (blog ), “If you could give advice about T-SQL to your younger self what would you say? My advice to share To be fair, when I saw the T-SQL Tuesday invitation, my first thought was, hmm I wouldn’t know what to advise. So before I wrote this…