Free SQL Book!!!
Akeel Din has written an introductory SQL book that is available for free in PDF form. It's also available in print from Amazon if you like holding something real in your hands.
2004-09-28
6,070 reads
Additional Articles
Difference between dates: Time Format
This function returns the difference between dates in the HH:MM:SS format.
2004-09-27 (first published: 2004-03-08)
105 reads
Dimensional Databases: Building A Data Warehouse
A basic look at how you can start to build a data warehouse. This has some basics you need to do the design of the various fact and dimension tables.
2004-09-27
5,004 reads
2004-09-25
72 reads
2004-09-25
56 reads
2004-09-25
579 reads
2004-09-25
75 reads
spilt function
Many a times we need to split a string into its indivisual words and return a array like the Split function of Visal Basic which accepts a delimeter. Here is a script which assumes the delimeter to be the space character and works in a similar method.
2004-09-24 (first published: 2004-03-25)
153 reads
Not All SQL Server Indexes Are Created Equal
Just because a column has an index doesn't mean the SQL Server Query Analyzer will use it. Learn how to create indexes SQL Server will use.
2004-09-24 (first published: 2001-04-22)
4,826 reads
Systems Thinking
J.D. Edwards was big on Systems Thinking, a way of looking at your systems and improving their functions. It was applied it to IT to become one of the top IT organizations to work for. Read some of these articles for an overview of how this works.
2004-09-24
2,685 reads
Blogs
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Forums
Crosstabs and Pre-Aggregations - Reporting on Steroids by Jeff Moden
The LA Data Platform User Group had a necessary speaker cancellation for the group...
How Many Can Be the Greatest
Comments posted to this topic are about the item How Many Can Be the...
How to process images and analyze charts with AI
Comments posted to this topic are about the item How to process images and...
Question of the Day
How Many Can Be the Greatest
I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this:
select GREATEST( col1, col2, col3, ...)See possible answers