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
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 →

How to Install SQL Server 2012 Shared Management Objects

  • By BlogAdmin
  • 4 July, 2014
  • 8 Comments

Recently was asked to install the SQL Server 2012 Shared Management Object on an application server.  There was a new application need some of the library file that are installed … Continue Reading →

Script to change the SERVERNAME property in SQL Server

  • By BlogAdmin
  • 26 June, 2014
  • 1 Comment

When the Master Database is restored or moved to another server with with a different hostname, the master database is unable to detect that it is on a new server.  … Continue Reading →

Microsoft Lync Starts Automatically When I Log-On

  • By BlogAdmin
  • 17 May, 2014
  • No Comments

At work, a vendor asked if I would join a Lync Meeting.  Since then Microsoft Lync now opens every time I log on my laptop.  This was annoying. Below is … Continue Reading →

Moving a Certificate from Windows to the Java Cacerts File

  • By BlogAdmin
  • 1 March, 2014
  • 7 Comments

Recently I had a server with a java application that one day stopped authenticating users.  I was able to trace it back to the JDK  (java developer kit) that the … Continue Reading →

Installing node.js on Oracle Linux Server (OEL)

  • By BlogAdmin
  • 6 February, 2014
  • 4 Comments

Install node.js is much easier to install on other Linux operating system like Ubuntu & Fedora.  I was challenged to find a way to install node.js on the Oracle Linux Server … Continue Reading →

Cloned Oracle Linux (OEL) is missing eth0

  • By BlogAdmin
  • 31 January, 2014
  • 5 Comments

Normally I use Oracle Linux to do much of my testing because of its similarity to RedHat Linux.  However I had an issue when I cloned OEL (Oracle Enterprise Linux) … Continue Reading →

Grep like command in Windows?

  • By BlogAdmin
  • 3 December, 2013
  • 1 Comment

In Linux & Unix, I find that I use the grep command to filter the information by different utilities that returns more then a screen full of information.  For example … Continue Reading →

Delete or Drop a GridFS object in mongoDB

  • By BlogAdmin
  • 11 November, 2013
  • No Comments

Recently I was asked to remove a GridFS object from one of our mongoDB databases.  As of version 2.4.6 of mongoDB, this is not straight forward right click & delete … Continue Reading →

Renaming a GridFS object in mongoDB

  • By BlogAdmin
  • 10 November, 2013
  • No Comments

Recently I was asked to rename a GridFS object from one of our mongoDB databases.  As of version 2.4.6 of mongoDB, this is not straight forward right click & rename … Continue Reading →

MongoVUE Message – Invalid credentials for database

  • By BlogAdmin
  • 16 October, 2013
  • 2 Comments

Being new to the MongoDB database, only in my second week of training,  I wanted to test the MongoVUE gui tool to see if it would help make my administration … Continue Reading →

Posts navigation

Previous Page 1 … Page 9 Page 10 Page 11 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

  • 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…
  • SQL Server – List of All Databases with Compatibility Levels

Archives

  • 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 © 2023 TheSQLReport.com . All Rights Reserved.
Powered by: WordPress | Theme: Simple Catch