Removing Databases from Availability Groups with Powershell

Those days at work I had to remove a bunch of databases from the Availability Groups and later drop them from the primary and secondary replicas. I know I could do the click, click and drop thing, but why not PowerShell? I decided to invest some time, around 10 minutes and create this nice and […]

Synchronize Files and Folders using Powershell

Hello everyone! Last week I was helping an Application Admin to Synchronize files and folders between Source and Destination Servers. The challenge was because some folders had really long hierarchies, so you could imagine something like this. I would say that doing this for some files it is really ok, but for my case we […]

My Lightining Talk at SQL Saturday Vienna 2018

Hello everyone! I just wanted to share that I will be presenting a Lightining Talk at SQL Saturday 679 in Vienna, Austria. I will have 10 minutes to present the following session. Title: My 5 favorite Powershell Commands! So, if you are planning to be in Vienna for the SQL Saturday, make sure to register […]

Looking at dbatools github with Power BI

First of all! Really, really thanks dbatools team for this. I don’t have words to describe the impact that you guys have in my job. I use it every single day! Now… back to the subject.. Those days I was preparing myself for a presentation and started to play around with Online Services Content Packs […]

Azure SQL Database – Dynamic Data Masking

O Azure SQL Database estende a funcionalidade de Dynamic Data Masking (DDM) que foi introduzido no SQL Server 2016. A intenção desse post é ter um overview sobre o que o DDM e mostrar como utilizar essa funcionalidade no Azure SQL Database O que é o DDM Ofuscar dados em tempo real para impedir o … Continue lendo »

PowerShell: Automatizando tarefas

Olá pessoal, apartir de agora no blog teremos assuntos mais avançados e diversos, começando com uma ferramente muito poderosa -> PowerShell. O PowerShell é o novo caminho para DBAs que suportam muitas instância e bancos de dados. Podemos agendar o script para ser rodado através do agendador de tarefas do próprio Windows (taskschd.msc - Task …

Continue reading "PowerShell: Automatizando tarefas"

CISL 1.4.0 is released

Another happy release of the CISL (Columnstore Indexes Script Library) is live – this time it is 1.4.0! This release is focusing on the addition of the Extended Events, so that a user of CISL can easily set up the…

Migrating to Azure SQLDatabase

Right now one of the hottest topics around the world is the cloud and the successful methods for the migration to the cloud. In the world of Microsoft Data Platform and the relational databases, the Azure SQL Database represents one…

CISL 1.3.1 is released

I am happy to share that the newest release of the CISL (Columnstore Indexes Script Library) – 1.3.1 is live! Do not get confused by the small incremental of the build version – this release is something that anyone should…

Resolvendo problemas: The corresponding line is ‘$space.ForegroundColor = $host.ui.rawui.ForegroundColor

Olá pessoal, Dica rápida sobre PowerShell. Ao tentar executar um script PowerShell dentro de um step, do tipo PowerShell, de um job no SQL Server o seguinte erro era exibido: “The corresponding line is ‘$space.ForegroundColor = $host.ui.rawui.ForegroundColor’. Correct the script and reschedule the job. The error information returned by PowerShell is: ‘Exception setting "ForegroundColor": "Cannot […]
Go to Top