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...
database-tools
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:...
Reading Multiline Text
PowerShell 3.0 and later Sometimes you will stumble across tips like the following one: $FilePath = "$env:SystemRoot\WindowsUpdate.log"...
Requiring Administrator Privileges
PowerShell 4.0 and later If you know that a given script needs Administrator privileges, then a simple #requires statement is enough to make sure...
Documenting Your Data Landscape For The Organization
When it comes to making informed decisions, data is the most critical asset an organization possesses. In this session, you'll see how to create...
Analyzing and Removing Print Jobs
Windows 8.1 or Server 2012 R2 Both Windows 8.1 and Server 2012 R2 come with a module called “PrintManagement”. It includes all cmdlets...
How to centrally manage enterprise data definitions in your data mangement projects?
One of the key issues in a Data Warehouse, Master Data Management or BI project is the lack of a centralized and easily accessible Data Definition...
Listing All Print Jobs
Windows 8.1 or Server 2012 R2 Both Windows 8.1 and Server 2012 R2 come with a module called “PrintManagement”. It includes all cmdlets...
Remotely Updating Group Policy
Windows 8.1 or Server 2012 R2 To update Group Policy settings on a remote machine, use Invoke-GPUpdate, and submit the name of the computer where...
Getting Physical – Using automation to build robust, high-fidelity schemas from your logical models
High-fidelity database schemas capture essential business rules and help ensure data quality, but can be very time-consuming to produce and...
Managing Printers
Windows 8.1 or Server 2012 R2 Both Windows 8.1 and Server 2012 R2 come with a module called “PrintManagement”. It includes all cmdlets...
Simplifying .NET Types
All PowerShell versions PowerShell uses short names for the most common .NET types. To see if there is a short name for a .NET type you are using,...
Top 3 Development Environments for PostgreSQL
PostgreSQL is an object-relational database management system (ORDBMS) supporting extensibility and standards-compliance. Just like any...
Converting Code to Uppercase
PowerShell ISE 3.0 and later To turn PowerShell code to all uppercase letters in PowerShell ISE, select the text, then press CTRL+SHIFT+U. To turn...
Mapping Drives
PowerShell Version 3 and later To permanently map a network drive, use New-PSDrive with the –Persist parameter. This parameter makes the drive...
Using System Error Colors for Output
All Versions If your script wants to output warnings or error messages, you can use Write-Warning or Write-Error. Both cmdlets will use the default...
The Intrinsic Value of Data Modeling
Maybe you're using Visio, Excel, or a proprietary tool with limited functionality to create a data model. Perhaps you are expanding your job...
Resolving IP Addresses (and Parameter Types, Too)
PowerShell 2.0 and later Here is a function that illustrates two things: it shows how you can limit a parameter to a given data type, and it shows...
How do I get INSERT/UPDATE/DELETE, Table Data Editor and Import to work with Hive?
How do I get INSERT, UPDATE, DELETE, the Table Data Editor and Import to work with Hive? Response Jonathan Powers over 8 years ago With Aqua Data...
Conditional Breakpoints
PowerShell 3.0 and later The PowerShell ISE supports line breakpoints only: they make the code stop once the debugger hits that particular line. You...
Detecting 64-bit Operating System
Windows 7/Server 2008 R2 To detect whether a script runs in a 32-bit or 64-bit environment is fairly easy: check a pointer size, and test whether it...
Taming the Wild West of Data
Prior to joining Embarcadero, Ron was a consultant who used ER/Studio as well as a variety of other data modeling suites throughout his career....