Archive for the ‘Data Integration’ Category

Cloud Computing Benefits for Accounting Firms

August 19th, 2012
Posted by: Julia Uglietta


By Julia Uglietta
Associate, Marketing and Sales

Accounting firms deal with data day in and day out. The volume of numbers that go through an accounting office each day is unimaginable. The number of emails that go in and out of the offices is inundating.

It’s not only the size issue that challenges accounting offices every day.  Rather, it’s also the need to work faster while remaining efficient – in addition to improving better client and interoffice communications. These goals sound fairly standard for a successful business, right?  But in fields such as accounting, where large amounts of data are being received and stored, achieving these goals can be onerous.  The good news is, however, that new technology known as cloud computing is helping accounting firms attain these goals and save money too.

AIS Network accounting

Taking business to the cloud allows accountants to work from anywhere, at any time.

Taking accounting firms to the cloud is a way to reduce costs, improve efficiency and make data more accessible.  Throughout the industry, the discussions about cloud computing and how many accounting practices are moving to an outsourced cloud computing model has people thinking.  Accountants can see clearly that cloud computing is moving up and moving fast.  Now, more firms are looking into cloud solutions before they buy that next new sever.  They’re performing a cost benefit analysis, and in the process, they’re discovering that the operational expenditure associated with implementing an outsourced model is more desirable than the large capital expenditure associated with buying and maintaining all those new servers.

Not only does migrating to a cloud-based, paperless environment cut costs for accounting firms, but it also introduces new efficiencies.  When you put your data and applications in the cloud and entrust a cloud provider to care for them round-the-clock, you’re achieving IT efficiencies such as:

  • Eliminating the need for physical storage (throw out those old filing cabinets!)
  • Upgrading to industrial strength physical security (including partial or full fault tolerance, fire protection, etc.)
  • Improving backup and disaster recovery processes
  • Enhancing data security
  • Increasing availability (through improved power redundancy,  etc.)
  • Extending IT resources with a 24x7x365 team of hosting experts

For many accounting firms, this makes the decision to switch to the cloud even easier.

The most brilliant feature of the cloud is, in my opinion, its “anywhere” accessibility – which is an aspect that most accounting firms will find appealing.  When your data and your applications are in the cloud, they are accessible via any Internet-enabled device whenever you need them and wherever you are.  It just makes life easier.  Allowing the staff to work faster (and, I might add, without necessarily increasing billable rates) allows them more time to focus on the clients’ needs.

Most customers prefer communicating with their accountant via the Internet, and in many ways, the new cloud-based dashboards, reporting applications and unified communications systems that are now available only make this easier.  By enabling better collaboration and communication among geographically diverse staff and clients, accounting firms’ processes and workflows are vastly improved and the work gets done much faster – often with greatly reduced travel costs.

Life in the cloud has changed many industries’ ways of operating.  Slowly but surely, accounting firms will ease into cloud computing and reap benefits that were previously unachievable any other way.

 

 

TAGS:

CATEGORIES:

SharePoint Users: Microsoft SQL Server 2012 Solves Common Business Challenges

June 29th, 2012
Posted by: admin

 

By Jay Atkinson
AIS Network CEO

Microsoft SQL Server 2012 is here now.  How much do you know about it?

If you’re using Microsoft SharePoint 2010 or Microsoft SharePoint 2010 for Internet Sites or if you manage big data, then it’s likely that you are familiar with SQL Server.  This newest version of Microsoft’s premier enterprise database management system has numerous new (and quite powerful) features over the previous release, 2008 R2.

In fact, there are so many noteworthy improvements over 2008 R2 that it would take quite a long time to blog about them all.  Rather, let’s just examine how this new version helps you solve some basic business challenges effectively.

Why use SQL Server 2012?  As the foundation to the cloud-ready information platform, SQL Server 2012 will help businesses of all sizes unlock breakthrough insights across the organization as well as build solutions quickly and extend data from server to private or public cloud — all backed by advanced capabilities for mission critical confidence.

Not only does SQL Server 2012 help improve customer management, but it also may help you face a number of common challenges.  Let’s look at five:

SQL Server 2012

