Skip to content
TheSQLReport.com

TheSQLReport.com

Resolutions found with SQL Server and other types of databases

Primary menu

  • Home
  • SQL Server
  • Oracle
  • Teradata
  • AIX
  • Linux
  • Windows
  • SQL Saturday Presentations
  • About Me

Author: BlogAdmin

How to run Showblocks with the Ferret Utility

  • By BlogAdmin
  • 1 March, 2016
  • No Comments

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 →

Generate DDL for a Role in a Teradata Database

  • By BlogAdmin
  • 15 January, 2016
  • No Comments

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

  • By BlogAdmin
  • 15 January, 2016
  • No Comments

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

  • By BlogAdmin
  • 3 December, 2015
  • No Comments

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

  • By BlogAdmin
  • 24 November, 2015
  • 1 Comment

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

  • By BlogAdmin
  • 29 October, 2015
  • No Comments

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

  • By BlogAdmin
  • 11 September, 2015
  • No Comments

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

  • By BlogAdmin
  • 31 August, 2015
  • No Comments

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

  • By BlogAdmin
  • 26 June, 2015
  • 10 Comments

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

  • By BlogAdmin
  • 4 May, 2015
  • No Comments

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 →

Posts navigation

Previous Page 1 … Page 7 Page 8 Page 9 … Page 12 Next

Recommended Blogs

  • James Serra’s Blog Big Data and Data Warehousing
  • TF3604 Blog — Probing the internals of SQL Server
  • SQL Server World
  • Rottengeek?
  • Frugal Fixes
  • Ray Kim’s Blog
  • ClevelandDotNet

Recent Posts

  • Using Ola Hallengren Backup Procedure with Cohesity
  • Query – Percentage of Physical Memory SQL Server is Currently Using
  • Using Microsoft’s TroubleShootingScript Version 2 (TSSv2) Toolset to Collect Support Information
  • Error: 18452 – login is from an untrusted domain and cannot be used with Windows authentication
  • Excel Error: SSL Provider, error: 0 – The certificate chain was issued…

Archives

  • May 2024
  • March 2023
  • February 2023
  • January 2023
  • July 2022
  • February 2022
  • December 2021
  • 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
  • Oracle
  • SQL Server
  • Teradata
  • Windows
TheSQLReport.com Copyright © 2025 TheSQLReport.com . All Rights Reserved.
Powered by: WordPress | Theme: Simple Catch