How to run Showblocks with the Ferret Utility
Teradata support asked me for information from the “showblocks” command for a problem table in the Ferret Utility. Below is an example of how I retrieved the information. In my … Continue Reading →
Author: BlogAdmin
Generate DDL for a Role in a Teradata Database
There are times I would like to copy the permissions for a role with a Teradata database to use on another database. Below is a nice query to give me … Continue Reading →
Query to Check the Last Time a Teradata View was Rebuilt or Altered
Recently I was asked to update a couple of views on a Teradata database. This script was an easy way to verify that the Teradata views’ timestamp for the DDL … Continue Reading →
Increasing the Font in SSMS on the Fly
Recently, I have learned a neat trick to quickly increase or decrease the font size. This something I found with a different database product, but was happy to see work … Continue Reading →
Upgrade SQL Server 2014 Standard to Enterprise
This blog is about upgrading SQL Server 2014 Standard Edition to the Enterprise Edition. This blog looks & sound much like my October 2013 post, “Upgrade SQL Server 2012 Standard … Continue Reading →
Increasing the Font in Teradata SQL Assistant on the Fly
One of my frustrations with the Teradata SQL Assistant is when the application starts, the font in the query window is very small. Recently, I have learned a neat trick … Continue Reading →
Problem Starting Teradata Studio
Problem: Just downloaded the Teradata Express 14.10 for VMware Player, I opened the Teradata Studio version 14.10 in the virtual machine. Before I configured a connection profile, I closed the … Continue Reading →
Opening a Remote Desktop Connection in Full-Screen Mode on a 2nd Monitor
Problem: I was give a second monitor at work. My problem was that when I would drag an open Remote Desktop Connection to the second monitor, the window would have … Continue Reading →
After Cloning a 12c Oracle Home – SQLPLUS error exec(): 0509-036
Problem: After cloning a 12c Oracle Home to another AIX 7.1 server, I received the following error when I started SQLPLUS. $ ./sqlplus /nolog exec(): 0509-036 Cannot load program sqlplus … Continue Reading →
dm_tcp_listener_states DMV Altered to be Readable
The sys.dm_tcp_listener_states DMV was introduced in version SQL Server 2012. This is a great DMV because the SQL Configuration Manager does not have to opened to find these values. However … Continue Reading →