Isolation Levels

Technical Article

storing business objects as Blob in the DB

  • Topic

We are currently debating how to store BO's within our SQL Server DB.We have a object to relational mapping layer that allows us to map BO's to DB tables. It has been suggested that we take the serialised BO graph and just place it in to a blob within the DB.I'm looking for any pro's and […]


1 reads

Technical Article

Help using TOP n

  • Topic

I've been struggling with this one for a while.  Guess it's easy when you know how??I am running a query across two views.View A contains People recordsView B contains diary entries for those people records.There are multiple diary entries on View B for each of the View A RecordsI want to run a query giving […]


Technical Article

RE: Hidden Dangers!

  • Reply

I would like to understand how this is working in the first place. Does anyone have a minute to tell me more about how it works.Also I noticed that it will pick up any servers you have registered and will not pick up the 'local' server if it is noted possibly in the registry as such. 


Technical Article

Trigger to list columns updated

  • Topic

Below is a trigger that I'm TRYING to use (in SQL2000) to list which columns are updated. However, it never stops running and I can't determine why. Apparently the WHILE maybe generating an infinite loop. To test, just change the table name 'admin' in a few places. Any help would be appreciated. ------------------------------------------------------------------ CREATE Trigger tr_admin -- list all […]


424 reads


Flyway Desktop Projects for My PoC


In a previous post, I set up the basic databases for the PoC project...

Daily Coping 30 Jan 2023


Today’s coping tip is to plan something fun and invite others to join you....

Migrating or Recovering a TDE Protected Database 


When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...

Read the latest Blogs



By sqlguru

Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...



am getting the following when run report what can I do to fix this

This code works, but am requesting help with the code.

By Doug

Hello everyone.  I don't post here often even though I am constantly on the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers