Category Archives: FromSitesTree.com

Razor, Web-page Model, Web-Application Development in C# #19

Razor, Web-page Model, Web-Application Development in C#

  • Razor: a markup syntax to add server side code into ASP.net pages
  • Razor example: Current time is @DateTime.Now
  • Razor Code Syntax
               Single statement block          @{ var message = "Hello World"; }           Inline expression or variable           The message: @message           Multi-statement block           @{              var greeting = "Hello";             var currentTime = DateTime.Now;             var greetMessage = greeting + " Current time is: " + currentTime;           }           The greeting is: @greetMessage      
  • Some Razor functions mainly used in the Layout file [can be used in other files based on the function]: RenderPage() - render the content of a page, RenderBody(), RenderSection(section) - render the content of a section named section
  • using _ at the beginning of a web-page name prevents it from being browsed from browser such as _header.cshtml, _Layout.cshtml
  • In ASP.net, you can hide sensitive information by using the _AppStart.cshtml file. Here, you can keep database passwords, and email passwords. You can also keep your webmail server configuration.
  • _AppStart.cshtm example
                   @{                  WebMail.SmtpServer = "smtp.bizmail.yahoo.com";                  WebMail.EnableSsl = true;                   WebMail.UserName = "sayed@justetc.net";                 WebMail.Password = "password";                  WebMail.From = "sayed@justetc.net";             }           
  • Some folders as used in ASP.net web applications: App_Data - to keep database files, Images - image files, Scripts - JavaScript files for example, Shared - common files such as CSS files
  • In a file path, ~ is used to indicate the virtual root folder.
  • Server.MapPath, can convert a virtual path to a physical path
  • @Href(cssPath), here cssPath is a variable for a path. You can use Href(cssPath) for the value of href attributes
  • Page object methods: href (builds a url), RenderBody(), RenderPage(page), RenderSection(section), Write (object) - HTML Encoded string, WriteLiteral - No HTML encoding
  • Page object properties: isPost, Layout, Page, Request, Server
  • You can add properties to the Page object such as Page.Title; here Title is your own variable [not built in]
  • Read from a physical file: File.ReadAllLines(filePath). You may want to use var filePath = Server.MapPath("~/file.txt");, to get the physical path from a virtual path
  • File.ReadAllLines(filePath), can also be used to read excel csv files [comma delimited]
  • Some ASP.net helpers: Helpers are just components. WebGrid, Chart, WebMail, and WebImage are some common helpers
  • WebGrid helper example: webGrid = new WebGrid (data); grid.getHtml(); data for example can be the rows of a database table, GetHtml () - will render the data as a HTML table.
  • Chart example
                   @{                  var db = Database.Open("dbName");                   var dbdata = db.Query("SELECT Name, Price FROM Product");                   var myChart = new Chart(width: 600, height: 400)                       .AddTitle("Product Sales")                      .DataBindTable(dataSource: dbdata, xField: "Name")                      .Write();                }           
  • The above example will create bar chart [column chart]
  • if you want a pie chart as output, use .AddSeries(chartType:"Pie" in the above example
  • You can use an Array, or XML data as the datafeed for the Chartff
  • Sending emails: WebMail.Send(to:"xyz@xyz.com", subject: "Email from - " + customerEmail, body: request )
  • Publish your web-site: Use the publish option fromyour IDE (Webmatrix, Visual Studio for Web)
  • Manual publish: Make sure that the server side has the compatible ASP.net framework, copy all of your folders and files, copy the DLL files into the bin folder, copy SQL server DLL files, copy the database if appropriate

From: http://sitestree.com/?p=5299
Categories:19
Tags:
Post Data:2006-07-25 23:46:16

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Automating Digital Delivery with Paypal Payment Processing System #19

In the past, I implemented an automatic notification and digital product delivery system with Paypal Payment Processing System. The concept is, when a person buys products from your web-sites, he gets his products automatically as email attachments after you have confirmed the transaction. The most important part is - collecting payment data and buyer information from Paypal to ensure that the transaction is legitimate and the payment really went through. You can use either Paypal IPN or Paypal PDT to collect these data and email products on successful verification. Either will/should work. For me, PDT worked alright. Check the following web-pages/documents. Also, from PDT section, check the sample examples. For me the sample example with ASP/VBSCript worked alright.

In the past, I have worked with MiraServ, and Moneris payment processing systems. You can find short-notes and video tutorials in this web-site on them. Just search through our web-sites.

A relevant code in ASP is provided below. The code collects the payer's information just after someone has paid. The code also checks, if the payment was successful, if so prints some details about the transaction and the payer

The flow of actions (in terms of code and operations)

  • Create a paypal button, provide return url for successful payment and canceled payment.
  • In your successful payment page, write down the following code
  • Your paypal account needs to be configured properly to make the following code work - consult the documents as listed above
  • You need to use the authentication code from your paypal account to/in the following code
  • The follwing code section
    authToken = "ytrtyrtr45654hgfhgfjhfsfdsfdsfds;ljlk" 'auth code for your paypal account txToken = Request.Querystring("tx") 'as sent from paypal query = "cmd=_notify-synch&tx=" & txToken & "&at=" & authToken set objectHttp = Server.CreateObject("Microsoft.XMLHTTP")   objectHttp.open "POST", "http://www.paypal.com/cgi-bin/webscr", false objectHttp.setRequestHeader "Content-type", "application/x-www-form-urlencoded" objectHttp.Send query

    submits to the paypal to grab transaction details. (remember, after payment the control is required to come to this page, then based on authentication code and tx-id, the code grabs detail transaction information)

< %      Dim query   Dim objectHttp  Dim strQuerystring  Dim i, result   Dim firstName, lastName, itemName, curGross, mcCurrency, email  Dim authToken, txToken  Dim strParts, intParts, aParts  Dim strResults, strKey, strValue        authToken = "ytrtyrtr45654hgfhgfjhfsfdsfdsfds;ljlk" 'auth code for your paypal account   txToken = Request.Querystring("tx") 'as sent from paypal     query = "cmd=_notify-synch&tx=" & txToken & "&at=" & authToken  set objectHttp = Server.CreateObject("Microsoft.XMLHTTP") objectHttp.open "POST", "http://www.paypal.com/cgi-bin/webscr", false    objectHttp.setRequestHeader "Content-type", "application/x-www-form-urlencoded" objectHttp.Send query   strQuerystring = objectHttp.responseText    If Mid(strQuerystring,1,7) = "SUCCESS" Then       strQuerystring = Mid(strQuerystring,9)      strParts = Split(strQuerystring, vbLf)      intParts = UBound(strParts) - 1     ReDim strResults(intParts, 1)       For i = 0 To intParts           aParts = Split(strParts(i), "=")          strKey = aParts(0)          strValue = aParts(1)            strResults(i, 0) = strKey           strResults(i, 1) = strValue         Select Case strKey              Case "first_name"                 firstName = strValue                Case "last_name"                  lastName = strValue             Case "item_name"                  itemName = strValue             Case "mc_gross"                   curGross = strValue             Case "mc_currency"                    mcCurrency = strValue               Case "payer_email"                    email = strValue                    email = Replace(email, "%40", "@")          End Select      Next        email = Replace(email, "%40", "@")      Response.Write("")        'send email to customer     Dim myObject        Set myObject = Server.CreateObject("CDO.Message")       'set the To and From        myObject.To = email     myObject.From = "webmaster@justetc.net"     myObject.Bcc = "sayed@justetc.net"              myObject.Subject = "Please download your product"       myObject.TextBody = "Dear Customer, Thank you for purchasing from us. Download from the link belownn"       myObject.AddAttachment "http://www.justetc.net/test.pdf"     myObject.Send()     'Set objects to "nothing" to free up the computer memory        Set myObject = nothing      'send email to the seller       Set myObject = Server.CreateObject("CDO.Message")       'set the To and From properties     myObject.To = "webmaster@justetc.net"       myObject.From = "webmaster@justetc.net"     myObject.Bcc = "sayed@justetc.net"              myObject.Subject = "You got one customer: Product emailed to the customer"      myObject.TextBody = "Customer email address: " & email              myObject.Send()     'Set your objects to "nothing" to free up the computer memory       Set myObject = nothing      Else        'log        Response.Write("ERROR") End If%>

We have received your order") Response.Write("Details
") Response.Write("
  • Name: " & firstName & " " & lastName & "
  • ") Response.Write("
  • Description: " & itemName & "
  • ") Response.Write("
  • Amount: " & mcCurrency & " " & curGross & "
  • ") Response.Write("
  • Email: " & email & "
") Response.Write("
Home Page

From: http://sitestree.com/?p=5281
Categories:19
Tags:
Post Data:2006-10-25 18:41:19

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Random Notes and simple code on Developing Web Sites (Applications) in ASP.net using C# #19

Random Notes and simple code on Developing Web Sites (Applications) in ASP.net using C#

  • The information below primarily apply to the web page model of web-development in C#
  • _PageStart.cshtml runs at each page start/open
  • _AppStart.cshtml runs at the beginning of the application
  • Syntax to use the Layout file: @{Layout = "/Shared/Layout.cshtml";}
  • if you use this - @{Layout = /Shared/Layout.cshtml";} in the _PageStart.cshtml file, you will not need to use it at the top of each file
  • You can use Microsoft Webmatrix, Visual Web Developer, or Visual Studio for web development
  • Webmatrix, includes IIS Express, and also a database workspace where you can create and use compact SQL Server Databases
  • DateTime.Now : will display current date and time
  • You can connect to a database using var db = Database.Open("db_name");
  • db = Database.Open("db_name"); will look for the database in the same workspace; if not found will use the connection parameter as defined in the web.config file to find and connect to database
  • Executing a query: var queryString = "SELECT * FROM Product ORDER BY Name"; db.Query(queryString)
  • Accessing each row from a rowset of data as returned from database:
                   foreach(var entry in db.Query((queryString))){                @entry.Id, @entry.Name            }               
  • if (IsPost) : will check if a form is submitted by POST or not
  • username = Request.Form["username"]; Will retrieve username from the Request object [submitted form with control named username]
  • A basic login authentication code can be as follows
               var username = "";      var password = "";      var ErrorMessage = "";              // If this is a POST request, validate and process data     if (IsPost){                        username = Request.Form["username"];            password = Request.Form["password"];                        if (username.IsEmpty() || password.IsEmpty()){              ErrorMessage = "You must specify a username and password.";         }else{              // Login, Navigate back to the homepage and exit                if (WebSecurity.Login(username, password, false)){                  Response.Redirect("~/");                }               else{                   ErrorMessage = "Login failed";              }           }       }                                       @if (ErrorMessage!="") {            @ErrorMessage, Please correct the errors and try again.     }   
  • Execute an Insert Statement: db.Execute("INSERT INTO UserProfile (Email) VALUES (@0)", email);
  • WebSecurity object can be used for the security of your web-site (application) such as user authentication, block a page until a user is authenticated
  • Block user if he is not logged in [can be added at the top of the page to be blocked]
               @{              if (!WebSecurity.IsAuthenticated) Response.Redirect("~/Login"); //redirect to login page            }       
  • WebSecurity.InitializeDatabaseConnection("db_name", "profile_of_the_users_table", "UserId", "Email", true);
  • WebSecurity.CreateAccount(email, password, false);

From: http://sitestree.com/?p=5298
Categories:19
Tags:
Post Data:2012-01-30 09:33:18

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Code: Email Sending using ASP #19


From: http://sitestree.com/?p=5280
Categories:19
Tags:
Post Data:2012-11-16 11:05:08

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Formatting Web-application output #19

  • You can apply CSS styles to format web-application output
  • If you have the same styles defined in multiple places (for the same element), the styles defined closest to the element will be applied. The order, inline, page, global
  • You can create classes that can be applied to multiple elements
  • Use the CssStyle/CssStyle attribute to apply a style class to a server control
  • use the class attribute to apply a style class to an HTML element
  • Yes, you need to create a style file, and link to it from your web-form
  • You can click the style property of an element or the style property/attribute of the form to bring the Style Wizard to define/modify existing styles
  • You can also use the 'Add Style Rule' option in the popup menu on the .css files to define new styles. Also, use the 'Synchronize Document Elements' from the popup menu if required

From: http://sitestree.com/?p=5234
Categories:19
Tags:
Post Data:2009-07-01 02:45:13

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

.Net: Globalizing Web Applications #19

Three ways of globalizing web-applications

  • Create one for each culture/language - usually the web-interfaces. Redirect to a web-site built based on the current culture.
  • Write one web-application but detect current culture, then change the user interface (texts, date time formats) to represent the current culture - dynamically
  • Satellite Based: Use resource files to keep culture specific messages. One resource file for one culture. Resource files will be in the format: key = value/message. Use the keys in the user interfaces. The keys will be replaced with the messages/values as stored in the resource files - based on current culture.
  • Best Approach: Satellite Based
  • Current culture: as set in the browsers/operating systems - or give culture/language change option on a button click
  • How to detect current culture: Use CultureInfo, Calendar, and comparison classes
  • Setting culture in the web.config file: Use the globalization element of the web.config file. You can set properties for each culture
  • Satellite Based
    • set the id and runat attributes for all the user-interface elements that require translation
    • create a fallback resource file to keep default strings (key=value) (displays by default or no culture is set or culture is not recognized)
    • create resource file for each culture that you want to support
    • Use the ResourceManager class to load the resource files
    • write code to detect the user's current culture.
    • Write code to load strings from the resource files and display them
    • Example:
        using System.Globalization  using System.Threading  using System.Resourcesprotected ResourceManager gStrings = new ResourceManager( "JustEtcWebAppsCS.strings", typeof(Satellite).Assembly);......head1.InnerHtml = gStrings.GetString("satellite.head1");

From: http://sitestree.com/?p=5232
Categories:19
Tags:
Post Data:2010-11-12 15:45:20

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Providing Help in an ASP.Net Web-application #19

  • Use the Tooltip attribute of the ASP.Net controls to display help in Tooltip text
  • You can create HTML pages to provide/show help. Just as a simple web-site
  • You can use Web Forms to display help information
  • You can display help using HTML Help Viewer
  • You can use the HTML Help Workshop as comes with the Visual Studio to create Help projects similar to the generic windows help. Use the workshop and create a help project. Compile the help project into one .chm file. Use the ShowHelp method of the Window object to open this file (as a help file). Such help files usually have three tabs such as Contents, Index, and Search.

From: http://sitestree.com/?p=5233
Categories:19
Tags:
Post Data:2010-06-14 05:19:10

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Basic Dot Net Web Development Concepts #19

From: http://sitestree.com/?p=5100
Categories:19
Tags:
Post Data:2006-10-08 13:14:33

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

nHibernate & ADO.net entity Framework #19

From: http://sitestree.com/?p=5104
Categories:19
Tags:
Post Data:2007-04-05 04:55:01

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

JQuery & ASP.Net #19

Don't panic. It's not rocket science. Watch the following videos. Then read a book on ASP.Net & JQuery (May be from Apress), and then consult a good reference book lightly. Keep the book with you always. You will be there soon.

From: http://sitestree.com/?p=5199
Categories:19
Tags:
Post Data:2012-04-30 11:23:06

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

How to Build a Personal Web-site with ASP.Net (VS 2008, .Net 2.0/3,5) #19

  1. Video Tutorial on this topic
  2. Web-site Code used in this tutorial
  3. Steps
    • Open visual studio 2008 IDE
    • File -> new project -> Visual Basic -> Web -> ASP .Net Web Application
    • Rename default.aspx to template.aspx
    • Insert a table from the tool box
    • Create three rows for the table: top, body, bottom
    • Top Row: banner, slogan
    • Body Row: three cell: left, right, middle: left for left menu, right for right menu/advertising code, middle for contents
    • bottom: privacy, copyright, links to contact us
    • Keep left menu, right menu, top banner, bottom/footer contents in separate files such as leftMenu.aspx, rightMenu.aspx, topBanner.aspx
    • In the template.aspx use Response.WriteFile("file.aspx") to link to the left and right menu, the top banner, the bottom/footer. Change file.aspx to the right file name.
    • Create the leftMenu.aspx, rightMenu.aspx, topBanner.aspx, bottom.aspx
    • template.aspx is just the template file. We have two options in the left menu like Home and Companies, that point to index.aspx, and companies.aspx respectively. You have to create those files
    • Now copy the template file, paste it, rename it to index.aspx. index.aspx will be the root file of your web-site. Change the body part of the index.aspx to add contents
    • Copy the template.aspx file, paste it, rename it to companies.aspx. Change the body part of companies.aspx to add contents
    • You can modify leftMenu.aspx to add more options in the left menu. For each option that links to a .aspx file you have to create the .aspx file using the template.aspx [unless already existing]
    • Similarly, you can change your right menu contents by updating rightMenu.aspx
  4. Deployment:
    • Can copy the aspx files in the right place under IIS
    • or let VS 2008 to deploy - right click the project in the solution explorer, click on publish, select the path where you want to publish the website, publish it to a folder where IIS has access
    • You may need to configure IIS a bit, create/identify this application as a .Net application. Otherwise it may not work. Else, you can adjust/edit the files to make them work [remove some lines].
    • Test the application

From: http://sitestree.com/?p=5086
Categories:19
Tags:
Post Data:2010-03-18 10:48:21

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

What is silverlight? #19

Quick Facts

  • It's by Microsoft for Rich Internet Application Development
  • Supports high quality graphics/animations
  • Runs in Windows, Mac, Linux
  • From PHP you can also make use of Silverlight
  • Offers copy protection
  • Related technologies: Adobe Flash, Java FX
  • Debugging possible from Visual Studio 2008 IDE
  • Supports IE, Firefox, Opera, Safari
  • The claim is: it's significantly fast
  • Supports progressive download and play
  • What is Silverlight
  • Silverlight Tutorial: Creating an Animated Navigation Bar with Silverlight

From: http://sitestree.com/?p=5018
Categories:19
Tags:
Post Data:2009-03-30 07:34:51

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

ASP.Net Examples #19

ASP.NET HTML Controls

HTMLAnchor
HTMLButton
HTMLImage
HTMLImage 2
HTMLInputbutton
HTMLInputCheckbox
HTMLInputHidden
HTMLInputImage
HTMLInputRadiobutton
HTMLTable
HTMLTable 2
HTMLTextarea

ASP.NET Web Controls

AdRotator
Button
Button 2
Calendar
Calendar 2
Calendar 3
Checkbox
CheckboxList
DataList
DataList with styles
DataList with
DropdownList
Hyperlink
Image
ImageButton
Label
LinkButton
Listbox
Literal
Literal 2
Panel
Radiobutton
RadiobuttonList
Repeater
Repeater with
Repeater with
Table
Table 2
Textbox
Textbox 2
Textbox 3
XML

ASP.NET Validation Controls

CompareValidator
CompareValidator 2
CustomValidator
RangeValidator
RangeValidator 2
RegularExpressionValidator
RequiredFieldValidator
Validationsummary
Validationsummary 2

ASP.NET Events

Page_Load
Page.IsPostBack

ASP.NET Data Binding

ArrayList RadioButtonList
ArrayList DropDownList
Hashtable RadioButtonList 1
Hashtable RadiobuttonList 2
Hashtable DropDownList
SortedList RadioButtonList 1
SortedList RadiobuttonList 2
SortedList DropDownList
XML RadiobuttonList

ASP.NET Database

Database connection - Bind to a Repeater control
Database connection - Bind to a DataList control

From: http://sitestree.com/?p=4870
Categories:19
Tags:
Post Data:2010-07-19 15:00:53

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

ASP.Net Controls #19

HTML Server Controls
HtmlAnchor
HtmlButton
HtmlForm
HtmlGeneric
HtmlImage
HtmlInputButton
HtmlInputCheckBox
HtmlInputFile
HtmlInputHidden
HtmlInputImage
HtmlInputRadioButton
HtmlInputText
HtmlSelect
HtmlTable
HtmlTableCell
HtmlTableRow
HtmlTextArea

Web Server Controls
AdRotator
Button
Calendar
CalendarDay
CheckBox
CheckBoxList
DataGrid
DataList
DropDownList
HyperLink
Image
ImageButton
Label
LinkButton
ListBox
ListItem
Literal
Panel
PlaceHolder
RadioButton
RadioButtonList
BulletedList
Repeater
Style
Table
TableCell
TableRow
TextBox
Xml

Validation Server Controls
CompareValidator
CustomValidator
RangeValidator
RegularExpressionValidator
RequiredFieldValidator
ValidationSummary

From: http://sitestree.com/?p=4869
Categories:19
Tags:
Post Data:2013-01-02 02:38:21

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

20 Tips to Improve ASP.net Application Performance #19

Please check: http://www.realsoftwaredevelopment.com/2007/08/20-tips-to-impr.html

From: http://sitestree.com/?p=4752
Categories:19
Tags:
Post Data:2006-09-15 02:39:15

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Firebird Stored procedure delphi #2

In firebird, the syntax to create TRIGGERs and Stored Procedures is as below:

---

SET TERM !! ;
CREATE TRIGGER auto_update_1 FOR DBPATHS
after INSERT POSITION 0
AS
BEGIN
insert into commission values (100,100);
END !!
SET TERM ; !!

---

SET TERM !! ;
CREATE PROCEDURE CountTo10
RETURNS (Cnt INTEGER)
AS
BEGIN
Cnt = 1;
WHILE (Cnt < = 10) DO
Cnt = Cnt + 1;
END !!

SET TERM ; !!

----
An example how to use stored procedure from delphi is as follows:
procedure TForm1.Button1Click(Sender: TObject);
var

result : integer;
begin
if ibdatabase1.Connected = false then
begin

ibdatabase1.Connected := true;

end;

with IBStoredProc1 do
execproc;

IBStoredProc1.Transaction.Commit;

result := IBStoredProc1.Params.ParamValues['Cnt'];

showmessage(inttostr(result));

end;

From: http://sitestree.com/?p=4727
Categories:2
Tags:
Post Data:2008-07-08 16:53:04

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Tools to create ER diagrams from a database dynamically #2

Microsoft Visio, and dbVisualizer provide features to create ER diagrams from existing database tables.Why needed?ER diagram is very useful to understand the total database structure that helps a new programmer to work on the existing databases more efficiently.Visio:While creating Database diagrams, a menu item named database is displayed. Reverse Engineering option under Database menu helps to create ER diagram from existing database tables. Before that, target database drivers for visio need to be installed. If the database is in db2/mysql/postgresql, then  db2/mysql/postgresql drivers for visio should be installed. From Database/options/drivers, the driver needs to be configured. Afterwards, Reverse Engineering option may be used to create the ER diagram. There is no suitable driver for postgresql databases for Visio. ODBC drivers may be used for the purpose (the ER diagram may not be accurate from ODBC driver for postgresql). dbVisualizer:In dbVisualizer, when the TABLEs group/option is selected in the left pane in the right/middle pane there will be a references option. When the references tab is selected, an ER diagram is displayed using all tables. The ER diagram can be displayed as Hierarchical, circular, orthogonal, or organic. There are options for the purpose.When a single table name is selected, the table and the associated tables are displayed in an ER diagram.In the rightest column, selected tables option allows to create ER diagrams only for the selected tables. When 'selected tables' is clicked a list is displayed in a dialog box. Tables can be selected from this list (use control key). Build graph  option creates and displays the ER diagram.

From: http://sitestree.com/?p=4785
Categories:2
Tags:
Post Data:2012-08-27 09:57:03

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Passing Parameters from Front end to Access Queries. VB.Net/ASP platform #2

Just append the parameter values with the query name from the front end.

For example, say a query in access has the pattern:catId = [categoryId].

It indicates that categoryId has to be supplied to this query.

From the front end, you can use:strQuery = " qry_name ' " & numCategoryID & "'"

//VB.Net/ASP platform

ASP Code:

Dim numCategoryIDnumCategoryID = Request.Form("CategoryID")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("/cats.mdb")
Set objRS = Server.CreateObject("ADODB.Recordset")
strQuery = "qry_name ' " & numCategoryID & "'"
objRS.Open strQuery, objConn, 0, 4

From: http://sitestree.com/?p=5216
Categories:2
Tags:
Post Data:2007-01-11 23:23:02

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Speed: Firebird vs. PostGreSql #2

Please read.According to this article postgresql faster than firebird. But I also got information/tests where firebird is faster than postgresql.

http://archives.postgresql.org/pgsql-advocacy/2003-06/msg00280.php

However, Speed may not be the only factor to select a database product. We can improve raw speed in many alternate ways, hardware solutions, ram, faster storage, faster CPU. To compare speed issue, efficiency issue, we need to take a look how the query optimizations are implemented in databases. How, the joins, inner joins, outer joins are implemented. How multiple joins are implemented. Also, indexing is a factor that also affects performance issue. We can try creating same database and using a queries that are simple to complex and run on both databases and see, how well they perform.

Postgresql supports SMP (multiple processor system) and provides better efficiency in multiprocessor systems. Firebird, is not still matured in SMP environment.

Firebird supports 32 bit environment, still not stable/reliable enough for 64 bit env. It supports max ram of 2 gb and hence 150 - 450 concurrent users. Postgresql supports 2 TB of ram in a single server. For both of them, we can implement multiple servers with master/slave relation for better performances.

From: http://sitestree.com/?p=4718
Categories:2
Tags:
Post Data:2010-10-28 19:53:29

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

FireBird GUI Tools #2

GUI Tools for Firebird DB management
------------------------------------

Commercial
These are very good tools
IBExpert - Developer Studio
Interbase firebird development studio - develop/design
EMS sql mgmt studion for interbase/firebirdails.html -- http://www.soft32download.com/software/EMS-SQL-Manager-2005-for-InterBase-Firebird-download-details.html
xstarter FBIB - good management tools--scheduling of works -- http://www.xstarter.com/firebird-interbase-job-scheduler.html

Free
----Development and Administration Tools
DbVisualizer Free
JDBStudio
ibview
ibexpert free personal edition limited
IBSQL not great but have some good features
Crypton firebird database manager -- very good
administration tool
IBUtils--design tools
DBManager Professional--good tool design/develop/admin tool
FIBS Firebird -- InterBase Backup Scheduler
IBEasy+ -- not much useful
Recommendation:
------------------

Crypton firebd db manager ---- very good administration
tool -- http://www.crypton.co.uk/freetools.html

DBManager Professional ---- good tool design/develop/admin tool http://www.dbtools.com.br/EN/downloads/downloads_file.php?file_id=11http://www.download.com/DBManager-Standard-Edition/3000-2065-10580436.html?part=dl-DBManager&subj=dl&tag=button

FIBS Firebird-InterBase Backup Scheduler -- http://www.talatdogan.com/frees.htm From: http://sitestree.com/?p=4724
Categories:2
Tags:
Post Data:2009-10-08 18:50:36

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Why PostGress better than FireBird: This comparison may not be accurate though. #2

Postgres Vs Interbase/Firebird (Score:0) By Anonymous Reader on 2004.12.03 18:23 (#102740) http://www.vitavoom.com/postgresql.htmlFirebird has not true text type you must use the clumsy blobs and weird blob subtypes.Postgres is much closer for enterprise use than Firebird.almost all of this applies to Firebird as well as interbase.PostgreSQL vs InterbasePostgreSQL... * ... has no "dialects" or other weird features. * ... has no "backdoors" which can compromise your whole company's security and business (check here and here). * ... supports unlimited row sizes, unlimited datasebase sizes, tables up to 16TB (!!), unlimited number of rows, unlimited indexes for table and 1Gb per field. * ... has a boolean field. * ... can cancel a query asynchronously (Interbase 6.5 - the commercial version - seems to support it now). * ... has a flexible (not fixed) types system, and supports more types then Interbase. You can always add your own types at your wish, or change existent types behavior. PostgreSQL even has geometrical and IPv4 types support (!!). * ... supports inheritance. * .. supports flexible full text indexing through OpenFTS. * ... has a much more sofisticated locking mechanism (MVCC). * ... has arbitrary precision numeric fileds (numeric type). * ... is resistant to crashes and power failures (by using it's logging system, MVCC and chepoint)). Although it is technically possible that a database gets corrupt, we at Vita voom never saw it (except for corrupt media storage of course). * ... supports functions (whose can be used as stored procedures). These functions current can be written on SQL, pl/PgSQL (a language similar to Oracle's pl/SQL), TCL, Perl, and Python, C, C++ (or other compiled languages) but it's not limited to them. * ... can have functions to define default values for columns (providing ultimate default value flexibility). * ... supports much more arrays types then Interbase, they are more flexible and can support much more elements. * ... supports rules. * ... supports "fetch" SQL command to get only a limited number of rows at a time, making queries more responsive and resource economic. * ... has regular expressions support (for searches and operations). * ... has a 'EXPLAIN' command which will show will how it will perform a query, so that you optimize it. * ... has statistics about database usage which can be used to optimize queries and indices. * ... has sequences. * ... has more built-in functions then Interbase (or any other open source RDBMS). * ... supports indexes on functions. * ... has broader subselects support then Interbase. * ... has a more flexible BLOB fields support. * ... can limit the number of rows retrieved at at time (with the 'LIMIT' keyword). * ... is more standards-compliant then Interbase. * ... allo From: http://sitestree.com/?p=4715
Categories:2
Tags:
Post Data:2013-03-14 18:15:43

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Query Optimization in Firebird #2

Please check: http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1154575297:5422&page=ibp_50_query From: http://sitestree.com/?p=4717
Categories:2
Tags:
Post Data:2012-08-31 08:12:40

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Important Links for Mysql, PostGreSQL, Firebird, EnterpriseDB, Ingres #2

Firebird and postgresql:http://www.linuxjournal.com/node/7010
Important comment: easy to migrate from oracle to firebird than to postgre or mysql. From interbase to firebird will be better as they are similar.

http://forums.devshed.com/firebird-sql-development-61/mysql--vs--firebird-sql-62269.html : Firebird is far better choice than mysql
As for Performance, MySQL will outperform Firebird on almost all tests on local machine......
On a Network Server a properly designed Firebird Server will outperform MySQL on any Test and the network-Traffic generated by Mysql will be many times higher than FirebirdSo you decide the one you need according to your needs .....

This link also compares fb with potgre and favors fb as the author's background is borland

Why Postgress is better than firebird

Firebird is not as good as PostgresQL (Score:0) By Anonymous Reader on 2004.12.03 2:21 (#102703) And here is why:

  1. Firebird has no temp table support.
  2. Firebird uses several SQL modes i.e DSQL which only works client side and PSQL which only works in procs. All sql works in Postgres functions.Try creating a table or a user in a Firebird proc...ooops can't be done.

  3. Firebird databases grow out of control and have to be backed up restored on a regular basis.

  4. Firebird has a concept of a OAT (oldest active transaction counter) if this counter gets stuck all transactions get held up and your DB size goes through the roof and performance goes to the basement.

  5. Firebird has virtually no built in functions and flakey UDFs must be used. Postgres on the other hand has every function you can think of.

  6. Postgres has many rich procedural languages including perl,TCL,Java and C# in the works.

I could go on.... Version 8 of Postgres which will be released soon adds point in time recovery, Try except error handling in functions, table spaces and more.

I converted all my apps from Firebird 1.5 to Postgresql 7.4 and I would never use Firebird again on Unix or Windows

From: http://sitestree.com/?p=4714
Categories:2
Tags:
Post Data:2008-08-04 23:03:04

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Comparison: FireBird, MySQL, PostGreSQL #2

PosTGRESQL Provides better query responsetime than firebird and MySql. Firebird stands somewhere in the middle. A little longer response time than PostGreSql.
http://benchw.sourceforge.net/benchw_results_open3.html

Several PostGreSQL versions are compared at:
http://benchw.sourceforge.net/benchw_results_postgres_history.html

Several MySQL versions are compared at:
http://benchw.sourceforge.net/benchw_results_mysql_indexes.html


A good comparison among these databases will be found at:http://www.geocities.com/mailsoftware42/db/



Mentionable comments

PostGreSQL Supports 400+GB DB.One source: As for each connection it forks new thread, it is bit slower than MySql: Another source: postgresql is faster than mysql. Seems the truth is: for single connection postgresql can be faster but for multiple connections mysql is faster. just an information, not sure yet.

New PostGre Features

http://www.postgresql.org/docs/whatsnewSome mentionable comments: Supports SMP and almost linearly improves performance witth multiprocessor system.

Supports roles, in/out parameters/two phase commit/table partitioning shared row locking(firebird record level locking), 64 bit shared memory hence supports two terabytes of ram

PostGreSQL capability4.4) What is the maximum size for a row, a table, and a database?These are the limits:
Maximum size for a database? unlimited (32 TB databases exist)
Maximum size for a table? 32 TB
Maximum size for a row? 400 GB
Maximum size for a field? 1 GB
Maximum number of rows in a table? unlimited
Maximum number of columns in a table? 250-1600 depending on column types
Maximum number of indexes on a table? unlimited
One limitation is that indexes can not be created on columns longer than about 2,000 characters. Fortunately, such indexes are rarely needed. Uniqueness is best guaranteed by a function index of an MD5 hash of the long column, and full text indexing allows for searching of words within the column.Source:http://www.postgresql.org/docs/faqs.FAQ.html4.20) What replication solutions are available? Though "replication" is a single term, there are several technologies for doing replication, with advantages and disadvantages for each.
Master/slave replication allows a single master to receive read/write queries, while slaves can only accept read/SELECT queries. The most popular freely available master-slave PostgreSQL replication solution is Slony-I.
Multi-master replication allows read/write queries to be sent to multiple replicated computers. This capability also has a severe impact on performance due to the need to synchronize changes between servers. PGCluster is the most popular such solution freely available for PostgreSQL.
There are also commercial and hardware-based replication solutions available supporting a variety of replication models.

Important Notes

Server Configuration A number of postgresql.conf settings affect performance. For more details, see Administration Guide/Server Run-time Environment/Run-time Configuration for a full listing, and for commentary see http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html and http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html.
Hardware Selection
The effect of hardware on performance is detailed in http://www.powerpostgresql.com/PerfList/ and http://momjian.us/main/writings/pgsql/hw_performance/index.html.

Wikipedia link for postgressql-http://en.wikipedia.org/wiki/PostgreSQL

EnterpriseDB kind of commercial but cheap based on postgressql
From: http://sitestree.com/?p=4712
Categories:2
Tags:
Post Data:2010-01-24 02:30:40

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

PostGreSQL Limitations and solutions #2

http://searchopensource.techtarget.com/originalContent/0,289142,sid39_gci1172668,00.html

PostGreSQL Windows Installerhttp://pgfoundry.org/projects/pginstaller/

From: http://sitestree.com/?p=4713
Categories:2
Tags:
Post Data:2006-09-24 22:18:42

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Firebird as an Alternative to Oracle/MS SQL Server/Interbase/Access #2

Note:Firebird can be a very good alternatives to Oracle/MSSql Server/Interbase. First of all, it is free. It can be good enough for upto medium level of enterprises. Supported database size is more than 11 terabytes. For a single table 20GB. It also implements ACID properties well enough. Implements two phase commit and in record level locking and hence can provide more concurrency and connection.It also implements MGA to provide recovery that also Oracle/MSSQL server imitated from interbase/firebird.A well designed database and a well designed network using Firebird will be strong enough to support a mid - size company. Also, if the database is designed well and used the clean normalization, and used clean indexing, the query will be faster enough.Linux platform is more suitable than windows platform for Firebird.In 32 bit environment, Firebird server version support 2 GB of ram and hence around 450 concurrent connection. This is due to memory addressing in 32 environment, required cache size and for similar reasons.In Linux 64 bit versions Firebird can provide better service and more concurrent connections. Firebird is not stable and reliable enough to be used with windows platform in 64 bit environment. Though, Firebird project, hopes to work on this.Firebird, has a dedicated community to support the product. They provide supports through a discussion forum. (May be .. with some other ways). Firebird team also hopes to continue the project to fullfill future demand.Being opensource project the database system seems will be strong enough and well designed and well featured to meet customer demand.For details please check:A detail discussion can be found here.http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_enterprise_firebirdNote:Firebird can be a good option for a Midsize company in Bangladesh From: http://sitestree.com/?p=4710
Categories:2
Tags:
Post Data:2007-09-09 08:56:56

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Software Testing Resources #22

Software Testing Resources. Read the resources as provided in this short-note. Also, go through the short-notes in the further reading section below.

From: http://sitestree.com/?p=5279
Categories:22
Tags:
Post Data:2006-07-30 13:41:52

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Overview on .Net Solution Architecture #20

Just an overview (Will be updated ...).

  • Microsoft Solution Framework is a combination/mix of both Waterfall model and Spiral model. It includes waterfall models milestone based planning and resulting predictability with the spiral model's benefits of feedback and creativity
  • Roles in the MSF Team Model:
    • Product Management (Deals with customers, collects customer requirements, ensures requirements are met, plans project communications, and performs related duties)
    • Project Management: Develop processes and deliver solutions
    • Development: Develop the solution
    • Testing:
    • Release Management: Responsible for deployment
    • User Experience: Analyzes performance needs, supports issues of the users
    • Project Sponsor:
    • Customer
    • End user
    • Operations
  • Gathering Information: Information Categories: Business, Application, Operations, Technology
  • Information Gathering Techniques: Shadowing (Observe the operation, ask questions (how do interruptions affect users?) and collect information), Interviewing, Focus Groups, Surveys, User instruction, Prototyping
  • Sources of information:Artifacts (like documents), Systems (set of processes performing an action), People (responsible for different project related tasks)
  • Analyzing Information Step: Analyze collected information and create use cases and use case diagrams. Use cases and use scenarios will identify the total/complete system clearly, all processes involved in the system, identify gaps in the information collection, establish connections between business needs and user requirements. Collecting information and Analyzing can be iterative processes
  • A use case diagram will contain information like: Requirement ID, Requirement description, Priority, Data Source, current functionalities, questions from this item.
  • Several other documents may be created such as: Actors Catalog (For each responsibilities in the system list the actor's/responsible employee's name, and source of information), Business Rules Catalog (may include short title, description of the rule, source of the business rule, reference to the corresponding use case diagram, functionalities related to the business rule)
  • UML notations may be used to create the diagrams
  • Envisioning Phase: The team, the customer, and the sponsor define the high level business requirements and overall goals of a project. Identify what the project involves, what the customers want to achieve with the project, what is the business need, what must be developed to solve/address the business needs. Make all involved people aware of the project goals and requirements clearly. Form project team
  • Output from the Envisioning Phase: Vision/Scope document, Project structure document, Risk assessment document, list of testable features, preliminary requirements and architecture, a GUI storyboard.
  • Vision/Scope Document: Problem Statement, Vision Statement, User profiles, Scope of the project, Solution concept, Project Goals (both business and design), Critical success factors, Initial schedule
  • Project Structure Document: components of the project structure (team and structure, project estimates, project schedules)
  • Contents of the project structure document: Team and customer roles and responsibilities, communication decisions, Logistical decisions, Change management decisions, Progress assessment decisions
  • Next three steps: Conceptual Design->Logical Design->Physical Design
  • Conceptual Design: Define the problem from the perspective of the user and the business/usage scenarios
  • Logical Design: Define the problem from the perspective of the project team/cooperative services
  • Physical: Define the problem from the perspective of the developers
  • Goals of Conceptual Design: Understand the business problem to be solved, requirements of the business, and target future state of the business.
  • Steps in Conceptual Design: Research, Analysis, Optimization
  • Build Conceptual Design: analyze information, Restate requirements, categorize requirements, refine use case diagrams, select an application architecture (client/server, layered, Stateless, Cache, Layered-client-cache-stateless-cash-server),
  • Logical Design: List candidate tools and technologies, identify business objects and services, identify important attributes and key relationships, optimize logical design (refine, validate)
  • Outputs of Logical Design: logical object model, high level user interface design, logical data model
  • logical object model - identify all the relevant objects/entities [will be pretty similar to identifying entities to create data model and E-R Diagram]
  • In logical design, identifying services are also important
  • Physical Design: Defines the parts of the solution, how they will be developed, how the interaction will happen.
  • Physical Design: Components, User Interfaces, and Physical Database. Scope: Coding, deployment
  • At the end of logical design UML diagrams such as Class Diagram, Sequence Diagrams, Activity diagrams, Component diagrams are available. In physical design refinements of these diagrams occur.
  • Physical Design: Define programming model, Specify component interfaces and interactions, Design Physical UI Model, Design Physical Database model
  • Designing the Presentation Layer: Functions of the User Interface Components: Acquire data from users, capture events from the users, restrict the types of input a user can enter, perform data entry validation, perform simple mapping and transformation of the user provided information, perform formatting of values
  • Well designed interface: Intuitive design, Optimum screen space utilization, appearance, easy of navigation, controlled navigation, populating default value, input validation, menus, toolbars and help, efficient event handling
  • Designing the Presentation Layer: Create an initial user interface either by hand or using Visual Basic forms, provide user assistance, use tooltips if appropriate, display status, use wizards if appropriate, provide accessibility aids for disabled people
  • Types of user interfaces: Windows based, web-based, mobile device based, documentation based
  • Design Data Layer: Typically database objects are modeled in an entity-relationship diagram.
  • Data Model Types: Flat file, Hierarchical, Relational, Object oriented
  • Optimize data access: Minimize roundtrip requests, minimize returned resultset size, reduce concurrency, find the tradeoffs between managing data on the client or on the server
  • Optimize the database: Index data (clustered, non-clustered), Partition data (why and how vertical and horizontal partitioning), Normalize data
  • Sometimes Denormalization of database tables is also required for better performance.
  • Implement data validation: Check for Data Integrity (Domain, Entity, Referential), Validate Data (Range check, Data format, data type check)
  • Think about client side/server side data check. Many times both are required for optimum performance and integrity.
  • Design Security Specifications: Common Types of Security Vulnerabilities: Weak passwords, Misconfigured software, Social engineering, Internet connections (through unsecured ports, if firewalls are not configured appropriately), Unencrypted data transfer, Buffer overrun, SQL Injection, Secrets in code.
  • Principles for creating Security Strategies: Rely on tested and proven security systems than creating your own, use your own only after expert auditing and reviewed by security organizations, never trust external input, Assume that external systems are not secure, use principle of least privilege, reduce components and data availability, default to a secure mode, follow STRIDE (spoofing identity, tampering, repudiation, information disclosure, denial of service, and elevation of privilege) principles
  • How to create a security model: Arrange for a brainstorming meeting, list all possible threats, apply the STRIDE security categories, conduct research, rank the risk of each threat
  • Security mitigation techniques: Authentication and authorization, Secure communication, Quality of Service, Throttling, Auditing, filtering, least privilege
  • STRIDE mitigation techniques: Authentication, protect secrets, audit trails, do not store secrets, privacy protocols, authorization, hashes, digital signatures, time stamps, filtering, throttling, quality of service, run with least privilege
  • .Net security features: type safety verification, code signing (Ensure authenticity, ensure integrity) - digital certificates and signatures, code access security, role based security (make use of windows users and permissions) , saving data in isolated storage
  • ASP.net authentication: Forms authentication, Passport authentication, Windows authentication
  • Web-services security: transport level, application level, message level

From: http://sitestree.com/?p=4916
Categories:20
Tags:
Post Data:2009-07-17 16:41:21

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Should developers test software? #22

Not really my opinion; however, as found in different articles and opinions. You may have a business case to utilize developers for software testing; Also, your developers may end up being a good tester as well, and happily willing to do the software testing work.

Should developers test software?

Software testing is testers' work not software developers' work. Usually big and reputed companies keep testers whose sole purpose is testing where development is for the developers. Software architectures/frameworks like Microsoft Solution Framework do not mix software development and testing to the single/same role. Though software testing is sometimes mixed with business analyst [may be also with project managers, architects] role as they some/many times need to ensure software acceptance/quality.

Another note here, Companies such as Microsoft prefers Software Developers with some additional skills in software testing/software quality assurance related positions.Software testing is not best suited to software development role for reasons as below (though it does not mean that software developers cannot and will not test software. Also, it is not the case that developers do not test; for a large % of cases, software developers also test software):

1. The goal of software testing is just the reverse of software development. The aim of the developers' is to try to prevent errors and make sure the code runs but testers aim to find errors.
2. Testing can never proof absence of errors. So, the question is when the developers need to stop testing?
3. Testing by itself does not improve software quality.
4. Testing requires you to assume you will find errors. But developers usually after writing the code assume the code is working/(he wrote it right, he wanted to write it right, so it should be right, though it's not practical/best thought).

5. Developers are usually biased that the software feature work, just after implementing it. Developers also know, how to use the software. What are very trivial for a software developer (how to use the software), may not be understood by others. Developers may end up using the softare in almost the right way and may miss some issues. This may not be right all the time; however, sometimes this will be the case6. Software developers may not deal with the end users all the time; may not understnad the usage pattern or knowledge/experience level of the end users. Also, may not always be aware, how the software will be used; if this is the case, it may lead to undiscovered issues.Another note here is, a software feature is written and it worked for the developer, does not mean that it will work. It needs to be tested separately to ensure that it works. Just because the code is written and it worked for some cases does not mean that it will work all the time and in all situations and use cases. If you want a good and reliable software, you need to invest the time and money, to identify use cases, and possible ways to interact/use that software or the software feature, then test and ensure that the software work to some acceptable (define what this means to you) extent.It may also be useful, if developers use a different time (not immediately after writing the software) to plan and test the software or the feature just got implemented. When taking time off from the code, the bias may be gone and the developer may end up testing like a user or with a test's mindset. He may also discover the limitations of his or her code when taken some time away from the code.However, testing like Unit testing, component testing, integration testing are the developers work. Sometimes, regression testing and system testing are also required to be done by developers [ thought to be their responsibilities not testers ].

Unit Testing: Test separately a single complete class, a single routine, a small program

Component Testing: Involves testing of classes, packages, small programs separately from the complete system that are developed by multiple programmers.

Integration Testing: Involves testing two or more classes or packages, components, and subsystems that are developed by multiple programmers. It can be done on an ongoing basis, just when every new class is written, it can be tested with other classes as a whole and/or pairwise [if applicable].

Regression Testing: Execute the same set of tests that were executed before and no errors were found.

System Testing: Involves testing the software in it's final state. Integrated with other software and/or with different hardware platforms. Tests for timing, security, performance and other issues that could not be tested at lower levels.

From: http://sitestree.com/?p=4822
Categories:22
Tags:
Post Data:2009-09-12 13:04:04

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Developer testing: Some Talk #22

Developer testing: Some Talk

  • Thinking about test cases before writing the code may become handy sometimes. If you think before then hopefully, you will also write code that will avoid those errors/test cases. The thinking time is almost equal.
  • Check for both the control flow and the data flow of your code.
  • Check that each of your statements work right.
  • Check that you do not have errors in your test data.
  • Keep test records and how did you solve errors.
  • Learn from your mistakes, what kinds of mistakes you usually make.

From: http://sitestree.com/?p=4829
Categories:22
Tags:
Post Data:2007-04-04 11:08:59

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

How to find bugs fast in a software tester role? #22

The mission of the position TESTER may vary based on the industry, company, project, or the personalities of the team.When you work as a tester, be clear about your mission [mission of your position]. If you are not sure...ask the management - what is the mission of the position - what are your responsibilities. You may have to check these time to time and align your activities with the mission of the position.

Example Missions for a Software Tester Role

  • Find important bugs fast
  • Assess the general quality of the product
  • Certify that the product meets a particular standard.

How to Find important bugs fast

  • First, test things that are changed recently than that are the same
  • Test core functions before the contributing functions
  • Test capabilities first, then go for reliability
  • Test common situations before the esoteric situations
  • Test common threats before the rare threats
  • Test high impact problems before the low impact problems
  • Test the most wanted areas/features before the features/areas that are not requested

From: http://sitestree.com/?p=5266
Categories:22
Tags:
Post Data:2009-02-23 19:16:31

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

.Net Remoting/ Windows Services #24

From: http://sitestree.com/?p=5230
Categories:24
Tags:
Post Data:2012-10-07 01:02:12

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Key Strategies in Software Debugging #22

Key Strategies in Software Debugging.

1. Understand the requirements well. Design the software well. Code well.
These will reduce the number of defects in your system.

2. Don't use random guessing about defects. Use a systematic and scientific method to detect and fix bugs.

3. Identify the root cause of a defect. Understand the program and then try to solve

4. Set the compiler warning in it's pickiest level. Solve all the issues as listed in the warning messages

5. Make wise use of debugging tools but use your brain in parallel.

Debugging? Is a process to find the cause of an error/issue/defect whereas testing is the process to find the error/defect in the first place.

Defects are opportunities for a good programmer. How? When you are a good programmer, you will code well.

Still if you have defects than something is missing somewhere, it will give you opportunities to learn many stuffs like:

1. Check: Did you understand the program/requirements?

2. Learn: what kinds of mistakes you make

3. Learn: how you solve problems4. How you fix defects
When you know your own patterns then there will be opportunities to improve yourself.

Bad ways to debug software:

1. Find defects by random guessing, by using print statements randomly.

2. Don't try to understand the program just find the defect and fix

3. Use most obvious fix. You see the code does not work for 23 as input otherwise fine. So write a special case for 23

4. Debugging by superstition.


Finding a Defect

Scientific method of debugging

1. Stabilize the error through experiments. Be sure about the error and when it happens.

2. Gather the data through repeatable experiments that produces the defect

3. Form a hypothesis that states the cause of the error

4. Design experiments to prove or disprove the hypothesis.

5. Prove or disprove the hypothesis.

6. Repeat as needed

7. Fix the defect

8. Test the fix

9. Look for similar errors in your code.

Checklist for finding defects:

Reproduce the same error in several different ways.

Brainstorm for possible hypotheses

Use a notepad to list the things to try

Find the suspicious region of your code

Check the error-prone classes and routines

Check recently modified/added codes

Check for common defects

Check region by region. Expand your region after one region is covered

Talk to someone about the problem

Relax a bit. It works great sometimes.

Reference: Code Complete, 2nd Edition by Steve McConnel

From: http://sitestree.com/?p=4780
Categories:22
Tags:
Post Data:2006-11-06 07:32:26

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Creating and Consuming XML Web Services #24

  • visual studio .net -> File Menu -> new project -> Visual Basic/C# projects -> ASP.Net Web Service -> The project will get created
  • Some Files as created: AssemblyInfo.cs/vb: sharing and reuse in the CLR, Web.config, service1.asmx, service1.asmx.cs/vb
  • Create web service methods in the asmx.vb/cs files. A sample web-service method is already there
  • Now you can build the project using the Build Solution option
  • You can start the application, using the start option in the debug menu
  • Check other short-notes as listed in: http://www.justetc.net/knowledge/index.php?table=Articles&categoryID=24 to know different aspects of web service programming
  • You can publish the web-service using the publish option in the popup menu from the solution explorer. or the publish option in the build menu
  • Then you are required to change some configuration in the IIS server such as give directory browsing permission, make the virtual directory an IIS application, provide execute permission
  • XML WebService Discovery Mechanism: enables a client application to locate or discover the documents that describe an XML Web Service
  • You may want to create a discovery file and deploy in your web-server so that clients can know your services and make use of them.
  • To create, client application for a web-service, first you have to have the permission to access, then you need to add a web-reference to that service from your application
  • Create a proxy class, create an object of that proxy class, call the web service methods using this proxy object
  • You may want to use serialization and deserialization while communicating with the web-services

From: http://sitestree.com/?p=5229
Categories:24
Tags:
Post Data:2007-12-19 00:46:24

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Debugging in .Net, (XML Web Services) #24

May not make sense to all. Just listing some related notes.

  • Tools: DbgClr - GUI Based, CorDbg - command line based
  • You can use the debug menu. Start, Step Into, Step Over, New Breakpoint options - as available in most Good to great IDEs for debugging
  • Watch Window: Check the values of variables and expressions
  • Call Stack Window: Function and procedure calls currently on stack
  • Locals Window: Variables that are local to current context
  • Autos Window: Variables in the current statement and in the previous statement
  • Breakpoints Window: Function break point, file breakpoint, address breakpoint, data breakpoint. Gives information on breakpoints - name, condition, hit count
  • Debug XML Web-services: During Development: Place break points in the line where you want to start your debugging. Start the application, keep on executing, and come to the point where the breakpointed (never mind - my invention) statement will execute. Now you can use other windows (watch, call stack,..)
  • Debug XML Web-services: After Deployment: Open the XML webservice in IE, from visual studio debug menu select processes -> aspnet_wp.exe then select Common Language Runtime, select the program to debug, close process dialog box. From visual studio, open the code behind the file that you want to debug, then set breakpoints there
  • Debug Must: In the web.config file, set debug=true.
  • Along with debugging, you can use tracing to collect runtime information for debugging purpose.
  • Three types of Tracing: TextWriterTraceListener: Write messages to an object of the TextWriter class. EventlogTraceListener: Write messages to event logs. DefaultTraceListener: Send debug messages to the output window.
  • As tracing usually generates a lot of information, it's better that you turn off tracing while you don't intend to use it. Use TraceSwitch classes for the purpose

From: http://sitestree.com/?p=5226
Categories:24
Tags:
Post Data:2008-02-16 11:45:08

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Advanced Topics in .Net XML Web Services #24

  • SOAP Extensions: "SOAP Extensions are components that can access the SOAP messages. Think of them as objects that sit on the HTTP pipeline who can pick the SOAP messages at each stage and manipulate them.

    When the HTTP request comes from the client, it is handled by aspnet_isapi.dll. The appropriate handler for web services will be called and the web method will be invoked. It is during this stage where the SOAP Extension comes into picture. The SOAP Extension can access the SOAP message before and after calling the web method. Thus we now know in a vague manner what a SOAP extension is and where it fits in the life cycle of a SOAP message.

    SOAP Extensions can be used for a number of purposes. They can be used to secure web services, compress the verbose SOAP messages, log messages etc. In this article, we will see how to encrypt the SOAP message and send it over the network using SOAP Extensions.

    "Reference:Securing web services using SOAP extensions

  • You can use the web.config file to configure the SOAP Extensions to use and the priority of the SOAP extensions.
  • Configuring and Securing a Web Service: You can use the following elements of the web.config file to Configure a Web Service:

    compilation: compilation language and debug mode
    customErrors: On off remoteonly
    authentication: set to Windows Forms Passport None
    authorization: set users attribute to * ? or similar
    trace: enable disable application level tracing
    globalization: set globalization settings

  • Authentication: Windows: default - Windows and IIS authenticationForms: Use HTML forms to collect login credentialsPassport: Use a third party centralized authentication service using keysNone: no authentication required
  • Authorization: example:

From: http://sitestree.com/?p=5228
Categories:24
Tags:
Post Data:2013-01-13 09:19:13

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Advanced XML Web Services Programming #24

Attributes of a web method. Using attributes, you can define the behavior of the methods exposed.
Syntax

VB.net

_
Public Function ....

C#
[WebMethod (BufferResponse=false)]public int HelloWorld(){......

Attributes:

  • BufferResponse: Should the response be buffered?
  • CacheDuration: Number of seconds the response is cached in memory
  • Description: Describe a web method
  • EnableSession: Should session state be enabled or not?
  • MessageName: Alias to a web method
  • TransactionOption: Transaction support for a web-method

Creating Asynchronous methods: later ......

From: http://sitestree.com/?p=5225
Categories:24
Tags:
Post Data:2011-05-16 15:16:30

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

XmlTextReader Overview #24

Overview of .Net XmlReader and XmlWriter Object

XmlReader

Can read XML data both from file or stream. Readonly access. Also, provides information about the XML data. XmlTextReader class is derived from XmlReader. It provides faster access to XML data though it does not support validating DTD or XML schema. XmlValidatingReader class supports both DTD and schema validation. Attributes of XmlTextWriter class areAttributeCount,Depth,HasAttributes,HasValue,IsEmptyElement, Item,Value. Some methods are: IsStartElement, MoveToElement, MoveToFirstAttribute, MoveToNextAttribute, Read, ReadAttributeValue, ReadString, ReadStartElement, ReadEndElement, Skip

Example
   dim reader as New XmlTextReader("")   while reader.Read() select case reader.Nodetype     case XmlNodeType.Element            Console.Write("")   if reader.HasAttributes then   while reader.movetonextAttribute()   Console.Write(reader.value)   End While   end if  case XmlNodeType.Text Console.Write(reader.value)       case XmlNodeType.EndElement   Console.WriteLine("")end selectend while

From: http://sitestree.com/?p=4748
Categories:24
Tags:
Post Data:2011-10-11 17:18:58

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Overview of XML programming in Dot Net #24

Overview of XML programming in Dot Net

XML DOM(Document Object Model)

Three ways to read XML documents in dot net are: XML DOM, SAX, XMLReader.DOM loads entire XML data into memory for processing, it is both read-write, I mean you can change XML data and save. DOM uses data-structures to represent the data in the RAM.

SAX does not load all XML data in memory rather processes sequentially. SAX is good for just reading large XML file/data but as it does not store the data in the RAM and does not use any data structure, it can not perform complex operations(search) on the data.

XmlReader class of the .net framework can also be used to read and process xml data. It provides read only and forward only access.

How XML DOM works?

The root node of an XML document is represented by the XmlDocument. XmlDocument is derived from XmlNode class. XmlDocument provides methods such as Load(Load XML data from file), LoadXml(takes XML string as parameter to load), and Save(to save XML data into a file). Also, you can use XmlDocument to traverse through the XML data and process/print

Example code:Vb.net

dim xmlDo as New XmlDocument

xmlDoc.load(emp.xml);//or xmlDoc.loadXml("");

Console.WriteLine(xmlDoc.InnerXml.ToString)

xmlDoc.save("newDoc.xml");

C#

XmlDocument xmlDoc = New XmlDocument();

xmlDoc.load(emp.xml);//or xmlDoc.loadXml("");

Console.WriteLine(xmlDoc.InnerXml.ToString())

xmlDoc.save("newDoc.xml");

Parsing an XML document

------------------------

C#

count=0;

i=1;

XmlNode node=xmlDoc.ChildNodes[1];

foreach(XmlNode node1 in node.ChildNodes)

{

foreach(XmlNode node2 in node1.ChildNodes)

{

Console.WriteLine(xmlDoc.DocumentElement.FirstChild.ChildNodes[count].Name+":"+node2.FirstChild.Value); count = count + 1;

}

i=i+1;

count=0;

}

---

count =0

i=1

dim node1 as XmlNode;

node1 = xmlDoc.ChildNodes(1)

foreach node1 in node1.ChildNodes

dim node2 as XmlNode

foreach node2 in node1.ChildNodes

xmlDoc.DocumentElement.FirstChild.ChildNodes(count).Name +":"+node2.FirstChild.value

next

i=1+1

count=0

next

---------- From: http://sitestree.com/?p=4747
Categories:24
Tags:
Post Data:2011-04-21 04:17:46

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Build RPM Package #26

Check the tutorial below for a detail discussionhttp://www.rpm.org/max-rpm/ From: http://sitestree.com/?p=4749
Categories:26
Tags:
Post Data:2010-08-25 17:48:18

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Quick guide to RPM (Red Hat Package Manager) #26

Quick Guide to RPM

RPM-Red Hat Package Manager

Caldera, Suse, Fedora also use RPM

  1. rpm -qa | more

to check the installed software in the system

q=query

a=list

  1. rpm -qi faq

Query individual package

q=query

i=requires a package name

faq=the package

  1. rpm -ql faq

List all the files for the package faq

q=query

l=list files

faq=package name

  1. rpm -ivh xapp-1.1.0.i386.rpm

install a package

i=install

v=verbose

h=show progress with hash

  1. rpm -e faq

remove package

-e = erase

  1. rpm -e --nodeps faq

erase without checking any dependancy

may cause some other packages to fail

  1. rpm -Va

Verify all of the files on your system.

  1. rpm -qf /usr/bin/uptime

check a file for its source/package

  1. rpm -ivh --force pack-1.0.0.i386.rpm

sometimes you will need it. When you go to install, you may get 'already installed' message, if you want to remove you may get 'not installed' message, --force is the solution.

  1. rpm -ivh --nodeps pack-1.0.0.i386.rpm

install without checking dependencies

[may not be a very good thing sometimes] From: http://sitestree.com/?p=4750
Categories:26
Tags:
Post Data:2006-11-30 22:11:36

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

How to create a RPM package in Linux #26 #RHCSA

How to create a RPM package in Linux

Creating basic installation RPM package is really easy. You just have to use rpmbuild command. rpmbuild will be applied to your source files and a RPM package will be created [all source files will be included in the RPM package]. Somewhere you need to specify the path of your source files. Just before creating the RPM package, your source files will be copied to a temporary location [termed as Build Root]. Actually, you need to write a spec file. rpmbuild will read that file to extract parameters and will act based on the parameter values.

Sample RPM Package

Summary: A summary description of the software.
Name: xyz
Version: 1.0.0
Release: 1
Group: System Environment/Base
BuildRoot: /var/tmp/%{name}-buildroot
Prefix:/opt/xyz
%description
Description of your software
%pre%prep%build%installrm -rf /opt/xyz/$RPM_BUILD_ROOTmkdir -p /opt/xyz/$RPM_BUILD_ROOT/dir1mkdir -p /opt/xyz/$RPM_BUILD_ROOT/dir2cp -r your_source_files_path/* /opt/xyz/$RPM_BUILD_ROOT/%post%cleanrm -rf /opt/xyz/$RPM_BUILD_ROOT%files%defattr(-,root,root)/opt/xyz/dir1/opt/xyz/dir2

In the example, BuildRoot is assigned to: /var/tmp/%{name}-buildroot. %install section is doing the building/creation of the RPM package. From Summary to %description are the headers to specify different information as the names indicate. %install section is creating the directories needed and copying your source files to BuildRoot directory(cp -r your_source_files_path/* /opt/xyz/$RPM_BUILD_ROOT/). %files section specifies where rpm package will install your software.%clean section just cleans the BuildRoot directory after the RPM package is created.

Just a note: As I mentioned Prefix to be /opt/xyz, I provided /opt/xyz in the paths. If you keep Prefix to be null, then you need to remove /opt/xyz from the paths. You can place shell commands under %pre section. These command will run just before the RPM package is being installed(using rpm -i command). Under %post section, you can also place some shell commands that will run immediately after the software installation(using rpm -i command). You can use %preor %post section for operations like creating databases, users, and assigning permissions

This may not be 100% perfect. I did not test it on any system, but it should be almost ok. For another example, please visit: http://www.redhat.com/magazine/002dec04/features/betterliving-part2/

The spec file should have name of type name-version_release.spec. After creating the spec file, run the command rpmbuild -ba the_spec_file_name. It will create rpm packages under /usr/src/redhat/BUILD/x86_64 and /usr/src/redhat/SRPMS. You need to copy the spec file under /usr/src/redhat/SPECS/

To install the created RPM package, use rpm -ivh rpmpackagename.rpm command. Look %files section to know where the software will be installed. You can change the path using commands like:rpm -ivh --prefix /opt/rty/ rpmpackagename.rpm. Check our guide on rpm command From: http://sitestree.com/?p=4751
Categories:26, RHCSA
Tags:
Post Data:2009-01-06 06:48:45

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Overview on Windows Azure Cloud – Demo for inside Azure – what can you do with Windows Azure #27

Overview on Windows Azure Cloud - Demo for inside Azure - what can you do with Windows Azure From: http://sitestree.com/?p=5346
Categories:27
Tags:
Post Data:2011-12-04 04:42:32

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Overview on Windows Azure Cloud – Demo for inside Azure – what can you do with Windows Azure #27

Overview on Windows Azure Cloud - Demo for inside Azure - what can you do with Windows Azure. Overview on Windows Azure Cloud - Demo for inside Azure - what can you do with Windows Azure From: http://sitestree.com/?p=5347
Categories:27
Tags:
Post Data:2008-03-19 09:38:37

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

How to be a SEO Consultant? What do you need to know? #28

How to be a SEO Consultant? What do you need to know?................................................

Note 1: Some information are taken from the Book 'Search Engine Optimization - Bible'

Note 2: The guide is no way complete. It is not well formatted yet (actually, it's an ongoing slide). Just use it to know what to learn and to get an introduction on the related topics.

From: http://sitestree.com/?p=5289
Categories:28
Tags:
Post Data:2013-04-30 00:14:51

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Web Hosting Companies #27

Best Hosting Companies

I was searching for a suitable webhosting for me. Until now features and cost wise I liked HostGator, VodaHost, HostMonster, BlueHost. Yahoo is another one I like but pricy. I am into hostgator and vodahost mainly. Though, vodahost has some bad reputation and their customer support may not be great. Just few other hosting companies are below. They are also very popular with huge customers. They may be better than Hostgator or Vodahost or HostMonster for you but for me I am sticking with HostGator[Do not have much experience with their customer support though]. It's really difficult to come up with the best.

From: http://sitestree.com/?p=4753
Categories:27
Tags:
Post Data:2011-05-18 09:29:31

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Resources for Online Publishing: How to Earn Revenue from Online Advertising: Tools for the Online Publishing #28

Resources for Online Publishing: How to Earn Revenue from Online Advertising: Tools for the Online Publishing

Just some great discussions that you can check

From: http://sitestree.com/?p=5251
Categories:28
Tags:
Post Data:2012-11-15 19:08:32

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

How is the Price of Social Networking site Determined? #28

If you have no idea on it, then the following will give you just an idea. Simply, you can think it as follows (just the basics):

  • 1. Take the Number of registered users
  • 2. Only 3 to 10% registered users are usually active (actively participate in the site)
  • 3. Think about the number of registered users growing every day/month/year
  • 4. Also, think about the non-registered visitors every day/month/year
  • 5. For the 3 to 10% of the real/actual visitors, for each visitor calculate $10/year to $20/year of revenue = the value of the social networking site (for one year)

From: http://sitestree.com/?p=5273
Categories:28
Tags:
Post Data:2011-03-30 03:14:40

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Just 2 cents on Google Adsense Income #28

I am not going to convince you that Google Adsense is a great way to earn money online. Adsense - Great or bad, you decide. Just if you are already convinced, then you may want to take a look on this short-note. I am here, just to tell that if you search the Internet, you will see people are claiming to earn big money with Google Adsense. How true are they? To my sense, a few of them should be right, but many of them are not. Can you earn big with Adsense? My sense is - yes, you will, only if you are also big and popular, if your web-sites attract a significant number of Internet Visitors, also your site is useful to them, additionally, if the adsense ads that are displayed on your sites pay something significant per click.

Lets do the math, so far I have seen from different peoples' analysis - Adsense pays on an average 20-30 cents/click, where it can go upto 12-15$/click [I think rare] per click. Also, according to analysis in the internet, the click rate is 0.2 to 3-4%. Reference: http://www.webmasterworld.com/forum89/6726.htm

Lower Limit: Now, say if you have a web-site that attracts 100 visitors a day (3000/month), then you get 0.2 click/day, 6 clicks/month, $1.8/month.

With 1000 Visitors per day: 2 clicks/day, 60 clicks/month = 18$/month

With 100,000 Visitors per day: 200 clicks/day, 6000 clicks/month = 1800$/month

Reality is, if you have 100,000 visitors/day - you will get many other advertisement income opportunities - big players may come to you with great/good offers.

Upper Limit: Now, say if you have a web-site that attracts 100 visitors a day (3000/month), then you get 1 (1%) click/day, 30 clicks/month, $9/month.

With 1000 Visitors per day: 10 clicks/day, 300 clicks/month = 90$/month

With 100,000 Visitors per day: 1000 clicks/day, 30000 clicks/month = 9000$/month

Reality is, if you have 100,000 visitors/day - you will get many other advertisement income opportunities - big players may come to you with great/good offers.

This is not the exact right amount that you will/can earn. There will be many other factors that will play roles. My concern is: if you decide/try to earn through Adsense, you have to do it seriously, and think practically - how big can you become, how many visitors are you capable to attract, how demanding are your contents. How much patience do you have? How much time and efforts can you put on it? Do you have the mindset to do it?

There is a possibility that your click rate can be at least 0.5% to 0.8%. There is no guarantee on it. One possible approach can be - start a web-site, promote it to your target users, wait for three or four months, keep advertising to strangers interested in your type of web-site (I would say mostly to strangers - online or offline). After, three four months, you will know how much is your click rate, and how much you can get per click. In the meantime, you may also try to alter the ads in your web-site (position of the ads, color of the ads, sizes of the ads, type of the ads(text/image), also the advertisers/ads). Then you will know that it does worth your effort or not. I am just trying to say - if it is something - you wanna do - proceed logically.

Before, believing the claims in the internet, check their traffic rankings, popularity, and reliability.

According to the, AdsenseOverDrive.com (I do not know much about AdsenseOverDrive.com), some statistics are given below:

  • PlentyOfFish Founder Earns Over $1 MILLION Dollars In Less Than 3 Months!
  • Jason Calacanis Earns Over $2,000.00 Per Day With Adsense!
  • Jeremy Shoemaker, blogger, earns over $140,000 MONTHLY with Adsense.
  • Shawn Hogan, Digital Point forum owner earns over $10,000 monthly with Adsense..
  • Tim Carter, from AskThe Builder, earns over $30,000.00 monthly with Adsense.

Are these figures and data true, I do not know - but seems some of the web-sites attract a huge traffic. Some of the web-sites (askthebuilder.com) are also featured in google adsense web-site. According to google, askthebuilder.com, increased their 10000$/month income to 30000$/month with adsense. You have to decide yourself. However, you can start at checking the lower limit and the upper limit, as I just provided above.

Last Talk:If you want to go with Adsense for earning, do it only if you can take it seriously and over the time can grow very big (I mean your web-site). If not, I do not think - it is the right way of trying to earn money. You may need to wait for several years to grow your traffic to be big enough to earn something significant. Hmm, not always though, if it is a hit like the Facebook, you can reach fast and grow big fast. First of all, your site need to be of great demand, useful in some ways. You may need to complete the site first, do extensive marketing to reach to all target people (definitely you need to do market research and/or understand market).

Sure, if you are not bothered with how much you earn from your web-site, just want to maintain a web-site as a hobby or some other good reasons - go ahead and create your web-site and probably place Adsense ads on your site. However, don't believe the claims in the Internet that you will earn money easily (without much effort).

Follow this link to read success stories right from Google. AskTheBuilder.com is also featured here

Whatever you do, do it with your own responsibility, we are not liable for any of your actions. Seek professional and/or legal help if required. I do not know much about AdsenseOverDrive.com

From: http://sitestree.com/?p=5211
Categories:28
Tags:
Post Data:2008-04-28 18:59:55

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

SEO Tools #28

Backlink Checker

Google Banned Checker

Google Datacenter Search

Google PageRank Prediction

Keyword Density Checker

Keyword Suggestion

Link Popularity

PageRank Checker

Rank Checker

Search Engine Position

Search Listings Preview

Spider View

Visual PageRank

Miscellaneous

Domain Checkups

HTML

From: http://sitestree.com/?p=5236
Categories:28
Tags:
Post Data:2007-10-01 20:50:22

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Some online business ideas without much investment #28

Some random ideas --

  • Do hosting reselling - some hosting providers target only the resellers. You can be a reseller. Many big and reputed hosting providers are practically resellers in the back. As a reseller, you will get web-sites in predefined formats for different purposes. Or you will get access to the API of the providers. Then you have to create your own web-sites or software to use those APIs for your activities. Search google with "hosting reseller" for more information.
  • Work as an affiliate - go to www.cj.com - under www.cj.com, join all hosting companies as affiliates. For each sale you will earn 90-150$. If you are a web-site developer, then you can refer your customers to a good hosting provider and earn some extra cash.
  • Also, under cj.com, you can join as affiliates for many other merchants. You can earn commissions by selling their products (online/offline). One approach can be, you can create your own web-site with all the products under cj.com. Then 1. you can give links to the merchant web-sites for sale. If any item is sold, you get a commission 2. You can sale from your own web-site. Do all the payment processing on your end. Later buy the product from cj.com merchants and provide buyers' addresses as the shipping address. You need to check, is this profitable or not? Also, you need to check - if this is legitimate or not.
  • Join cj.com, shopping.com, and other such networks (affiliate networks) as affiliates. Create your own web-sites, enter product details from all affiliate networks (i mean merchants under them) into your database. Then create a service like - shopzilla, bizrate. Compare prices, give links to the merchants, and earn commissions for each sale.
  • You can do drop shipping. From your web-site you can sale drop-shippers' products. When products get sold, the drop shipper ships the products for you in the back. You have to buy the products from the drop-shipper at a lower price earlier. salehoo.com can be a place to find drop-shippers.
  • You can use domain parking to earn from online advertising. Bit difficult and lengthy. can be costly. You can buy expired domain names with high traffic. Such domains will have more earning potential than completely new domain names. However, domain names that (like fish.com) can attract huge search engine traffic can be bought new.
  • Buy meaningful domain names that may be of interest to businesses. Later sale them for big money. So far, I can remember, senior.com was sold at 6 million dollar [or similar]. fish.com was also sold around 5-7 million dollar. Check internet for exact figure.
  • Google adsense is always there to earn from your web-sites. If you search in google about adsense, you will see people are claiming that they are earning big money with adsense. My opinion: you can earn big only if you attract huge traffic. Also, if your web-site is authoritative in a particular area. Otherwise, the revenue may not be great. It also depends on the content area. If there are many advertisers (big players) in the area and they compete over each other for search engine/google adsense traffic then probably, you will earn great.

From: http://sitestree.com/?p=5102
Categories:28
Tags:
Post Data:2006-11-11 14:56:13

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Tips on How to Earn from Your Web-sites/(Online) #28

Just a short-note. I have spent very little time on this short-note. Use the information at your own risk.

  • Sale products
  • Just like the regular businesses, sale products in demand. Sale products in need. Sale products that people will not mind to buy online. Find a niche and sale products of that niche category. Remember, big players like Amazon, shopping.com can not reach to all/(all levels/all niche) customers with all sorts of customer needs. Customers may not feel comfortable to search and buy the right product from their big web-sites. You may focus on a particular category of products and advertise to the audience who will be interested in those products. Still, big players are there, you can find a niche category and focus on that, can sale products of that type, and make good profit. Customers may feel more comfortable in your specialized web-site. You need to earn customers' trust though.
  • Sale advertising/(ad-inventory) space of your web-site
  • Most importantly, you need traffic/visitors to your web-sites whether you want to sale products or sale ad-inventory
  • Try to reach to your target audience through online or offline marketing. If you search google for "online/internet income", people claim that they earn big money from the Internet. Some of them are true though not all of the claims are true. what is the catch? reach of their web-sites to the target audience. They usually spend much on advertising (online/offline) to reach to the target customers.
  • How to reach to your target audience: Use Google Adwords, Use search engine optimization of your web-sites, use classifieds web-sites to promote your services, use google base/local, take professional SEO services, submit your sitemaps to google webmaster tools, use yahoo and google groups, advertise through online/offline ezines/magazines, press release (paid/non-paid) of your services, create blog about your web-sites/products/services, use blog ping service to advertise your blog, submit your web-sites to paid/non-paid directories, use web-rings, submit articles on your websites/products/services to free/paid article directories, use link services, use forums to post contents and keep a link to your website (may be from signature). Publish your own magazine and advertise your service to the subscribers in your newsletter. Use email marketing services. You have to use one or more of these alternate marketing strategies.
  • Remember, you must have to bring visitors to your web-sites. Though you will see, many claim that they did it without any investment - my understanding is that is not completely true. You should be ready to invest some for marketing at least in addition to your production cost/time.
  • You can use only the free marketing strategies but it will take time to reach to your target audience.
  • AD-INVENTORY
  • Adsense Income tips: You need original and useful content. Better if you have fresh and useful contents everyday. Significant traffic is a must. You need at least 300-500 visitors/day, to see some mentionable earning
  • For adsense, placement of your ads does matter. Place your ads near the top of your web-pages or embed ads to your contents. The target is, adsense ads should be placed in places/areas that visitors must see (where visitors eyes will be focused more) the ads while reading your contents/web-pages. You can vary the places and colors of the ads so that even regular visitors can't even skip them noticing. If the ads catch the eye of your visitors, that may lead you good income. Again visitors are the keys.
  • For earning from, advertising - don't just depend on adsense. You can use three blocks of ad from adsense. Your web-pages may have more blocks to display ads. So join other programs that are compatible with adsense. You can join text link advertising services like IntelliTxt, echotype, infolink, kontera, and adbrite.
  • In addition you can use banner advertising companies such as fastclick, valueclickmedia, tribal fusion, burst media, casaelmedia, advertising.com. These programs usually require a good traffic to join. However, the good news is, when you have good traffic. through these programs you will have guaranteed monthly income. Research and decide yourself.
  • In addition, you can join pop-under and pop-up advertising. Though personally I do not like these kind of advertising. I find them annoying.
  • You can also sign up for interestial ads(adbrite/clicksor). Usually these pay more 9-10$/1000 impressions.
  • If you have good traffic then placing affiliate ads may also lead to some good income.
  • cj.com, chitika, shopping.com can be very good sources of affiliate programs. Remember, if you do not have much traffic - do not expect to earn much through affiliate programs. You can also join ebay affiliate programs to advertise ebay products.

From: http://sitestree.com/?p=5136
Categories:28
Tags:
Post Data:2010-08-15 19:39:36

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

On Internet Marketing and Online Income #28

From: http://sitestree.com/?p=5186
Categories:28
Tags:
Post Data:2006-09-26 15:24:53

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Lesson 1: How to build hosting business with little investment #28

From: http://sitestree.com/?p=5068
Categories:28
Tags:
Post Data:2010-05-15 08:04:05

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Required Components for Internet Income #28

Do you want to earn through your website? Well you want to start your own home business. In this category, we will provide you detailed information to meet your needs. We will provide information how you can earn through your website. We will also explore the opportunities for online based home business and online business.

First you need to know what are the options that can make you money through your websites. If you search the Internet you will find thousands of options and opportunities. I personally believe all of them are not useful. Some of them are just scam. We will try to identify some good options.

Here we will discuss our opinions in several steps: Steps:

  1. Types of programs that will pay you
  2. Requirements and tools needed for such programs

Types of Programs. For details click on HOME Button.

  1. Pay Per Click
  2. Pay Per Surf
  3. Pay Per Sale
  4. Pay Per Lead
  5. Pay Per Email Read
  6. Pay Per Pop Up show
  7. Pay for Blind Clicks
  8. Earn by Joining Reseller Programs
  9. Being a Seller in a Program

Well, these are some basic categories. We will add when we are familiar with new options. You can join and test one program alone. Even, you can try multiple programs simultaneously. Please, check the policies for corresponding programs whether they comply together.

Tools and Requirements needed for online earning:

  1. A Well Designed Website
  2. Website Hosted with User Friendly URL
  3. Merchant Tools
  4. Marketting

A Well Designed Website
You yourself can build your website or take help of an expert to build your website. You can learn HTML, FrontPage, DreamWeaver, JavaScript, Phtoshop, Flash, PHP, MySQL to build a good website. In future links to several free tools to build website will be provided.

Website Hosted with User Friendly URL
You need a hosting space for your website. There are plenty of free webhosting services in the Internet. The good talk about them are they are free. However, they are not good for online business. Also they are not good for Pay Per Click programs as they might force you to keep their adds on your webpages. If you are interested with free webhosting please search google.com with the phrase "free webhosting" and try the links. You can also try the link http://www.free-webhosts.com/. If you want paid hosting service you can search google with the phrase "ranking web hosting". You can also try with similar phrases. You can also try www.TheHostingChart.com, www.top10webhosting.com, toptenreviews.com.

For online transactions you will need to setup merchant accounts with your hosting packages. You need secure SSL connection. If you work as a seller you will need to use shopping cart from your hosting/other companies. You can yourself program your shopping cart. Verisign is a company that will help you to preserve security in your online transactions.

When you join a program you will get payment from the company. The company will pay you in various ways. They might send you check. There are some convenient ways to accept money online from the owner of the programs. Such as:

  1. Paypal
  2. Egold
  3. StormPay
  4. IntGold
  5. EPassporte

Personally I am familiar with paypal. I found it to be secure and trustable way of making online transactions. Other options are new to me. However, not all companies work paypal. Hence, in some cases you will not have any option to avoid the others. Read articles regarding the other options, consult with your friends and other webmasters to know about the services clearly.

Meta Tag Generator

Websites that offers free Meta tag Generator Utility

From: http://sitestree.com/?p=4989
Categories:28
Tags:
Post Data:2010-11-17 14:17:24

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Search Engine Optimization #28

Well, the truth is, the most effective internet marketing is the search engine marketing. But this is the most difficult internet marketing option also. Think if your webpage is listed in the first 10 entries in Google search and/or Yahoo search and your product/content is in high demand, you are sure to make a fortune. However, can you think, how difficult can it be to be in the top 10 among all the websites in the world in your category (a very popular one)? It is certainly difficult. But you should not lose hopes, this is one option that you must try. Over the time your site will get good ranking. Follow some basic search engine optimization strategy to develop your web-sites, make your web-sites search engine friendly, submit your websites to search engines you will get results. Remember, before submitting to search engines, you need to build your web-sites accordingly first. Note: for keywords like tutor dhaka, tutor bangladesh I get very good ranking in both Google and Yahoo search.

                         <h2>Search Engine Optimization Guides</h2>              <p>Read the following guides for better understanding how to make your web-pages search engine friendly</p>                             <ul>                    <li> <a href='http://www.e-future.ca/alberta/pdf/efc_search_engine_optimization.pdf' target="_blank" rel="noopener">Search Engine Optimization Tips:Alberta-E-future Center</a>                </li></ul>              <h2>Search Engine Optimization Tips from Ebay (especially for ebay users)</h2>              <ul>                <li> <a href='http://pages.ebay.co.uk/education/SEO/SEO-introduction/index.html' target='new' rel="noopener">Search Engine Optimization:ebay</a>               </li></ul>              <h2>Articles on Search Engine Optimization</h2>             <ul>                    <li> <a href='http://smallbusiness.yahoo.com/r-subCat-m-6-sc-35-sales_marketing_search_engines-i' target='new' rel="noopener">Search Engine Optimization:Yahoo Small Business</a>               </li></ul>              <h2>Submitting to Search Engines </h2>      <div style='float:left;border:0px 0px 0px 0px;text-align:justify'>                      </div>              <p>                 Submitting to search engines is not an one time work. You need to submit frequently, may be once in a week or once in a month.              </p>                    <ul>                        <li> <a href='http://www.google.com/addurl'>Submit to Google</a>                      </li><li> <a href='http://search.yahoo.com/info/submit.html'>Submit to Yahoo</a>                      </li><li> Use the free software WEBCEO to submit to lots of search engines for free                 </li></ul>              <p align="justify">                 Read all of the webpages of the website <a href='http://dollarintheair.com'>dollarintheair.com</a>. Try to understand them. Try to come up with some ideas and plan. Don't try this and that randomly. Afterwards, if you need any assistance, feel free to email us. Join our email group  for helpful tips and updates.              </p>         From: http://sitestree.com/?p=4984<br /> Categories:28<br />Tags:<br /> Post Data:2006-11-05 14:44:03<br />

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Query Optimization in PostGreSQL #3

check: http://www.postgresql.org/docs/7.3/interactive/geqo.html"optimization effort is caused by the support of a variety of join methods (e.g., nested loop, hash join, merge join in PostgreSQL) to process individual joins and a diversity of indexes (e.g., R-tree, B-tree, hash in PostgreSQL) as access paths for relations. "

"The current PostgreSQL optimizer implementation performs a near-exhaustive search over the space of alternative strategies. This query optimization technique is inadequate to support database application domains that involve the need for extensive queries, such as artificial intelligence. "

From: http://sitestree.com/?p=4716
Categories:3
Tags:
Post Data:2013-01-25 12:41:08

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Apache WebServer: Basic Configuration #29

Configuring Apache WebServer

----------------------------

GUI Tools:
There are some GUI tools to configure Apache web server but they mostly do the basic or intermediate levels of configurations. For advanced configuration, modifying the configuration file. is the way to go. Some GUI tools are: Comanche, TkApache, LinuxConf, WebMin, ApacheConf, user_manage. Among them, Webmin is browser based and may be a better choice than the others.

Basic Apache Configuration Information is as below:
Apache has three configuration files:
httpd.conf
access.conf
srm.conf

httpd.conf is the main file, you can forget about the others.
A basic configuration file may look like the following:
ServerName www.justetc.net #host name .. serving website URL
listen 192.168.0.1:80 # listen to the network interface 192.168.0.1 and port 80
listen 192.168.0.1:400 # listen to the network interface 192.168.0.1 and port 400
User nobody #connect to the apache server as the user nobody #default
Group nobody
ServerAdmin admin@justetc.net #email of the administrator
ServerRoot /usr/locale/apache #apache's main working folder, apache keeps essential files here
ErrorLog logs/error_log #to keep track of errors
TransferLog logs/access_log #check the access, may make website slower
DocumentRoot /home/www/justetc

------You can create your own user and set that to access webpages
groupadd -g httpd
useradd -u 999 -g httpd -s /bin/false -c 'Web Server'
then use

User httpd
Group httpd

From: http://sitestree.com/?p=4760
Categories:29
Tags:
Post Data:2012-10-28 23:39:54

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

IBM Websphere: Download #29

From: http://sitestree.com/?p=4882
Categories:29
Tags:
Post Data:2007-01-30 16:46:20

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Online Resources: Hourly Rate for Consultants in IT/Software Development #34

From: http://sitestree.com/?p=5278
Categories:34
Tags:
Post Data:2009-11-02 13:20:56

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Interested in a Career in Computer Graphics? What it takes? Just the basics #34

Check the following resources (may be, only if you have no idea on this - Google search can give you more information)

From: http://sitestree.com/?p=5288
Categories:34
Tags:
Post Data:2009-06-18 01:55:17

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Canada Top Technology Companies #34

From: http://sitestree.com/?p=5179
Categories:34
Tags:
Post Data:2013-03-07 20:03:11

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

What should be your hourly rate as an IT consultant? #34

Consult the following resources, you will get a pretty good understanding.

From: http://sitestree.com/?p=5247
Categories:34
Tags:
Post Data:2012-10-10 11:44:01

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Online Resources: Hourly Rate for Consultants in IT/Software Development #34

From: http://sitestree.com/?p=5277
Categories:34
Tags:
Post Data:2011-10-24 16:11:32

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Salary/Wage Canada Government Jobs #34

I think that the following web-pages may give you an understanding of salaries for Government Jobs in Canada. The information provided may not be the most recent information, still you will have an idea.

From: http://sitestree.com/?p=5178
Categories:34
Tags:
Post Data:2007-07-31 07:21:12

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

How Much Should an Independent Consultant Charge? #34

From: http://sitestree.com/?p=5168
Categories:34
Tags:
Post Data:2008-08-10 22:05:02

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Salaries in Different Companies Such as Microsoft #34

Comments: Salaries at big and reputed companies are usually significantly higher than small companies.

Jobs in the IT department of a good company (non-IT) are much more stable than positions in small software companies (salaries are also higher)

By working for your own company, you can earn much more than being employed. You need to do it right though

If you get contract jobs continuously, one after another, you will earn significantly higher than full time employment. At contract jobs, your hourly compensation is usually two to three times than full time permanent jobs. In Manitoba, if you have around 5 years of experience, you can demand 60-70$/hour (very usual)

If you are academically great, being a professor can be very rewarding in terms of job satisfaction (salary is not bad).

To my knowledge, when a software company charges his clients (corporate clients) the usual (minimal) rate is: 80-120$/hour.

From: http://sitestree.com/?p=5158
Categories:34
Tags:
Post Data:2010-04-11 23:47:59

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

IT-Job, IT Skills, Skills-Gap #34

From: http://sitestree.com/?p=5112
Categories:34
Tags:
Post Data:2009-11-18 16:39:47

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

How to Set Your Consulting Fees? #34

Check the following resources:

From: http://sitestree.com/?p=5114
Categories:34
Tags:
Post Data:2012-08-03 17:39:21

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Salary By Fields #34

From: http://sitestree.com/?p=4949
Categories:34
Tags:
Post Data:2011-12-10 06:06:21

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Employment Laws: Employment Insurance, Quit, Fire #34

From: http://sitestree.com/?p=4952
Categories:34
Tags:
Post Data:2009-02-22 07:59:10

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Toronto: Top 50 Employers #34

From: http://sitestree.com/?p=4884
Categories:34
Tags:
Post Data:2013-02-08 10:36:02

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Winnipeg Recruiters #34

Agency Name Specialize in Industries
Adecco Employment Services Ltd General - most or all
Andersen General - most or all
Anokiiwin Employment Solutions Inc. Federal Government
Brant & Associates General - most or all
Careersource Recruitment Aerospace, Health care, Hospitality
Centre for Aboriginal Human ... General - most or all
Charter Management Group (CMG) General - most or all, Academic, Advertising, Aerospace,...
David Aplin & Associates Inc Computers, Direct Marketing, Electronic equipment,...
Drake General - most or all
Employment Projects Of Winnipeg General - most or all
G Braha & Associates Ltd Computers, Information technology, Software
Global Education Services Academic
Harris Consulting Corporation, The Aerospace, Agri-business, Food manufacturing,...
Higgins International Inc Gaming
Houston Personnel Group, The General - most or all
Kee Transport Group Inc Transportation
Kelly Services General - most or all
Lock & Associates Consumer goods, Financial services, Health care,...
Mancomit Int'l Inc General - most or all, Hi Tech, Information technology
Manpower General - most or all
MER Executive Search Call centres, Consulting, Manufacturing
PCGI General - most or all, Computers, Data processing, Hi Tech,...
People Bank, The General - most or all, Financial services,...
People First HR Services Ltd General - most or all, Manufacturing
Personnel Management Group Agri-business, Automotive, Construction,...
PriceWaterhouseCoopers General - most or all
Progestic Group General - most or all, Computers, Data processing, Software
Reaching E-Quality Employment ... General - most or all
Scarrow & Donald General - most or all
Simpson McGrath Inc General - most or all, Aerospace, Associations,...
SMD General - most or all
Specialty Office Staff General - most or all
StafFind Federal Government, Municipal government
Sturgeon Creek Enterprises General - most or all, Hospitality, Manufacturing,...
Technical Service Consultants of ... General - most or all, Consulting, Construction,...
TSC Group General - most or all, Automotive, Manufacturing, Metal,...
Westwood Employment Link General - most or all, Manufacturing
Zen Zen International General - most or all, Computers, Data processing, Hi Tech,...

From: http://sitestree.com/?p=4881
Categories:34
Tags:
Post Data:2008-08-23 22:17:57

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

JSP: Custom Tags #37

  • Custom Tags = alternatives to java beans for JSP = reduces some limitations of JavaBeans (in JSP) like to few methods to access the bean, you may still require to write much java code in JSP [that we want to avoid]
  • Overview:
  • Custom tag with no body should extend TagSupport class that implements Tag interface
  • Tags extending TagSupport should extend only one method - doStartTag(), and in this case the doStartTag() method should return SKIP_BODY
  • A simple tag code is shown below:
  • Next you need to define a tld file - a descriptor file for the tag - XML file.
  • In the tld files, the most important tag is the tag
  • The sub-elements of the tag element are: name, tag-class, description, body-content.
  • Sample:
      SimpleTag  tags.SimpleTag  Sample TLD File  empty
  • To use the custom tag in a JSP file, You need to provide a directive like:
     
  • Example use:
  • How to add attributes to tags: In the class, declare private variable for each attribute you want, define a setXXX method for each of the attribute
  • In the tld - file, add an attribute tag for each attribute you want. This attribute tag can have following sub-elements: name, required, rtexprvalue = can the value be an expression, type=class to which the value should typecast to, description
  • Defining tag body: doStartTag() should return EVAL_VALUE_INCLUDE
  • A new method named doEndTag() should be defined that will define what will be the effect on the body text.
  • The doEndTag() method may return EVAL_PAGE = continue to process rest of the JSP page, SKIP_PAGE = stop processing rest of the page
  • To support body inside the custom tags - body-content tag in the tld file needs to be adjusted: example
      SimpleTag  tags.SimpleTag  Sample TLD File  JSP
  • Example use: Body Text

From: http://sitestree.com/?p=4964
Categories:37
Tags:
Post Data:2012-12-20 05:06:38

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Manitoba: Income : Income Tax #34

Your income and income tax
http://www.cra-arc.gc.ca/tax/individuals/faq/taxrates-e.html

Federal Tax

* 15% on the first $37,885 of taxable income, + * 22% on the next $37,884 of taxable income (on the portion of taxable income between $37,885 and $75,769), + * 26% on the next $47,415 of taxable income (on the portion of taxable income between $75,769 and $123,184), + * 29% of taxable income over $123,184.

Manitoba Provincial Tax

10.9% on the first $30,544 of taxable income, +12.75% on the next $35,456, +17.4% on the amount over $66,000

Manitoba:Some example
30.5K/year = 1794$/month approx., 828$ approx. bi-weekly after tax
38K/year = 2300$/month approx., 1061$ approx. bi-weekly after tax
42K/year = 2552$/month approx., 1177$ approx. bi-weekly after tax
45K/Year = 2715$/month approx., 1253$ approx. bi-weekly after tax
55k/year = 3258$/month approx., 1503$ bi-weekly after tax
75K/year = 4311$/month approx., 1989$ bi-weekly after tax

From: http://sitestree.com/?p=4860
Categories:34
Tags:
Post Data:2013-02-15 18:29:43

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

JSP Expression Language #37

Expression Language-------------------Introduced in JSP 2.0You can write short expressions for different operations [other than using functions]If you want to ignore EL in any page addSome examplesEL=> what does it mean?${3+2-1}=> ${3+2-1} ${"1"+2} => ${"1"+2} ${3%2} => ${3%2} ${(8 div 2) mod 3} => ${(8 div 2) mod 3} ${1<2} => ${1<2} 

From: http://sitestree.com/?p=4793
Categories:37
Tags:
Post Data:2010-01-28 02:13:10

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

JSP: Random Information #37

  • Three JSP constructs: scripting elements, actions, directives
  • Scripting elements: expressions, scriptlets, declarations
  • Expression = translates to println in servlets in _jspService methods
     < % = expression %> < % = new java.util.Date() %>

    inserts values directly to the output

  • scriptlet: block of java code : directly inserted into the related servlets in the _jspService method:
    < % java code %>
  • declarations:
    < %! variable and method declarions%>

    Directly placed in the body of the translated servlets

  • >= JSP 1.2 : XML Syntax for expressions, scriptlets, declarations
    Java ExpressionJava CodeJSP Declaration
  • JSP implicit objects: request, response, out, session
  • Implicit objects: application = servletContext = persistent data, config = ServletConfig = initialization parameters, pageContext = context to store reference to objects, and page = this, exception = used by error pages :
  • < %@ directive attribute ="value " %>< %@ directive attribute1 ="value1 " attribute2 ="value2 " ... attributeN ="valueN " %>
  • JSP Directives : page, include, taglib
  • page directive attributes: import, extends, session, isThreadSafe, buffer, autoFlush, contentType, pageEncoding, errorPage, isErrorPage, language, and info
  • < %@ page import="package.class " %>< %@ page import="package.class1,...,package.classN " %>< %@ page extends="somepackage.someclass " %>< %@ page session="true" %>< %@ page session="false" %>< %@ page isThreadSafe="true" %>< %@ page isThreadSafe="false" %> < %@ page buffer="none" %>< %@ page buffer="sizekb" %>< %@ page autoFlush="true" %>< %@ page autoFlush="false" %>< %@ page contentType="MIME-Type " %>< %@ page contentType="MIME-Type ; charset=Character-Set " %>< %@ page contentType="video/mpeg" %>< %@ page pageEncoding="GB_2312-80" %>< %@ page errorPage="Relative URL " %>< %@ page info="Some Message " %>
  • XML Syntax
  • Other directives:
  • < %@ include file="relevantURLspec " %> : output of another file
  • JSP Custom Tag:
     < %@ taglib uri="TagLibraryURI " prefix="someprefix " %>
  • JSP Pages and Java Beans: JSP page can include logics in Java Code - not recommended - rather embed code into beans or custom tags
  • JavaBean: basically a class, visible, also invisible: JSP supports both types:
  • JavaBeans are accessed through Introspections :
  • Introspection: a class that extends BeanInfo Interface
  • JSP action tags for Java Beans: jsp:useBean, jsp:getProperty, jsp:setProperty
  • jsp:useBean: attributes: id, class, scope=(page,request,session,application), beanName, type,
  • jsp:getProperty: name = name of the bean = id of jsp:useBean, property = property to access
  • jsp:setProperty: attributes: name = name of the bean = id of jsp:useBean, property = property to access, value = value to set, use param attribute to extract from request object for setting values
  • To use a bean from JSP page, place the bean class file in one of the accessible servlet directories
  • Custom Tags = alternatives to java beans for JSP = reduces some limitations of JavaBeans (in JSP) like to few methods to access the bean, you may still require to write much java code in JSP [that we want to avoid]

From: http://sitestree.com/?p=4963
Categories:37
Tags:
Post Data:2007-04-22 17:46:00

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

JSP Tags #37

JSP Tag Library (JSTL)

JSP Disadvantage
1. Java code embedded in scriptlets make the
                                
                                         code difficult to understand
2. Reduced code reusability
3. Difficult to modify [Java Code]
4. Java code needs to use Class Casting

JSTL Advantages

1. Better code
2. Enhanced Code reusability
3. No type casting from the request and session objects
4. Expression Language in JSP makes it easier to call getter and setter methods.

Drawback

1. Adds overhead as JSTL adds more into the resultant Servlet
2. Can not do all that Java code can do


Four Libraries:

Core: Basic tags like loops, conditions, and input/output
fmt: Format like date format
xml: XML processing
sql: Database access


Core Tag Library

<%@ taglib prefix="core" uri="http://java.sun.com/jsp/jstl/core" %> 
<core:set var="var" scope="session" value="..."/> 

Conditional
<core:if test="${condition}"> </core:if> 
<core:choose>
     <core:when test="condition1" >
     ...
     </core:when>
    <core:when test="condition2" >
    ...
    </core:when>
    <core:otherwise>
    </core:otherwise>
</core:choose>

<core:otherwise> will be executed only and if only all other conditions fail.


Iterator

Iterator tages are used to traverse an array of objects and process each object (when required)
<c:forEach var="item" items="collection">
</c:forEach>

or

<c:forEach begin="0" end="10" varStatus="status" step="1" >
</c:forEach>


Function Tag Library

Basic String Functions
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> 

Example
<%@ taglib uri="/WEB-INF/fn.tld" prefix="fn" %>
<%@ taglib prefix="core" uri="http://java.sun.com/jsp/jstl/core" %> 

<core:set var="test" value="Hello World"/>
Index of l is :- ${fn:indexOf(test, "l")}<br>

From: http://sitestree.com/?p=4792
Categories:37
Tags:
Post Data:2007-12-05 06:15:58

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Creating Custom Tags in JSP #37

How to create custom tags in JSP?You can create custom tags in JSP. Steps:-----1. You have to create a Java file that will define the operation of the custom tag2. For the Java file, you have to extend javax.servlet.jsp.tagext.BodyTagSupport class3. in your implementation, you have to override (re-write) doStartTag(), doEndTag(), and doAfterBody() methods4. Create tag library description file(XML file with .tld extension).Example-------Implement a tag that reverses a stringimport java.io.IOException;import javax.servlet.jsp.JspTagException;import javax.servlet.jsp.JspWriter;import javax.servlet.jsp.tagext.BodyContent;import javax.servlet.jsp.tagext.BodyTagSupport;public class ReverseTag extends BodyTagSupport {    private static final long serialVersionUID = 1L;            //override doStartTag    public int doStartTag() throws JspTagException{        return EVAL_BODY_TAG;    }            //override doEndTag    public int doEndTag() throws JspTagException     {      try {           JspWriter out = pageContext.getOut();      } catch (Exception ex) {           throw new JspTagException("Exception" + ex);      }    return SKIP_BODY; }//reverse the text    public int doAfterBody() throws JspTagException {    BodyContent body = getBodyContent();    try {            JspWriter out = body.getEnclosingWriter();            //get text inside the tag            String bodyContent = body.getString();            //reverse the text            if (bodyContent != null) {                for (int i = bodyContent.length() - 1; i >= 0; i--) {                    out.print(bodyContent.charAt(i));                }            }            out.println();            body.clearBody(); // Clear for next evaluation          } catch (IOException ioe) {               throw new JspTagException("Exception at doAfterBody " + ioe);     }        return (SKIP_BODY);    }}5. Create the taglib descriptor    1.0    1.1                    stringreverse        net.justetc.taglibrary.ReverseTag                    Reverse the text            6. Example use of the custom tag    Custom Tag library
justetc

From: http://sitestree.com/?p=4791
Categories:37
Tags:
Post Data:2010-05-23 22:42:48

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

SQL Server Short-notes at JustETC #38

How to optimize query response time?

How to optimize SQL Server Cursors

What are cursors?

SQL Server Hints

Scalability: SQL Server 2005

Scaling Out

Dynamic Management Views

SQL Server Database System Tuning

SQL Server: Index

SQL Server : Backups

SQL Server Short-notes at JustEtc

SQL Server Short-notes at JustEtc

From: http://sitestree.com/?p=5257
Categories:38
Tags:
Post Data:2009-08-28 05:17:15

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

SQL Server : Backups #38

Why are backups needed?

To protect accidental data loss. Still, if you use highly available and fault-tolerant systems like SAN, and RAID, you may need to backup your database regularly. These fault tolerant systems can not provide accidental data delete by users, accidental data corruption from software and hardware failure. If you have a disaster recovery site or a secondary datacenter to where all data are replicated and data changes are stored, then you may not need backup but otherwise regular backups are always useful.

Data backup can restore data until the last backup. . Transaction Logs may help to restore data up to the point of failure. Restore data from the data backup, then if you have the transaction log up to the failure apply it to the data.

SQL Server Recovery Models:

  • Simple Recovery Model. Transaction logs are not used
  • Full Recovery Model: Use both data and transaction log backups
  • Bulk-logged recovery model: Like full recovery model. But here bulk operations are minimally logged to the transaction log. So full recovery becomes faster.

Types of Backups

  • Full database backup: Full database, all files and file groups are backed up
  • Partial Back up: It's not the differential backup. Here, all primary file groups and any other file groups that are read-write are backed up. But read-only file groups are not backed up by default.
  • File or file group backup: Usefull when full back ups take too long. Backup in parts.
  • Differential back up: Backup only the changes. Should be applied to a full backup.
  • Log backup: In log back ups, transaction logs are backed up regularly. It helps in bulk logged recovery model and full recovery model.
  • Copy only backups:
  • Full text catalog backups

Knowing about backup devices, media sets, and backup history tables is also important.

Mirrored Media Sets: Backup data to more than one media at the same time.

Backup Strategy:

Based on your company need and type of data, you should come up with a backup strategy.

Some backup strategies

Strategy - 1

  1. Take full database backup every saturday night
  2. Take a differential backup every wednesday night
  3. Perform, continual transaction log backups every 30 minutes

Strategy - 2: If the database is too big, and user activities need continuous uptime and optimal performance

  1. Filegroup 1 backup every saturday night
  2. Filegroup 2 backup every sunday night
  3. File group 1 differential backup every Tuesday night
  4. File group 2 differential backup every wednesday night
  5. File group 1 differential backup every Thursday night
  6. File group 2 differential backup every Friday night
  7. Perform, continual transaction log backups every 30 minutes

Backup System Databases

It is also important to back up system databases like master, model, msdb, tempdb, distribution, resource.

From: http://sitestree.com/?p=4837
Categories:38
Tags:
Post Data:2011-02-01 01:27:56

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

How to optimize query response time? #38

  • Check that only the required columns are selected [in select statements]
  • Check that the right types of joins are used
  • Check that if re-ordering the joins will help or not
  • Check the indexes of the tables [is indexing done on the right columns]
  • Check that in joins you used the indexed columns in the join condition
  • Check that the operating system is configured for optimum performance [for SQL Server]
  • Use concepts like Scaling Up and Scaling Out to increase the overall performance of queries/SQL Server
  • Use Dynamic Management Views to analyze the query performance/(query execution plans)
  • Use hints to skip default query execution plan to introduce your plan for quick response. Use hints on join types or also for table index selection
  • Check that the system and the network are appropriately configured and there are no issues that can cause the performance penalty
  • Tools that may help in the analysis and improvement: DBCC Commands, Dynamic Management Views, SQL Server Profiler, SQL Server Management Studio, System Stored Procedures, and SQL Trace
  • Check these articles for more information

From: http://sitestree.com/?p=5087
Categories:38
Tags:
Post Data:2013-01-20 11:22:32

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

SQL Server Short-notes at JustEtc #38

Query Optimization

How to optimize query response time?

SQL Server

How to optimize SQL Server Cursors

What are cursors?

SQL Server Hints

Scalability: SQL Server 2005

Scaling Out

Dynamic Management Views

SQL Server Database System Tuning

SQL Server: Index

SQL Server : Backups

From: http://sitestree.com/?p=5221
Categories:38
Tags:
Post Data:2012-10-04 19:57:27

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Dynamic Management Views #38

Dynamic Management Views provide ways to analyze database performance and to find the cause behind bad-performing SQL server databases/instances. Bad performance can be due to: poor design, insufficient memory, poorly configured system, disk bottlenecks, poorly written queries and many others

Previously Windows System Monitor(perfmon.exe) and SQL server profiler were used to find the cause of bad-performance. Now, Dynamic Management Views can help a lot better.

Dynamic Management Views are categorized into 12 categories

  • Common language runtime:
  • Database: Provides details about database sizes, files used, and partition information.
  • Database mirroring related: About mirroring and mirroed databases
  • Execution related: Provides insight into query execution statistics.
  • Full text search: Provides information on full-text catalogs, indexes, full-text crawl memory buffer
  • Input/Output Related: Provides insights into I/O operations, I/O devices, and database file statistics.
  • Index related: Database file statistics
  • Query notification related: Insights into active query notifications subscriptions in the server
  • Replication related: Insights into the workings of replication in the database
  • Service Broker Related: Insights into the workings of Service Broker
  • Sql server operating system related: Insights into the internal operations of the SQL Server OS.
  • Transaction Related: Insights into the operations of active transactions

Performance Data Warehouse: A historical archive of periodic snapshots of the DMV data of interest. How can it help? the problem may occur only at night 3:00 a.m. and when there are not many users. If you want to fix the issue in the morning Performance Data Warehouse will be of great help.

From: http://sitestree.com/?p=4809
Categories:38
Tags:
Post Data:2008-12-05 20:21:03

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

SQL Server Database System Tuning #38

Database tuning approach

  • Proactive approach
  • Reactive approach

Best Approach: Use a mix of both.

Be aware (collect information) of the followings that may have significant impact on the performance.
Hardware: Server, Available memory, number of processors, disk subsystems.

Network Infrastructure: Network Cards, Switches, and the rest of your LAN and WAN.

Operating System: Make sure the OpSys is optimally configured for SQL Server.

Database Engine: Know about the SQL Server Architecture and about your operational environments.

Database: Tune database properly

Client Connection: How clients connect to the server

Monitoring and Tuning Hardware: Use Network Monitor Agent, Performance Logs and Alerts, System Monitor, and Task Manager.

System monitor (perfmon.exe) is a great tool for the purpose Using perfmon.exe you can also find where the bottleneck is Processor Subsystem, Memory Subsystem, I/O Subsystem

Monitoring and Tuning SQL Server:Tools:

  • DBCC Commands
  • Dynamic Management Views
  • SQL Server Profiler
  • SQL Server Management Studio
  • System Stored Procedures
  • SQL Trace

System Monitor: when SQL server is installed many new parameters (performance objects and their counters) are added to System Monitor (perfmon.exe) that help to monitor SQL Server performance.

SQL Server Profiler: This tool is used to capture traces like client activities, stored procedure calls, lock activities. SQL server profiler can help to determine if the client application is at fault.

SQL Trace: create traces using using stored procedures.

Tuning the tempdb system database

  • Capacity plan and pre-allocate adequate space
  • Separate the log file from the database file
  • Use multiple secondary files for the tempDB system database
  • Use a faster disk
  • Use an appropriate RAID solution.
  • Use local disk sybsystem for tempdb.

Tuning Database Layout

Use file and filegroup architecture properly.
File: Use multiple data files for your databases.

Filegroups:example: create two file groups and place them in different drives. Create tables in one file group and create non-clustered indexes in the other. table I/O and Index I/O are now divided.

From: http://sitestree.com/?p=4810
Categories:38
Tags:
Post Data:2012-08-07 00:06:40

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

SQL Server: Index #38

SQL Server: Index

  • Indexes make database access faster. Without index your queries will run but indexes can increase the performance dramatically.
  • You can define multiple indexes for a table and select the index that is required for current operations.
  • Only one clustered index is supported for a table
  • To get advantage of indexes you have to mention the index related constraints in your where clause like where last_name ='xyz'
  • If you have indexes on two or more columns, in where clause mention the first column name/constraint first [that was first in the index creation].
  • A clustered index contains table data sorted in the index where a non-clustered index contains reference to the table data or clustered index. Non-clustered indexes are both physically and logically independent of table data.

Index Best Practices

  1. Select a column/(columns) for indexes that will provide good uniqueness and selectivity otherwise indexing may degrade the performance
  2. Create indexes that result in lower number of rows to be searched
  3. Create indexes that select a range of rows
  4. Try to create clustered index with as uniqueness as possible
  5. Keep indexes as narrow as possible (not many/unnecessary columns)
  6. Don't index very small table

In SQL server, you can create indexes through your sql statements or using the development studio interface.

From: http://sitestree.com/?p=4836
Categories:38
Tags:
Post Data:2011-01-21 05:26:33

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Scalability: SQL Server 2005 #38

Scalability: SQL Server 2005

After you have optimized your database design and the application design, you can improve the scalability of SQL Server in two ways
1.Scaling Up
2.Scaling Out

Scaling Up: Improve performance by
1. Adding more processors, memory, and storage capacity

2. Replacing existing hardware with faster hardware

Note: You also need the right version of SQL Server so that scaling up is supported.

How to scale up Processors:
SQL Server is mostly I/O bound not CPU bound, still better/faster CPU usually provides better performance [depends on the application need though].

Processor choices:32 bit
64 bit x64
64 bit IA64
Hyperthread technology
Multiprocessor based server
Multicore based servers

It is always better to go for 64 bit than 32 bit as it will also support more memory. 64 bit x64 processors provide better performance than ia64 however if your work requires lots of floating point operations and the workload needs > 8 processors you can think about IA64 processors

Multiple processor systems provide better performance than the single processor systems. Windows implements SMP architecture of parallel computing and SQL Server 2005 also takes advantage of it.

Multiple processor systems usually performs better than the equivalent multicore uniprocessor systems.

Intel's hyperthreading technology may increase performance (10-20%) based on the applications (but not always)

Memory Subsystem:
As SQL server is I/O bound using more memory almost always increases performance. Though the amount of memory that we can add depends on the operating systems. 32 bit operating systems supports 4GB RAM max. For 32 bit windows 2 GB is reserved for operating system, in Windows Server 2003 we can specify 1 gb for operating system so getting 3gb for SQL Server.

32 bit SQL Servers can address 4 gb ram, the actual ram amount depends on the operating system used. if 32 bit windows then 2 to 3 gb max as mentioned before

When 64 bit windows and 64 bit sql server then physical memory limits 32TB.

I/O SubSystems:
You can improve disk I/O subsystem by using an appropriate RAID array or SAN (Storage Area Network) solution

Using Network Interface Card (NIC) teaming, you can also improve performance. NIC teaming allows to bond multiple physical NICs into one logical network device. Teaming provides load balance, fault tolerance, and high bandwidth.

Scaling Out will be discussed later.

Scaling Out involves using multiple SQL servers to provide increased scalability.

From: http://sitestree.com/?p=4804
Categories:38
Tags:
Post Data:2008-04-28 01:08:59

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Scaling Out #38

Methods

  • SQL Server instances
  • Clustering
  • Database mirroring
  • Log shipping
  • Replication
  • Shared scalable databases
  • SQL Server instancesIn the same computer install multiple instance of SQL Server to take advantage of multiple processors. Each instance may use separate processor with separate lock manager, worker threads, tempdb system database.
  • ClusteringFailover Clustering can provide robustness and protection against failure. Clustering can provide scaling using spare hardware through passive nodes
  • Database mirroringWith database mirroring transaction logs are directly sent to the mirror. The mirror is up to date and can be used in case of failure of the principle server.
  • Log shippingIt depends on the transaction log backups, file copying. The secondary database need not to be updated in real time. The secondary database is read only and hence, be in great use for reporting purposes.
  • ReplicationMerge Replication: Both way, both from and to publishers and subscribers
    Transactional Replication: Publisher to the subscriber
  • Shared scalable databasesScale out a read-only database only for reporting purposes.
  • From: http://sitestree.com/?p=4806
    Categories:38
    Tags:
    Post Data:2007-05-23 02:02:25

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    SQL Server Hints #38

    SQL Server Hints
    ----------------
    What are hints?
    
    Simply to influence query execution plans to retrieve data 
    faster.
    
    syscacheobjects
    ----------------
    SQL server after compiling a query creates the execution 
    plan and keeps it on syscacheobjects object.
    You can query the object to see the existing query plans as 
    follows:
    
    select * from sys.syscacheobjects
    where cacheobjtype='compiled plan'
    
    
    Hints
    -----
    
    When you specify hints in your queries the query execution 
    plans are biased toward your hints rather than using default
     strategies.
    
    Types of Hints
    --------------
    Join Hints: Affects the joins [join types]
    Query Hints: Affects overall execution plan
    Table: Affects to table access 
    
    
    Join Hints
    ----------
    Loops: Uses nesting for join. Each row of the inner table is
     checked for condition satisfaction with the corresponding 
    outer row.
    Hash: One table is treated as a hash table and the other is 
    scanned one row at a time and the hash function is used to 
    find equalities
    
    Merge: Each table is sorted first. Then they are compared 
    row by row [corresponding]
    
    Remote: In this case, at least one table is remote. The join
     is done at the right table side.
    
    
    Example:
    
    select *
    -----
    ----
    ---
    option (merge join)
    
    
    or
    
    select * 
    from x
    inner merge join y on...
    
    
    Query Hints:
    ------------
    Specified at the end of the query with keyword 'Option'
    
    
    select * from x
    ------------
    ------------
    option (recompile, fast 80)
    Hash Group or Order groups:  Aggregations (group by, compute, distinct) are done by hashing or ordering
    Concat Union, Hash Union, Merge Union: All unions will be done with the specified union type
    Loop Join, Hash Join, Merge Join: Joins will be done with the specified join types
    FAST number_rows:
    Force Order:
    MaxDop:
    Optimize For:
    Recompile:
    Keep Plan:
    Expand Views:
    
    
    
    Table Hints:
    ------------
    Affects how the table will be locked or which index will be 
    used for the query.
    NoEXPAND
    INDEX
    fastfirstrow
    nowait
    rowlockpaglock
    tablock
    nolock
    holdlock
    ignore_triggers
    
    
    Plan Guides
    -----------
    Sometimes queries are originated from a third part application and you have no control to change the query.
    You can use plan guides to influence such queries. For example: Using plan guides you can specify the nature of the
     select, update, insert queries.
    You can use built in stored procedures to create or drop 
    plan guides.
    
    sp_create_plan_guide
    sp_control_plan_guide
    

    From: http://sitestree.com/?p=4800
    Categories:38
    Tags:
    Post Data:2007-12-13 01:33:56

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    What are cursors? #38

    Cursors are server side database objects that are used by applications to apply operations on the database table data on a row-by-row basis. The operations may vary from one row to another row dynamically based on the requirements (business logic) and also multiple operations can be performed on the same row. Typical SQL commands apply the same updates/changes to all the selected rows at once where cursors apply updates/changes one by one row. Cursors must be declared in the database before they can be used/called from the applications [front end]. Afterwards, you can open cursors to fetch data using them, you can fetchrow by row and make multiple operations on the currently active row in the cursor. You should close the cursors and deallocate them after you are done with the cursors.This is the Transact-SQL Extended Syntax:DECLARE cursor_name CURSOR[LOCAL | GLOBAL][FORWARD_ONLY | SCROLL][STATIC | KEYSET | DYNAMIC | FAST_FORWARD][READ_ONLY | SCROLL_LOCKS | OPTIMISTIC][TYPE_WARNING]FOR select_statement[FOR UPDATE [OF column_name [,...n]]]An example cursor:DECLARE AuthorsCursor CURSOR FORSELECT authors.id, au_lname, au_fnameFROM authorsORDER BY authors.idAnother ExampleDECLARE @AuthorID char(11)  DECLARE Cursor1 CURSOR READ_ONLYFORSELECT au_idFROM authorsOPEN Cursor1FETCH NEXT FROM Cursor1INTO @AuthorIDWHILE @@FETCH_STATUS = 0BEGIN   PRINT @AuthorID FETCH NEXT FROM Cursor1 INTO @AuthorIDENDCLOSE Cursor1DEALLOCATE Cursor1wherecursor_name: The name of the server side cursorLOCAL: The cursor will be available only to the batch, stored procedure, or trigger in which the cursor was created GLOBAL: The cursor is global to the connection FORWARD_ONLY: The cursor can only fetch data sequentially STATIC: The cursor will use a temporary copy of the data instead of base tables KEYSET: Specifies keysets so that the membership and order of rows in the cursor are fixed when the cursor is opened DYNAMIC: The cursor reflects all data changes made to the base tables as you scroll around the cursor FAST_FORWARD: The cursor is FORWARD_ONLY and READ_ONLY  READ ONLY: The cursor [data] cannot be updatedSCROLL_LOCKS: The fetched data will be locked OPTIMISTIC: The cursor does not lock rows as they are read into the cursor select_statement: The standard select statement, cannot contain COMPUTE, COMPUTE BY, FOR BROWSE, and INTO keywordsUPDATE [OF column_name [,...n]]: Specifies which columns can be updated

    From: http://sitestree.com/?p=4795
    Categories:38
    Tags:
    Post Data:2011-07-27 22:47:54

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Introduction to Printer Programming With Examples: Must Read #4

    You can use the functions/procedures/classes that a programming language provide to program a printer. Another alternative is, sending raw printing command to the printer itself. Each printer has their own instruction sets. Usually what happens, when you use built in functions they convert your procedure/function call to printer language and send it to the printer. They do it, using the printer driver

    You can do that by yourself by sending raw printer commands to the printer itself. Windows has an API called 'Escape' that can send raw texts/printer commands to the printers without using the driver. Now you need to know the language that the printer uses and use 'Escape' function to send raw print commands to the printer.

    I personally have working experience with intermec label printers. Intermec label printers support two different kinds of printer languages. IPL (Intermec printer Language) and DP (Direct Protocol). You need to check what your printer uses. The printers that use DP come with a tool named fingerprint installed on the printer itself. This fingerprint tool understand DP language and executes the printer in that way. Good thing is, fingerprint supports dynamic printing language that means you can use if then else, for, while etc in your printing language.

    An example DP program can be as follows:

    INPUT ON
    PRPOS 10, 1000
    PRTXT "hELLO hOW aRE yOU"
    PF
    LAYOUT RUN
    INPUT OFF

    YOU HAVE TO SEND THESE RAW PRINT COMMANDS USING THE ESCAPE FUNCTION.

    From: http://sitestree.com/?p=4719
    Categories:4
    Tags:
    Post Data:2007-03-18 00:05:38

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Database Administration : Random #39

    Vacuum:vacuum is a useful command to maintain PostGreSql database integrity. Also, it permanently removes deleted database records (by default PostGreSql does not delete permanently). It also rearranges page tables, segments for better performance. vacuum should be run regularly for optimized performance. You can also automate the execution.

    Syntax: vacuum [FULL|Analyze|Verbose|table name]
    Example:
    vacuum member verbose
    vacuum full
    vacuum analyze full

    vacuum also has linux command line command like
    vacuumdb dbname
    vacuum -a -f -v -z

    --------

    PostGreSql maintains a list of databases in the pg_database system table. Sometimes when it/the table gets corrupted, a full vacuum on all databases may fix the issue. When the table gets corrupted many operations like pg_dump may not work and you may get error messages like missing entry in the pg_database table.

    ----------

    Backup command:
    pg_dump options dbname > destination txt/tar file

    Example: pg_dump -Ft -b mydb > db.tar

    Restore Command:
    Example: pg_restore -d newdb db.tar

    --------------

    Linux and PostGreSQL

    commands to access PostGreSql:
    su - postgres
    password:

    psql -l : list all databases

    --------

    From: http://sitestree.com/?p=4805
    Categories:39
    Tags:
    Post Data:2012-09-16 12:23:46

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    How to optimize SQL Server Cursors #38

    Optimize Cursors
    1. Avoid using SQL Server cursors whenever possible
    2. Always close SQL Server cursors when result sets are not needed
    3. Deallocate SQL Server cursors when the data structures comprising the cursors are not needed
    4. Reduce the number of records to process in the cursor
    5. Only use the required columns in the cursors
    6. Use READ ONLY cursors, whenever possible, instead of updatable cursors.
    7. Avoid using insensitive, static and keyset cursors, whenever possible.
    8. Use FAST_FORWARD cursors, whenever possible.
    9. Use FORWARD_ONLY cursors, if you need updatable cursors

    From: http://sitestree.com/?p=4794
    Categories:38
    Tags:
    Post Data:2010-03-10 01:20:46

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Oracle 11g: Basic PL/SQL #40

    • Database objects:
      • table
      • view
      • sequence
      • Index
      • synonym
      • stored procedure

    Will be continued

    From: http://sitestree.com/?p=4967
    Categories:40
    Tags:
    Post Data:2011-09-05 21:55:20

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Oracle: Application Developer : Certification : Topics #40

    From: http://sitestree.com/?p=4895
    Categories:40
    Tags:
    Post Data:2010-12-18 23:31:34

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Oracle Fundamental Concepts #40

    Terms
    Database: In oracle, the term database refers to the files required for the operation of Oracle. These files include:data files, temporary data files, redo log files, control files, and parameter files

    Instance: All the processes and memory structures required to operate the database

    Users: Users are accounts that can be used to log in to the database.

    Schema: A schema is the collection of all the objects owned by a user

    Security: Oracle provides privilege-based securities. Oracle uses two types of privileges. System privilege, and object privilege. To facilitate the easy operation of privilege-based securities oracle uses roles.

    SYS and SYSTEM Account: Administrative Accounts. Have unrestricted access. SYS account owns the data dictionary. SYSTEM account owns the tables used to store information for features and options of the database. SYSTEM is the default administrative account. It is recommended that you do not use SYSTEM account to administer the database; rather create your own DBA account to administer.

    SQL*PLUS: Is a client tool to interact with the Oracle database using SQL.

    Data Dictionary: A repository that keeps track of all the database objects

    SQL: A language to interact with the database such as insert data into the database, update data, retrieve data from the database, control transactions

    PL/SQL: A procedural language that can be used to write custom programs and procedural codes to run inside the database

    Oracle SQL Types

    • Data Manipulation Language (DML)
    • Data Definition Language (DDL)
    • Transaction control statements
    • Session control statements
    • System control statements

    Joins in Oracle

    NATURAL
    INNER
    OUTER - LEFT
    OUTER - RIGHT
    OUTER - FULL

    SET Operations Supported by Oracle:
    UNION, UNION ALL, INTERSECT, MINUS

    Select, Insert, Update, Delete operations are similar to the ANSI SQL

    Transaction Management DML SQLs: COMMIT, ROLL BACK, SAVEPOINT, ROLL BACK TO , SET TRANSACTION,SET CONSTRAINT(S)

    User Creation in Oracle:
    create user oracle_admin identified by password;
    grant create session, dba to oracle_admin;

    Oracle Architecture Areas

    • User Processes: Such as a client tool
    • The Oracle Listener: Runs in the oracle database server and listens to the clients
    • The Oracle Net Client: How to talk to the server processes
    • Parameter files
    • Control Files
    • Data Files
    • Tablespaces
    • Segments
    • Extents
    • Data Blocks
    • Pre-allocated Files
    • Redo Log Files
    • Temporary Files
    • Oracle Managed Files
    • Memory Areas
    • Background Processes

    From: http://sitestree.com/?p=5048
    Categories:40
    Tags:
    Post Data:2013-05-14 18:15:24

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Oracle Certifications Overview #40

    From: http://sitestree.com/?p=4894
    Categories:40
    Tags:
    Post Data:2013-02-05 17:50:27

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Oracle Database Objects #40

    Oracle Database ObjectsSchema Objects

    • Clusters
    • Constraints
    • Database links
    • Database triggers
    • Dimensions
    • External procedure libraries
    • Index-organized tables
    • Indexes
    • Indextypes
    • Java classes, Java resources, Java sources
    • Materialized views
    • Materialized view logs
    • Object tables
    • Object types
    • Object views
    • Operators
    • Packages
    • Sequences
    • Stored functions, stored procedures
    • Synonyms
    • Tables
    • Views

    Nonschema Objects

    • Contexts
    • Directories
    • Parameter files (PFILEs) and server parameter files (SPFILEs)
    • Profiles
    • Roles
    • Rollback segments
    • Tablespaces
    • Users

    What are schema objects?
    A collection of logical structures of data, or schema objects. In Oracle, each user owns a single schema and the schema is named after the user.

    Non-schema Objects:
    Other types of objects stored in the database but not part of any schema.

    Both can be manipulated using SQL

    From: http://sitestree.com/?p=4813
    Categories:40
    Tags:
    Post Data:2012-08-12 22:08:43

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Oracle background processes #40

    Oracle Process architecture
    Oracle processes running simultaneously in the background

    • archiver processes (ARCn)
    • checkpoint process (CKPT)
    • database writer processes (DBWn)
    • dispatcher processes (Dnnn): multiplex server-processes on behalf of users
    • memory-manager process (MMAN): used for internal database tasks such as Automatic Shared Memory Management
    • job-queue processes (CJQn)
    • log-writer process (LGWR)
    • logical standby coordinator process (LSP0): controls Data Guard log-application
    • media-recovery process (MRP): detached recovery-server process
    • memory-monitor process (MMON)
    • memory-monitor light process (MMNL): gathers and stores Automatic Workload Repository (AWR) data
    • process-monitor process (PMON)
    • process-spawner (PSP0): spawns Oracle processes
    • queue-monitor processes (QMNn)
    • recoverer process (RECO)
    • remote file-server process (RFS)
    • shared server processes (Snnn): serve client-requests
    • system monitor process (SMON)

    From: http://sitestree.com/?p=4812
    Categories:40
    Tags:
    Post Data:2010-06-23 15:17:48

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>
    

    Canada: Employment Laws #41

    Canada: Employment Laws: Check Here

    Another good source of information

    From: http://sitestree.com/?p=4811
    Categories:41
    Tags:
    Post Data:2011-08-19 00:41:29

        Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
        (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
        In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
        <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
        8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
        Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
        Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>