The Best “Management Lessons” Story You’ll Ever Read
Such as: Often, the best candidate for a given job isn’t the person who’s most skilled at fulfilling its primary...
2014-02-12
263 reads
Blog Posts
Time Management: Strategies for CEOs and CFOs In the Midmarket
Time management resources for CEOs and CFOs
1. “An Approach To Developing People.”
One way to gain more time is to properly...
2014-02-12
358 reads
Winner – Conference Pass to #SQLServerLive in Las Vegas
This is a quick post to announce the winner of my blog giveaway for a free conference pass to SQL Server Live! in Las Vegas.
Those...
2014-02-12
726 reads
Winner – Conference Pass to #SQLServerLive in Las Vegas
This is a quick post to announce the winner of my blog giveaway for a free conference pass to SQL Server Live! in Las Vegas. Those rather nice folks at SQL Server Live are also offering...
2014-02-12
17 reads
#TSQL2sDay – Data marts across a shaky WAN link
It sounded good in principle, especially given the requirements and the limitations:
We needed our various sites to be able to...
2014-02-11
710 reads
[SQL Snacks Video] The What, Why, and How of Instant File Initialization with SQL Server
Instant File Initialization (IFI) is an interesting topic with regards to how SQL Server works with storage. It is an...
2014-02-11
647 reads
175 Analytic and Data Science Web Sites #bigdata #freedata #analytics #datascience
Following is a list (in alphabetical order) of top domains related to analytics, data science or big data, based on...
2014-02-11
455 reads
8 Proven Steps to Starting a Big Data Analytics Project #bigdata #analytics
AN EIGHT-STEP APPROACH TO A BIG DATA ANALYTICS PROJECT
We’ve created a high-level list that speaks to 8 different steps to...
2014-02-11
761 reads
Book Review: The Phoenix Project
Let’s get this straight right up front, the thought of reading a novel that’s about IT is so repellent, so...
2014-02-11 (first published: 2014-02-05)
1,933 reads
Calculating the length of a hash in SQL Server
Some time ago I added a script component to a few SSIS packages to compare rows with each other using...
2014-02-11
2,590 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