In part 3 of our mini-series about running console applications in PowerShell, here is a goodie: how can you run a console application separately...
database-tools
Oracle Optimization, Proactive Oracle Tuning
Many DBAs begin Oracle tuning by focusing on the slow SQL statements. Time to tune is often made only when there is an issue. We believe that...
Combine PowerShell and SQL Diagnostic Manager to Automate SQL Server Monitoring
Run new and existing PowerShell scripts with SQL Diagnostic Manager and utilize the vast power of PowerShell via the customizable monitoring...
Evaluating Exit Codes (aka Error Level – Part 2)
When you directly launch a console-based application, PowerShell returns its exit code (aka Error Level) in the automatic variable $LASTEXITCODE....
How to run an application under an account of a different domain
Not too long ago, I came across a scenario where a user needed to launch an application (e.g. SQL Server Management Studio) to access SQL Server,...
Evaluating Exit Codes (aka Error Level – Part 1)
When running a console-based application, it typically returns a numeric exit code. The meaning of this exit code is up to the console-based...
Ejecting CD Drive
Here is a fun little function that uses WMI to eject your CD drive. It does so by first asking WMI for all CD drives. It then uses the explorer...
Identifying CSV Delimiter
[a-z0-9 0="äöüß"()" _i="0" _address="0" theme_builder_area="post_content" /]
Identifying Duplicate CSV Headers (Part 2)
[Import-Csv _i="0" _address="0" theme_builder_area="post_content" /]
Why Should A Data Modeler Care About Business Processes?
Data Modelers are responsible for creating and maintaining conceptual, logical and physical data models. These data models are used to define...
Identifying Duplicate CSV Headers (Part 1)
What are Business Processes??
Business Processes are a set of tasks or activities that help an organization to define and communicate their goals, optimize their...
Serializing Date and Time in a Culture-Invariant Way
When you save date and time to text, for example when exporting to CSV, or when creating text reports, DateTime objects are converted to the date...
Converting Ticks to Date and Time (Part 2)
In the previous tip we explained how you convert date and time displayed as ticks to a true DateTime format. However, there are two different time...
Is your SQL drawing a blank? It’s NULL a surprise!
The title of this post is a play on words, but very appropriate. We are going to discuss the inconsistent results, as well as performance...
Converting Ticks to Date and Time (Part 1)
Occasionally, you may run into strange date and time representations: they might be represented as a 64-bit integer like this: 636264671350358729....
Response time – What it is, how you should treat it, and some SQL goodness.
I get asked a lot "What does 'response time' really measure?" Or something close... Response time, simply put, is a measurement of...
Directly Importing Certificates (Part 2)
In the previous tip we showed how to import digital certificates with .NET methods on any version of PowerShell. Newer versions of PowerShell come...
April #SQLChat Findings
Jim Donahoe (@SQLFlipFlopsDBA ) hosted a #SQLChat on Wednesday, April 5 over Career Satisfaction within the SQL Space. This was a busy conversation...
Directly Importing Certificates (Part 1)
Installing certificate files on a computer can be done using .NET methods with any version of PowerShell. This would import a certificate file to...
Working with Glossaries in Team Server
Working with Glossaries in Team Server So Why Business Glossaries? A typical way of structuring glossaries is aligning glossaries to...
Beware of Aliases
Can you spot what is wrong here? PS C:\> function r { "This never runs" } PS C:\> r function r { "This never runs" } PS C:\> When you run...
Dealing with Long File Paths
Historically, the Windows file system sometimes stalls when paths grow longer than 256 characters. There is a module available at the PowerShell...
Monitoring Amazon RDS: Beyond Raw Logs
Amazon Relational Database Service (RDS) is a hosted database service in the AWS cloud. If your organization's data is stored in one of the...