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...
Stored Procedures vs Functions
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
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?
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...
Intro to SQL – More functions (4 of 4)
Intro to SQL – Views and Stored Procedures (3 of 4)
Intro to SQL – CREATE, SELECT, INSERT, UPDATE DELETE (2 of 4)
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
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...