Searching SQL Servers & Saving Results, with Write-SqlTableData
The other day I was chatting with my friend Tom Roush ( B | T ) and he mentioned needing to scan every database on every SQL Server instance...
2016-10-14
71 reads
Aaron Nelson
Get-SqlLogin and Remove-SqlLogin Are Here
Learn how to use the login commands included with SSMS2016 from PowerShell.
2016-09-01
3,444 reads
Next for the PoSh VC: PowerShell, SQL and Power BI
That’s right, PowerShell & Power BI.
How does this work you ask?
Well back in July, Rob Sewell ( b | t ) gave us...
2016-08-12
247 reads
Next for the PoSh VC: PowerShell, SQL and Power BI
That’s right, PowerShell & Power BI. How does this work you ask? Well back in July, Rob Sewell ( b | t ) gave us a preview of this,...
2016-08-12
17 reads
The cmdlets Are Coming! The cmdlets Are Coming!
A number of new SQL Server PowerShell cmdlets have been released and the Microsoft is asking for feedback on what else you'd like to see.
2016-07-01
1,222 reads
Webinar on 25 New PowerShell cmdlets for SQL Server and more!
Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a...
2016-06-30
563 reads
Webinar on 25 New PowerShell cmdlets for SQL Server and more!
Next week Chrissy LeMaire ( b | t ), Laerte Junior ( b | t ), Rob Sewell ( b | t ) and I will be hosting a...
2016-06-30
7 reads
Connect is Working! Get in While the Getting is Good!!!
TL;DR: Go Vote / File on Connect NOW! For years I’ve avoided Connect, it’s true. In an ironic twist fit for a recursive-CTE I think I quit using Connect...
2016-05-07
12 reads
Connect is Working! Get in While the Getting is Good!!!
TL;DR: Go Vote / File on Connect NOW!
For years I’ve avoided Connect, it’s true.
In an ironic twist fit for a recursive-CTE...
2016-05-07
271 reads
What Does the Near-Future of PowerShell & SQL Server Look Like? An Interview with Ken Van Hyning
Ken Van Hyning is the Engineering Manager for the SQL Server tools, including SQLPS.
2016-04-19
1,679 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