Archive

Archive for January, 2012

Introduction: .NET Framework Data Providers

Here, I’m going to discuss a very popular and common question that I have always faced during .NET interviews: What is .NET Framework Data Provider and what types of data providers does .NET Framework support?

The .NET Framework data provider is nothing but a built-in library that provides various functions/methods to a .NET application to interact with a specific type of data source. When we are trying to make a connection with a particular data source, we need to let the hardware machine, called server and the operating system know that we wish to connect to a server application, usually called RDBMS. In order to do so, we need to connect to the port of that machine and send the request across to the operating system at first, and then that is handed over to the data source application.

Read more…

Advertisements

Introduction to DataSet in ADO.NET

Today, I’m going to talk about the DataSet in ADO.NET. Before I go ahead with the DataSet, I would like to discuss little bit about the pitfall of ADO (ActiveX Data Objects) that we used during Microsoft classic technologies like VB 6.0 to handle data in an application.

If one wants to pull the data out from a data source and keep it into memory using ADO, we can do it using something called ADODB record set. This object make data available to you but it requires data source connection to be alive all along. If you close the connection, you lose the data in ADODB record set immediately. Here we face the problem. We can’t keep connections open all the time as it puts unnecessary load on the data source server.

ADO.NET provides the remedy to this problem by introducing the Connected and Disconnected architecture.

Now, if you wish to pull the data out in your application and work with that without keeping data source connection alive, you can do so using DataSet object. That’s the beauty of this object.

Read more…

The .NET Framework Evolution Map

The .NET Framework evolution is a topic where everyone is having different things to say. Everyone is having different chronology or evoloution map for it. I myself was little bit confused about it.

So, here goes the list:

Version
Version No. Release Date Visual Studio
1.0 1.0.3705.0 13-Feb-2002 Visual Studio .NET
1.1 1.1.4322.573 24-Apr-2003 Visual Studio .NET 2003
2.0 2.0.50727.42 7-Nov-2005 Visual Studio 2005
3.0 3.0.4506.30 6-Nov-2006  
3.5 3.5.21022.8 19-Nov-2007 Visual Studio 2008
4.0 4.0.30319.1 12-Apr-2010 Visual Studio 2010
4.5 4.5.40805 13-Sep-2011 (Dev. Prev.) Visual Studio ’11’

 

I’m providing two links that discuss about the .NET Framework evolution. The first link provides summary: See .NET Framework Evolution Summary and the second link provides complete details about the .NET Framework, even patch details: See .NET Framework Evolution Complete Chart.

I got this information from the wikipedia.org. Thanks to you guys!

Trust it helps everyone out to have a clear idea about the .NET Framework evolution.

About the author

Dhananjay Kumar UpadhyayHi, and welcome to DhananjaySpeaks Consulting!

My name is Dhananjay Upadhyay. I’m a software consultant, corporate trainer, writer and speaker based out of  Bangalore, Bharat (India).

I am having 16 years of experience in the IT industry. I conduct technical workshops and provide consultancy on Microsoft .NET and SQL Server technologies as a Solutions Architect. I’m passionate about Web-based and Business Intelligence technologies like Artificial Intelligence, Machine Learning, Python, R Programming, IoT, Blockchain, AngularJS, TypeScript, ReactJS, Node.js, Microsoft Azure, ASP.NET MVC, RESTful Web API, JavaScript Frameworks, Data Warehousing, Reporting, Analysis, ETL, PowerBI, MDX, DAX, etc.

I’m a Microsoft certified professional, having following certifications:

  • Microsoft Certified Trainer (MCT) since 2012
  • Microsoft Certified Solutions Associate (MCSA) – SQL Server 2014
  • Microsoft Certified Professional Developer (MCPD)
  • Microsoft Certified IT Professional (MCITP)
  • Microsoft Certified Technology Specialist (MCTS)
  • Microsoft Certified Solutions Developer (MCSD.NET)
  • Microsoft Certified Application Developer (MCAD.NET)
  • Microsoft Certified Professional (MCP)

I head a consulting firm DhananjaySpeaks Consulting as CEO, based out of Bangalore, Bharat (India).

My clientele includes companies like Accenture, Siemens, HP, Mphasis, Honeywell, L&T Infotech, L&T Technology Services, DELL, Capgemini, Logica, CGI, HCL Technologies, MindTree, Cognizant, Fidelity, Ariba, Sonata, EMC Square, Manhattan Associates, ANZ, Bank of America, ABB, Ernst & Young, FIS Global, Steelwedge, Kennametal, Sumeru Inc., XLCare, GBM (Bahrain), Bapco (Bahrain), Siddaganga Institute of Technology, Studec, Exilant, Craft Silicon, NettPositive, Novozymes, NuWare, etc.

I’m also part-time faculty/trainer with The Art of Living, the biggest and fastest growing NGO in the world. And, my entire world revolves around my guru, Poojya Gurudev Sri Sri Ravi Shankar Ji, founder of The Art of Living.

You can reach me at dhananjayspeaks@yahoo.com or follow me on Twitter: @dhananjayspeaks.

Microsoft SQL Server 2008 Certification Details

If you wish to get certified on Microsoft SQL Server, here goes the link, which contains complete details about it: http://www.microsoft.com/learning/en/us/certification/cert-sql-server.aspx#tab4

Below link gives you details about Microsoft’s all server products certification details: http://www.microsoft.com/learning/en/us/certification/mcitp.aspx#tab2

Below document shows you the SQL Server certification path, which gives you clarity how to go ahead about it: SQLServer2008CertificationPath

Best of luck…

 

Download SQL Server Sample Databases including SQL Server 2012

I’ve always come across the same query from my participants: Where can we donwload the SQL Server sample databases from i.e. AdventureWorks? People do ask for sample databases for different versions of SQL Server i.e. 2005, 2008, 2008 R2 and now for 2012 as well.

So, here is a link which contains download details about sample databases i.e. AdventureWorks for all versions of SQL Server including SQL Server 2012 RC0:

http://msftdbprodsamples.codeplex.com/

Enjoy!!!

MDX Functions Reference Document (.pdf)

This document contains most of the MDX functions details along with examples.

I found it very useful when I started learning MDX. Beauty of this document is that it contains functions as per their logical category like Array Functions, Set Functions, Level Functions, etc. This compilation approach helps a lot when we need to search for a particular function for a specific job.

Click below link to download it:

Collection of MDX Functions