Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-20
2,366 reads
Cláudio Silva
When one of your DBA colleagues leaves the company, what is your checklist?
A colleague left the company, a couple of days after SQL Server processes start failing...what do you do?
2020-09-29
4,599 reads
Recover database encrypted modules code with dbatools
This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments I read about it, mainly why people still use WITH ENCRYPTION when it's simple to...
2020-09-22
7 reads
Recover database encrypted modules code with dbatools
If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
2020-08-18
1,998 reads
Generate SQL Server Role Member Reports using dbatools and ImportExcel PowerShell modules
This was initial posted on SQL Server Central articles. As one of dbatools' first members, I've been using it for years and it's really my goto tool. This task...
2020-07-31
110 reads
Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules
Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.
2020-06-30
3,934 reads
Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism
We have seen how we can export and save the results to a folder and commit them to a GIT repository on my last blog post Backup your SQL...
2020-06-22 (first published: 2020-06-04)
342 reads
Backup your SQL instances configurations to GIT with dbatools – Part 1
Today I want to share how I’m keeping a copy of instances’ configurations using dbatools. Chrissy LeMaire (B | T) wrote about it before on the Simplifying disaster recovery...
2020-06-15 (first published: 2020-06-02)
536 reads
Replicate permissions to new Login/User with dbatools
Continuing to share tips and tricks using dbatools like the Refresh databases that belongs to availability group using dbatools posted a few days ago, today I will share a...
2020-06-12 (first published: 2020-05-28)
469 reads
Export Deadlocks to file from system_health Extended Event using PowerShell
Just a quick post as may help any of you searching for this. Scenario Client wants to analyze most recent deadlocks that happened on a specific instance. They asked...
2020-06-09 (first published: 2020-05-25)
376 reads
Blogs
The T-SQL Tuesday Corollary
T-SQL Tuesday is a fantastic series of blog posts derived from over 130 topics...
How to Import Perfmon Data into a SQL Server for Analysis
By kleegeek
If you followed the last video, I showed you how to set up windows...
How To Set Up Perfmon for 24×7 Collection
By kleegeek
I just released a new training video (one of many to be released in...
Forums
OLAPQueryLog does not work for SSAS Tabular mode
I running into a problem when I try to setup querylog in SSAS. The...
Code to auto-update tables on set date
I am in a project where information is being pulled from a database then...
Required Environment Variables
Comments posted to this topic are about the item Required Environment Variables
Ask SSC