Click here to Skip to main content
15,117,549 members

Articles by Keshav Singh (Articles: 32, Tip/Trick: 1)

Articles: 32, Tip/Trick: 1

RSS Feed

Average article rating: 4.34

Database Development
SQL Server
Posted: 23 Jun 2011   Updated: 23 Jun 2011   Views: 160,213   Rating: 4.61/5    Votes: 31   Popularity: 6.88
Licence: The Code Project Open License (CPOL)      Bookmarked: 57   Downloaded: 0
Please Sign up or sign in to vote.
An article on replication in MS SQL Server
Posted: 22 Dec 2011   Updated: 22 Dec 2011   Views: 11,600   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
This demo session demonstrates a little POC as to how can you make your SSIS talk to you.
Posted: 6 Jan 2012   Updated: 6 Jan 2012   Views: 31,082   Rating: 3.00/5    Votes: 2   Popularity: 0.90
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
This video demonstrates a standard extract-transform-load in SSIS
Posted: 25 Feb 2011   Updated: 25 Feb 2011   Views: 16,880   Rating: 4.60/5    Votes: 5   Popularity: 3.22
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 0
Please Sign up or sign in to vote.
A very exciting feature in Microsoft SQL Server
Posted: 28 Feb 2011   Updated: 28 Feb 2011   Views: 29,070   Rating: 4.64/5    Votes: 7   Popularity: 3.92
Licence: The Code Project Open License (CPOL)      Bookmarked: 22   Downloaded: 0
Please Sign up or sign in to vote.
Monitoring Free Space on Microsoft SQL Server
Posted: 8 Mar 2011   Updated: 8 Mar 2011   Views: 83,841   Rating: 4.80/5    Votes: 14   Popularity: 5.50
Licence: The Code Project Open License (CPOL)      Bookmarked: 29   Downloaded: 0
Please Sign up or sign in to vote.
CDC is a new feature for logging DML changes. In this article, we will see how CDC could be put to use and how efficiently it could serve our purpose.
Posted: 8 Mar 2011   Updated: 8 Mar 2011   Views: 74,413   Rating: 4.71/5    Votes: 6   Popularity: 3.67
Licence: The Code Project Open License (CPOL)      Bookmarked: 22   Downloaded: 0
Please Sign up or sign in to vote.
An important new feature of MS SQL Server 2008 that provides a true auditing solution - SQL Server Audit.
Posted: 11 Mar 2011   Updated: 11 Mar 2011   Views: 39,700   Rating: 4.50/5    Votes: 3   Popularity: 2.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 0
Please Sign up or sign in to vote.
How the Copy Database Wizard can be helpful to users working on upgrades and migration projects.
Posted: 2 May 2011   Updated: 2 May 2011   Views: 290,879   Rating: 4.84/5    Votes: 72   Popularity: 8.97
Licence: The Code Project Open License (CPOL)      Bookmarked: 100   Downloaded: 0
Please Sign up or sign in to vote.
This article focuses on how MS SQL Server uses indexes to read and write data.
Posted: 13 May 2011   Updated: 13 May 2011   Views: 30,021   Rating: 4.50/5    Votes: 3   Popularity: 2.15
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
SQL Server 2008 provides a very efficient SQL policy administrator which constantly monitors the server and reports errors appropriately. Administrators can define policies and ensure that they are being adhered to by evaluating the policies.
Posted: 26 May 2011   Updated: 26 May 2011   Views: 21,481   Rating: 4.60/5    Votes: 4   Popularity: 2.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 0
Please Sign up or sign in to vote.
Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the first part.
Posted: 26 May 2011   Updated: 26 May 2011   Views: 16,700   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Through this video I have tried to explain the concept of log shipping in MS SQL Server. It's broken into 2 parts, this is the second part.
Posted: 9 Jun 2011   Updated: 9 Jun 2011   Views: 18,280   Rating: 4.13/5    Votes: 5   Popularity: 2.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 24   Downloaded: 0
Please Sign up or sign in to vote.
Mirroring is the best database fail over option used by the SQL Server DBAs today. I hope this contribution adds little value to the beginner level DBAs.
Posted: 9 Jun 2011   Updated: 9 Jun 2011   Views: 15,840   Rating: 4.13/5    Votes: 5   Popularity: 2.89
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   Downloaded: 0
Please Sign up or sign in to vote.
Mirroring is the best database fail over option used by the SQL Server DBAs today. I hope this contribution adds little value to the beginner level DBAs.
Posted: 14 Jun 2011   Updated: 14 Jun 2011   Views: 71,830   Rating: 4.63/5    Votes: 19   Popularity: 5.92
Licence: The Code Project Open License (CPOL)      Bookmarked: 30   Downloaded: 0
Please Sign up or sign in to vote.
An introduction to the database snapshot functionality in MS SQL Server. It is one of the important tools used for generating data for reporting purposes.
Posted: 15 Jul 2011   Updated: 15 Jul 2011   Views: 19,470   Rating: 4.50/5    Votes: 4   Popularity: 2.71
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
This article is nothing but a very critical real time scenario that I have faced for a Delta Derivation warehousing project where I found the newly incorporated Merge keyword in SQL Server of immense importance.
Posted: 11 Oct 2011   Updated: 11 Oct 2011   Views: 198,835   Rating: 4.81/5    Votes: 31   Popularity: 7.10
Licence: The Code Project Open License (CPOL)      Bookmarked: 36   Downloaded: 0
Please Sign up or sign in to vote.
Views In SQL Server
Posted: 1 Nov 2011   Updated: 1 Nov 2011   Views: 223,713   Rating: 4.87/5    Votes: 38   Popularity: 7.46
Licence: The Code Project Open License (CPOL)      Bookmarked: 40   Downloaded: 0
Please Sign up or sign in to vote.
CTE In SQL Server
Posted: 6 Jan 2012   Updated: 6 Jan 2012   Views: 16,850   Rating: 4.33/5    Votes: 2   Popularity: 1.30
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
This video explores how we can setup a system to detect issues when, my replication fails or SQL Job fails or there is an alert fired.
Posted: 2 Apr 2012   Updated: 2 Apr 2012   Views: 25,260   Rating: 4.75/5    Votes: 4   Popularity: 2.86
Licence: The Code Project Open License (CPOL)      Bookmarked: 17   Downloaded: 0
Please Sign up or sign in to vote.
This is a technical article for new bees on how to upload/update/download files (picture/mp3/excel/doc) into sql server database.
Posted: 2 Apr 2012   Updated: 2 Apr 2012   Views: 22,040   Rating: 3.75/5    Votes: 4   Popularity: 2.26
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
This video describes how to generate table scripts with/without data in SQL Server 2008.
Posted: 2 Apr 2012   Updated: 2 Apr 2012   Views: 13,660   Rating: 4.17/5    Votes: 3   Popularity: 1.99
Licence: The Code Project Open License (CPOL)      Bookmarked: 11   Downloaded: 0
Please Sign up or sign in to vote.
This video discusses a typical scenario where mirroring and replication happens hand in hand on the same database. It is important for those who implement mirroring as high availability solution for their database and also replicate/publish some articles (tables). There are certain settings which al
Productivity Apps and Services
Microsoft Office
Posted: 16 Dec 2011   Updated: 16 Dec 2011   Views: 49,001   Rating: 4.86/5    Votes: 7   Popularity: 4.10
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 0
Please Sign up or sign in to vote.
In this video article
Programming Languages
SQL
Posted: 7 Aug 2012   Updated: 7 Aug 2012   Views: 26,272   Rating: 4.00/5    Votes: 3   Popularity: 1.91
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
This is a very simple and brief video on variables, expression and casting of them in SSIS. It will also teach developers to pass result sets in SQL task.
Posted: 2 Apr 2012   Updated: 2 Apr 2012   Views: 12,910   Rating: 3.00/5    Votes: 3   Popularity: 1.43
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
In this video you will learn to make adhoc reports on the fly with the help of MS excel. You will be able to connect to SQL Server Databases or SQL Server Analysis Server Cubes and generate reports for specific business
SSIS
Posted: 19 Dec 2011   Updated: 19 Dec 2011   Views: 30,572   Rating: 3.89/5    Votes: 2   Popularity: 1.17
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
Dynamically export data to Flat File using SSIS
Posted: 21 Dec 2011   Updated: 21 Dec 2011   Views: 21,591   Rating: 4.17/5    Votes: 6   Popularity: 3.24
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
This video shows the essence of parallel processing in SSIS.
Posted: 23 Dec 2011   Updated: 23 Dec 2011   Views: 36,431   Rating: 2.38/5    Votes: 5   Popularity: 1.67
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 0
Please Sign up or sign in to vote.
In this video you will learn to deploy SSIS package in both SQL Server (MSDB) format and File System format
Posted: 23 Dec 2011   Updated: 23 Dec 2011   Views: 24,681   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
This article describes how to pass values from parent package to a child in SSIS.
Posted: 7 Aug 2012   Updated: 7 Aug 2012   Views: 36,760   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
This video introduces Package Configurations to the SSIS developers, you will learn: XML Configuration a.) Direct b.) Indirect (Using Environment Variables), Environment Variables, and SQL Server Configuration
Posted: 30 Aug 2012   Updated: 30 Aug 2012   Views: 24,232   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
This SSIS training video will explain data viewers.
Posted: 30 Aug 2012   Updated: 30 Aug 2012   Views: 15,240   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
This video explains conditional split transformation for SSIS.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.75

Programming Languages
SQL
Posted: 30 May 2011   Updated: 31 May 2011   Views: 22,020   Rating: 4.75/5    Votes: 3   Popularity: 2.27
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
Model System DB in Microsoft SQL Server

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Keshav Singh
Database Developer
India India
I am a Microsoft certified Technology Specialist in MS SQL Server 2008 and 2005.I have fair amount of experience and expertise in MS database development, administration and modeling and MS BI. Started my career in 2007 and primarily into MS databases, and later diversified into MS BI especially SSIS. I also have a little exposure in Oracle 10g while working on one of the migration projects. But MS SQL Server is my passion!

Firm believer in knowledge grows from sharing, I really like reading books, trying new features and sharing the little that I know. Unless we're willing to have a go, fail miserably, have another go, success won't happen. The best thing I have discovered about myself is the "never say die" attitude. The best comment I have ever received is when my manager at my first job said "when this guy works he throws away his watch".