But how do you know if you need SQL 2012?  Many organizations are 24×7 operations.  They may have a global presence too.  But they all have one very important quality in common:  they cannot afford downtime.  Does this describe you?  If so, ask yourself some of these questions:

  • How is your current database supporting your needs?
  • Is the performance of your current database where you need it to be?
  • Are you planning a move to the cloud?
  • Do you see yourself introducing new mission critical applications or planning migrations within three months to a year?
  • How are you viewing business insights for your organization?
  • Are you planning any major projects within the next three months to a year?

These are all good discussion points that we’d be happy to help you work through in your effort to discover whether or not SQL Server 2012 would benefit your organization.

Finally, I’d suggest three brief points for consideration:

1)  Mission Critical Confidence. SQL Server 2012 enables mission critical performance and availability at low TCO.  Consider that it offers:

  • A new integrated high availability and disaster recovery solution
  • Advanced performance speeds
  • Built-in encryption capabilities help protect confidential information without changes to the application

2)  Breakthrough Insight. Use SQL Server 2012 to unlock new insights with pervasive data discovery across the organization.  With SQL Server 2012, you can:

  • Empower business users to create visually rich dashboards or reports across heterogeneous data sources
  • Activate managed self-service BI, which easily balances an employee’s need for rich information and collaboration with IT’s need to manage the safety and confidentiality of information

3)  Cloud on Your Terms. SQL Server 2012 is useful in enabling you to create business solutions quickly – on your terms – across servers to private or public clouds. You’ll like that you can:

  • Easily move applications across on-premises and cloud with unlimited virtualization (available through SQL Server 2012 Enterprise Edition) and license mobility
  • Extend data across on-premises and the cloud

Are you aware of the significant improvement Microsoft has made to the licensing model for SQL Server 2012?  We’ll cover that topic in a future blog.

In the meantime, to learn more about how Microsoft SQL Server 2012 can help you stay productive and reduce costs, please just contact our office.  We’re happy to help.

TAGS:

CATEGORIES:

SharePoint 2010 Security: Adding an SSL Certificate to Your Hosted SharePoint Site

June 11th, 2012
Posted by: admin

By Bill Peters
AIS Network Director of Sales

SSL certificates create secure (HTTPS) connectivity between your Web server and your visitors’ browsers.  If you are transmitting sensitive information via a Web site, such as Social Security numbers, credit card numbers or other personal information, you should secure it with SSL encryption to safeguard against others seeing your data.  If you do not use an SSL certificate, then you are vulnerable.

SharePoint Security

SSL certificates aid in ensuring data security for your hosted SharePoint site.

In a SharePoint environment, SSL certificates can easily be added to a hosted site in order to secure it.  There are different kinds of SSL certificates but I won’t address that in this blog.  Rather, this is about SharePoint 2010 security and the recent request by one client that we add an SSL certificate to his existing hosted SharePoint site with us.

In preparation, I asked him what domain name he wanted on the SSL certificate.   Unsure of my question, he responded, “Doesn’t the domain name have to match the domain of the (AISN) network?”

Here’s how I explained it to him.   In his case, the server hosting his SharePoint is a member server in the Active Directory domain called aisn.local.  Web sites which serve Web pages from this server (SharePoint included) can be addressed by either an IP address or a domain name.  This Web site domain is not the same type of domain as the Active Directory domain in which the server resides.  And actually, Active Directory domains such as aisn.local cannot be present on the Internet.  The ‘.local’ indicates to the Internet that it is a private, not a public, domain name.

That said, it is possible to have an SSL Certificate for either type of domain.  The real question is what are you going to use it for?  That was for my client to decide.

As I explained to him, if you intend to use the SSL Certificate for Server Identification, then we can get a certificate for you for “yournamehere.aisn.local”.  You would use this type of certificate when, for example, you remote desktop to the server.  It would guarantee that you are connecting to the right server.

If, however, you want to use the SSL Certificate for identification of your SharePoint Site, then you can pick any public name you want.  In this case, the domain must be registered publicly in order to get a public SSL Certificate.

So, for example, if you chose to address your SharePoint Site by the name “sp.yournamehere.com”, you would need to make sure that the domain name “yournamehere.com” is registered to you.  Then, you can define “sp.yournamehere.com” in IIS on your SharePoint server. You would also need to configure the public DNS for yournamehere.com such that the “host” known as “sp” points to the IP address on the server.

That explanation seemed clarify things for him.  I told him that I thought he was looking for the latter, but we do not know what his host and domain names are.  It appeared to me that he was addressing his SP site by IP address currently.  In order to assign an SSL certificate, it needs to have a full name.  We cannot register it to an IP.

