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

Featured

Recent Posts

  • An error occurred while attempting to connect to a Hyper-V server
  • How to install all roles and features of one server on another
  • Where did the SSL Certificate details in Chrome 56+ go?
  • How to recover data from a deleted, BitLocker enabled partition? – 2017 Edition
  • How to purge Kerberos tickets of the system account
  • Data Protection Manager Database Backup fails with Invalid Command
  • Tape Label Studio 1.0 is now available!
  • ADThumbnails 1.0 released

Recent Comments

  • Jesper on An error occurred while attempting to connect to a Hyper-V server
  • BitLocker tips and tricks | Ammar Hasayen on Restore deleted computer object including BitLocker recovery information
  • Raghul on Error 18054 and Error 777971002 in SQL log after moving System Center Operations Manager 2007 Database
  • Fabian Keßler on How to recover data from a deleted, BitLocker enabled partition?
  • Norman Bauer on How to get some information on Bitlocker using VBScript and WMI?
  • Jeff on How to get some information on Bitlocker using VBScript and WMI?
  • Raymond Chastain on How to recover data from a deleted, BitLocker enabled partition?
  • Recover BitLocker keys from Recycle Bin ! – Azure Mechanics on Restore deleted computer object including BitLocker recovery information

Tags

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