spark-dotnet how to manually break a file into rows and columns
I found this question on stack overflow that went something like this:
“I have a file that includes line endings in the wrong place and I need to parse the...
2019-08-06
14 reads
spark-dotnet how to manually break a file into rows and columns
I found this question on stack overflow that went something like this:
“I have a file that includes line endings in the wrong place and I need to parse the...
2019-08-06
17 reads
A Day in the Life (4/?) - August 2, 2019
This is my fourth installment in a series responding to Steve Jones’s (blog | twitter) #SQLCareer challenge. I jotted down most of what I did through the day, filling...
2019-08-06
14 reads
Feature Restrictions in SQL Server 2019 are Worse Than Useless: a False Sense of Security And Wasted Opportunity
A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.… Continue reading Feature Restrictions in...
2019-08-19 (first published: 2019-08-05)
1,308 reads
Running Containers In a Virtual Machine
The more you work with containers, the more you just want to work with containers. However, there are still reasons to have a virtual machine for some types of...
2019-08-15 (first published: 2019-08-05)
327 reads
SQL Homework – August 2019 – Getting the data out
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-08-16 (first published: 2019-08-05)
326 reads
David's book: Putting Your Head in the Clouds
I have had a few people contact me over the last few weeks asking if David’s ebook “Putting Your Head in the Clouds” is still available. The short answer...
2019-08-15 (first published: 2019-08-05)
287 reads
SSMS Keyboard Shortcut Fun
Andrea Allred (@RoyalSQL) just gave her SQL tips and tricks session at SQL Saturday Salt Lake City, and a great time was had by all! I learned some things...
2019-08-03
58 reads
PASS.ORG–MS Renews #SQLSat Sponsorship and More…
The recent blog post on PASS.org announces that Microsoft has renewed its sponsorship of SQLSaturday events. They are even, at the own discretion, sponsor individual events with more money...
2019-08-03
35 reads
Getting Downtime
It’s been a crazy year, as are many of my years. I tend to like that, because I prefer to be busy rather than idle. That’s good, but I...
2019-08-02
19 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