Understanding Indexes in SQL Server Today, we're exploring the vital topic of indexes in SQL Server. Indexes are crucial for database performance, and understanding them can greatly improve your efficiency in...
SQL
Working with XML Data in T-SQL: Marvel Movies Example
XML (eXtensible Markup Language) remains a powerful and popular format for storing and exchanging structured data. In this blog post, we’ll explore how to work with XML data in T-SQL using an example that features Marvel movies and their directors. We'll cover how to...
Stored Procedures vs Functions
Stored procedures and functions are both important concepts in SQL used to encapsulate and reuse code. Many people don't seem to know the difference between the 2. I've realised that from interviewing many many people and asking them to explain the differences. Here...
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...