| # Copyright: (c) 2023, Jordan Borean (@jborean93) <jborean93@gmail.com> | |
| # MIT License (see LICENSE or https://opensource.org/licenses/MIT) | |
| Function Get-SqlServerTlsCertificate { | |
| <# | |
| .SYNOPSIS | |
| Gets the MS SQL X509 Certificate. | |
| .DESCRIPTION | |
| Gets the X509 Certificate that is being used by a remote MS SQL Server. |
| * | |
| !Microsoft.*_profile.ps1 | |
| !.gitignore |
| IF OBJECT_ID('tempdb..#sp_DBPermissions') IS NOT NULL DROP PROCEDURE #sp_DBPermissions | |
| GO | |
| /********************************************************************************************* | |
| sp_DBPermissions V6.1 | |
| Kenneth Fisher | |
| http://www.sqlstudies.com | |
| https://github.com/sqlstudent144/SQL-Server-Scripts/blob/master/sp_DBPermissions.sql | |
| This stored procedure returns 3 data sets. The first dataset is the list of database |
| <# -- UserRights.psm1 -- | |
| The latest version of this script is available at https://gallery.technet.microsoft.com/Grant-Revoke-Query-user-26e259b0 | |
| VERSION DATE AUTHOR | |
| 1.0 2015-03-10 Tony Pombo | |
| - Initial Release | |
| 1.1 2015-03-11 Tony Pombo | |
| - Added enum Rights, and configured functions to use it |
| #Note - will want to install "Chocolatey" first in order to use this file to install software. | |
| # https://chocolatey.org/docs/installation | |
| # Open a command prompt (cmd) and run the following: | |
| # @"%SystemRoot%\System32\WindowsPowerShell\v1.0\powershell.exe" -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin" | |
| # .. | |
| # or open a PowerShell Admin prompt and run: | |
| # Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1')) | |
| # After Chocolatey is installed, open a PS prompt in Administrator mode, |
| # Copyright: (c) 2020, Jordan Borean (@jborean93) <jborean93@gmail.com> | |
| # MIT License (see LICENSE or https://opensource.org/licenses/MIT) | |
| Function Invoke-WithImpersonation { | |
| <# | |
| .SYNOPSIS | |
| Invoke a scriptblock as another user. | |
| .DESCRIPTION | |
| Invoke a scriptblock and run it in the context of another user as supplied by -Credential. |
| #PowerShell script | |
| ################################ | |
| ########## PARAMETERS ########## | |
| ################################ | |
| $projectFolder = "C:\SSIS\myProject\myProject" | |
| $dtutilPath = "C:\Program Files\Microsoft SQL Server\130\DTS\Binn\dtutil.exe" | |
| # The number changes per SQL Server version | |
| # 130=2016, 120=2014, 110=2012 | |
| # Also check the drive where SQL Server is | |
| # installed |
How to backup a SQL database to an AZURE storage account using the Ola Hallengren scripts.
Requires the stored procedures from: https://ola.hallengren.com/sql-server-backup.html
First, create an azure storage account with block blob support (v2 will suffice) and then create a blob container within that. For this example we'll call it sqlbackup.
| <?xml version="1.0" encoding="UTF-8"?> | |
| <opml version="1.0"> | |
| <head> | |
| <title>Bert's mostly SQL subscriptions in feedly Cloud</title> | |
| </head> | |
| <body> | |
| <outline text="Marketing" title="Marketing"> | |
| <outline type="rss" text="Signal v. Noise" title="Signal v. Noise" xmlUrl="https://signalvnoise.com/posts.rss" htmlUrl="https://m.signalvnoise.com"/> | |
| <outline type="rss" text="Austin Kleon" title="Austin Kleon" xmlUrl="http://feeds2.feedburner.com/AustinKleon" htmlUrl="https://austinkleon.com"/> |
| Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1')) | |
| choco install chocolatey -y | |
| choco install sql-server-management-studio -y | |
| choco install azure-data-studio -y | |
| choco install azuredatastudio-powershell -y | |
| choco install git.install -y | |
| choco install vscode -y | |
| choco install vscode-powershell -y | |
| choco install powerbi -y |