In this blog post I am going to focus on a performance comparison between temporary tables and table variables...

Today I'll be providing you with a T-SQL script that generates various permutations and variations of common and weak passwords and uses...

If you are an R&D business working with SQL Databases, and your database developers are still stuck in the 90's, then this is for you...

This article explains what an Azure Synapse Serverless SQL Pool is all about, and why you should consider using it...

If you work with a SQL Server instance or an Azure SQL Managed Instance, then you might need to collect database information...

PostgreSQL is an open-sourced, feature rich and extendable relational database that handles high concurrency workloads easily. It...

MySQL is an open-source relational database that is widely used for web applications, it’s easy to use, reliable, secure, and fast....

Leave your peers awe-struck using the "magic trick" of Hypothetical Indexes in SQL Server

A few days ago, I helped one of my customers with a cyber security review questionnaire. One of the sections asked about the guest users...

This series of articles will cover the first steps you should take when entering a new environment, aiming to improve overall...