Resolutions found with SQL Server and other types of databases
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 →
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 →
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 →
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 →
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 →
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: 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 →
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 →
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 →
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 →