PowerShell 3.0 and later By default, Out-GridView is a one-way road: you can pipe data into it and display it in a grid view window, but you cannot...
database-tools
Finding All Stoppable Services
PowerShell 3.0 and later Get-Service lists all services installed on your computer. It has no parameter to select only running or stopped services,...
Managing Database Security and Compliance
When managing database security and compliance, the DBA can't take a chance on anything falling through the cracks. In this session, you'll...
The DBA and Developer Career Tips eBook
The DBA and Developer Career Tips eBook Author:Pinal Dave Like in any profession, DBAs and developers face competition in the workforce for job...
What You Know but Don't Know
How To Know What You Don’t Know - Path to the DBA World As a new DBA to a company it can be overwhelming and sometimes confusing on knowing where to...
Exporting Out-GridView Content
PowerShell 3.0 and later Out-GridView is a very useful cmdlet to output results to an extra window. Unlike outputting to the console, Out-GridView...
Integrating Data from Multiple Sources: Inferring Source Metadata – by David Loshin, Knowledge Integrity
This is the second post in this series. Read the previous post and the next post. In my last post, we began to review the data element...
Getting a Clean PowerShell Environment
PowerShell 3.0 and later When you develop PowerShell scripts in the PowerShell ISE, you will probably make a lot of changes and revisions, and...
Congratulations You're a DBA…Now What?!
This is a guest article by SQL Server MVP Mike Walsh (www.straightpathsql.com | www.linchpinpeople.com), based on an Embarcadero sponsored webinar...
Adding PowerShell Tools to Windows 8 Start Screen
Windows 8/Windows 8.1 You may have noticed that the Windows 8 start screen by default is missing PowerShell tools like the PowerShell ISE. When you...
Solving Performance Problems on Oracle DB
DBAs and database developers regularly spend a lot of time tracking down and resolving performance issues on the database servers they are...
Find AD Replication Failures
Windows 8.1, Server 2012 R2 Investigating Active Directory replication failures becomes easy with Windows 8.1 and Server 2012 R2. A new cmdlet...
Useful Static .NET Methods
All Versions PowerShell can access static methods of .NET types. Here are some real world one-liners that can do a lot for you: [Math]::Round(7.9)...
Mandatory Parameters with a Dialog
All Versions Typically, when you declare a parameter as mandatory, and the user does not submit it, PowerShell takes care and prompts the user for...
Bind Variables and Application Performance
Not many people are familiar with Bind Variables or how they can be used. Find out how bind variables can be used effectively to make your SQL...
Use Open File Dialog
All PowerShell versions To add some sophistication to your script, here is a simple function that opens the OpenFile dialog and lets the user pick a...
Logging Folders with Access Denied Errors
All Versions When you browse the file system with Get-ChildItem, you may stumble across folders that you have no access to view. If you’d like...
Managing Terminal Service Settings
ActiveDirectory Module Sometimes you may want to directly access properties related to the terminal service in an Active Directory account. Here is...
Integrating Data from Multiple Sources: The Challenge of Data Element Conformance – by David Loshin
This is the first post in this series. Read the next post. The continued fascination with expanding an organization’s analytics capabilities often...
Credential Obfuscator
PowerShell ISE 3.0 and later While it is generally not recommended to hard code passwords in scripts, there are sometimes scenarios where this is...
Achieving Database Schema Compliance at a UK Finance Institute
The requirement to maintain and prove schema compliance within the organization's database inventory continues to expand. The key objective is...
Updating SQL Elements health check intervals
Periodically when I am speaking to users of SQL Elements I receive a request related to changing the interval at which health checks are run for...
Automatic Unrolling and Memory Consumption
PowerShell 3.0 and later In PowerShell 3.0, a new feature called “Automatic Unrolling” was introduced. With it, you can write code like this:...
Copying Command Line History
All PowerShell versions To preserve all the PowerShell commands that you entered in a PowerShell session, check out this one liner:...