Tag: Microsoft SQL Server

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

A very very Happy New Year 2012 to all of you. These are the festive and jubilant times when people look back on previous years and make plans for their new year and beyond. Well, this Log Buffer Edition is no different. This week covers the new year posts of the bloggers across the database arena in Log Buffer #253.

Read More >

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

As we all look forward eagerly to 2012, bloggers around the gblobe are writing about their insightful reflections on 2011. You’re also welcome to write your’s regarding to database arena in the comments, if you like. This Log Buffer Edition welcomes you to the new year with festive posts from Oracle, SQL Server and MySQL bloggers in Log Buffer #252.

Read More >

What’s new in SQL Server RC0 setup

In this post I quickly cover the new features in SQL Server RC0 setup.

Read More >

SQL Server Licensing Changes May Mean Something for DBAs

In this post I’ll Briefly cover the changes to SQL Server licencing which happened in two areas, edition changes and licensing changes. Lets get started.

Read More >

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

ew Year is the time to bid farewell to the old year and welcome the coming year. It is the time to remember the golden olden blog posts. It is the time for new beginnings and new starts in life, and of course for new blog posts. Bloggers in the database arena are also enjoying the festivities with full zeal and zest and this Log Buffer Edition, which is Log Buffer #251 covers just that. Happy Holidays.

Read More >

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

Tis the season to be fearless in blogging and read the blogs around the database globe. To make your foray in intrepid world of database blogs, this Log Buffer Edition compiles some of the most interesting posts in this Log Buffer #250.

Read More >

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

Welcome to Log Biffer #249, the weekly review of database blogs.

Read More >

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:

Read More >

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.

Read More >

SQL Server 2012 Denali: Discussion On Usage Scenario for “Extended Events” (Part-1)

In this blog, I am going to demonstrate how we can use the wait event category sqlos.wait_info* to track the wait resources the queries running in a particular session undergo.

Read More >
Page 22 of 50« First Page...10...2021222324...30...Last Page »