Skip to content
TheSQLReport.com

TheSQLReport.com

Resolutions found in SQL Server, Oracle, Teradata, and other issues

Primary menu

  • Home
  • SQL Server
  • Oracle
  • Teradata
  • MariaDB
  • AIX
  • Linux
  • Windows
  • SQL Saturday Presentations
  • About Me
Install SQL Server Management Studio (SSMS) 2016 Without Internet Access
Install SQL Server Management Studio (SSMS) 2016 Without Internet Access: 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 →
Server ‘SERVERNAME1’ is not configured for RPC for a Linked Server
Server ‘SERVERNAME1’ is not configured for RPC for a Linked Server: Once in while I am asked to troubleshoot a SQL Server database where my only connection is though a linked server.  Because this database server is on protected network, I … Continue Reading →
How FTP Multiple Files from the Command Line
How FTP Multiple Files from the Command Line: Many times I am challenged to move many similar files from one server to another.  Either I have to remote-desktop on to the server (Windows), or have a session on … Continue Reading →
3004-303 There have been too many unsuccessful login attempts; please see the system administrator
3004-303 There have been too many unsuccessful login attempts; please see the system administrator: Sometimes I am needed to do a little Operating System administration.  I work with a couple of a databases that are on the IBM AIX operating system. Although I work … Continue Reading →
TSQL Query to Find Fragmented Indexes Including Partitioned Indexes
TSQL Query to Find Fragmented Indexes Including Partitioned Indexes: What I wanted to find is the most fragmented indexes, including the partition number (for the partitioned tables) and size for each index.  I want to bring back only the … Continue Reading →
Upgrade SQL Server 2012 Standard to Enterprise
Upgrade SQL Server 2012 Standard to Enterprise: This blog is about upgrading SQL Server 2012 Standard Edition to the Enterprise Edition. This issue has been written about a couple of times, but one more blog about this … Continue Reading →
sp_readerrorlog vs xp_readerrorlog
sp_readerrorlog vs xp_readerrorlog: Question: What is the difference between sp_readerrorlog and xp_readerrorlog? Executive Summary Answer: ALMOST NOTHING The More Detailed Answer: under the covers sp_readerrorlog is a stored procedure in the master database … Continue Reading →
TDP for Oracle error – SBT error = 7011, errno = 106, sbtopen: system error
TDP for Oracle error – SBT error = 7011, errno = 106, sbtopen: system error: Today, for the first time,  I configured TDP (Tivoli Data Protect) for Oracle on Linux .  I had already have done this many times before on AIX.  The Linux version requires … Continue Reading →

SQL Server Audit: Error: 25725, Severity: 16, State: 1

  • By BlogAdmin
  • 1 February, 2020
  • No Comments

Recently I received the following error from one of my SQL Servers: Audit: Server Audit: 65536, State changed from: STARTED to: SHUTTING_DOWN Error: 33059, Severity: 16, State: 1. An error … Continue Reading →

Teradata chk_node VS nodecheck

  • By BlogAdmin
  • 28 January, 2020
  • No Comments

Teradata systems have a couple of command-line utilities to verify the health of a Teradata node.  Both these command-line utilities are good to run when looking for something like hardware … Continue Reading →

node.check Utility in Teradata

  • By BlogAdmin
  • 28 December, 2019
  • No Comments

The “node.check” utility has been been around for a while with Teradata.  Recently I was working with Teradata’s Hardware Support team, and watched them use this utility to uncover a … Continue Reading →

Teradata – Convert Timestamp to the Month of the Year

  • By BlogAdmin
  • 22 November, 2019
  • No Comments

This one also surprises me that someone has not already posted. The TD_Month_Of_Year function returns an integer value that need to converted to string value.  Careful when using this on … Continue Reading →

Teradata – Convert Timestamp to the Day of the Week

  • By BlogAdmin
  • 22 November, 2019
  • No Comments

This surprises me that someone has not already posted this. The TD_Day_of_Week function returns an integer value that need to converted to string value.  Careful when using this on a … Continue Reading →

Errorlog Configuration Problem When Upgrading SQL Server

  • By BlogAdmin
  • 1 November, 2019
  • No Comments

Problem: This morning when working with one of my SQL Server servers, I went looking for an error log from last August.  After finding that I was only able to … Continue Reading →

Windows Server Uptime

  • By BlogAdmin
  • 10 October, 2019
  • No Comments

There are times I need to know if a scheduled server reboot has occurred.  Below works on both Windows Server 2012 & Windows Server 2016. 1. On the server, right … Continue Reading →

Collect Statistics Spool Space Error in Teradata

  • By BlogAdmin
  • 9 October, 2019
  • No Comments

Recently I received an e-mail alert that my collect statistics job had a spool space error (“Failure 2646 No more spool space in…”) for one of the statements it ran … Continue Reading →

Unable to Connect to Teradata from Toad DataPoint with an Active Directory Account

  • By BlogAdmin
  • 8 August, 2019
  • No Comments

A user was unable to connect to Teradata from Toad DataPoint using a Microsoft Active Directory account.  When I looked at the user account in Teradata, it was showing as … Continue Reading →

Cannot Alter the Schema – Msg 15151, Level 16, State 1, Line 1

  • By BlogAdmin
  • 5 July, 2019
  • No Comments

A rookie developer reached out to me requesting help to move a couple of tables to a new schema.  Thinking the developer did not have permissions to the one of … Continue Reading →

Posts navigation

Previous Page 1 Page 2 Page 3 … Page 11 Next

Recommended Blogs

  • James Serra’s Blog Big Data and Data Warehousing
  • TF3604 Blog — Probing the internals of SQL Server
  • Wylie Blanchard — Technology Leader, Database Expert, and Web Strategist
  • SQL Server World
  • Rottengeek?
  • Frugal Fixes
  • Ray Kim’s Blog
  • ClevelandDotNet

Recent Posts

  • After Azure SQL Login Password Change – Error 916
  • FileStream – High Number In The Num_Unprocessed_Items Column After Running Garbage Collection
  • Bitnami MariaDB Virtual Machine – How To Enable Port 3306 for MariaDB
  • Msg 7302, Level 16, State 1 with a Linked Server
  • There Are No SQL Server Instances Or Shared Features That Can Be Updated On This Computer

Archives

  • December 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • June 2013
  • April 2013
  • March 2013
  • January 2013
  • December 2012

Categories

  • AIX
  • Linux
  • MariaDB
  • Oracle
  • SQL Server
  • Teradata
  • Windows
TheSQLReport.com Copyright © 2021 TheSQLReport.com . All Rights Reserved.
Powered by: WordPress | Theme: Simple Catch