CHECK it

Who designed MSDB ??

It looks abnoxious when as MS MVP I advocate MOF/MSF Database Designs for customers and USers but still one of our main System Databases named MSDB has columns which are related to Datetime have been kept as INT... WHo Designed this Database and WHo pruned it... I wish to meet them .. God... It wasted my extra time and Extra resources to get them casted , So that my RDL can just publish the report on SYSJOB and SYSJOB HISTORY.. RUN_DATE and RUN_TIME why are they int type ?? By any standard both should...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, May 24, 2007 8:39 PM | Feedback (1)

Why GUEST ACCOUNT SQL Server

It has been long time that I am back on my Blog... But trust me I missed it more than it might have missed me.. Okay here is a kwel finding.. For those who are confused about Guest account in SQL server Databases.. Well we need GUEST account in Master and TEMPDB ... because when when we create login that person should get authenticated at least w.r.t Public Profile.. then onwards suppose if he/she hasnt been added to any Database then he will keep on looking at Master DB from Public profile with...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, May 24, 2007 8:36 PM | Feedback (3)

Vista for lesser mortals

Few days back someone made a comment “what the hell you know about VISTA” .. I didn't respond much ..but smiled... Slowly I tried to navigate and gather information about Vista if not knowledge about it.... somehow I felt Comfortable enough to write some lines about it... Here I go ... SIDE TRACK :- Few days back we had three day Session on VISTA for dev MVPS and Vinod provided some nice presentations and demos...although I being long away from DEV but still enoyed it asDI was able to...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Thursday, June 01, 2006 4:21 AM | Feedback (2)

Teched 2006 :: Things to Watch For from ::: SQL IT perspective

Well lots of buzz in the town.. watched some kwel thoughts around and listened to some wild wind about Teched 2006. But here is my recommended list for IT pro people and particularly those who work in remote management Believe me you should start from here {Click it}.... where Teched is more than we thought about it .... Dont miss the big MVP Logo on the left handside.... ask me if you want to know what it means...??? Some good sessions that I am interested in Using CLR inside SQL Server: Best Practices[Nauzad...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Wednesday, May 31, 2006 5:06 AM | Feedback (0)

Optimization Examples I used in my recent Seminar (Unedited and Without Formating)

It was packed room of some 40 Odd people in Noida and from developers to DBAs anb my 8 Hour long Seminar/Training/ Presentation for them. I have used lots of examples in that seminar worth mentioning are the last 13 examples but you can just try reading from here and hopefuly after page reads you will be on track WARNING First few pages are un formatted and might confuse you but carry on soon you will see a nice road ahead.Read SARGS,OPTIMIZER, and INDEXs for refernce here Lets start from here:-...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati
Posted On Monday, May 02, 2005 12:56 PM | Feedback (4)