The Truth about SQLPS and PowerShell V2
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...
2010-05-28
5,490 reads
With the release of SQL Server 2008 R2 there have been claims that sqlps is really PowerShell V1 under the...
2010-05-28
5,490 reads
If you have experience with the SQL Server Agent you quickly realize the difficulty in managing job schedules. On a...
2010-05-15
4,611 reads
In case you’re wondering about the title T-SQL Tuesday, it’s a monthly collection of SQL Server related content where a...
2010-05-11
3,809 reads
Automating SQL Server Integration Services (SSIS) administration through PowerShell is very different than writing scripts against the core database engine....
2010-04-13
1,184 reads
Visual Studio Team System 2008 Database Edition (VSDB) ships with a .NET class for parsing T-SQL. I’ve previously blogged about...
2010-04-04
2,136 reads
I was interviewed by Jon (@JonWaltz) and Hal (@Halr9000) in episode 106 of the PowerScripting Podcast. This was my second...
2010-03-25
1,917 reads
After blogging on Live Spaces for a 517 days, I’ve made the difficult decision to move to my own domain...
2010-03-25
644 reads
After blogging on Live Spaces for a couple of years, I’ve made the difficult decision to move to my own...
2010-03-21
517 reads
SQL Server Powershell Powershell Extensions (SQLPSX) has been updated to version 2.1. The most notable change is the addition of...
2010-03-10
1,871 reads
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-01
3,145 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