A Month of PowerShell – Day 15 (Databases: Adding Foreign Keys)
Welcome to Day 15 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-15
733 reads
A Discussion of SQL Server-Related Topics
A Month of PowerShell – Day 14 (Databases: Altering Tables)
Welcome to Day 14 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-14
2,145 reads
A Month of PowerShell – Day 13 (Databases: Adding Schemas, Tables and Indexes)
Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-20 (first published: 2013-02-13)
2,964 reads
A Month of PowerShell – Day 12 (Logins, Users and Roles)
Welcome to Day 12 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-12
1,338 reads
A Month of PowerShell – Day 11 (SMO: Databases)
Welcome to Day 11 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-11
4,768 reads
A Month of PowerShell – Day 10 (Navigating SMO collections)
Welcome to Day 10 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-13 (first published: 2013-02-10)
2,729 reads
A Month of PowerShell – Day 9 (Getting Started with SMO)
Welcome to Day 9 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-09
6,056 reads
A Month of PowerShell – Day 8 (Working with Snippets in the ISE)
Welcome to Day 8 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-08
701 reads
A Month of PowerShell – Day 7 (Script Input/Output)
Welcome to Day 7 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-07
1,867 reads
A Month of PowerShell – Day 6 (Exporting and Importing)
Welcome to Day 6 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-06
794 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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