NORMAN BAUER
  • Home
    • About me
    • Certifications
  • Blog
    • Hardware
    • Microsoft Products
    • Scripting
    • Windows Internals
    • Certification
  • Software
    • Audio Tagging Tools
    • Tape Label Studio
    • Complete list
  • Contact
Select Page
System Center 2012 SP1 Operations Manager: Datawarehouse configuration failed to install

System Center 2012 SP1 Operations Manager: Datawarehouse configuration failed to install

by Norman Bauer | Feb 19, 2013 | SC Operations Manager, SQL Server, Transact-SQL

While installing Microsoft System Center 2012 SP1 Operations Manager I got following error: In the log I could see that Setup could not create the Datawarehouse database: EXEC(@sql);: Threw Exception.Type: System.Data.SqlClient.SqlException, Exception Error Code:...
Cannot insert duplicate key error while upgrading SCCM 2012 to SP1

Cannot insert duplicate key error while upgrading SCCM 2012 to SP1

by Norman Bauer | Feb 5, 2013 | SC Configuration Manager, SQL Server, Transact-SQL

The following error occurred during SP1 update of Microsoft System Center 2012 Configuration Manager: ERROR: SQL Server error: [23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint...
SQL Server 2012: Always On and SQL Server authentication

SQL Server 2012: Always On and SQL Server authentication

by Norman Bauer | Sep 4, 2012 | SQL Server, Transact-SQL

Here is just a small problem I experienced while adding databases with SQL Server authentication enabled (used for some php websites) to an availability group. Steps I took to add the databases: Add all logins to the secondary server (SQL Management Studio >...

How to (re-)set identity column value in SQL Server?

by Norman Bauer | Mar 2, 2011 | SQL Server, Transact-SQL

When you use identity columns in SQL server you may have recognized that when deleting all table data your identity value stays at its latest position. Sometimes this is useful, sometimes it is not. Then you need to set this value to your preferred starting point....

How to display active connections and running queries in SQL Server?

by Norman Bauer | Nov 6, 2010 | SQL Server, Transact-SQL

This query shows all queries executed at the moment, the session id, status, used cpu time and the execution duration SELECT st.text, r.session_id, r.status, r.command, r.cpu_time, r.total_elapsed_time FROM sys.dm_exec_requests r CROSS APPLY...

Tape Label Studio

Tape Label Studio Screenshot

Buy Tape Label Studio one time – create hundreds of free backup tape barcode labels anytime.
Once you got a license, it’s yours to keep. No monthly fee.
For more information on Tape Label Studio visit www.tapelabelstudio.com

Recent Posts

  • An error occured while enabling automatic rebinding of certificate in IIS
  • Unarchive archived certificates with PowerShell
  • The disaster with the Windows 11 taskbar
  • How to batch-handle mounted media with SCVMM managed VMs
  • Unify DHCP scope and DNS update settings across all authorized servers in an Active Directory domain
  • How to get the ‘real’ last logon time of an Active Directory user
  • The system cannot find the file specified error while enabling Bitlocker
  • Tape Label Studio 2019 is on its way

Recent Comments

  • Rhett on How to install all roles and features of one server on another
  • Raj on An error occurred while attempting to connect to a Hyper-V server
  • Nick on SQL Server Update: The Database Engine system data directory in the registry is not valid
  • mohamed on How to recover data from a deleted, BitLocker enabled partition?
  • Monica on An error occurred while attempting to connect to a Hyper-V server
  • sriman rajan on SQL Server Update: The Database Engine system data directory in the registry is not valid
  • Arjen on The system cannot find the file specified error while enabling Bitlocker
  • Elias on An error occurred while attempting to connect to a Hyper-V server

Tags

Active Directory Apple Application apps App Store BitLocker bug Connection Data Protection Manager DHCP Documents Error Events Exam Exchange Flights HTTP Hyper-V iOS iPhone LTO Barcode Label Generator manage-bde MCM Microsoft Certified Master Namespace open passed Pictures Powershell Qualification Query Recovery Password Second week SharePoint SP1 SQL Server start update User VBScript Website Windows Server 2012 Windows Server 2016 WMI XML
Copyright © 2002 - 2021 by Norman Bauer · Contact, Terms of Use and Legal Details