Do you truly feel valued by those with whom you work

Is appreciation communicated regularly at your workplace?
Do you truly feel valued by those with whom you work?

If you try to express appreciation in ways that aren’t meaningful to your co-workers, then they may not feel valued at all. The problem is that you’re speaking different languages.

Express genuine appreciation to co-workers and staff — even on a tight budget. Increase loyalty with the employees and volunteers in your organization. Reduce cynicism and create a more positive work environment. Improve your ability to show appreciation for difficult colleagues. Convey the language of physical touch in appropriate ways.

At work, people express and receive appreciation in different ways. Dr. Gary Chapman and Dr. Paul White identify these as the five languages of appreciation:
• Words of Affirmation
• Acts of Service
• Tangible Gifts
• Physical Touch
• Quality Time

 

Snippet of notes:

Words of Affirmation – confirming positive characteristics or achievements about a person. This is especially effective when done toward an accomplishment or efforts. It is even better in a public setting.

“Rob, your report was outstanding this morning. Your recommendations were extremely helpful. I appreciate your bringing it to our attention.”

It seems like common sense, but it can be easily overlooked in such a fast paced environment. Being more specific has a larger impact than global praise. “Good job Guys” is not as strong as “Good job on the report Rob.” It can even be degrading.

Character traits should be affirmed as well. They are more powerful than achievements.

Honesty, Integrity, Trust, Security, Compassion, Understanding, Genuine.

 

Based on the #1 New York Times bestseller, The 5 Love Languages, Dr. Chapman and Dr. White give you practical steps to make any workplace environment more encouraging and productive. Before you know it, you will learn to speak and understand the unique languages of appreciation and feel truly valued in return.

Most common yet tricky questions for an SQL Interview

I had an interview recently where I was asked a list of questions. It was directly pulled from this website where Auppal80 had posted them previously. I have not had a true SQL dba interview, but I have had a few mySQL dba interviews as well as most of the positions that I apply for require dba knowledge and understanding so they always cover certain aspects. These questions follow right along with that theory.

These are the most common yet tricky questions that you can expect in a .NET/SQL interview.

 

1)      What is the difference between truncate and Delete?

  1.  Delete will fire delete trigger, truncate will not.
  2. The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.Once you truncate you can’t rollback.
  3. If there is an identity column in the table truncate will reset identity to 1, delete will not.

2)      Name the different type of joins

  1. Inner Join
  2. Outer Join  (Left Outer Join and Right Outer Join)
  3. Cross join
  4. Self-Join

3)      What is an Index?

There are two types of indexes. Clustered index and Non Clustered Index. A table can have only 1 Clustered Index while it can have up to 249 & 999 nonclustered indexes on SQL Server 2005 & 2008 respectively. A clustered index stores the actual data rows at the leaf level of the index. Indexes can make Select statement fast but delete, update and insert statements will get slow.

 

4)      What are different types of Isolation levels in SQL Server

a)     READ UNCOMMITTED

b)      READ COMMITTED

c)       REPEATABLE READ

d)      SERIALIZABLE

e)       SNAPSHOT

 

 5)      What are different types of constraints in SQL Server?

  1.  Primary key Constraint
  2. Foreign key Constraint
  3. Check Constraint
  4. Unique Key Constraint

6)      What is the difference between where and having clause?

A having clause is typically used when you use group by clause.

Example:

SELECT titles.pub_id, AVG(titles.price)
FROM titles INNER JOIN publishers
ON titles.pub_id = publishers.pub_id
WHERE publishers.state = ’CA’
GROUP BY titles.pub_id
HAVING AVG(titles.price) > 10

WHERE clause is applied first to the individual rows in the tables . Only the rows that meet the conditions in the WHERE clause are grouped. The HAVING clause is then applied to the rows in the result set.

 

7)      How would you do “Error Handling” in SSIS?

SSIS package could mainly have two types of errors

a) Procedure Error: Can be handled in Control flow through the precedence control and redirecting the execution flow.

b) Data Error: is handled in DATA FLOW TASK buy redirecting the data flow using Error Output of a component.

 

8)      What is the difference between a primary key and a unique key?

Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column. Major difference is that, primary key does not allow NULLs, but unique key allows NULL.

 

9)      What are defaults? Is there a column to which a default cannot be bound?

A default is a value that will be used by a column, if no value is supplied to that column while inserting data. IDENTITY columns and timestamp columns can’t have defaults bound to them.

You can create default and then bind a column to them.

Example:

//This will create default “ ZipCode ” in database

Create default ZipCode as “78746″

//This will bind the default we created to a column “PostalCode” in table “EmployeeData”
sp_bindefault ZipCode, “EmployeeData.PostalCode”
10)  What is SQL Blocking?
Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock type. This forces the second connection to wait, blocked on the first.

IDN (Internationalized Domain Name)

IDNs are domain names that include characters used in the local representation of languages that are not written with the twenty-six letters of the basic Latin alphabet “a-z”. An IDN can contain Latin letters with diacritical marks, as required by many European languages, or may consist of characters from non-Latin scripts such as Arabic or Chinese. Many languages also use other types of digits than the European “0-9″. The basic Latin alphabet together with the European-Arabic digits are, for the purpose of domain names, termed “ASCII characters” (ASCII = American Standard Code for Information Interchange). These are also included in the broader range of “Unicode characters” that provides the basis for IDNs.

The “hostname rule” requires that all domain names of the type under consideration here are stored in the DNS using only the ASCII characters listed above, with the one further addition of the hyphen “-”. The Unicode form of an IDN therefore requires special encoding before it is entered into the DNS.

The following terminology is used when distinguishing between these forms:

A domain name consists of a series of “labels” (separated by “dots”). The ASCII form of an IDN label is termed an “A-label”. All operations defined in the DNS protocol use A-labels exclusively. The Unicode form, which a user expects to be displayed, is termed a “U-label”. The difference may be illustrated with the Hindi word for “test” — परीका — appearing here as a U-label would (in the Devanagari script). A special form of “ASCII compatible encoding” (abbreviated ACE) is applied to this to produce the corresponding A-label: xn--11b5bs1di.

A domain name that only includes ASCII letters, digits, and hyphens is termed an “LDH label”. Although the definitions of A-labels and LDH-labels overlap, a name consisting exclusively of LDH labels, such as”icann.org” is not an IDN.

What are Heading Tags? Commonly Asked Search Marketing Questions

What are Heading Tags?

The <h1> to <h6> tags are used to define HTML headings. <h1> defines the most important heading. <h6> defines the least important heading.

 

<h1>This is heading 1</h1>
<h2>This is heading 2</h2>
<h3>This is heading 3</h3>
<h4>This is heading 4</h4>
<h5>This is heading 5</h5>
<h6>This is heading 6</h6>

H1 Tags Improve Search Engine Placement

Effective search engine optimization involves many factors. Ranking highest in importance is providing informative content with proper page layout and programming. Much consideration should be made to your proper use of heading tags. H1 is given the most ranking value and is used as the title of content. Your article heading should be an h1 tag. Including a single H1 tag on a page is recommended as to not confuse search engines.

 

    • Heading tags will be recognised by browsers which don’t recognise style sheets (or use a user-defined style sheet).
    • Heading tags are used by search engines to identify words which are more important than the rest of the page text. The theory is that headings will sum up the topic of the page, so they are counted as important keywords.
    • Screen readers and magnifiers (for the visually impaired) rely on headings to navigate the page.
    • Heading tags make it easy to make global changes to headings. Although you could theoretically achieve this by defining a new css class, it makes more sense and tends to be easier to define a style for heading tags.

Software as a Service Platform – SaaS

A lot of the jobs that I have been applying for want SaaS experience. It is a methodology that replaces the current install a program on your dekstop and only that computer can access your files and program. Utilizing the SaaS methodology you gain a lot of advantages especially from a convenience standpoint.

 

What is SaaS?

Software as a service or on-demand software is software hosted in the cloud and accessed through a web browser. This means no installing on a local computer and it can be accessed from any PC, Mac, or depending on the product mobile device.

Software as a service (SaaS, typically pronounced [sæs]), sometimes referred to as “on-demand software,” is a software delivery model in which software and its associated data are hosted centrally (typically in the (Internet) cloud) and are typically accessed by users using a thin client, normally using a web browser over the Internet.

—————————————————–

Software as a service Platform also known as SaaS Platform is a web model of software consumption.

With On Demand SaaS Platform, or Software as a service Platform, a provider licenses an app to customers for use as a service on demand, either through a time subscription or pay by usage.

The software as a service Platform model allows vendors to develop, host and operate software for customer use. Software as a service Platform means that alternative too having to purchase the hardware / software to run an application, clientele only require a computer or a server to download the app and internet access and utilise the software. SaaS Platform (Software as a service Platform) allows the software to be licensed for either a single user or for a whole group of users.

5 P’s of SaaS

Primacy, Proprietary,Portability, Positioning, Profitability.

• Primacy – Is the PaaS vendor’s offering pivotal to their overall success?

• Proprietary – Is the PaaS vendor’s development environment open or proprietary?

• Portability – Can you migrate your solution from one PaaS environment to another?

• Positioning – Does the PaaS vendor’s sales and marketing efforts enhance your position in the market?

• Profitability – Does the PaaS vendor have a sustainable business model to ensure their long-term success?

Extract-Transform-Load (ETL)

Extract Transform Load

ETL is a process that is used to take information from one or more sources, normalize it in some way to some convenient schema, and then insert it into some other repository.

I have used this process on a number of occasions both manually and through the use of scripting. This process is taking information from one source or application and converting it into another form where you can use that data to whatever you need. I rarely used one of the examples of GUI software below which apparently would make my life so much easier.

