tag:blogger.com,1999:blog-66733192011-12-10T01:59:07.765-08:00Hi This is Veer..I am Microsoft SQL JUNKIE working online from almost every where except from my Toilet(till it gets online)...I am focussed on SQL2000 and YUKON but have good interest on DOTNET technologies...(YUKON junkie Dot Net Charmer...Veer...) <center> <a href="http://groups.yahoo.com/group/sqlcon/join"> <img src="http://us.i1.yimg.com/us.yimg.com/i/yg/img/ui/join.gif" border="0" alt="Click here to join sqlcon"><br> Click to join sqlcon</a> </center>khaqsarnoreply@blogger.comBlogger131100tag:blogger.com,1999:blog-6673319.post-1123912760916874222005-08-12T22:57:00.000-07:002005-08-12T22:59:20.920-07:00

I am writting about my SQL and IT stuff on geeks these days...Till I synch these two blogs please follow this linkMY OTHER SQL BLOG A BIGGER AND BETTERAlso I ahve my Space on MSN which has increased manifold in past few months

khaqsarnoreply@blogger.com79tag:blogger.com,1999:blog-6673319.post-1091156301290841592004-07-29T19:55:00.000-07:002004-07-29T19:59:00.153-07:00

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

khaqsarnoreply@blogger.com1tag:blogger.com,1999:blog-6673319.post-1089692367541448202004-07-12T21:17:00.000-07:002004-07-12T21:19:27.540-07:00

/* Written By :- Veer ji Wangoo (India) http://vsql.blogspot.com Inputs from:- Dinesh Asanka(Sri Lanka) SqlServer Central http://www.geocities.com/dineshasanka/index.htm Dated :- 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

khaqsarnoreply@blogger.com18tag:blogger.com,1999:blog-6673319.post-1089098486265779652004-07-06T00:16:00.000-07:002004-07-06T00:21:26.266-07:00

Just last week this buzz word hit my head at South Ex Cofe Shop while talking to Sourabh..then all of a sudden things where getting carzy as Sudhakar mentioned in his comments on pooja BLog ("Your blog gonna be a one stop shop for Monad ")..Thats what Happened to me as well.. It was my final stop there..So To lok at originals as Pooja has put a Copyright sign on her Paper on Monad so I am

khaqsarnoreply@blogger.com2tag:blogger.com,1999:blog-6673319.post-1088066190677063092004-06-24T01:35:00.000-07:002004-06-24T01:43:03.163-07:00

SQL Server's default TCP/IP port is 1433 and uses the UDP port of 1434. You cannot change the UDP port from 1434 to another, which is what helped the SQL Slammer virus spread so quickly. The UDP port is constantly listening on port 1434 and when ping responds with the TCP/IP port SQL Server listens on. Default instances of SQL Server use TCP port 1433 by default. 1433 is the official Internet

khaqsarnoreply@blogger.com61tag:blogger.com,1999:blog-6673319.post-1087887261117900922004-06-21T23:52:00.000-07:002004-06-22T00:20:32.906-07:00

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 Wangoo Applies to : - SQL SERVER “YUKON” Beta 1 Target Audience :- SQL DBA,Solution Architects,IT analysts ,Developers etc Introduction The world of Programming had never

khaqsarnoreply@blogger.com19tag:blogger.com,1999:blog-6673319.post-1087381134651580562004-06-16T03:17:00.000-07:002004-06-16T03:56:43.516-07:00

Since last two mails I was wondering as to what is this RSS Stuff going:- Very confusing word ??? I was wondering how cum our technical group went into political doldrums... No wonder as they say lesser mortals think a lot... So here we break the jinx.I have collected some info and links to some sites that will make you understand the whole crux of the RSS technology. What is RSS? RSS (Rich

khaqsarnoreply@blogger.com6tag:blogger.com,1999:blog-6673319.post-1087303246438727702004-06-15T05:39:00.000-07:002004-06-15T05:40:46.436-07:00

To convert the format of a Date Time String transformation 1. On the Transformations tab of the Transform Data Task Properties or Data Driven Query Task Properties dialog box, click the Source column containing the date or time to be modified, and then click the Destination column where you want the modified string to be placed. 2. Do one of the following: --If there is a mapping arrow

khaqsarnoreply@blogger.com4tag:blogger.com,1999:blog-6673319.post-1087273431456107032004-06-14T21:22:00.000-07:002004-06-14T21:23:51.456-07:00

It happened in UK last month that 137 (UDP), 138 (UDP), 139 (TCP), 445 (UDP & TCP), 593 (TCP), 1433 (TCP), 1434 (UDP), 27374 (TCP) were blocked by NTL broadband services on the pretext of Virus vulnerability. This inturn affected MS SQL users a lot as 1433 was blocked. I request the whole group to debate this issue. I am putting the initial crux of these articles as they appear on the NTL

khaqsarnoreply@blogger.com20tag:blogger.com,1999:blog-6673319.post-1085647688238794792004-05-27T01:45:00.000-07:002004-06-04T02:39:26.990-07:00

Before planning for the capacity of the SQL Server we must include the following details 1. Resource Requirements. 2. Process Flow Chart. 3. System Classification. 4. CPU and Memory Management. 5. Disk Planning. 6. Data Storage Subsystem Management. 7. Database File Placement. 8. Monitoring For capacity management. 1. Resource Requirements: - By Resource Requirements we must be able to

khaqsarnoreply@blogger.com39tag:blogger.com,1999:blog-6673319.post-1082689781313366992004-04-22T20:09:00.000-07:002004-04-22T20:13:49.560-07:00

Check out the cool guide introduced by Microsoft for handling the Production issues on SQL 2000. This guide is presented within the structure of the Microsoft Operations Framework (MOF) methodology. There are numerous documents that should be read to fully understand MOF and its related Frameworks, and a summary has been provided in the next section. MOF is a representation of the cyclical

khaqsarnoreply@blogger.com1tag:blogger.com,1999:blog-6673319.post-1082615702478409192004-04-21T23:35:00.000-07:002004-04-24T07:16:02.200-07:00

Hi From MUGH and SQLCON we would like to thank all who participated in the yesterday discussion. Am attaching few links which where part of our discussion and other helpful links that could be useful for performance tuning. Join Hints http://www.mssqlcity.com/Articles/General/NestLoop.htm http://www.mssqlcity.com/Articles/General/HashJoins.htm http://

khaqsarnoreply@blogger.com1tag:blogger.com,1999:blog-6673319.post-1080244214457256662004-03-25T11:49:00.000-08:002004-03-25T11:53:43.310-08:00

Introduction Good Application Architecture is essential for any application to perform better than best ,but without the proper Database Support it becomes a distanct dream. Software Enggs particularly our DBA s spend hours discussing the performance pit falls of any database design,But once production starts or in testing,whole new world of issues arise with respect to Database. Most

khaqsarnoreply@blogger.com1