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...
All PowerShell versions Often, WMI and API calls return cryptic numeric error codes. To find out what went wrong, try this little helper function:...
All PowerShell Versions Error numbers that are returned by Windows API calls often appear as very large negative numbers. To give meaning to these...
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 let's face it! is the World's most advanced Open Source Database. It has been replacing many proprietary database systems out...
SQL Server 2005 version introduced the concept of Snapshot isolation setting. It is one of those hidden gems inside SQL Server which is under...
All Versions To convert decimal color values to a hexadecimal representation, like the one used in HTML, try this line: PS>...
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 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...
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...
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...
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...
If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help you in understanding...
All PowerShell versions You can use ping.exe just like any other command inside PowerShell scripts. By adding “-4” to the command line,...
We live in an exciting time where technology is entering our lives in areas that many of us never expected. For example, at home, once unintelligent...
This week I’ll take a look at IF-THEN-ELSE-ELSEIF syntax. Next blog I’ll take a look at the similar CASE syntax and compare/contrast the...
Hi, Last blog we visited the IF-THEN-ELSE conditional syntax. This blog, I’d like to convert those examples using the newer CASE...
PowerShell ISE 3 and later When you have downloaded the PowerShell help files (using Update-Help from an elevated shell), you can use the Get-Help...
All PowerShell versions Functions always have higher rank than cmdlets, so if both are named alike, the function wins. This function would...
As a DBA, you probably look at auditing tools as a something forced upon you by the security officer. You are asked to provide continuous auditing...
All PowerShell versions Provided EFS (Encrypting File System) is enabled on your system, and you are saving files to a NTFS location, then this is...
PowerShell Console Note that any of this will only work in a “real” console. It will not work in the PowerShell ISE. To output data page...