#dbatools

Using PowerShell to Manage SQL Server Audits

PowerShell is a power scripting tool that can also be used to manage your SQL Server audits. In this article by Colleen Morrow we learn some of the advanced techniques. You can also start at the beginning here.

Creating an Audit Object

The first step in implementing SQL Audit is to create the audit object, so that’s where we’ll start. Let’s look at the whole script and then break it down.

1 2 3 4…

Using PowerShell to Manage SQL Server Audits

PowerShell is a power scripting tool that can also be used to manage your SQL Server audits. In this article by Colleen Morrow we learn some of the advanced techniques. You can also start at the beginning here.

Creating an Audit Object

The first step in implementing SQL Audit is to create the audit object, so that’s where we’ll start. Let’s look at the whole script and then break it down.

1 2 3 4…

Gap (pulo) no Identity, como evitar? #SQLServer #SQLBlog

Desde o SQL Server 2012, o produto sofreu uma alteração no controle dos campos IDENTITY onde, logo na inicialização da instância, ele coloca em cache aproximadamente 1000 registros para agilizar o processo. Ao fazer isso, o identity é “pré-usado” internamente e o SQL se encarrega de entregar os próximos valores.

O ‘problema’ é que, ao reinicializar a instância, o cache é perdido e ele cria um gap…

For us at DuPSUG, the Dutch PowerShell user group, 2018 is our sixth year and to start off the year we organized our first iteration of DuPSUG this Wednesday at Tools4ever in Baarn.

At the Dutch PowerShell User Group we are ready to kick off 2018 in style, by organizing another iteration of our user group. We have an evening crammed with sessions ready for you, and we look forward at seeing you there.

Speakers

For this event we had the following three speakers:

Jaap Brasser

Sander Stad

Tjeerd Seinen

BEGIN END SPEAKER TITLE 18:30 19:00 Jaap Brasser Implementing Chat Automation with PowerShell 19:00 19:30 Sander Stad Simplifying Log Shipping using dbatools 20:00 20:30 Tjeerd Seinen

Photos

To give you an impression of the event, here are some photos we have taken during the event and gathered from social media:

DuPSUG kickoff

Jaap Brasser Demo

Tjeerd speaking

Sander presenting

Tjeerd presenting

  Slides & Code

The code and presentations have been shared on the DuPSUG GitHub in the DuPSUG 11 repository: DuPSUG 11 – New Year edition