Recently got a question regarding PowerShell installation hence this post took an existence.
How to Install PowerShell various versions
http://technet.microsoft.com/en-us/library/hh847837.aspx
http://social.technet.microsoft.com/wiki/contents/articles/21016.how-to-install-windows-powershell-4-0.aspx
Can we have...
2016-06-06
648 reads
Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a...
2016-06-02 (first published: 2016-05-28)
4,070 reads
I was working on generating scripts for logins, users and server roles and I could able to to generate scripts...
2016-06-01
630 reads
“The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)” error may occurs when executing PowerShell scripts using WMI query.
There can...
2016-05-25
2,777 reads
Convert the XML document to JSON document example
<person>
<name>John</name>
<age>25</age>
<address>
<city>New York</city>
<postalCode>10021</postalCode>
</address>
<phones>
<phone type="home">212-555-1234</phone>
<phone type="mobile">646-555-1234</phone>
...
2016-05-24
465 reads
This post is a continuation of Multiple DB refresh automation using PowerShell post . The OP requested me to automate the...
2016-05-23
675 reads
This post demonstrates the methods of PIT recovery of the database. The step by step details of the recovery process...
2016-05-17
1,973 reads
.SYNOPSIS
The purpose of the script is to restore database/s from a database backup. The requirement is to refresh ‘n’ databases.
.DESCRIPTION
The...
2016-05-12
1,749 reads
<#
.SYNOPSIS
The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh...
2016-05-11
580 reads
I have recently experienced an issue with a third-party backup application (Commvault) that was trying to backup the databases from...
2016-05-09
3,329 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Dipping my toes into the waters of Azure and of course before I get...
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
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;
GO See possible answers