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...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
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>...
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...
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...
Tips Database Developers Must Know Reading Query Plans
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...
Pinging via IPv4
All PowerShell versions You can use ping.exe just like any other command inside PowerShell scripts. By adding “-4” to the command line,...
The 3Vs may require NoSQL, but data modeling is still required – by Rob Loranger
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...
Knowing your Storage Basics- 2 Life Lessions for a DBA
IF_THEN_ELSE_RapidSQL
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...
CASE Syntax using Rapid SQL
Hi, Last blog we visited the IF-THEN-ELSE conditional syntax. This blog, I’d like to convert those examples using the newer CASE...
Use F1 in PowerShell ISE
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...
Functions Always Beat Cmdlets
All PowerShell versions Functions always have higher rank than cmdlets, so if both are named alike, the function wins. This function would...
Auditing is More Than a Way to Get the Security Team Off Your Back
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...
Securing your Data Modeling Assets – ER/Studio Repository
Encrypting and Decrypting Files with EFS
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...
Use Out-Host instead of More
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...
Invoke-Expression is Evil
All PowerShell versions Try and avoid Invoke-Expression in your scripts. This cmdlet takes a string and executes it as if it was a command. In most...
Display Command History in PowerShell Console
All PowerShell Versions In the PowerShell console (not the PowerShell ISE), you can open a list with the last commands you entered, simply by...
Importing and Installing Certificate
All PowerShell versions To programmatically load a certificate from a file and install it in a specific location inside the certificate store, have...
How do I turn off Scientific Notation in the Grid and Text Results for Sybase ASE FLOAT data type?
How do we turn off scientific notation? I’m getting this in both text and grid results for Sybase ASE servers. create table myfloat (...
How to execute IBM DB2 UDB Admin commands that are part of CLP in Aqua Data Studio ?
How to execute IBM DB2 UDB Admin Functions in Aqua Data Studio ? IBM DB2 has server SQL commands, and commands that are part of their...
Using Notepad to Print Things
All PowerShell versions To print a text-based file with the Notepad, try using this line (replace the path to the text file with some path that is...