The 3 major steps are:

  1. Extract the data
  2. Transform the data to your needs
  3. Load the data into your application / database
The steps broken down are:

The typical real-life ETL cycle consists of the following execution steps:

  1. Cycle initiation
  2. Build reference data
  3. Extract (from sources)
  4. Validate
  5. Transform (clean, apply business rules, check for data integrity, create aggregates or disaggregates)
  6. Stage (load into staging tables, if used)
  7. Audit reports (for example, on compliance with business rules. Also, in case of failure, helps to diagnose/repair)
  8. Load (to target tables)
  9. Archive
  10. Clean up

Extract-Transform-Load (ETL)

Examples of data migration software

Expressor Studio

Designed to provide immediate business value to analysts and ETL experts alike, Expressor Studio is an easy-to-use, modern, metadata-driven ETL tool that offers a simplified approach to data integration—ranging from small ad-hoc ETL tasks to complex data integration projects.

You can download, install, build, and run your first Expressor Studio application in minutes. Studio provides excellent out-of-the-box connectivity to flat files and all major database systems—and offers built-in data cleansing and validation support. You can configure common ETL operations using Studio’s drag and drop interface, and you can extend applications with expressor DatascriptTM—a powerful and flexible scripting language. Moreover, expressor Studio enables reuse of data objects, design artifacts, and business rules—and seamlessly integrates with the server components of the expressor platform.

 

Talend

Talend, the Open Source Integration Software Company, provides open source middleware solutions that enable organizations to gain more value from their applications, systems and databases. Shattering the traditional proprietary model, Talend democratizes the integration market by providing enterprise-grade open source technologies that cover both the data integration and application integration needs of organizations of all sizes.

Talend’s unified integration platform addresses projects such as data integration, ETL, data quality, master data management and application integration. With their proven performance, ease of use, extensibility and robustness, Talend’s solutions are the most widely used and deployed integration solutions in the world.

 

These programs make your life easier. A senor engineer wrote to me after I inquired about Talend:

This is the tool we use to move data from feed format in to our central database.  It’s basically a “game engine” for data, meaning it has lots of components in a GUI format that represent hundreds or thousands of lines of code.

What is a customer journey map?

Engage, Buy, Use, Share, Complete.

A customer journey map is a very simple idea: a diagram that illustrates the steps your customer(s) go through in engaging with your company, whether it be a product, an online experience, retail experience, or a service, or any combination. The more touchpoints you have, the more complicated — but necessary — such a map becomes. Sometimes customer journey maps are “cradle to grave,” looking at the entire arc of engagement.

Visually illustrate an individual customer’s needs by a series of interactions to fulfill those needs along with resulting emotional states a customer experiences throughout the process.

What you illustrate is the process for customers to have a great experience from the alpha to the omega. It is a simple process whether eCommerce or retail.

UX – User Experience

UX encompasses everything to do with the system: the interface, graphics, physical interaction, what you see on the screen, as well as how that is presented, and its functionality. You have to understand the limitations of the web and be able to come up with creative solutions that really enhance the users experience with your application. It should be simple for the entire audience to understand. You have to feel out their experience from a user’s perspective. My experience wearing many hats has helped me with this tremendously.———————————————————————————————————

The Image Group – we were working on a new design for their website. We started out with wire framing the layout. It was very clean and minimal – white background with clean green lines. To really bring the site to life we took advantage of the white background and incorporated a lot of the text white. Once the site had loaded a very thin green jQuery powered bar came across the screen from right to left, it then expanded and snapped into place revealing the white heading text. The entire site was a horizontal scrolling site that certain elements expanded with browser window size. There was no page reloading. The way it worked was the JavaScript would load the next set of elements once a menu item was clicked. This way images and videos weren’t all rendered from the start because that would make the load time excessively long.

Inigral – on their data pages they had a poor user experience and extremely high bounce rate. We redesigned these pages and implemented new features one of the new features was a CSS3 graph with jQuery powered animation. This was a great alternative to the static image they had used before. What the graph did was upon loading the bars would appear at the bottom and grow to their defined height. We also redid the landing pages. This really drew the user’s attention to them. It also decreased the load time by .2 seconds. We also redid the landing pages to really drive traffic and provide additional calls to action directing them where to go and what to do next. This not only increased the page views by 300% it also reduced the bounce rate by 64% and most importantly increased leads by 10%.

Xunlight Corporation – the slideshow on the homepage was a boring Mootools slide show that simply faded on transitions. To liven it up we came up with the idea of utilizing Flash. What this did back in 2007 was enabled further user interaction. The slideshow now became a focal point. When your cursor hovered over the corners it bent up the image and revealed the image underneath as well as the inverse of the image just pealed and on transition it whipped across your screen like removing tape or a band aid. Now I can’t take credit for this UX decision. It was done by a group from Columbus. If only I could remember their name or email…