Blogs

Today I was sitting inside a training that my friend Pinal Dave was doing. Spent just about over an hour with the attendees, what came to my notice is some of the simple text statistics techniques that have been with SQL Server for more than a decade...

Many a times there are needs to figure out if really there are instances where SQL Server components were raising Out-Of-Memory conditions. A quick way to keep track of this is to track the ring_buffers table. Typically you will use something like this...

The new Microsoft Assessment and Planning (MAP) Toolkit 5.0 is now available for download! MAP 5.0 is an agentless tool designed to simplify and streamline the IT infrastructure planning process across multiple scenarios through network-wide automated...

Majority of the folks over various conversations tell me there are not much of changes with the R2 version. Well, there are tons of little things that make the product better and better both for Developers and ITPro’s alike. In this list is some subtle...

I have been using Outlook 2010 for a while and one of the interesting part of the new version while using with Win 7 is this interesting icon that gets set with “Large Icons” on the taskbar. In the recent past, I suddenly did some changes to the settings...

In SQL Server 2008, the DECLARE statement has been extended to allow specifying an initial value along with the declaration. Not sure how many of you have taken a chance to use this feature … Beyond the normal looks there is more to this than the eye...

Continuing the conversations around CHECKDB and my session at TechEd. Here is another interesting trivia about CHECKDB and its usage against TempDB. If you remember the post around CHECKDB going ONLINE on the blog the usage of Snapshot internally is something...

The series of activities I have been writing on CHECKDB, I just dont seem to stop exploring interesting things about this command. It is so powerful that I just love it. In a session with MS Internal IT today I was talking about how CHECKDB is done as...