Checking for an Element in an Array Using PowerShell If you’d like to know whether an array contains a given element, PowerShell provides the...
Blog
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Working with LDAP and Dates
LDAP filters LDAP filters are a fast and powerful way of retrieving information from Active Directory. However, LDAP filters use a very low-level...
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...
How Can SQL Workload Analysis Help You?
To find the key points of how SQL Workload Analysis can help you, look for the ducks throughout this blog post! What Is SQL Workload Analysis? It...
Using Named Parameters in PowerShell Functions
When you create a PowerShell function, all parameters are positional until you start adding the “Position” attribute. Once you start to do this, all...
Modern Replacement for systeminfo.exe
Retrieving System Profiling Information with systeminfo.exe For ages, systeminfo.exe returned all profiling information for a computer, and could...
HOW TO – Monitor MS-SQL Clusters and Always-On Availability Groups
Problem: Monitoring a traditional Microsoft SQL Server cluster, one that typically has 1 active and 1 passive node, is a challenge because at any...
PowerShell Remoting and HTTP 403 Error
Resolving "HTTP 403" Errors in PowerShell Remoting If you use PowerShell remoting and get “HTTP 403” errors, one of the more obscure reasons for...
SQL DM & ServiceNow Email Integration
Using Email Action Responses in SQL DM to Integrate with ServiceNow This document describes the procedure of using email action responses in SQL DM...
Why Be Normal?
Being normal may not seem like much fun; I wore a “Why Be Normal?” button with pride throughout college. And I did it out of choice rather...
Replacing Special Chars like “Umlauts”
PowerShell 2+ Sometimes it becomes necessary to replace special characters like German “Umlauts” in order to normalize user names or...
5 Database Reports In SQL Server Management Tools
Built-in Database Reports in SQL Server Management Studio When connecting to a SQL Server instance in SQL Server Management Studio, there are built...
Finding AD User by SAMAccountName
PowerShell 5 The free Microsoft RSAT tools come with a full-blown ActiveDirectory module, but sometimes simple AD tasks can be mastered with just a...
Changing Excel Cells from PowerShell
Modifying a Specific Cell in an Excel Spreadsheet Using PowerShell If you need to change the content of a specific cell in an Excel spreadsheet,...
Cleaning Week: Deleting CBS Log File
Windows maintains a log file named cbs.log in $env:windir\logs\cbs. It logs various pieces of information related to the Windows trusted installer,...
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling...
One-Liner Random Password Generator
Generating Temporary Passwords the Easy Way Check out this simple way of creating temporary passwords: You can easily vary the password length: change the number…
Adding New Nodes to an XML Document
Adding New Items to an XML Document Efficiently If you need to add new items to an XML document that already contains such items, the easiest way is...
Bringing Window in the Foreground
Bringing a Process Window to the Foreground with PowerShell PowerShell can use Add-Type to access internal Windows API functions. This way, it is...
Enabling Telnet Client and Watching Star Wars
By default, the Telnet client is disabled on Windows systems. You can easily enable it with a one liner in PowerShell, though. Just launch a...
Enabling PowerShell Remoting with NTLM
By default, PowerShell remoting uses Kerberos authentication and works only in domain environments, and only when you specify computer names, not IP...
Test-Connection with Timeout
The Test-Connection cmdlet implements a simple ping to check whether a system responds to an ICMP request. Unfortunately, you cannot specify a...
Use Get-CimInstance with DCOM
Using Get-CimInstance as an Alternative to Get-WmiObject PowerShell 3.0 added an alternative to Get-WmiObject: Get-CimInstance seems to work very...
Waiting for Process Launch
PowerShell has a built-in support to wait until a process or many processes end: simply use Wait-Process. Understanding Data Marts and Dimensional...
Try CTRL+SPACE!
Useful Keyboard Shortcuts in PowerShell ISE In the PowerShell ISE, there are two key shortcuts that can help you. Pressing TAB works just like in...
Updating Your Office Phone Number in Active Directory
Updating Active Directory User Information with PowerShell If you have installed the free RSAT tools from Microsoft, you can use PowerShell to...
Cloning Active Directory Security Settings
Whenever you add delegation rights to an AD object (i.e. allow a user to manage the members of an organizational unit), you really invoke a change...
Bulk-Remove Protection for Accidental Deletion in AD
Removing Accidental Deletion Protection By default, AD objects are protected from accidental deletion. To remove this protection for all objects in...
Part 1: Monitoring Analysis Services(SSAS) Performance
So you’re a DBA and your manager comes in and says that the BI team wants to install and configure an instance of Analysis Service. Oh and by the...
DBA Triage Using Heatmaps
The word “triage” for me brings up images from MASH re-runs; or memories of emergency room visits with nurses quickly deciding whether you are...