database-tools Archives

Improve your protection for SQL Server backup

Not protecting physical backups You should think about the value of the data or the consequences of it getting into the wrong hands since a full...

Solutions to common methods of SQL Server intrusion

by Peter

To understand how malicious actors can infiltrate SQL Server is the key to understanding how to prevent intrusions. The consequences for inadequate...

Simple Text-Based Filtering a la grep (Part 1)

by ps1

PowerShell is object-oriented so there’s not much text filtering and regex magic required compared to Linux and grep. Yet occasionally, it would be...

SQL Server security best practices

by Peter

There are several examples where data theft has brought organizations to a halt or resulted in a bad press that will leave a tarnished image. For...

SQL Server security threats are closer than you think

by Peter

Today, business is about data. Database systems and the elements they store are the most valuable assets in any enterprise. Not only are business...

Reading Windows 10 Product Key

by ps1

There are plenty of scripts available that promise to read the original Windows 10 product key from the registry by converting a series of binary...

Creating sudo for PowerShell (Part 2)

by ps1

In our effort to create a sudo command for PowerShell – to elevate individual commands – in part 1 we created the sudo function body: function sudo...

Improve your planning for SQL Server backups

by Peter

Not understanding recovery needs The whole point of creating backups is to retrieve data in case data is lost or there is a failure. But to set up...

Creating sudo for PowerShell (Part 1)

by ps1

In Linux shells, there’s a command called “sudo” that lets you run a command with elevated privileges. In PowerShell, you’d have to open a...

Code-Signing PowerShell Scripts (Part 3)

by ps1

In the previous parts, we created a code signing certificate and used it to add a digital signature to a PowerShell script file. Yet what good can a...

Code-Signing PowerShell Scripts (Part 2)

by ps1

In our previous tip we explained how you can use New-SelfSignedCert to create a self-signed code signing certificate. Today, we’ll use a self-signed...

Deliver data-driven capabilities with data modeling

by Peter

Werner Enterprises is a transportation and logistics leader with more than 8,000 trucks, 24,000 trailers and nearly 13,000 employees. Today, 65...

Code-Signing PowerShell Scripts (Part 1)

by ps1

Adding a digital signature to a PowerShell script is no black magic anymore these days, and while you ideally need an official “trusted” code...

Professional Error Handling

by ps1

Often PowerShell scripts use a very simple form of error reporting that is structured like this: # clearing global error list: $error.Clear() #...

Cleaning Hard Drive (Part 2)

by ps1

In the previous post we introduced the Windows tool cleanmgr and its parameters /sageset and /sagerun that you can use to define and run automated...

How to ensure that databases are backed up regularly

by Peter

Keep sensitive and mission-critical data safe by performing regular backups of all important databases. Identify any non-backed up databases....

Cleaning Hard Drive (Part 1)

by ps1

Part of Windows is an ancient tool that can clean your hard drive: cleanmgr.exe. This tool can remove a variety of data garbage and at times removes...