PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually...
2011-01-20
1,204 reads
SQLvariant
PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually means something to a SQL person whenever we ca. ...
2011-01-20
9 reads
PowerShell Week at SQL University – Post 4
Recap
So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using...
2011-01-18
1,373 reads
PowerShell Week at SQL University – Post 4
Recap So far we’ve walked though how to turn on PowerShell and add modules, adding SQL Server 2008 snapins and using PowerShell variables, what cmdlets and functions are, what...
2011-01-18
26 reads
PowerShell Week at SQL University – Post 3
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
813 reads
PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers
What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and...
2010-05-20
1,283 reads
PowerShell Week at SQL University – Post 3: Providers, PSDrive
Providers What are Providers? Providers in PowerShell are a hierarchical namespace way flattening out an infrastructure to make it accessible and traverse-able just like a directory structure hard drive....
2010-05-20
21 reads
PowerShell Week at SQL University – Post 2
Cmdlets, Functions and Snapins
So far we’ve learned how to open up PowerShell and add on to it with some modules;...
2010-05-19
1,072 reads
PowerShell Week at SQL University – Post 1
Getting Started With PowerShell Variables
Yesterday we laid the ground work for PowerShell Week. Today we will learn about Variables in PowerShell. You will...
2010-05-18
996 reads
PowerShell Week at SQL University – Post 0
Welcome to PowerShell Week at SQL University. For regulars at SQLvariant, SQL University is something Jorge Segarra organized to get...
2010-05-17
1,062 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