Independent consultant: How to find work
When I talk to people about switching from being a salaried employee to an independent consultant (see my presentation How to...
2014-01-14
1,837 reads
Blog Posts
Laying The Ground For A Successful Reporting Project
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...
2014-01-14 (first published: 2014-01-09)
3,152 reads
One error which you don’t want to see while doing upgrades – Missing MSI !
The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...
2014-01-14
1,210 reads
PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server Login. Regular readers know that I practice the philosophy...
2014-01-14
306 reads
PowerShell – Change SQL Server Login Password
Here’s a quick post detailing a PowerShell script that can be used to change the password for a SQL Server...
2014-01-14
2,274 reads
Sometimes It’s A Dirty Job – #TSQL2sDAY #50
Sometimes being a DBA really stinks. You try to follow best practices in everything you do. You’re not shrinking databases...
2014-01-14
777 reads
SQL in Albuquerque
It’s a little less than two weeks until SQL Saturday #271 – Albuquerque. The second event in that great city, and...
2014-01-14
801 reads
SQL Server Diagnostic Information Queries for January 2014
I spent some time this month to true up the SQL Server 2005 version, with the other versions for the...
2014-01-14
1,060 reads
SQL Server Quick Tip: Growing your database past 2TB on SQL Server 2008
A couple of days ago I had to manually grow the database data file for a client, they do not...
2014-01-14
2,836 reads
Time to Plan For Running For The PASS Board
I know it’s only January, but if you’re at all considering being a candidate you need to get going now....
2014-01-14
434 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