database-tools

Overriding Out-Default (Part 3)

Advanced PowerShell users often find themselves doing one of three things: They run a previous command and add Get-Member to learn more about the...

Overriding Out-Default (Part 2)

When you override Out-Default to do something meaningful, you really want to make sure the old behavior isn’t lost, and instead just something...

Overriding Out-Default (Part 1)

Out-Default is a hidden PowerShell cmdlet that gets called at the end of each command, and outputs results to the console. You can override this...

Use Out-GridView as Output Window

Typically, Out-GridView opens a window and displays whatever you pipe into the cmdlet: PS C:\> Get-Service | Out-GridView However, with a little...

Cloud Deployment Models

Concluding our Solutions for the Cloud blog series, we discuss cloud deployment models - public cloud, private cloud, hybrid cloud, and community...

Geocoding: Sentiment Analysis (Part 5)

Some geocoding APIs provide sophisticated sentiment analysis like in the example below: "Most important museums of Amsterdam are located on the...

Geocoding: Text Scanning (Part 4)

Geocoding can automatically extract geolocations from text. This example also shows a new way of submitting information to a server: in the example...

Working with GeoCoding (Part 1)

Last year, Google changed their terms and requires an individual API key now to use their geocode API. Fortunately, there are free alternatives, so...

Agile is the new Waterfall

With changes in software development methodologies, the role of the data modeler has changed significantly.  In many organizations, data...

Left Side of Comparison

When using comparison operators, always make sure the relevant part is placed left. That’s because PowerShell looks at the left side of an...

Subscribe to Lock and Unlock Events

Whenever a user locks his machine, and whenever a user unlocks a machine, Windows emits an event. PowerShell can subscribe to these events and do...

Finding Installed Updates (Part 2)

The Windows Update Client maintains its own log of installed updates. Rather than querying the generic system event log, or actively searching for...

1 40 41 42 43 44 159