Archive for the ‘Internals’ Category
PAGE_VERIFY – Checksum vs. Torn Page Detection
All this talk of testing backups and data integrity and checksums has me thinking that maybe now would be a good time to discuss page verification options in SQL Server. Sometimes bad things happen to good SANs and data pages aren’t quite the same when we read them as when we wrote them to disk. [...]
June 7, 2012
Tags: checksum, data integrity, SQL Server, torn page detection Posted in: Internals 
2 Comments
Custom TDS Endpoints: Listening on multiple ports
Last time, I talked about how clients communicate with SQL Server through TDS endpoints and how to disable endpoints to prevent user access. Today we’ll see how we can configure SQL Server to listen on multiple ports through the use of user-defined endpoints. Create a new TDS endpoint There can only be one Shared Memory [...]
April 18, 2012
Tags: connectivity, network, SQL Server, TDS Posted in: Internals No Comments
TDS Endpoints: SQL Server’s “Listener”
In the land of Oracle, if you want to prevent user access to your database, you stop the listener. Without that agent running, you can still connect to the database locally, via shared memory, but all TCP/IP connectivity is disabled. As a DBA, this is pretty handy if you need time to perform maintenance tasks [...]
April 17, 2012
Tags: connectivity, Internals, network, SQL Server, TDS Posted in: Internals 3 Comments
