Microsoft SQL Server

Using NOLOCK Hint

Use NOLOCK hint to avoid block – this is what I have often heard/see in many forums I participate in, during local user group events and meetings. I have always advised that its not that good idea to use hints, as it may cause data corruption and blocking. And anyways, there are many things that you can do to avoid blocking, like:

Troubleshooting SSPI handshake error

I have seen lots of questions floating in the msdn forums about SSPI Handshake error, the main question is around error code 0x80090311 which is indicative of the authentication failure error. Apart from this, there are many other reasons for SSPI Handshake error to appear in error logs. I cover them here.

Log Buffer #248, A Carnival of the Vanities for DBAs

Simple messages are the most powerful. Keep it simple is the advice given by top technologists. One reason why blogs are extremely popular is their simplicity. This simplicity comes from the shortness and focus of the message of the blog. This Log Buffer Edition collects some simple yet powerful blog posts for you in Log Buffer #248.

Log Buffer #247, A Carnival of the Vanities for DBAs

Thanksgiving is here and the circular chain of thankfulness is going on. Clients are thankful that they have applications, applications are thankful to their databases, database are thankful to their DBAs, and DBAs are thankful to clients. And they all are thankful that there is weekly Log Buffer Edition, of which the latest is Log Buffer #247. :)

Log Buffer #245, A Carnival of the Vanities for DBAs

Getting stuck on technical problems is a norm in the life of any IT professional and DBAs are no exception. With evolving databases and their streaming new features make it more challenging. Blogs often provide the Eureka moment for those problems. So sit back and enjoy this Log Buffer Edition, which is Log Buffer #245.

Page 21 of 50« First Page...10...1920212223...30...Last Page »