PowerShell, the New SQL Hammer
This is my PowerShell presentation that I have given to both Chicago SQL Server User Groups. The name of the presentation is having some fun with the old quote,...
2011-04-17
23 reads
PowerShell, the New SQL Hammer
This is my PowerShell presentation that I have given to both Chicago SQL Server User Groups. The name of the...
2011-04-17
965 reads
Powershell Day 17
Day 17 Advance Mini Shell Mini shell is a good and can be used as a replacement of management studio,...
2011-04-17
419 reads
SSMS Tips & Tricks – Registered Server Groups
Here are a couple more SSMS tricks I’ve stumbled upon recently. Both involve the functionality of registered servers. If you...
2011-04-17
1,614 reads
A SQL Server Hardware Nugget A Day – Day 16
For Day 16 of this series, I want to talk a little bit about the new hardware license limits that...
2011-04-17
760 reads
Powershell Day 16
Day 16 Introduction to Mini Shell Mini Shell or SqlPS is the default shell utility provided by Microsoft to support...
2011-04-16
400 reads
SQL Azure
If you’ve talked to anyone from Microsoft recently you had to have heard the phrase “all in.” It’s been made...
2011-04-15
645 reads
Do you work with data? You’ve always got options.
She's ready for the future. Are you?
In preparing for the SQLPeople event, I thought about the role, motivation, and techniques...
2011-04-15
944 reads
The Pro-Active DBA List Updated
A couple of years back, in the heart of the economic tsunami, I proposed a list of pro-active steps to...
2011-04-15
1,381 reads
A SQL Server Hardware Nugget A Day – Day 15
For Day 15 of this series, I am going to talk about Power Management and its effect on processor performance....
2011-04-15
468 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