'Technobabble' - A Jovial Insight into the World of Acronyms by Steve Laidler, Celerity Limited

'Technobabble' - A Jovial Insight into the World of Acronyms Posted on: 27/06/13 When I naively entered into the profession of IT about one hundred and fifty ice-ages ago, I was overwhelmed by almost everything. The knowledge that my much older and wiser colleagues possessed; a knowledge that they could call forth at will without consulting Yahoo or trawling the IBM website looking for that one line that solved the ‘most urgent problem that has ever existed’. Where the last three screws of that server could possibly go? Because it looks just like it should in the instructions? Why that light is green there? and yet, red over there? And what does a flashing ‘888’ mean on that little window? However, the most confusing aspect of my new life as a junior IT consultant was the acronyms. There were more acronyms than I could even begin to comprehend. I had no idea that one job could have that many acronyms. I was drowning in buzz words. As I attempted to absorb information I would need for my duties, the sometimes seemingly random letters and numbers would appear and obfuscate the rest of the sentence. In my desperation to learn the abbreviation I began documenting them in my ‘book of knowledge’. A journal of important commands and stuff to remember, alphabetically organised. I began writing them down and annotating them as to their meanings. This was clearly a stupid idea. I quickly realised that the world would run out of paper before I would run out of IBM acronyms. After months of stock piling combinations of alphabetic and alpha-numeric phrases in my head, I decided that there was only one thing for it, I gave up! One man could not hold that many acronyms in his brain.

I recently found that book of knowledge. It had acronyms in it that I now know, being much older and so people keep telling me wiser, that I will never need. Why then did my younger self attempt to cram them all into his head? Did he think that he would need them? Possibly. Would they help him in his daily work? Undoubtedly. Would they impress the ladies? No. Maybe he was hoping that they would make him sound particularly clever and gave more substance to conversations? Then I realised I had not looked at that ‘book of knowledge’ for over 10 years. Some of it must have actually stuck with me. Thankfully, no one else will need to attempt superhuman feats of memory recall as I have discovered that IBM has on its website, a glossary of technical terms, acronyms and all things generally computer related, and alphabetically organised. Hey, that was my idea! Steve Laidler - Technical Consultant - Celerity Limited Contact - See more at: http://www.celerity-uk.com/news/196/technobabble-a-jovial-insight-into-the-world-of-acronyms#sthash.fZpzgI96.dpuf

Backups by Celerity Technical Consultant, Mike Metcalf

Backups Posted on: 20/06/13 In this article we’ll take a look at the differences in Backup and Restore methodologies between on premise ‘SQL Server’ and cloud based ‘Azure SQL Database’. Whilst both products are based on a similar set of technologies under the hood, they are very different animals in the way that they work and require different skills to administer them correctly. SQL Server Backups Traditional on premise SQL Server has three fairly well established backup methods that are generally used in combination to ensure that should a failure happen, a database can be restored to any point in time that is required. In all cases the database backup in transactionally consistent from the point in which it was taken. Full Backups This essentially takes a complete backup of the entire database and stores it in a file on disk. Generally the taking of a Full Backup would be seen as a weekly event. This is primarily because maintaining multiple copies of the entire database would require a significant amount of storage to do so. By way of example, if your company had a retention policy of 5 days, a 100 GB database would require 6 times the storage needed for just the database (original + 5 copies = 600 GB). Task Storage Required (GB) Full Backup 1 100 Full Backup 2 100 Full Backup 3 100 Full Backup 4 100 Full Backup 5 100 Total Storage Required 500 To recover the database you would simply restore the full backup file required. Differential Backups A Differential Backup, backs up all data written to the database since the last full backup was taken. Each differential backup will be larger than the previous one, but only by the amount of data written to it. Using the same 5 day retention period from above, and assuming that your database is growing by 1GB per day this gives the following storage profile. Task Storage Required (GB) Notes Full Backup 100 Differential Backup 1 1 Differential Backup 2 2 (Diff 1 + 1GB) Differential Backup 3 3 (Diff 2 + 1GB) Differential Backup 4 4 (Diff 3 + 1GB) Total Storage Required 104 As you can see, this represents a significantly smaller backup footprint than would be required in the Full Backup only scenario (204 GB as opposed to 500 GB) whilst achieving the same goal. In order to recover the database in this situation, you would restore the Full Backup, and then the latest Differential Backup required. Transaction Log Backups SQL Server maintains a log of all activity written to the database in the precise order that it was written in, called the transaction log. Backing up the transaction log means that it is possible to restore the database to a specific point in time throughout the day. Generally speaking, multiple transaction log backups would be taken periodically throughout the day. They are generally very small as they only back up the data since the last transaction log backup. It should be noted that in order to take transaction log backups, it is necessary to run the database in ‘Full’ recovery mode. Running a database in ‘Simple’ recovery mode effectively means that the transaction log is truncated once the transactions have been committed to the database, meaning that since it has been cleared out, it cannot be backed up. It is not essential to run a database in ‘Full’ recovery mode, but it should be remembered that if you do not you will only be able to restore the database to the last full or differential backup that was taken. All work on the database since that point will have been lost. Transaction log backups are used in conjunction with Full and Differential backups. In order to recover the database to a point in time you have 2 options available: Option 1 Restore the Full Backup and then restore each transaction log backup in turn. As you can imagine, if you take 12 transaction log backups throughout the day this can mean that you have a lot of files that will need to be restored. Option 2 Restore the Full Backup, then restore the latest Differential Backup, followed by only the transaction log backups taken since the differential. This significantly reduces the number of files that need to be restored in the correct order. The more observant of you may have noticed that since we are taking full and transaction log backups, that it is not strictly essential to also take differential backups, and you would be right, this is perfectly true, but seeing as I’m a ‘belt-and-braces’ type of guy who likes having different options available when it comes to recovery, that is the way that I always work. Windows Azure SQL Database Backups Windows Azure SQL Database is Microsoft’s cloud based offering for SQL Server. Whilst it is based on the same technology it is quite a different in the way that it is managed and administered. These differences also extend to the way in which backups are taken. Microsoft has two recommended methods for backing up an Azure SQL Database: Database Copy This feature essentially creates a new database that is transactionaly consistent with the source database that it was copied from at the time that the copy process completes. With a large database, this copy operation can take a while to run, but you know that all changes made to the source database during the copy process are also going to be committed in the backup. A word of warning, whilst this does ensure transactional consistency, it also means that you have created a second database and, therefore, have incurred any additional costs associated with that action. You should also keep in mind that this method does not actually allow you to create/keep a copy of the backup on your own servers as it leaves the database copy on the Azure platform. SQL Database Export Service The database export service copies the object definitions (tables, stored procedures, etc.) from the source database to a logical file (BACPAC). This is then followed by a bulk copy of all data from the tables into the BACPAC file. Transactional consistency in this case is potentially a problem, changes made to the source database that affect only certain tables may not be included in the BACPAC file. The only way to guarantee transactional consistency within a BACPAC file is to first put the database into read-only mode (preventing it from being written to) followed by reverting back to allow writes once the backup has finished. This has obvious questions regarding system availability and by itself is not a valid solution for larger/enterprise systems that need to run 24/7. In order to ensure transactional consistency, and allow you to maintain a copy of the database on your local server(s) for Disaster Recovery purposes, you will need to use both of these methods. First create a transactionally consistent copy of the production database using method 1, and then create a BACPAC backup of the copy using method 2. I hope that this brief overview has helped you to see that regardless of which version of SQL you choose to use, the backup mechanisms in place are robust enough to provide a level of restore needed for each platform. Celerity Consultants have a wealth of experience with Microsoft products and would be happy to discuss any requirements that you may have. Mike Metcalf, Technical Consultant, Celerity Limited Contact - See more at: http://www.celerity-uk.com/news/194/backups#sthash.Ex5jerl2.dpuf

