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...
How to execute IBM DB2 UDB Admin commands that are part of CLP in Aqua Data Studio ?
read more
database-tools
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...
Changing the Max Concurrent Service Connections for SQL Diagnostic Manager
SQL Diagnostic Manager automatically limits the number of connections that a collection service may make to an individual monitored server. This...
Changing PowerShell Priority
All PowerShell versions Maybe you’d like a PowerShell script to work in the background, for example copy some files, but you do not want the...
Reading In PFX-Certificate
All PowerShell versions When you use Get-PfxCertificate, you can read in PFX certificate files and use the certificate to sign scripts. However, the...
Accessing SQLServer Database
All Versions, SQL Server You are running an SQL Server? Then here is a PowerShell script template you could use to run an SQL query and retrieve the...
Top 2 Reasons Why Database Developers Take Certifications
Developers, Administrators and individuals have various levels of motivations when it comes to taking certifications. There are no set rules or ways...
5 Different Ways to Start SQL Server Services
If nothing works, then a restart works. This is the exact sentiments that an Administrator has when it comes to working with software. If you are...
Creating Colorful HTML Reports
All PowerShell versions To turn results into colorful custom HTML reports, simply define three script blocks: one that writes the start of the HTML...
Lesser Known SQL Server Backup Practices by Pinal Dave
One of the most critical responsibility of a Database Administrator (DBA) is to make sure that the databases are backed up on regular basis. What...
Tips Developers Must Know Reading Query Plans
Guest post by Pinal Dave If you are a developer, you might have heard this from your DBA – “That query plan has some problems”. This blog would help...
3 Leadership Tips That Define Success by Pinal Dave
Check out this guest post by industry expert Pinal Dave who provides 3 leadership tips to define success in any industry. Every individual has their...
Understanding Database Backup Strategies by Pinal Dave
Backup is one of the driest topics and it seems to be something non-negotiable for a DBA role. If we look into the fine prints of why someone should...
5 Common Mistakes Every Database Developer Must Avoid
Being a developer is an awesome experience – trust us. You are an architect and the builder of your dreams. A developer shapes the way the...
Turning Off “FullLanguage” Mode
All PowerShell versions PowerShell can be restricted in many ways. One is to set the language mode from “FullLanguage” to...
Building Your Very First Data Model From Scratch
Section 1: Creating a Data Model In this section, we will be learning how to create a data model from scratch using ER/Studio Data Architect. See...
What Policy Guidelines are Required for your SQL Environment?
As adherence to regulations continues to be pressed upon organizations by industry and government regulators, the ability of the organizations to...
Controlling Execution of Executables
All PowerShell versions PowerShell treats executables (files with extension EXE) like any other command. You can, however, make sure that PowerShell...
Three Facets of Metadata: Structure, Content, Meaning – by David Loshin, Knowledge Integrity, Inc.
Faking Object Type
PowerShell 3 and later The internal PowerShell ETS is responsible for converting objects to text. To do this, it looks for a property called...
Metadata Integration
The operational culture of the enterprise has gradually shifted towards a more business-centric model, one where business users and front line...
Using PowerShell Remoting without Domain
PowerShell 3 and later By default, when you enable PowerShell remoting via Enable-PSRemoting, then only Kerberos authentication is enabled. This...
Enabling and Disabling PowerShell Remoting
PowerShell 3 and later If you want to access a computer remotely via PowerShell, then on the destination side (on the computer you want to visit),...
Reading System Logs from File
All PowerShell Versions Sometimes, you may have to evaluate system log files that have been exported to disk, or you want to read a system log file...