Geeks With Blogs
My Place For SQL Lets Talk SQL July 2004 Entries
Beleive it from Hashims Lock Down Mechanism
He should have been the Lockup Man in Tihar because he knows better ways to lock and unlock the system.... Here is a nice trick to lock your system as I found it in Hashims Blogs..Liked it alot... If CTRL-ALT-DELETE seems like too much of a hassle, try this instead: 1. Right click an empty spot on the desktop, point to New and clickShortcut. 2. In the Create Shortcut dialog box, type the following into the Type thelocation of the item text box:"rundll32 user32.dll,LockWorkStation" // remove quotes ......

Posted On Friday, July 30, 2004 4:50 AM

Interesting SQL IO information
I was fine tuning a Script Batch and wondered abt the different results been given out by profiler,Statistics io and Sysprocess...I was in utter choas (which I luv at times as that choas leads me to truth ). I digged in and found following document which explains why they summarize results on READ/WRITES differently...A very interesting scenerio or for you reading here it is There are several different places in which SQL Server reports different input/output ......

Posted On Friday, July 30, 2004 4:47 AM

YUKON-A Snap Shot Look
Resources Covered: - · Introduction· Review of Features· Enhancements· DTS Redefined· Deployment and Management· Hand Shake of Brothers (.NET and YUKON) or Marriage of Romeo and Juliet.Author: - Veer Ji WangooApplies to : - SQL SERVER “YUKON” Beta 1Target Audience :- SQL DBA,Solution Architects,IT analysts ,Developers etcIntroductionThe world of Programming had never moved so fast as it did in last couple of years. After Y2K the things got so fast that it ......

Posted On Tuesday, July 20, 2004 3:48 AM

PasssWord Encryption in SQL 2000
/*Written By :- Veer ji Wangoo (India) http://vsql.blogspot.comInputs from:- Dinesh Asanka(Sri Lanka) SqlServer Central :- 12 July 2004 A very simple and unique way to encrypt Password in your database application using a function called pwdencrypt Lets have look at it,we first create a table named [UserTab] which will have two columns along with a UserTab .Note the data Typevarbinary(255) to include Hashed encrypted value in the Table*/ CREATE ......

Posted On Tuesday, July 13, 2004 2:22 AM

Copyright © Veer Ji Wangoo | Powered by: