How to Use Parameters in PowerShell
Every DBA should have basic PowerShell skills. In this article, Greg Moore explains how to write a PowerShell script that takes parameters.
2019-10-07
PowerShell
Getting a List of the Striped Backup Files
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
2019-10-03
2,679 reads
Using PowerShell to Generate Logins, Server and Database Permissions
Discover how to reduce the pains you might have feel when migrating all the logins and associated permissions from one instance of SQL Server to another.
2019-09-24
PowerShell and Secure Strings
Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.
2019-09-23
PowerShell and Secure Strings
Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.
2019-09-09
Look up AD user properties using powershell
I realize that this is a bit of a lengthy script for something that you can use a one liner in the power shell:
Example:
Get-ADUser
But I needed to highlight certain properties of given user and take certain actions based on the values. And the result is this power shell script.
2019-07-15 (first published: 2019-07-02)
1,307 reads
Password-less Authentication for Azure AD Guest Accounts with Azure SQL DB with Access Tokens
Learn how we can generate tokens that will give access to resources inside Azure without actually adding new users to your domain.
2019-07-01
2,710 reads
2019-05-31
Scripting out SQL Server Data as Insert statements via PowerShell
As a companion script with his recent article abou...
2019-05-30
Ordering T-SQL Scripts with Git and PowerShell
Learn how you can ensure that scripts are executed in a specific order with Git and PowerShell for use in a Docker container.
2019-05-28
5,070 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
Question of the Day
Adding Bits I
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers