SQLServerCentral Editorial

Decoupling the Database

Database refactoring is a difficult proposition at the best of times, but is rendered more or less impossible if the database is close-coupled to the application's other components. In a guest editorial, Mladen Prajdic stresses the importance of a native SQL Server abstraction layer.

(1)

You rated this post out of 5. Change rating

2010-11-22

2,774 reads

Blogs

More fun with Git: git restore

By

The setup My day job involves babysitting a lot of Git repositories hosted on...

When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages

By

Recently, the world was reminded of just how fragile the internet can be.  Two...

Prepping for Certification, Part 4 of 4

By

In Parts 1-3, I covered how I prepare for a certification exam. In this...

Read the latest Blogs

Forums

Catalog max connection pool size: 100

By Pete Bishop

Seeing this message repeated every 10 seconds in the RSHostingService_yyyy_mm_dd_hh_mm_ss.log file. Can anyone advise:...

CAST datetimeoffset(7) as a datetime in UK format

By tylerschuler75

I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...

what are the downsides of TDE not running vs running?

By stan

hi for the 2 years i've been here I believe we've had "encryption" turned...

Visit the forum

Question of the Day

Putting the Player with the Number

In SQL Server 2025, what does this return?

DECLARE @player varchar(20) = 'Bo Nix',
@num VARCHAR = '10'

SELECT @player || @num

See possible answers