Resolutions found with SQL Server and other types of databases
When attempting to change an email account in my Database Mail, I received the following error: Msg 14604, Level 16, State 1, Procedure sysmail_verify_account_sp, Line 14 Both account parameters (id … Continue Reading →
This is something that I wish I had discovered years ago. I have put together my nine most used queries, functions, or system stored procedures that I use most everyday. … Continue Reading →
Problem: When I attempted to logon to one of individual node for my AlwaysOn Availability Group, I received the connection error shown below. TITLE: Connect to Server Cannot connect to … Continue Reading →
Problem: When attempting to install the command line tools for SQL Server on Ubuntu 16.04.3, I would get the error: “E: Unable to locate package mssql-tools” Resolution: Note: SQL Server … Continue Reading →
Problem: I was working with a SQL Server 2014 two node cluster in our test environment. After the cluster had been setup, I was asked to change the drive letters … Continue Reading →
Problem: Setting up a new computer with the 16.10 Teradata Tools And Utilities & other Teradata programs. When I went to setup the ODBC Connection to the using the Teradata … Continue Reading →
Problem: A user that was not part of the sysadmin role attempted to change its own password using the SQL syntax, “ALTER LOGIN WITH PASSWORD”. Returned is the following error: … Continue Reading →
Problem: About once a month, I get support ticket regarding SQL Server dropping an application’s or user’s connection. The problem is SQL Server does not just randomly drop a connection … Continue Reading →
Problem: With the new install of Ubuntu 16.04.3 LTS (GNU/Linux 4.4.0-87-generic x86_64), different attempts at installing SQL Server resulted in the error: “E: Unable to locate package mssql-server”. Resolution: On … Continue Reading →
Problem: I needed to know the ethernet device name of an unused port on a NIC (network interface card) on my Teradata server. Using the “ethertool” utility, I was able … Continue Reading →