Note to Self
Not only should you pay respect to those giving of their time, but you should spend a little time to also give back to the community. I will say...
2019-06-11
6 reads
Blog Posts
The butterfly effect. T-SQL Tuesday #115
This month, our host Mohammad Darab (b/t) has given us an interesting subject. Dear 20 year old self. Where we ... Continue reading
2019-06-11
17 reads
T-SQL Tuesday #115 – Dear 20-Year-Old Self
This month’s T-SQL Tuesday blog is brought to us by Mohammd Dorab (b | t) and this month topic is about what you would tell your 20-year-old self now...
2019-06-11
9 reads
T-SQL Tuesday #115 – Dear 20-Year-Old Self
This month’s T-SQL Tuesday blog is brought to us by Mohammd Dorab (b | t) and this month topic is about what you would tell your 20-year-old self now...
2019-06-11
5 reads
T-SQL Tuesday #115 – Notes to 20 year old Wayne
There’s a lot that goes on in June. From the 75th anniversary of D-Day, Fathers Day, to the official start of summer (though it feels like it already!)....
2019-06-11
9 reads
Using Azure Data Factory Mapping Data Flows to populate Data Vault
(2019-May-24) Data Flow as a data transformation engine has been introduced to the Microsoft Azure Data Factory (ADF) last year as a private feature preview. This privacy restriction has been lifted...
2019-06-11 (first published: 2019-05-24)
3,339 reads
What is the key to automated database deployments?
In my blog post here https://the.agilesql.club/2019/06/what-steps-are-there-to-move-to-safe-automated-database-deployments/ I described the steps you need to go through so you can build up your confidence that you are capable of deploying databases...
2019-06-11
7 reads
What is the key to automated database deployments?
In my blog post here https://the.agilesql.club/blogs/ed-elliott/2019-06-10/steps-to-automated-database-deployments I described the steps you need to go through so you can build up your confidence that you are capable of deploying databases...
2019-06-11
15 reads
Azure Cosmos DB Intro
Cosmos DB falls into the “NoSQL” technology group, call it a buzz word if you like but it is very different to classic Relational Databases such as SQL Server....
2019-06-10
215 reads
Do you have rarely used indexes that are hurting performance of writes?
We know that indexes are necessary for query performance but comes with overhead during DML operations. Usually, the overhead is worth the performance gain we get out of them....
2019-06-10 (first published: 2019-05-21)
866 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers