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

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

What to do with ‘suspect’ tapes in MS DPM 2007 and 2010?

by Norman Bauer | Feb 14, 2011 | Data Protection Manager

Sometimes it happens that Microsoft Data Protection Manager 2007, 2010 and 2012 mark a tape as ‘suspect’. Normally this should happen when 2 different tapes have the same barcode… If you do know that there are not 2 identically labeled tapes in your...

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 LTO Barcode Labels

Print barcode tape labels directly to blank labels, like Avery 3420, Avery 6571, Avery 6577, Herma 4459 and many more, available in stores and online.
For more information on Tape Label Studio visit www.tapelabelstudio.com

Recent Posts

  • 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
  • ioBroker unter Windows installieren
  • Neue Serie: SmartHome
  • Unknown error (0x80041024) in Data Protection Manager when taking a Hyper-V backup of a unix machine
  • Configuring DHCP Option 119 (Domain Search List) on a Windows DHCP Server

Recent Comments

  • Nathan Ashe on An error occurred while attempting to connect to a Hyper-V server
  • Antec on An error occurred while attempting to connect to a Hyper-V server
  • Shoey on How to recover data from a deleted, BitLocker enabled partition?
  • Anonymous on The system cannot find the file specified error while enabling Bitlocker
  • MuFa5a on How to recover data from a deleted, BitLocker enabled partition?
  • DPM 2016 - Suspect tape bzw. Ungültiges Band beheben - Nocksoft on What to do with ‘suspect’ tapes in MS DPM 2007 and 2010?
  • Thanks on The system cannot find the file specified error while enabling Bitlocker
  • Kasun on The system cannot find the file specified error while enabling Bitlocker

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 © 2019 by Norman Bauer · Contact, Terms of Use and Legal Details