It's that time again! Participate in our April #SQLChat for your chance to win a new Herschel Supply Co. Backpack! Our next #SQLChat will take place...
database-tools
Precise Ranks Tables and Indices By Activity | right indexes & right defragmentation schedule
Precise ranks the busiest objects (tables and indices) for Oracle, SQL Server, and DB2. The right indexes and the right de-fragmentation schedule...
Explore Objects
In PowerShell, anything is represented by objects, and here is a helpful one-liner that examines any object and copies its members as text into your...
Managing Bit Flags (Part 4)
In PowerShell 5, the new support for enums makes dealing with bit values much easier as you’ve seen in previous tips. Even setting or clearing...
Managing Bit Flags (Part 3)
Setting or clearing bit flags in a decimal is not particular hard but unintuitive. Here is a quick refresher showing how you can set and clear...
Managing Bit Flags (Part 2)
In the previous tip we illustrated how you can use PowerShell 5’s new enums to easily decipher bit flags, and even test for individual flags....
Managing Bit Flags (Part 1)
Occasionally, you might have to deal with bit flag values. Each bit in a number represents a certain setting, and your code might need to determine...
Working With Generics
Generic types can use placeholders for actual types, and you may be wondering why that can be exciting. There are a number of data types, for...
A Closer Look At SQL Safe’s Backup File Deletion
One of SQL Safe's frequently used feature is the ability to automatically delete backups older than a certain time period. This feature, however, is...
Inheriting Classes in PowerShell 5 (part 2)
Here is another use case for the new class feature in PowerShell 5. In the previous example, we illustrated how you can derive new classes from...
Inheriting Classes in PowerShell 5 (part 1)
PowerShell 5 comes with built-in support for classes. You can use this new feature to enhance existing .NET classes. Here is an example: let’s...
Show or Hide Windows
PowerShell can call internal Windows API functions, and in this example, we’d like to show how you can change the show state of an application...
Using Pester Tests to Test Anything
Pester is an open source module shipping with Windows 10 and Windows Server 2016, and can be downloaded from the PowerShell Gallery...
Uptime Infrastructure Monitor 7.8 now available. Download today!
We are pleased to announce the general availability of Uptime Infrastructure Monitor 7.8. Existing users may upgrade to this version through the...
Reading Environment Variables Freshly
When you read environment variables in PowerShell, you probably make use of the “env:” drive. This line retrieves the environment...
Setting Environment Variables
When setting environment variables through the PowerShell “env:” drive, you are always just manipulating the process set. It applies to...
Checking Host
In the past, Microsoft shipped two PowerShell hosts: the basic PowerShell console, and the more sophisticated PowerShell ISE. Some users used code...
Playing with PowerShell 6.0
PowerShell is open source now, and the next big release of PowerShell is being developed in the open. If you’d like to take a peek preview,...
Getting granular with the new Monitor Windows Memory plugin
Hello you metric hungry Windows Admins! Robert here with another plugin for your consideration, and, Windows monitoring needs. Yes, I...
How to prevent the data collector unavailable message on server restarts.
Hello Windows world Uptimers! Robert here with a quick tip to help cure those data collector blues. This message (malady) usually occurs because the...
Caching Credentials Using JSON
When you need to cache logon credentials to a file, this is typically done by piping the credential to Export-Clixml which produces a rather lengthy...
How NBT inc. improved their MySQL database performance
We had a chance to speak with JaiKwang Lee, Product Guild & DevOps leader at NBT, Inc. Lee and team are responsible for managing the company’s...
Golden Nugget: Working with The Repository Security Center
ER/Studio Repository is a server-side model management system that solves the day-to-day challenges of modeling in a team environment, where model...
Free Guides to Start With PowerShell
If you have colleagues that don’t know PowerShell, and you would like them to get started, here are three free learning resources:...