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,626 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,359 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,102 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
407 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,161 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
583 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,536 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
848 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
733 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
773 reads
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers