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

Author: BlogAdmin

After Azure SQL Login Password Change – Error 916

  • By BlogAdmin
  • 29 December, 2020
  • No Comments

My organization requires periodic password changes on all its accounts.  After changing a password for a local login for a Azure SQL Instance, this account was able to login into … Continue Reading →

FileStream – High Number In The Num_Unprocessed_Items Column After Running Garbage Collection

  • By BlogAdmin
  • 20 August, 2020
  • No Comments

First, I am by no means a FileStream expert.  I am a DBA that was thrown a FileStream support ticket. Problem, the developer ran the delete from the filestream table, … Continue Reading →

Bitnami MariaDB Virtual Machine – How To Enable Port 3306 for MariaDB

  • By BlogAdmin
  • 5 July, 2020
  • No Comments

Bitnami virtual machines are great for quickly enabling an environment for testing or learning.  Sometimes they can be a challenge when I want to use other software with them. Problem: … Continue Reading →

Msg 7302, Level 16, State 1 with a Linked Server

  • By BlogAdmin
  • 4 July, 2020
  • No Comments

Problem: A developer reach out to me about an error they were getting when attempting to run a stored procedure that used a linked server to pull data from an … Continue Reading →

There Are No SQL Server Instances Or Shared Features That Can Be Updated On This Computer

  • By BlogAdmin
  • 7 June, 2020
  • No Comments

Someone asked me to look at this error when applying a cumulative update on an instance of SQL Server 2016.   It was a strange error because I was able to … Continue Reading →

Teradata – Most Currently Updated Stats

  • By BlogAdmin
  • 17 May, 2020
  • No Comments

This is a quick query that I use to check if the on the stats job that ran over night.  Much faster then running the “SHOW STATISTICS” for each table. … Continue Reading →

SQL Server Patch Stuck at Install_sql_common_core_Cpu64_Action : InstallFinalize

  • By BlogAdmin
  • 5 April, 2020
  • No Comments

I was patching an old SQL Server 2014 server with Service Pack 3.  During the update process, the Service Pack froze at the “Install_sql_common_core_Cpu64_Action : InstallFinalize” for about ten minutes … Continue Reading →

Which Windows Server is the Clustered Instance is Running On

  • By BlogAdmin
  • 13 March, 2020
  • No Comments

When troubleshooting from SSMS, I need to know which Windows server my clustered instance is running on.   Surprised that this query is not already on the first page of the … Continue Reading →

View List of OLE DB Providers

  • By BlogAdmin
  • 22 February, 2020
  • No Comments

Sadly I have not found a better way to view the available OLE DB Providers on a server.  Even though I am using an out of support Windows Server 2012 … Continue Reading →

Enabling Line Numbers in SSMS v18

  • By BlogAdmin
  • 16 February, 2020
  • No Comments

Working with large sql statements, I find it is easier to have line numbers in the query window. Enabling “Line numbers” process is the same with every version of SQL … Continue Reading →

Posts navigation

Page 1 Page 2 … 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