Have more questions about hosted SharePoint 2010 and hosted SharePoint security?  Send me an email and I’d be happy to help.

TAGS:

CATEGORIES:

Private SharePoint Cloud: For Large Enterprises, It’s the Way to Go

March 21st, 2012
Posted by: admin

By Jay Atkinson
AIS Network CEO

Just last week, we made a bold statement that has captured quite a bit of attention within the SharePoint community.

We revealed that we are now deploying SharePoint Server 2010 in a single private cloud for less than our competitors are charging for a public or hybrid cloud implementation.  And, we expressed our strong view that enterprise-class Microsoft SharePoint 2010 customers should look only to private cloud environments.  In short, it’s the only way to go based on sheer practicality and bang-for-the buck.

private cloud

Enterprise-class SharePoint Server 2010 is hosted most cost-effectively in a private cloud.

Plain and simple, you want the most control over your SharePoint 2010 environment with the least hit to your organization’s bottom line, and you get every bit of that and more by moving from a traditional deployment to a hosted private cloud architecture.

Currently, hosting providers are steering enterprise-class SharePoint 2010 customers toward public cloud and hybrid cloud hosting models.  Our cost analysis research shows that those deployment approaches are needlessly costing more than they should and the customer sacrifices control at multiple levels.

A private SharePoint cloud is simply more economical and easier to manage for a large organization with security and compliance concerns.  An enterprise SharePoint Server 2010 platform implemented wholly in a private cloud, including the online storage components, exceeds core compliance requirements and surpasses the benefits of a public cloud or hybrid cloud.

With SharePoint 2010 deployed entirely in a private cloud, the customer gets:

  • a hosted environment that is exclusively internal to the organization,
  • complete control of its servers, security, permissions, policies and customization,
  • seamless federation between line-of-business systems and various data sources,
  • quick scalability for system resources, and
  • the ability to move other core applications and platforms to the same private cloud.

Public cloud services like Microsoft Office 365’s SharePoint Online and deployments of SharePoint Server 2010 in a public or hybrid cloud are okay for small to mid-size businesses, but they’re very impractical when it comes to serving the best interests of a large business.

The private SharePoint cloud model is an ideal outsourcing alternative.  Sooner or later, global and large enterprises evaluating SharePoint 2010 deployment platforms are going to realize that an enterprise SharePoint Server 2010 platform implemented solely in a private cloud is, indeed, the only way to go.

Have a different opinion?  I’d love to hear your thoughts below.  Need a free quote on a Private SharePoint Cloud?  Naturally, we’d be happy to help you with that.

 

TAGS:

CATEGORIES:

SharePoint Migrations: How Long Does a Migration and Upgrade to SharePoint 2010 Take?

December 1st, 2011
Posted by: admin

By Terry Engelstad
MCP, MCSE, CCNA, MCDBA, MCTS, MCITP
AIS Network Operations Manager

Recently, a visitor to our Web site asked an excellent question.  How long does a migration and upgrade from SharePoint 2007 to SharePoint 2010 take?  The answer to this question is very complex and depends on a number factors.  The subject is much more complex than can be explained in a mere couple of paragraphs but here’s a very brief response.

SharePoint Migration AIS Network

It's important to understand that a migration to SharePoint 2010 may take some time.

First of all, his question is not about just a migration.  It is about a migration and an upgrade.  The answer depends on the following:

1)  There are at least three different ways to migrate and upgrade SharePoint sites:

  • Site by site
  • Database detach/re-attach
  • In-place upgrade

2)  The size of the databases involved is huge in determining the duration.

3)  The type of documents in Content.

4) What customizations have been enabled in the SharePoint 2007 implementation? Some may not “migrate.”

5)  The speed of the server(s) involved.

As a point of reference, we recently did a migration and upgrade to SharePoint 2010 for a client.  It took approximately four weeks to plan, test, and finally do the deed.  The actual migration/upgrade took approximately 24 hours.  This client has a 100 GB Content database and they did a database detach/re-attach and then an in-place upgrade. The only customizations that they made in their 2007 environment were to the visual theme, which did not migrate (it’s a known issue).

For those of you who are planning a migration, we’d be interested in hearing more of your questions.

TAGS:

CATEGORIES: