Executing PowerShell in SQL Server Redux
A while ago I blogged about using xp_cmdshell to execute a PowerShell script in SQL Server and return a result...
2010-11-30
1,616 reads
A while ago I blogged about using xp_cmdshell to execute a PowerShell script in SQL Server and return a result...
2010-11-30
1,616 reads
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,343 reads
As part of the 2.3 build of SQLPSX I built an MSI based installer to package all 10 SQLPSX modules....
2010-11-23
2,069 reads
I run several SQL Server instances on my laptop, however I’ll keep the services shutdown to conserve resources and then...
2010-11-19
399 reads
Just in time for PASS Summit 2010, the CodePlex project SQL Server PowerShell Extensions (SQLPSX) has been updated . Here’s a...
2010-11-06
2,155 reads
Ed Wilson (Blog|Twitter) aka Scripting Guy is kicking off a SQL Server week (Nov 1st 2010) with my guest blog...
2010-11-02
579 reads
Symlinks are heavily used in Linux/Unix environments to provide an abstraction for file and directory locations and with the introduction...
2010-10-15
1,529 reads
During October I’ll be presenting at several online and in-person events
LocationDateSessionSQL Saturday #49 Orlando 2010Oct 16th ETL with PowerShellPASS PowerShell...
2010-10-06
843 reads
Last month I sat down with Blain Barton and TechNet Edge in an interview (Blain Barton Interviews Raymond James Chad...
2010-08-26
724 reads
My thanks to everyone at the Space Coast SQL Server User Group for inviting me to speak. Feel free to post questions...
2010-08-13
769 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc] AS SELECT Consumer_ID , Trend_Category , Bit_Trace FROM NewWorldDB.dbo.MarketTrend; GOSee possible answers