Jay's Blog

[coding, debugging, and troubleshooting with Microsoft Technologies]

Browse by Tags

Tagged Content List
  • Blog Post: Orphaned Locks - Idle Session - and XACT_ABORT

    Sometimes you might see a situation where a session is holding locks, blocking other sessions for an extended period of time, but does not have an active request and appears to be Idle.  This can happen in a few different scenarios, but here we’ll outline one scenario and how being sure to use XACT_ABORT...
  • Blog Post: Sequence Objects in SQL 2012 and SQL 2008

      Sequence Objects are new starting in SQL Server 2012.  They work similarly to an IDENTITY value, but where the IDENTITY value is scoped to a specific column in a specific table, the Sequence Object is scoped to the entire database and controlled by application code.  This can allow you...
  • Blog Post: Finding Missing Dependencies

      While working with a customer on a SQL port, I came across a system view that was new with SQL Server 2008.  Have you ever needed to check your database code (stored procedures) to see if it references any missing objects?  As of SQL Server 2008 this is easy thanks to: sys . sql_expression_dependencies...
  • Blog Post: Loading data with foreign keys

      Working on a customer project the other day, I needed to load some data into a database that had been scripted and re-created.  The newly created database already had foreign keys in place which means for loading data (this was from SSIS), we had 2 options: 1) drop the foreign key constraints...
  • Blog Post: How can I get a list of installed SQL Server instances?

    Today we’ll talk about how we can get a list of locally installed SQL Server instances on a system.   This information is stored in the registry at the following location: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL EDIT: If you are looking for 32 bit instances...
  • Blog Post: Searching through the SQL Server Errorlogs

    Sorry – It’s been a while since my last post.  The past few months have been very busy for me.  The other day, I had a brief discussion with a colleague on ways to search through all of the error logs in SQL Server.  Obviously there are a few ways to do this – through PowerShell, simple...
Page 1 of 1 (6 items)