SQL
SQL Indexes

SQL Indexes

Understanding Indexes in SQL Server     Get your FREE SQL Index Booklet This booklet is the perfect resource for everyone who wants to get to grips with indexes in SQL. Get your copy today to supercharge your...

How to be a Senior SQL Developer

How to be a Senior SQL Developer

If you're wondering if you have what it takes to be a Senior SQL Developer then this list will clear it up for you. Check out the video for more details. 10 Keys to Success as a Senior SQL Developer Mastery of SQL Syntax and Advanced Query Techniques Proficiency in...

Stop using IsNumeric for data validation

Stop using IsNumeric for data validation

The infamous ISNUMERIC function! It seems helpful at first, but then you wake up…hopefully. Here's why you should ditch ISNUMERIC and join the TRY_CAST crew: ISNUMERIC - Returns true for '+', '-', and '.' - Thinks hexadecimal strings are numeric (um, ok!) - Says...

Can you run SQL Server on a Mac?

Can you run SQL Server on a Mac?

Introduction Apple Silicon, Apple's pioneering venture into ARM-based processors, has been met with widespread acclaim for its impressive performance and power efficiency. However, it is not without its challenges, especially when it comes to compatibility with...

SQL Joins

SQL Joins

Get your FREE SQL Joins Booklet This booklet is the perfect resource for everyone who wants to get to grips with JOINs in SQL. Get your copy today to supercharge your code. When working with relational databases, one of the most powerful features you have at your...

Intro to SQL – Getting started

Intro to SQL – Getting started

This is video 1 of 4 In order to follow this intro, you will need a machine running Windows on Intel based processors. This means: a) Windows running on Mac on Intel based processors will work. b) Windows running on Mac on M Series processors will NOT work because SQL...