We’re excited to announce the release of SQL Safe Backup 9.1 SQL Safe Backup provides the industry's shortest time from starting a SQL Server backup...
Announcing the Release of SQL Safe Backup 9.1
read more
database-tools
Determining Language Packs (Part 3)
In part 2 of this series, you already witnessed how much easier and faster it was to query the list of installed operating system languages using...
Determining Language Packs (Part 2)
In part 2 of this series, we’d like to solve our puzzle – getting installed language packs – by using the built-in PowerShell features. In part 1 we...
Use better tools for SQL Server backup
Not knowing what tools are available There are several tools that come with SQL Server that can be used for backup processing, such as SQL Server...
Determining Language Packs (Part 1)
Let’s assume you need to find the installed language packs for a Windows machine. In this three-part series, we use PowerShell’s features to tackle...
Creating World Map Graphs
If you have data related to countries, you may want to visualize and highlight this geographic data. Classic bar- and chart-graphs won’t always work...
Improve your management for SQL Server backup
Inconsistent backup plans While it is hard enough to manage SQL Server, you find that having inconsistent backup plans from server to server will...
Running $PSScriptRoot in Selected Code
One of the big pitfalls in PowerShell code is the automatic variable $PSScriptRoot which always holds the path to the folder the current script is...
Pasting Multiple Lines in PowerShell
When you copy multiple lines of PowerShell code and paste them into a shell window, the result often is not what you expect. PowerShell starts...
Downloading Files
Simple file downloads can be done in a variety of ways, i.e., using Invoke-RestMethod, Invoke-WebRequest, or via the BitsTransfer module. If you...
Recovering Wasted Hard Drive Space
When software receives updates, it often does not clean up previous updates that are no longer required. These deprecated “patch files” accumulate...
Improve your performance for SQL Server backups
Writing directly to tape A lot of third–party backup tools have agents that allow you to write directly to tape. This was great in the old days when...
Cleaning Up PowerShell Modules (Part 3)
In part 1 and 2 we looked at removing PowerShell modules altogether. In this last part we’ll look at PowerShell module versions you may no longer...
Improve your knowledge for SQL Server backups
Not understanding options Another big problem is people not being aware of the different options that are available using T-SQL commands and using...
Cleaning Up PowerShell Modules (Part 2)
In part 1 we looked at removing PowerShell modules that were originally installed via “Install-Module”. You can as well remove PowerShell modules...
Cleaning Up PowerShell Modules (Part 1)
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...
Quickly Finding Outdated PowerShell Modules
In the most simplistic case, you can check all your installed modules for updates with just a one-liner (remove -WhatIf to actually perform the...
Improve your testing and scheduling for SQL Server backups
Testing Not using restore verify option The last thing you want is to discover that your backup is not good when trying to restore it. A restore...
Unblocking Multiple Files
When you download files from the internet, or when you copy files from untrusted sources to an NTFS-formatted drive, Windows adds a secret NTFS...
Announcing the Release of SQL Safe Backup 9.0
We’re excited to announce the release of SQL Safe Backup 9.0 SQL Safe Backup provides the industry's shortest time from starting a SQL Server...
SQL Diagnostic Manager versus other SQL Server performance monitoring tools
As a seasoned SQL Server database administrator or developer, you already know that there is an abundance of tools you can use to collect server and...
Tune SQL queries for SQL Server
Writing and tuning SQL code are two different things. There are many ways to write code so that it does the intended function. But there are also...
Major Update for PowerShell Extensions
If you have tried VS Code in the past but were disappointed because of speed and stability, you may want to have a second look now. On May 3, Sydney...
View wait stats for SQL Server
There are several things that could cause performance issues for a query. You can identify these by breaking down the processing time for a query...