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
651 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,088 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,935 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
473 reads
This post is a continuation of Multiple DB refresh automation using PowerShell post . The OP requested me to automate the...
2016-05-23
716 reads
This post demonstrates the methods of PIT recovery of the database. The step by step details of the recovery process...
2016-05-17
2,010 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,758 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
586 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,339 reads
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Comments posted to this topic are about the item The Microsoft SQL Year in...
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Comments posted to this topic are about the item Your Value from a Conference
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers