Top 3 Database Life Hacks
Three very powerful but simple hacks that can give you back dozens of minutes per day.
Related Posts:
Best New(ish) SSMS Feature December 26, 2017
Puzzles and Daily Trivia May 14,...
2020-02-12
25 reads
Top 3 Database Life Hacks
Three very powerful but simple hacks that can give you back dozens of minutes per day.
Related Posts:
Best New(ish) SSMS Feature December 26, 2017
Puzzles and Daily Trivia May 14,...
2020-02-24 (first published: 2020-02-12)
1,456 reads
Quick tip: Quickly bulk edit lines in SSMS
Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines? In SQL Server Management...
2020-02-12
4,196 reads
Change Outlook sender mailbox with PowerShell – A workaround
The idea of this blog post, like many others I write, is to document a workaround solution to my problem. Hopefully I can also help someone that may be...
2020-02-21 (first published: 2020-02-12)
3,011 reads
Dealing with rejection
“Dear speaker This serves as notice that your session submission was not selected for our upcoming event. We had a lot of sessions to sort through, and unfortunately there...
2020-02-12
34 reads
Speaking at PSConf EU 2020
I’m proud to announce that I will be speaking at PSConf EU 2020 in Hannover, Germany. The conference runs from 2 June 2020 to 5 June 2020 and brings together...
2020-02-12
11 reads
Speaking at PSConf EU 2020
I’m proud to announce that I will be speaking at PSConf EU 2020 in Hannover, Germany. The conference runs from 2 June 2020 to 5 June 2020 and brings together...
2020-02-12
7 reads
Speaking at PSConf EU 2020
I’m proud to announce that I will be speaking at PSConf EU 2020 in Hannover, Germany. The conference runs from 2 June 2020 to 5 June 2020 and brings together...
2020-02-12
11 reads
Speaking at Data Grillen 2020
I’m proud to announce that I will be speaking at Data Grillen 2020 the conference runs from 28 May 2020 through 29 May 2020.
This is an incredible event packed with fantastic...
2020-02-12
20 reads
Speaking at Data Grillen 2020
I’m proud to announce that I will be speaking at Data Grillen 2020 the conference runs from 28 May 2020 through 29 May 2020. This is an incredible event packed with...
2020-02-12
6 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