All PowerShell versions This line will take a list of numbers and randomize their order: Get-Random -InputObject 1, 2, 3, 5, 8, 13 -Count...
Month: November 2014
Reading Disks and Partitions
Windows 8.1 / Server 2012 R2 Disk management has been greatly simplified with the many new client and server cmdlets that ship with Windows 8.1 and...
Black Friday Sale – Flat 30% OFF on all products
Update: Thank you all for making this campaign a huge success. We are extending this offer till Dec 1st, 23:59 PST. Many corporate users requested...
Finding Out Windows Version
All PowerShell Versions Do you own Windows 8.1 Basic, Pro, or Enterprise? Finding out the Windows version is easy. Finding out the exact subtype is...
Big Data = Bigger Need for Data Models – by Rob Loranger
Big Data has had a great impact on science, healthcare, government and many other industries. For instance, it is now possible for scientists to map...
Internals of Statistics That You Were Not Aware Of
As a developer statistics is one of the important things we need to know while doing SQL Server query performance tuning exercise. Let us try to...
Join-Path Fails with Nonexistent Drives
All Versions To construct path names from parent folders and files, you may have been using Join-Path. This cmdlet takes care of the correct number...
3 More Reasons SQL Server Service is Not Responding
NOTE: This content has been updated and expanded in a whitepaper: 7 Reasons Your SQL Server Service Won't Start, by Pinal Dave ---------- After...
Using Cmdlets to Manage Virtual Hard Drives
Windows 8.1 Pro/Enterprise or Server 2012 R2 Both Windows 8.1 and Server 2012 R2 come with a vast number of additional cmdlets, some of which can be...
SQL Server Data Modeling Made Easy
Microsoft SQL Server is slowly beginning to become the preferred platform for most organization big and small. So it would make sense in building...
Engaging the Business Users in Enterprise Semantics – by David Loshin, Knowledge Integrity, Inc.
This is the fifth in a series of six posts on metadata collaboration from David Loshin. Read the previous post and the next post in the...
Looking Up Cryptic Error Codes
All PowerShell versions Often, WMI and API calls return cryptic numeric error codes. To find out what went wrong, try this little helper function:...
Converting Error Numbers
All PowerShell Versions Error numbers that are returned by Windows API calls often appear as very large negative numbers. To give meaning to these...
Collaboration Principles and Universal Data Models – By Len Silverston, Universal Data Models, LLC
Once upon a time, there were four expert data modelers engaged on an enterprise data modeling effort. There was also an additional expert data...
PostgreSQL Administration Made Easy
PostgreSQL let's face it! is the World's most advanced Open Source Database. It has been replacing many proprietary database systems out...
2 Things to Know About When Using Snapshot Isolation
SQL Server 2005 version introduced the concept of Snapshot isolation setting. It is one of those hidden gems inside SQL Server which is under...
Creating HTML Colors
All Versions To convert decimal color values to a hexadecimal representation, like the one used in HTML, try this line: PS>...
SQL Admin Toolset 1.8 Released
We’re happy to announce that SQL Admin Toolset 1.8 has been released. This version adds full support for SQL Server 2014 for all tools in the...
Getting Help
PowerShell 3.0 and later Provided you have downloaded PowerShell help via Update-Help, you can create yourself an excellent help topic viewer with...
SMO – SQL Server Management Objects
SMO stands for Shared Management Objects. It is a SQL administration API used to get meta data information from SQL Server. You may ask “Why? I can...
MongoDB – Data Modeling Primer
We all know and have been hearing about NoSQL systems since the last year or so! 2014 is slated to be the year of NoSQL DB Platforms and Big Data...
Break Into Script with PowerShell 5.0
PowerShell 5.0 Preview As you might know, PowerShell 5.0 Preview is available and comes with vast debugging improvements. One is to be able to debug...
How-To Guide: Upgrading Your Delphi VCL Applications To Support 4K Displays
Alexander Halser from EC Software GmbH. has released an in-depth how to guide for preparing your Delphi VCL applications to support 4K...
Watch Rick Astley Dance and Sing!
All PowerShell Consoles (not PowerShell ISE) Before you try this, you may want to click the icon in the upper left corner of the PowerShell title...