September 2020

Post thumbnail

Recently I have got a question about resources to learn PowerShell. There is plenty out there in the wild, but I came across an interesting module I would like to write today – PSKoans. What is PSKoans? The PSKoans module was created by Joel Sallow (blog|twitter) and here is its brief description taken from the…

Read More PSKoans – learn PowerShell with Pester

Post thumbnail

I always used VLOOKUP formula, I could do it even with my eyes closed, but now when I have Excel 365 I can use XLOOKUP, which is similar but not the same. When I have learned this new functionality I found out that I also have an option to use dynamic array formulas in a…

Read More XLOOKUP function and dynamic array formulas – Excel 365.

Saving emails attachments with PowerShell Saving emails attachments with PowerShell

Problem Save attachments from hundreds of emails received via Microsoft Outlook using PowerShell. Scenario One of the systems generates report daily and sends it out via email as an attachment, that is being saved in the Inbox subfolder MyAlerts. Sample email below. After 6 months someone decides to analyze all the reports from the attachments.…

Read More Saving Outlook attachments with PowerShell

dbatools = command-line SSMS dbatools = command-line SSMS

dbatools commands used in this post: New-DbaServiceMasterKeyBackup-DbaServiceMasterKeyNew-DbaDbMasterKeyGet-DbaDbMasterKeyBackup-DbaDbMasterKeyRemove-DbaDbMasterKeyNew-DbaDbAsymmetricKeyGet-DbaDbAsymmetricKeyRemove-DbaDbAsymmetricKeyNew-DbaDbCertificateGet-DbaDbCertificateBackup-DbaDbCertificateRemove-DbaDbCertificateRestore-DbaDbCertificate Service Master Key There are multiple security-related objects that are not easily accessible via SQL Server Management Studio. The first one would be Service Master Key, if exists, can be seen under the master database. Luckily, dbatools can help us to take a backup. SSMS dbatools: New-DbaServiceMasterKey dbatools:…

Read More dbatools.io = command-line SQL Server Management Studio: Keys, certificates

Post thumbnail

Many times happened to me when I received a PDF file with a table that I had to “type” into the program manually. Fortunately, the data didn’t have too many lines 10-20 at most, so it wasn’t time-consuming, but it was frustrating and it could cost a mistake. I wish I knew that before.This option…

Read More Microsoft Excel functionality – Data import from PDF – very useful tool.

dbatools = command-line SSMS dbatools = command-line SSMS

dbatools commands used in this post: Get-DbaService Stop-DbaService Start-DbaService Restart-DbaService Start-DbaAgentJob Stop-DbaAgentJob New-DbaEndpoint Start-DbaEndpoint Stop-DbaEndpoint Start-DbaTrace Get-DbaTrace Stop-DbaTrace Start-DbaXESession Stop-DbaXESession SQL Services OK, let’s start. While doing some maintenance tasks there is a need to start/stop/restart SQL Services. Using SQL Server Configuration Manager is one way or even straight from SSMS, however, working with multiple…

Read More dbatools.io = command-line SQL Server Management Studio: Start/Stop

T-SQL-Tuesday T-SQL-Tuesday

This month Elizabeth Noble (blog|twitter) hosts the #TSQL2SDAY event (see the invitation) and would like to know how did you make your life easier by automating thing. Paper age There was this place I just started and wanted to request a day off. I asked people around how to do this, what system do we…

Read More T-SQL Tuesday #130: Automate Your Stress Away

Hi, I am Magda and this is my first blog post. I have seen #TSQL2SDAY invitation from Elizabeth Noble (blog|twitter) for September and thought I would give it a try. I am going to tell you about my adventures in improving things at work. Intro As a non-technical worker, I can’t do changes on my…

Read More T-SQL Tuesday #130: Automate Your Stress Away – Magda