Learn by doing, ServiceNow

Getting Started with ServiceNow: Server-side Glide, Performance common issues, Business Rules and Client Scripts

| Rafael Martins Cardoso

Hi guys,

It’s time for ServiceNow go on air, all lights pointed at him now please.

The topics for today’s post are scripting (Server-side Glide, Business Rules, Client Scripting) and how to troubleshoot some performance issues. This are basic key points for any SN admin.

If you know how to answer the questions below, probably you should jump straight away to my next post I am going to post regarding this category.

Review questions:

  • How can I obtain a list of distinct incidents?
  • How can I measure performance of a request?
  • What’s the difference between client script and server-side script?
  • What is a business rule?
  • What is a client script?

Continue reading “Getting Started with ServiceNow: Server-side Glide, Performance common issues, Business Rules and Client Scripts” →

5/5 - (1 vote)
Business Intelligence, Learn by doing, Microsoft SQL

Getting Started with Business Intelligence: Data Warehouse (T-SQL, Indexes, Isolation Levels and Performance)

| Rafael Martins Cardoso

Hello.

When we’re talking about Business Intelligence (BI), we straightly imagine all Kimball concepts, star-schema, the famous slow changing dimensions among others, but we forget where it all begins. Today I will talk about some basic concepts (but quite important) in database concepts before things can start serious. The key points for this post are T-SQL, Indexes, Isolations Levels and Performance.

If you know how to answer the questions below, probably you should jump straight away to my next post I am going to post regarding this category.

Review questions:

5/5 - (1 vote)
Reviews

Putting HawkHost’s hosting provider to the test – PASSED!

| Rafael Martins Cardoso

Hello,

A Website is only as good as its Hosting Provider. If this scenario seems eerily familiar, it’s probably because you’ve lost sleep dreading the possibility. Or perhaps it’s already happened to you. Sadly, while the story above is purely fictitious, it has a very somber basis in reality. Such scenarios keep network administrators and senior management up at night (literally and figuratively). Poor website performance directly affects revenues, reputation, and brand, and the type of hosting provider your company uses can dramatically impact your bottom line. So if you’re experiencing warning signs, it’s probably time to find a new web hosting provider.

Typically, there are four basic types of hosted solutions:

– Dedicated Hosting is a fully autonomous solution, using dedicated servers (with full performance control, a built in layer of separation and security, and exclusive access). It is best for organizations that want to reduce the costs associated with site management, need superior performance, and require the ability to handle large volumes of traffic.
– Shared Hosting is essentially a dedicated server split up into many smaller accounts. It offers a low-cost solution for smaller organizations that experience a limited amount of web traffic. It is literally a server shared with other customers.
– Cloud Dedicated Hosting is dedicated hardware with the benefit of the instant provisioning and scalability that comes with cloud. With Cloud Hosting you can add more resources to your server, such as RAM or extra back-up.
– Virtual Private Hosting (VPS) is a smaller virtual server on a single, larger Cloud Dedicated server. It is a good option for small- to medium-sized organizations because it provides a virtual server dedicated to a single client website. One physical server will run multiple virtual servers, however those virtual servers are limited in their resources.

Which option your organization needs is usually dependent on the immediate and near-term goals of your business and its clients, while keeping one eye on the future. But there may come a time when you realize that your needs three years ago don’t mesh with your needs today.

So the question is, when will you know that you’ve outgrown your current web hosting?

Continue reading “Putting HawkHost’s hosting provider to the test – PASSED!” →

Rate this post
Status update:

Hi guys,

Lets just say that Christmas is arriving.

Christmas it’s not only a season of rejoycing but also reflection. It is important be self-aware to know why you do the things that you do. Self awareness is the process of having a clear perception of your personality, including strenghs and weaknesses, thoughts, beliefs, motivation and emotions.

Like it or not, now that we’ve hit December, it’s officially time to start thinking about 2018 as well. The earlier you start to prepare for the New Year, the better off—and more prepared—you’ll be.

So let’s start getting our New Year’s mindset together today so we can kill it next year!

Be so good at what you do we can’t take our eyes off of you. (Robin Sharma)

 

And probably this is my last post of 2017.
Keep tuned and see you soon,
Rafael
5/5 - (1 vote)
Learn by doing

How to add a configuration file (app.config) to your #C application?

| Rafael Martins Cardoso

