Resolutions found with SQL Server and other types of databases
There are a couple ways to change a user’s password in Teradata. Two methods covered here are using a SQL statement in Teradata’s SQL Assistant, and the other is using … Continue Reading →
Problem: I was asked about the “MaxLoadTasks” setting in Teradata. There are a couple of ways to view this information. In this case I am going to show the command-line … Continue Reading →
Situation: We had a very busy SQL Server, that could not have “DBCC CHECKDB” run during business hours with out impacting others. I was being asking for the output from … Continue Reading →
Note: this is being shown on Teradata Express. Working with Teradata support, I was asked for the version of the BYNET drivers. This is done with a utility called: bam … Continue Reading →
Problem: I thought that I had quit the Teradata Ferret utility when I typed “quit”, because the screen displayed “Ferret Exited”. My problem was I exited the utility with out … Continue Reading →
One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation. It is now has its … Continue Reading →
Problem: A profile was created with the wrong account ID which can be view in the DefaultAccount column in the dbc.profileinfo view. This was causing a problem with viewing the … Continue Reading →
The issue was a job failed that left Logging Online Archive on a number of tables on one of the Teradata databases. First step was to identify the tables affected, … Continue Reading →
In this example I am using the Teradata Express. Logon on to the Teradata system, using Putty is just a preference. Start the cnsterm supervisor screen (or window): cnsterm 6 … Continue Reading →
Setting up a connection for Excel to the Teradata database was a little bit of a challenge. In this example, the Operating System was Windows 7 and version Excel 2013 … Continue Reading →