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. […]
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 […]
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 […]