Hi,

This article shows how to add a simple configuration file (app.config) to your #C project. Sooner or later, you need to change a value such database connection string or username. By adding an application configuration file (app.config file) to a C# project, you can customize how the common language runtime locates and loads assembly files which means you can create keys to be used on your project without need to recompile it everytime you need to update some value.

 

What is App.config?

At its simplest, the app.config is an XML file with many predefined configuration sections available and support for custom configuration sections. A “configuration section” is a snippet of XML with a schema meant to store some type of information.

Settings can be configured using built-in configuration sections such as connectionStrings or appSettings. You can add your own custom configuration sections; this is an advanced topic, but very powerful for building strongly-typed configuration files.

Web applications typically have a web.config, while Windows GUI/service applications have an app.config file.

Application-level config files inherit settings from global configuration files, e.g. the machine.config.

Reading from the App.Config

Connection strings have a predefined schema that you can use. Note that this small snippet is actually a valid app.config (or web.config) file:

<?xml version="1.0"?>
<configuration>
    <appSettings>   
           <add key="ConnectionType" value="MSSQL" />
    </appSettings>
</configuration>

Once you have defined your app.config, you can read it in code using the ConfigurationManager class. Don’t be intimidated by the verbose MSDN examples; it’s actually quite simple.

Continue reading “How to add a configuration file (app.config) to your #C application?” →

3.7/5 - (3 votes)
Reviews, Tools

Synchronize your Folders using SyncToy (for Windows)

| Rafael Martins Cardoso

Hello,

If you use different computers and drives in your job or at home, it can be annoying maintaining the same data in all places in case of disaster recovery.

Today’s post is about how to create your own personal “backup” solutions. Let’s get the party started then!

My bottom line

All the lights goes to “Microsoft SyncToy“. It’s a piece of cake. It’s free, it does completely his job and it’s lightweight. What else?

 

For Windows

Creating your disaster recovery plan can be easier with the Microsoft SyncToy 2.1 utility. You might have a flash drive to bring your data from the workplace to your home and vice versa. Though sometimes you might forget to copy that files and misteriously your drive starts failing. And oh boy, now you’re in problems .. or not, if you use Microsoft Sync Toy. It’s easy!

With Microsoft’s SyncToy it allows you to easily make sure all data between drives and folders is synchronized. There are a plently of reasons you might want to synchronize folders,  wanna to sync your My Pictures folder with the one at work, or sync your music at home with music on another computer. The bottom line is, it’s free and it works. Is provided by Microsoft and was once part of the XP Power Toys but has continued to grow and improve.

Continue reading “Synchronize your Folders using SyncToy (for Windows)” →

5/5 - (1 vote)
Road to Certification, ServiceNow

How to become a Certified ServiceNow Administrator (CSA) in 20 days

| Rafael Martins Cardoso

Hello.

Before you start this journey, you need to take some points in consideration:

1. Where are you going to take the exam?

The first question is answered easily. Training is available directly from ServiceNow Education Services or through ServiceNow Authorized Training Partners. I purchased the certification through the website http://www.webassessor.com/servicenow and I selected on site, Rumos at Lisbon, Portugal. As alternative, you have Online Proctored which is online using a webcam and empty room.  As I’m afraid that’s something goes wrong, I preferred In Site option. So far so good.

2. When are you planning to take the exam?

The second question is tricky. It all depends on the amount of experience you have in this type of tool and your learning ability. Mark only the exam when you have experience as developer and user. The exam is 70% experience + 30% tricky questions from the official book. Schedule with a 2 weeks margin to give time to mentally be prepared.

3. How much experience you have?

It is advisable that you have at least 6 months of development experience in ServiceNow.

4. How many hours can I devote daily and what to study?

 Although you feel that you have mastered this already, you have to spend a considering amount of time daily to mistake in order to get it right.

5. Test, fail and try again

Search for sample tests, chapters questions existing in books. Evaluate yourself regularly, try to know where your faults are and correct them. Search your why!

The following books covers the last servicenow versions:

  • Mastering ServiceNow 1 – revised for the Eureka version, release date May/2015
  • Mastering ServiceNow 2 – revised for the Helsinki version, release date November/2016
  • ServiceNow Integrations Basics Wiki Book (*)

Probably a bit outdated and shabby but thats what it is.

 

Thank you,
Rafael

Rate this post