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...
What You Know but Don't Know
read more
database-tools
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:...
Getting Computer Serial Number
All PowerShell versions In a previous tip we illustrated how you can take a DELL serial number and check online the warranty status. Other vendors...
Checking DELL Warranty Online
PowerShell Version 2.0 and later If you own a DELL computer, you can take advantage of a web service that takes your computer serial number and...
Solving Common DBA Tasks at a Leading German Bank with DB PowerStudio
A leading German bank uses DBArtisan to manage hundreds of databases in their organization. This case study will show how many common DBA tasks are...
Cmdlets to Manage MSI Packages
PowerShell 2.0 and later Anyone who needs to manage MSI installer packages may benefit from an open source project found here:...