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,...
database-tools
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...
Detecting Character Code 0
Occasionally, strings use a “Byte 0” character as a delimiter. Unlike most other delimiters, this delimiter does not show in text output...
Auto-Declaring Alias Names for Functions
You probably know that PowerShell supports alias names for commands. But did you know that you can define alias names for PowerShell functions...
Checking Operating System Version
Here is a simple and fast way of checking the operating system version: PS C:\> [Environment]::OSVersion Platform ServicePack Version...
Comparing Against $NULL
If you want to find out whether a variable contains $Null (nothing), always make sure you keep $null on the left side of the comparison. Most of the...