28Aug

Leveraging on SQL Server metadata

0 Comments
Automation, Firebird, Metadata, PowerShell, sql server, SQLPrompt

Leveraging on SQL Server metadata was original posted in the Cláudio Silva’s Blog I’m working on a project where I need to convert Firebird SQL code into T-SQL code. No schema, just the modules. There are more than 1000 objects between stored procedures, views, triggers, user-defined data types, etc. First – […]

02May

Is this command broken? I can’t see some properties! – DefaultDisplayPropertySet, Get-Member and Select-Object *

0 Comments
DefaultDisplayPropertySet, Get-Member, PowerShell, PowerShell Tip, Scripting, Select-Object *

Is this command broken? I can’t see some properties! – DefaultDisplayPropertySet, Get-Member and Select-Object * was original posted in the Cláudio Silva’s Blog Every now and again I see some people complaining about not getting the properties they want when using a PowerShell command. For instance, someone was using the Get-Service command to query […]

09Apr

Using dbatools to verify your SQL Server instances version compliance

0 Comments
Automation, DBA, dbatools, PowerShell, SQLServer

Using dbatools to verify your SQL Server instances version compliance was original posted in the Cláudio Silva’s Blog One of the main DBA’s duties is to guarantee that SQL Server instances are up-to-date in terms of patches (Service Packs, Cumulative Updates or Security Updates). Recently, dbatools added a new command that turns this […]

09Oct

PowerShell Conference Asia

0 Comments
Events, PowerShell, PSConfAsia, SQLServer

We are happy and excited to announce that our teammate Cláudio Silva (b | t) will be speaking at PowerShell Conference Asia! On 28th of October he will be presenting two sessions with the following titles: Next step to your script…turn it into an Advanced Function SQLServer Reporting Services administration new best friend – PowerShell If […]

21Sep

Generate Markdown Table of Contents based on files within a folder with PowerShell

0 Comments
GitHub, Markdown, PowerShell, Table of Contents, TOC

Generate Markdown Table of Contents based on files within a folder with PowerShell was original posted in the Cláudio Silva’s Blog Last week I was talking with Constantine Kokkinos (b | t) about generating a Table Of Contents (TOC) for a GitHub repository. He wrote a cool blog post – Generating Tables of Contents for […]

17Sep

[PowerShell] From 20 minutes to 20 seconds – Change domain user password on multiple domains without login into each one

0 Comments
Active Directory, Change Password, Different Doamins, DirectorySearcher, LDAP, PowerShell, PowerShell Tip, Scripting

[PowerShell] From 20 minutes to 20 seconds – Change domain user password on multiple domains without login into each one was original posted in the Cláudio Silva’s Blog I’m working on a environment where I have to deal with multiple domains. The user’s password needs to be updated each 40/45 days (it depends on the […]

27Jul

“Does that copy subscriptions too?” – Now it does! New PowerShell SSRS commands

20 Comments
Automation, Deployment, PowerShell, SQLServer, SSRS, syndicated

On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the Microsoft PowerShell module ReportingServicesTools to automate several steps that otherwise would be a big time consumer. After a couple of shares and re-tweets, my friend Rob Sewell (t) pointed that blog post to […]

12Jul

SSRS Report Deployment Made Easy – 700 times Faster

9 Comments
Automation, Deployment, PowerShell, ReportingServices, SQLServer, SSRS, syndicated

Back in October 2016, Microsoft started a new GitHub repository – ReportingServicesTools – an open source PowerShell module to manage SQL Server Reporting Services. This project contains PowerShell scripts that allows you to perform various operations with SQL Server Reporting Services. This module, as of today, provides 28 commands that will help accomplish multiple […]

22Jun

Have you backed up your SQL Logins today?

0 Comments
Automation, Backup, dbatools, Logins, PowerShell, SQLServer, syndicated

Why am I asking? Have you never have been in a situation where: the master backup is corrupted you need to rollback a password change know the list of permissions on a specific day (the scenario: “yesterday was OK, today is not working” due permission changes) Do you see the pain?! If you are not […]

26May

PowerShell Quick Tip – Get-History and the Pipeline

2 Comments
PowerShell; Get-History;

On the last week I went to Anthony Nocentino’s (b | t) precon “Open Source Powershell On Linux – Skills To Manage Your Heterogenous Data Center” at TugaIT conference which I recommend (both the precon and the conference 😉 ). While we were running some commands we talked about Get-History cmdlet. For those who […]

Page 1 of 212