I read a very interesting post on Kimberly Tripp's blog which was about indexing, but she had a very interesting set of requirements for good indexing that I think apply to everything when designing, tuning, backing up, etc., any database. What strikes me the most are 1) and 2) - how can you tune any sort of system if you don't really know ...

Hello guys, I have to write business solution for shortterm and new term. Scenario like this. There are two companies one is in JAPAN and other one is in UK they both making bikes. Now they merger togather, CEO is asking  the HRM department to have data of employees. Now company 1 is having won XP workstation with IBM DB2 ...

Thank you so much for all the responses to the DBA Blunders post! As I mentioned, however, that question was asked on behalf of a friend of mine. Now I have a question of my own. I am currently training a group of new junior DBAs. One of them has already started assisting with some client operations, but is still closely supervised. For those ...

''My name is Andy Leonard. I tweet.'' ''Hi Andy, we love you.'' It's true, I am a bona fide Twitter-holic. If you use the service you may have noticed disruptions lately. Frank La Vigne (recently married - congratulations Frank!) blogged about it. The Twitter developers are blogging about it. And they have raised the ire of Mr. Scoble, who ...

Information_schema.columns was introduced in SQL 7, but for some reason it disappeared in SQL 2000; then come back in SQL 2005.When I upgraded to SQL 2000, I simply copy the code from SQL 7, and create my dbo.columns. Here is the script for SQL2000 only.Enjoy it.go--Displays columns accessable to the current usercreate view ...

A good friend of mine is putting together a presentation on the top DBA Blunders from the view point of a SQL Server Database Admin, not developer. He would love to hear what other people consider to be in the big mistake list. Of course, you don't have to admit that these were your own blunders; they can be ones you heard about, or that 'a ...

I hope I'm not overstepping any boundaries, but I could not find any policies regarding notifying other users of available job opportunities.  There is a large financial player in NE Florida that will be hiring an MSSQL Server DBA to provide administrative and technical support for multiple ...

Buck Woody, Microsoft SQL Server Program Manager, recently posted a list of enhancements in the works for SQL Server 2008 RTM in the SQL Server MVP newsgroup. The usual suspects were included in the list: Policy-Based Management (formerly DMF), Resource Governor, Multi-Server Query, PowerShell, and IntelliSense - but there are also some ...

While this is nothing new, a conversation I had with a client the other day got me thinking more than I wanted to about what I see as sort of a double – standard for lack of a better term at the moment.  Now I fully realize this can turn into a full out war of opinions, I feel the need to blog about it. But please keep in mind the focus of ...

Eric Wise drew some heat from the developer community at CodeBetter.com with this post about the need for a DBA during development (see my post on the subject here). I think Eric makes a couple good points, one explicit, one implied: 1. (Explicit) A DBA - or Database Developer, more accurately (and there is a difference) - adds ...