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
57 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,398 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
236 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
6 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,210 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
549 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
4 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
6 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
265 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,653 reads
Blogs
Advice I Like: Pyramid Schemes
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Forums
Database file shrink issue.
Hi experts, I have a 3+ TB database on a 2019 sql server which...
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers