Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether you're in data analysis, data science, or any field that uses data. Trust me, it's...
2024-12-17
68 reads
RealSQLGuy - Helping You To Become A SQL Hero
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the Basic SQL Practice: A Store course – it's totally free for the entire month! This...
2024-12-14
39 reads
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether you're in data analysis, data science, or any field that uses data. Trust me, it's...
2024-12-10
250 reads
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie or already know some SQL, this sale has awesome learning options at prices you won't...
2024-11-26 (first published: 2024-11-25)
17 reads
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie or already know some SQL, this sale has awesome learning options at prices you won't...
2024-11-22
37 reads
SQL from A to Z: Your Path to SQL Mastery this Fall
I'm excited to tell you about the "SQL from A to Z" learning track. This comprehensive program will take you from SQL newbie to pro in no time. It's...
2024-10-28
39 reads
Mastering the ORDER BY Clause in SQL Window Functions
This article provides a comprehensive overview of the ORDER BY clause within SQL window functions. We'll explore how it interacts with PARTITION BY and the standard ORDER BY clause,...
2024-11-11 (first published: 2024-10-24)
619 reads
SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow
Want to build a data analytics foundation that transforms raw data into valuable business insights? Look no further than SQL! It's the perfect tool for creating powerful data pipelines...
2024-11-04 (first published: 2024-10-21)
637 reads
Master SQL with This Free Course (141 Interactive Exercises Included)
SQL is essential for modern businesses and applications that rely on data. It's a robust language that lets you work with databases, pull out the information you need, and...
2024-10-16
118 reads
Want to Supercharge Your Business? SQL is Your Secret Weapon.
Look, we all know data is king these days. But having mountains of data and actually using it to make your business better are two different things. That's where...
2024-10-10
21 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers