Randy

Joined: June 26, 2022
Articles: 15
Comments: 1

PowerShell

POWERSHELL – RUN INVOKE-SQLCMD

The Code

try
{
Invoke-Sqlcmd -ServerInstance ServerName -Database DatabaseName -Query 'EXEC sp_StoredProcedureName' |select -ExpandProperty XML_F52E2B61-18A1-11d1-B105-00805F49916B| Out-File -FilePath E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml

(Get-Content E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml -Raw).Replace("`r`n","") | Set-Content E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml -Force
}
catch
{
    Add-Content -Path "E:\FilePath\ErrorLog\PSErrorLog.txt" -Value (Write-Output $(Get-Date) $_) -Force

}

try

{

Invoke-Sqlcmd -ServerInstance ServerName -Database DatabaseName -Query 'EXEC sp_StoredProcedureName' |select -ExpandProperty XML_F52E2B61-18A1-11d1-B105-00805F49916B| Out-File -FilePath E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml

(Get-Content E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml -Raw).Replace("`r`n","") | Set-Content E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml -Force

}

catch

{

Add-Content -Path "E:\FilePath\ErrorLog\PSErrorLog.txt" -Value (Write-Output $(Get-Date) $_) -Force

}

The Analysis This code is written in PowerShell to execute a stored procedure on a Microsoft SQL Server and save the results to an XML file. The first line of code invokes the Invoke-Sqlcmd cmdlet, which allows…

Randy
July 2, 2022
6 Comments

MANAGING SQL ROLES AND PERMISSIONS

Server-level roles There are database-level roles and server-level roles. Server-level roles lets you manage the permissions on a server. The following are fixed server-level roles:sysadmin, serveradmin, securityadmin, processadmin, bulkadmin diskadmin, dbcreator, and public. Every SQL server login belongs to the…

Randy
July 2, 2022
1 Comment

CREATING A SQL USER

Creating a new user in Microsoft SQL Server is a common task that can be accomplished using a variety of methods, including Transact-SQL statements, SQL Server Management Studio, and the SQL Server Management Objects (SMO) .NET library. To create a…

Randy
June 26, 2022
1 Comment

WordPress

ADDING SYNTAX HIGHLIGHTER TO WORDPRESS

With Urvanov Syntax Highlighter, you can add code to your wordpress site. It supports multiple languages such as PowerShell and T-SQL. Urvanov Syntax Highlighter is a plugin for your wordpress site. Below is an example of how it works:

SELECT * FROM SOMETABLE

1	SELECT * FROM SOMETABLE

…

Randy
June 26, 2022

PowerShell

INSTALLING INVOKE-SQLCMD

The Invoke-Sqlcmd module is a PowerShell module that will allow you to execute T-SQL statements. In order to install the Invoke-Sqlcmd module, you will need to open PowerShell. Before installing the module, you need to set the execution policy to…

Randy
June 25, 2022