database-tools Archives

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)

by ps1

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)

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...

Quickly Finding Outdated PowerShell Modules

by ps1

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

by Peter

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

by ps1

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

by Elan Kol

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

by Peter

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

by Peter

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

by ps1

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

by Peter

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...

View query metrics for SQL Serve

by Peter

There are many things that can cause slowdowns in SQL Server, such as resources like disk, memory, and network. But the one place where database...

Analyze deadlocking for SQL Server

by Peter

Deadlocking is a common problem that can occur in an SQL Server database. This is like blocking. But instead of being blocked forever, SQL Server...

Analyze blocking for SQL Server

by Peter

Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set...

See the entire SQL Server environment

by Peter

There are many advantages of using SQL Diagnostic Manager over building your own tools and one of these is the enterprise management view of all...

Identifying Multi-Language Online Documents (Part 1)

by ps1

In the previous tip we pointed you to the official PowerShell Language Definition which is available online in many different languages. Which...

Benefits of SQL Diagnostic Manager for database administrators

by Peter

As a database administrator, monitoring database systems for performance, corruption, and data issues is an ongoing task. It is also an overwhelming...

Benefits of SQL Diagnostic Manager for developers

by Peter

Development is a big undertaking and most of the time it focuses on making sure all the features are in place and working. Once this is done, tuning...

Trade-off between database security and database performance

by Peter

One can improve how secure databases are. However, that often degrades how well the database performs. The cost increases to improve database...

Worth a Read: PowerShell Language Definition

by ps1

Today I like to point you to the official Microsoft PowerShell Language Definition. As a seasoned PowerShell scripter, you can gain a lot of inside...

Database auditing essentials: Track who did what to which data when

by Peter

Stricter governmental and industry regulation coupled with the need for improving how secure the sensitive corporate data is has driven up the need...