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
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
Post thumbnail
I found the CTRL+D shortcut key as an interesting feature in many programs. It can duplicate without using copy and paste. But not always. It is also D like DELETE, DISPLAY, or HIGHLIGHT… Microsoft Office Excel and Google Docs Spreadsheets. In Excel or Google Spreadsheet, CTRL +D duplicates content from the cell/cells row above. We need to…
Read More D like Duplicate.
Post thumbnail
While I was preparing to work in the new (for me) Microsoft Office 365, I learned that Excel 365 already has the “built-in” Power Query add-in. It does not appear directly on the ribbon. It is located under the DATA tab. For previous versions of Excel, the Power Query add-in should be downloaded from the…
Read More Power Query installation.
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 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
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 AwayHi, 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 dbatools = command-line SSMS
dbatools commands used in this post: Export-DbaScript Export-DbaUser Export-DbaLogin Export-DbaDacPackage Publish-DbaDacPackage Export-DbaInstance Copy-DbaDbTableData Export-DbaDbTableData Import-DbaCsv Script it out The SSMS offers to script out lots of the SQL Server objects, however it can be limited in some areas. Using Get-Dba* commands and piping them into Export-DbaScript may add few more options. For example SQL Agent…
Read More dbatools.io = command-line SQL Server Management Studio: Export-Import