Steve Wynkoop and I talk about designing and managing our professional careers on a weekly interview on SSWUG.org. This episode was about how to prepare for that important interview. This article goes into more detail.

(Ted Krueger) The missing index feature, while tuning or checking estimated and actual plans, is very helpful. Something that is key in that sentence is the word, helpful. Don’t run out and simply create all of them.

(S.Kaur) In a support center there are agents who assist customers for solving their issues with company products. Company needs to track, amount of time spent by agents on various activities.

(K. Brian Kelley) I have a couple of databases supporting applications. The first application requires that it’s user be a member of the db_owner role. The second application actually has to own the database. What are the effects of having such permissions?

(Shiva sagar) Few days ago, I had redone my local home network. I have LAN setup with wireless router connected with my four computers, two mobile devices, one printer and one VOIP solution. I had also formatted my primary computer and clean installed SQL Server 2008 into it.

(Jason Strate) In a previous post, I discussed running SQLIO against multiple files. The purpose in using multiple files is being able to test not just a single volume’s capability to deliver data from storage, but to test the storage as a whole.

(Pinal Dave) I have previously written article how one can import a CSV file into a database table using SSIS package. This was a simple import operation when the CSV file structure corresponded to the table structure column-to-column.

(Buck Woody) Windows Azure has added Infrastructure-as-a-Service (IaaS), the ability to deploy, run and manage Virtual Machines, to its growing list of services. You can create Virtual Machines from a gallery, upload them from images you create locally on Hyper-V (that’s right, you can do that, even

(John Sansom) Ensuring excellent performance for users and customers is a high priority for Database Administrators.

(Dinesh Asanka) When no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances where you have heaps.