(Nelson John) In the last post, we have discussed the script to list the sessions which are waiting for resource or currently running. In this post let us see how to list the blocking sessions with required information.

(Edwin Sarmiento) In a previous tip on Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1, we have seen how to install and configure SQL Server 2008 on a Windows Server 2008 Failover Cluster. We now have a new requirement to deploy a SQL Server 2012 instance on a multi-subnet cluster th

In the previous newsletter article on Professional Development, we covered some office conflicts (don’t miss another professional newsletter tip—signup for the free newsletter here). A follow-up client question (regarding the previous newsletter article) was “If your workplace is getting too hard, b

(satnam singh) Recently on one of our staging servers had a memory consumption issue and even 32 GB of RAM was looking insufficient and application performance was being impaired. Initially I thought the cause would be poorly designed queries, but after a thorough investigation this turned out not t

(Mike Byrd) Many SQL Server data architects and developers have been strong proponents of letting an identity column define the primary key for large tables. Why not? The identity property is always increasing and newly inserted rows are always inserted at the end of the table – thus resembling (but

(Shaun J Stuart) I’ve written in the past about some of the ways you can configure SQL Server Management Studio to help you make your life a bit easier. I’ve discovered two more little tricks I thought I’d pass along.

(Pinal Dave) I have been recently exploring Elasticity and Scalability attributes of databases. You can see that in my earlier blog posts about NuoDB where I wanted to look at Elasticity and Scalability concepts.

(Stacia Misner) When I talk with DBAs and IT professionals about security, I usually hear a few groans or see some eyes rolling when I bring up the subject of Kerberos delegation, which many people refer to as simply Kerberos. Most people I encounter seem to think Kerberos is difficult to set up.

(Nelson John) In the Part 1, we have seen how quickly we can check the runnable task and I/O pending task on an SQL server instance. This is very light weight script and it will give the result even if the server is under pressure and will give an over all state of the server at that moment.

(Arshad Ali) When we are done creating a SSAS cube we often think of whether to use SSRS (SQL Server Reporting Services) or PPS (PerformancePoint Services) for the reporting UI. The question is what are the pros and cons of each of these approaches and in what scenario should one be chosen over the