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,617 reads
Chad Miller
Determining An Enterprise Execution Policy Setting
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,345 reads
Building A PowerShell Module Installer
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,073 reads
SQL Services on Laptop
I run several SQL Server instances on my laptop, however I’ll keep the services shutdown to conserve resources and then...
2010-11-19
400 reads
SQLPSX 2.3 Release
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,156 reads
Scripting Guy Guest Blog Post
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
Using Symlinks in PowerShell Scripts
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,530 reads
Upcoming October Events
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
A Really Simple Data Dictionary
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
SCSUG PowerShell ETL Presentation
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
770 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...