tag:blogger.com,1999:blog-6512467284578588870Wed, 14 Oct 2026 13:12:51 +0000DatabaseSQL ServerDBOOPOOPSSQL Server 2005Database TestingClassespolymorphismInheritanceObjectsabstraction1NF2NFBCNFCM CrossroadsDe-NormalizationJIRANormalizationTFSabstract classencapsulationnvarcharnvarchar(max)varcharvarchar(max)Important/interesting topics on programming are discussed.http://geekiatrics.blogspot.com/noreply@blogger.com (Nikhil)Blogger14125tag:blogger.com,1999:blog-6512467284578588870.post-7112543348640262033Sat, 05 Feb 2011 05:30:00 +00002011-02-04T21:30:03.496-08:00CM CrossroadsJIRATFSHere is the link to my post on CM Crossroads. http://www.cmcrossroads.com/blogs-menu/community-blogs/tfs-or-jira.htmlhttp://geekiatrics.blogspot.com/2011/02/tfs-or-jira.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-3434690046421912738Sat, 25 Dec 2010 12:37:00 +00002010-12-25T04:37:00.060-08:00DatabaseDatabase TestingSQL ServerSQL Server 2005I came across this problem of backing up all the databases on my SQL servers (and there were 70 of them). I didn't want to back them up using the SQL Server GUI. While searching on the internet I got my hands on this script. Thanks to Geekzilla - DECLARE @DBName varchar(255) DECLARE @DATABASES_Fetch int DECLARE DATABASES_CURSOR CURSOR FOR select DATABASE_NAME = db_name(http://geekiatrics.blogspot.com/2010/12/to-backup-all-sql-server-databases.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-5110733204626440959Fri, 24 Dec 2010 11:50:00 +00002010-12-24T03:53:07.749-08:00Database TestingDBSQL ServerSQL Server 2005Want to get rid of the SQL Jobs in your SQL Server? All of them are stored in msdb. You would need to run the following queries to remove them. If there is a scheduled time that this job runs at, you would need to first remove that. delete from msdb.dbo.sysjobschedules where job_id in (select job_id from msdb.dbo.sysjobs where name like '%JobName%') delete msdb.dbo.sysjobs where name like '%http://geekiatrics.blogspot.com/2010/12/delete-sql-jobs.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-8794617235903021614Tue, 21 Dec 2010 18:49:00 +00002010-12-21T11:00:33.919-08:00DatabaseDatabase TestingDBSQL ServerSQL Server 2005I've been into positions multiple times where I've to delete the databases in my SQL Server environment to clean up the QA environment or my local machine where I accumulate these test DBs over a period of time. If you are looking for one such situation here is the script that can come as a help - declare @command varchar (1000) SELECT @command = 'IF ''?'' NOT IN(''master'', ''model'', ''msdbhttp://geekiatrics.blogspot.com/2010/12/delete-multiple-databases-in-sql-server.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-8463208804885098530Wed, 21 Jul 2010 10:37:00 +00002010-12-21T09:51:54.229-08:00DatabaseDatabase TestingFound this presentation on database testing on internet -http://geekiatrics.blogspot.com/2010/07/database-testing.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-4926774923682875205Fri, 30 Apr 2010 19:35:00 +00002010-12-21T10:31:45.044-08:00DatabaseDBSQL ServerSQL Server 2005Delete and Truncate are both commands in SQL to remove data from a table. But why do we have two commands? Are there any differences? YES! There are differences although the result is same. Both of them delete the data. Here are few of those differences - Delete Truncate Delete table is a logged operation, so the deletion of each row gets logged in the transaction log, which makeshttp://geekiatrics.blogspot.com/2010/04/delete-and-truncate.htmlnoreply@blogger.com (Nikhil)1tag:blogger.com,1999:blog-6512467284578588870.post-7848746039423061430Mon, 19 Apr 2010 18:08:00 +00002010-12-21T10:32:24.877-08:00abstract classabstractionClassesInheritanceObjectsOOPOOPSpolymorphismAs we have already discussed in the previous post, OOPS characterizes objects by their class. So, if you only know the name of the class, you can name some of the characteristics of an object, such as even if you don't know what a BMW is, if someone tells you that it belongs to the class car, you would know the basic characteristics. Another important concept related to classes in OOP is the http://geekiatrics.blogspot.com/2010/04/inheritance.htmlnoreply@blogger.com (Nikhil)2tag:blogger.com,1999:blog-6512467284578588870.post-4442389907608537945Sun, 18 Apr 2010 10:33:00 +00002010-12-21T10:32:50.499-08:001NF2NFBCNFDatabaseDBDe-NormalizationNormalizationSQL ServerDatabase normalization is a data design and organization process applied to data structures based on rules that help building relational databases.  Normalization is done to achieve the following goals: eliminating redundant data (for example, storing the same data in more than one table) ensuring data dependencies make sense (only storing related data in a table). Both of these are http://geekiatrics.blogspot.com/2010/04/normalization-and-de-normalization.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-7401298984375438264Sat, 17 Apr 2010 08:58:00 +00002010-12-21T10:33:10.197-08:00ClassesOOPOOPSA class is a blueprint or prototype from which objects are created. This section defines a class that models the state and behavior of a real-world object. It intentionally focuses on the basics, showing how even a simple class can cleanly model state and behavior. The best thing about OOP is , When we look around the world, we can relate things to OOP. We can find many Objects of the same http://geekiatrics.blogspot.com/2010/04/classes-in-oop.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-8407193820686443499Fri, 16 Apr 2010 17:45:00 +00002010-12-21T10:33:28.348-08:00DatabaseDBnvarcharnvarchar(max)SQL ServerSQL Server 2005varcharvarchar(max)VARCHAR and NVARCHAR are two datatypes that are used in SQL Server very frequently and interchangeably. We would see what is the difference if any between these two: VARCHAR is an abbreviation for variable-length character string. It's a string of text characters that can be as large as the page size for the database table holding the column in question. The size for a table page is 8,196http://geekiatrics.blogspot.com/2010/04/sql-server-varchar-vs-nvarchar.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-1091789161752904494Mon, 12 Apr 2010 17:49:00 +00002010-12-21T10:33:48.891-08:00abstractionencapsulationOOPOOPSpolymorphismContinuing from the last post, we will look at what it means with abstraction polymorphism encapsulation event Abstraction is the process of ignoring the sub-class properties and using the ones from super class when required. For Example, our own CharlizeTheron, a Female can at times be treated as HumanBeing. Polymorphism as the name itself suggests is the ability to take many shapes. For http://geekiatrics.blogspot.com/2010/04/oops-building-blocks-2.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-5919754780517172576Mon, 12 Apr 2010 00:00:00 +00002010-12-21T10:34:18.409-08:00ClassesInheritanceObjectsOOPOOPSpolymorphismHere are the basic blocks:Class Objects Methods Inheritance Polymorphism Abstraction Event Encapsulation Class defines the attributes/qualities of anything and the processes that it can carry out. It brings in the modularity to the software, which thus starts making sense to even a person who is not a programmer himself. This is because a class tries to emulate the real life properties/qualitieshttp://geekiatrics.blogspot.com/2010/04/oops-building-blocks.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-1685806561639178121Sun, 11 Apr 2010 10:55:00 +00002010-12-21T10:34:34.933-08:00OOPOOPSOOPS is the Computer programming concept that breaks the problem into smaller objects similar to real life. Traditionally, computer programming used to emphasize on solving the problems with functions and procedures. For every task there would exist a function. This was good but was confusing with complex products and softwares. Moreover, the data used to suffer because of this approach. All http://geekiatrics.blogspot.com/2010/04/object-oriented-programming-oops.htmlnoreply@blogger.com (Nikhil)0tag:blogger.com,1999:blog-6512467284578588870.post-1676340499206438963Sun, 11 Apr 2010 07:38:00 +00002010-12-21T10:34:51.491-08:00I'm starting this blog to freshen up  my programming concepts. It's been more than 4 years that I finished my education and have since been working with an MNC. Somehow, I felt the need to go back to the basics and study again to be able to hold fort in the field. and hence this blog was born. Over the next few months, I'll keep posting my learnings on this platform. Hope this would also http://geekiatrics.blogspot.com/2010/04/why-geekiatrics.htmlnoreply@blogger.com (Nikhil)0