To Outsource or Not To Outsource | IT Solutions Provider

Author: Sharon Brown

Nearly everyone who works in the services industry has at some point heard the term Outsourcing more than once and can bring fear amongst some fellow workers. But is it really what we expect it to be? Do we believe that outsourcing is the end game of in house services? I for one don't believe it is. Times have changed in the outsourcing arena; the attitude of them and us seems to be a thing of the past. The arena is no longer a seated event where the customer sits as a spectator and the outsourcer is watched as the main event. Its more open these days, the event is interactive where the customer and the outsourcer are part of the same story.

The key to a successful partnership when outsourcing services can never be just one thing. The foundation of a relationship needs to be laid for something to grow. Understanding each other and working closely as a function are primary aims for any successful partnership. Boundaries need to be defined, with a clear understanding of what is to be expected in the relationship.

Overcoming the fear and lack of understanding of an outsource relationship can be complex and emotional for both partners. How we perceive the other is sometimes blared and castles can quickly be built as personal protection. It is important that we understand why outsourcing is needed and if it is right for you and your business, because sometimes the easy answer is not always the best.

There are many benefits to an outsourcing service and with a simple Google search you will find a plethora of do's and don'ts when outsourcing. But sometimes a business finds itself in a position that has become untenable through resource, cash flow or function break down. Turning to outsourcing can be seen as a way of resolving this position, and rightly so; after all outsourcing is a service that helps. A good service provider will work closely with your business to understand the culture of your business, the needs and most importantly why you requirethis service. Also a good service provider will know its weakness and know your strengths and be able to work closely to maximise both and encourage the growth of the relationship.

The fear of outsourcing is enforced by the horror stories of others who have ventured the path of outsourcing, and let's be honest you're more likely to notice these rather than the successful ones. Having worked in the industry for many years I have seen both and worked on both sides as the outsourcer and customer. During this time I have seen the many benefits outsourcing has brought, not just the cost saving it brings but also the on tap expertise and the flexibility needed. Being able to call up resource for key projects as well as the normal operation of the day to day business has been invaluable. Knowing you have access to such services reduces the work load of tenders and trying to find a suitable resource to carry out work, this has enabled me to focus on more key business needs and help reduce my overhead costs of engaging new resource.

So would I use outsourcing again? The question is relevantly simple as is the answer. With a growing need to be flexible in a business and focus on the core business drivers, outsourcing has enabled the business functions to deliverso many times. If I am in a position where the core business is different from that project that needs to be done or business function; then I would certainly use the outsourcing route.

Of course only the business can decide if the outsourcing route is the best approach for its needs. Speaking to an outsourcer in a non-formal, very open way can certainly help you make those decisions. Therefore if you find your business is in need of something that is outside its core business or skill set then don't dismiss outsourcing; it could be just what your business needs.

IBM business partner Celerity Limited is an experienced IT solutions provider offering a wide variety of infrastructure management solutions to a wide variety of clients throughout the UK. Offering a comprehensive portfolio of technical support services including: cloud computing services, data de-duplication, data migrations services, data security services, it disaster recovery services and it support services.

Article Source: http://www.articlesbase.com/software-articles/to-outsource-or-not-to-outsource-it-solutions-provider-6632471.html

About the Author