Whether it’s in our personal lives or the professional one, we do have checklists for certain tasks. On the professional level, it can be purely technical like SQL Server...
2020-09-03
16 reads
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
2,952 reads
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
185 reads
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
7,002 reads
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)
390 reads
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)
973 reads
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)
2,762 reads
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)
1,501 reads
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
9 reads
This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...
2020-06-09
12 reads
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Quite the title, so let me set the stage first. You have an Azure...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers