This article talks about the commonly used scenarios of SQL Select Distinct in an easily understandable format equally suitable for beginners and professionals.Read more »
- Common use cases of SQL SELECT Distinct - February 2, 2023
- Why do we need Correlated Subqueries in SQL - December 9, 2022
- Problem solving database or data warehouse production issues with PRIDESTES DEPLOY Principle - July 5, 2022
This article speaks about correlated subquery and why we need it when querying a SQL database.
Additionally, we are going to understand the difference between simple subqueries and correlated subqueries with the help of some easily understandable examples.Read more »
This article talks about a golden rule called PRIDESTES DEPLOY to sort out any SQL BI (business intelligence) related issue and it is particularly useful for resolving database, data warehouse or even reporting related issues where the database is built through modern tools like Azure Data Studio.Read more »
This article talks about centralizing reference tables in Azure Data Studio during the database development process for ease of deployments to multiple environments such as dev, test and production.Read more »
This article teaches how to migrate a lightweight on-premises SQL database to an Azure SQL database using Azure Data Studio.Read more »
This article talks about the steps required to add and use the DB Snapshot Creator extension in Azure Data Studio.Read more »
This article is all about declarative database development using Azure Data Studio for both beginners and professionals who are new to it.Read more »
This article is focused on installing and using SQL Server DACPAC Extension in Azure Data Studio.Read more »
This article talks about unit testing SQL database in Azure Data Studio using the tSQLt testing framework.Read more »
This article talks about the two standard ways of building SQL Database Projects in Azure Data Studio along with the simple steps of implementation.Read more »
This article talks about multiple ways to install tSQLt for SQL unit testing database projects managed through SQL Server Data Tools (SSDT).Read more »
This article talks about test-driven database hotfix development using a very productive database testing framework called tSQLt applying the same SQL unit test based approach.Read more »
This article talks about getting your database hotfixes tested with tSQLt provided they do not have any inherited complexities or dependencies on things other than SQL database.Read more »
This is the second part of a conceptual article for data professionals and enthusiasts interested to work on a test-driven data warehouse development concept by using tSQLt an industry recognized SQL unit testing framework.Read more »
This is a conceptual article consisting of two parts with enough supported material for any data professional or enthusiast with databases or data warehouse development background willing to go a step ahead by using an industry-recognized SQL unit testing framework called tSQLt.Read more »
This article talks about basic concepts of SQL unit testing from a Data Warehouse point of view using tSQLt, a highly productive and acclaimed SQL unit testing framework.Read more »
This article gives hands-on experience of writing basic utility procedures and creating their SQL unit tests using tSQLt an advanced SQL unit testing framework.Read more »
This article talks about the three standard SQL unit tests which can be written against any stored procedure ultimately becoming SQL unit testing object to meet internal or external business specification.
This article is focussed on clever database object naming from both development and SQL unit testing point of view.
This article also highlights the importance of naming database objects going through different development transitions including the SQL unit testing phase due to the agile nature of requirements.Read more »
This SQL unit testing article is based on the fact that we often learn from the mistakes so the idea is to highlight the mistakes to understand them clearly so that they can be avoided straight away.Read more »
This article talks about core concepts of test-driven database development followed by creating simple SQL unit tests with tSQLt based on this approach.Read more »
This article is about basics of conventional SQL unit testing concepts and its implementation through tSQLt, a highly acclaimed SQL unit testing framework because of being written in T-SQL and its built-in design support for SQL SQL unit testing needs ranging from simple to complex scenarios.
This article is an overview of tSQLt, which is one of the best SQL unit testing frameworks, due to number of reasons, including the ease of writing unit tests in the same language (T-SQL) in which the database objects themselves are written.Read more »