BT Service

We provide BT Infrastructure and User Service to our customers with global standards and allow them to focus on their work and use their energy in their own sector. In purview of our service, we consult our customers on the BT infrastructure field and create optimum solutions for their needs.

Helpdesk – Professional Service Desk

In addition to our onsite support, our Helpdesks, which are organized with professional technical infrastructure and resources, provide solution oriented remote support to our customers’ users.

We can model our Service Desk service according to our customers’ needs.

Our example Service Desk models are:

  • Team and infrastructure based on the customers needs and environment,
  • With a special team, formed to support the BT infrastructure projects of the customer,
  • With a special team, formed to support specific issues on software projects,
  • Team and infrastructure based in an office, formed for customer needs,

Application Support

As a part of our End User Support, we provide support to the applications (CRM, ERP, etc.) used by our customers or their software projects, with experienced teams in their fields. We can form our support as on-site or remote and as full time or part time based on our customers’ needs.

Database Management

As a part of our Database consulting, configuration and management service; we construct the database architecture with detailed analysis, determine the appropriate product, perform all the installation and backup, and then create replication solutions, based on our customers’ requirements.

Microsoft Corporate Services

They include all the services required for the application of efficient, safe and correct technologies, based on our customers’ needs. We provide Microsoft technologies in complex or simple structures that offer network technologies, messaging, communication, management, security, dissemination, virtualization, business continuity and disaster scenarios that corporations need, by using the MSF (Microsoft Solution Framework) methodology.

In conjunction with Microsoft Turkey, we offer Microsoft based solutions and value added services, we provide a wide range of corporate needs that include licensing services, consulting and solution sales.

IT Infrastructure Installation

By making detailed analysis of our customers’ IT Infrastructure installations or IT Infrastructure renewals/upgrades, we create solutions and provide the necessary support on topics such as:

  • Local and Wide Area Network design and installation,
  • Active Directory Domain design and installation,
  • Application and File Server planning and installation,
  • Shared Storage planning and installation,
  • Secure Internet access,
  • Intranet (SharePoint) installation.

Server Installation and Management

We provide service on needs analysis, selection of the appropriate product and licensing model, commissioning, operation and management.

We also perform continuous operational maintenance like the management of access on the servers, backups, security and update management, via on-site or remote support depending on the customers’ needs.

System Room Infrastructure Installation and Configuration

In our System Room infrastructure projects, we provide these types of solutions for our customers’ all kinds of System Room infrastructure requirements:
  • System room design and installation
  • System room reengineering and organization
  • Network cabinet organization
  • System room monitoring and fire, heat, humidity, and flood prevention solutions.

Network Infrastructure Installation

We offer solutions on our customers’ Network infrastructure needs with projects such as:
  • WAN Optimization
  • Connection Between Locations
  • LAN Cabling
  • Wireless Network Infrastructure Installation
  • System Room Design and Organization
  • Network Security

Business Continuity and Disaster Recovery

In today’s world where the BT and other processes inside its structure are extremely critical, backing up these structures is a very important part of the business continuity. Creating a structure that will allow the business continuity isn’t just about a change in BT structure but a strategy that requires the coordination of all business units. Our team, with these ideals in mind, plans our customers’ business continuity strategy with the most appropriate technological solutions.

Virtualization and Consolidation

Knowing today’s technology and conditions, as the first technological corporation using this solution on it’s own structure and one of the first that present this solution in Turkey, we provide VMWARE and Microsoft Hyper-V infrastructure as Intel Turkey’s first and only virtualization solution partner and VMWare Enterprise Partner. As a part of this solution we offer;

  • Virtualization solution and applications,
  • Integration of the current structures with virtualization technology,
  • Application of modular solutions which are scalable by need,
with the full features of the technology.
We also hold information sharing seminars that guide the sector to further widespread the virtualization technology.

Backup and Replication

We plan the most efficient strategy and the best ways of backing up the information that is related to our customers’ business continuity with the optimum budget. At the stage of forming a strategy, we designate all the operational steps and shape them according to the customer’s structure and previously experienced global standards.

SAN Data Storage and Backup Solutions:

The way we store and access our data affects our way of doing business crucially in this day and age. To allow our customers access and to store their data in the most secure and fast way, we offer;
  • Planning their data storage capacity,
  • Creating solutions for the best data storage appropriate for their structure,
  • Creating alternate data storage solutions categorized by the importance of the data,
  • Creating layered Data Storage and Backup based on different application needs.

Information Security:

As the global and local information crimes’ determination to profit from these factors persists, information security cases become unavoidable. The aim of an effective information security and management strategy is to reduce these attacks to a minimum and to solve these cases with maximum efficiency. A good information security management also helps prevent possible future cases. By having our customers information security as top priority, we create the most appropriate strategies and provide top level security with the most suitable products.

In addition to that, knowing that the most important element in information security is “the person using the information”, we provide security with Information Security in-process trainings.

Hardware Technology Consulting

We determine the most suitable models and brands of products for our customers’ IT infrastructure formation, upgrade and renewal. With our experienced sales team, we provide these products from the distributors which we have top level partnerships with, at the best prices.

IP Phone

IP phones are gradually replacing the analogue phone systems in modern world. IP phone systems are using VoIP technology , which is the acronym for Voice over Internet Protocol. VoIP, in short, means that the phone calls are made over the Internet structure. With VoIP infrastructure, users are not required to have any technical knowledge of its use. It can also be available wherever there is an internet connection.

When considering just the phone call advantages of IP phone over the analogue systems, some of the main benefits are its lower cost, location-free structure and availability for visual calls. In addition to these, reporting tools, CRM softwares, call management and upgradeability are the other advantages of IP phone infrastructure.

The greatest advantage of IP phone solutions is its open architecture for integration of value added telecommunication services. With it, it’s possible to monitor the status of a system room via the phone screen, relay the latest stock market and exchange information to the users use the phones as an internal announcement system or with other countless value added applications.

We identify the solutions/products that will answer the needs that are within the customer’s structure and budget and provide the requisition, installation and configuration of all the products that are included in the solution.

Live Agent

With our specifically designed Asterisk based software for IP Phone platforms, you can monitor and create detailed reports on agents', system’s and IP phones’ status via the wallboard situated in the call center and follow it live on Dashboard.

Video Conferencing and Telepresence:

We aim for an increase in productivity by providing visual conferencing technologies, which is especially important for customers that have different and remote located offices. This lowers the logistical costs and allows for active meeting and communication.

Helpdesk/Call Center Installation:

IP phone infrastructure, based on the size of your organization’s requirements and needs, gets planned and delivered, ready for the end user. All you have to do to receive this service is to point out your needs. In the light of this information, your network infrastructure, call infrastructure and reporting needs will be analyzed, and then we can perform the necessary adjustments and complete the installation. It’s also possible that, with the developing structures and evolving needs, these systems can be improved and upgraded.

KIOSK & Digital Signage & InfoPoint:

We increase the internal communication by placing InfoPoint and Kiosk stations on our customers offices’ shared space, which are customizable with corporate specific applications.

Aprego Restaurant Automation

Aprego! can help you manage your busy restaurant or bar with ease!

Totally Encompassing Hospitality POS, in Business for 22 Years and Counting...

The power to control all of your terminals resides in the feature packed and easy to manage Aprego Back-Office Module.
Easily add new inventory items, and instantaneously place and make them visible on your POS terminals.

Aprego is a global product

Aprego is configured to speak different languages

From Key West to Alaska, and Mexico to Manila, Aprego is configured to speak to you clearly in your specific dialect.

Lowest price guarantee!

Aprego TCO is the lowest

Without compromise of features, Aprego Total Cost of Ownership, with zero database administration and maintenance, is the lowest in the industry.

SQL Database Integrated Services

1.Virtuatic DBA Microsoft SQL Server

NicEye IT Consulting offers a range of virtual DBA services for Microsoft SQL Server
We can help you provide high availability and disaster recovery for your Microsoft SQL Server database platform. We have extensive experience with both SQL Server Standard Edition and SQL Server Enterprise Edition. We can work with any supported versions of the operating system that are appropriate in traditional or virtual machine environments for the version including:

SQL Server 2000 32-bit
SQL Server 2005 32-bit
SQL Server 2008 32-bit
SQL Server 2008 R2 32-bit
SQL Server 2012 32-bit
SQL Server 2000 64-bit
SQL Server 2005 64-bit
SQL Server 2008 64-bit
SQL Server 2008 R2 64-bit
SQL Server 2012 64-bit

Ensure high availability and disaster recovery with SQL Server active and passive clustering
SQL Server Cluster Services protect against disruptive hardware failures. With a cluster, if there is a failure, the system automatically fails over to a secondary server. The servers share disk resources so we recommend a SAN or RAID array with a high level of hardware redundancy. We can help you choose the right type of cluster as well as recommend storage solutions. We’ll work with you from the design phase through installation and provide ongoing support to maintain performance and uptime.

Other services to protect your database and ensure uptime SQL Server Database Mirroring Database mirroring is available on SQL 2005 and SQL 2008. Some types of database mirroring are available only on SQL Server Enterprise edition. We can help you choose and implement the right type of mirroring based on your business needs, version and hardware capabilities.

SQL Server Replication SQL Server Replication is a good option for setting up a reporting database, a test database or a high availability fail-over database. Replication works well in situations where there is a good connection between servers and works well moving data from different versions of SQL Server. We can help you gather requirements, implement and manage your replication solution.

Log Shipping Log shipping is a viable option for high availability and disaster recovery when a moderate amount of time to recovery is acceptable, a small amount of data loss is not critical and the locations and versions of SQL Server make database mirroring or clustering impractical. We can assist you with all aspects of log shipping.

SQL Server performance tuning and Health Checks
SQL Server performance can degrade for many reasons including increased data sizes, new applications, hardware failures and a host of other issues. Let us diagnose and fix your performance problems.
Keep your SQL Server at peak performance levels by having NicEye IT Consulting perform a Health Check. Let our experienced DBA’s perform an in-depth analysis of your system including configuration, performance, availability and security. Once our analysis is complete you’ll receive an easy-to-understand report that includes an overview of your system and offers suggestions for improvements.

SQL Server hardware and configuration problems
We can find and eliminate your SQL Server performance bottlenecks. Slow performance can result from incorrect memory configuration or database configuration. Our analysis can determine if:
Keep your SQL Server at peak performance levels by having NicEye IT Consulting perform a Health Check. Let our experienced DBA’s perform an in-depth analysis of your system including configuration, performance, availability and security. Once our analysis is complete you’ll receive an easy-to-understand report that includes an overview of your system and offers suggestions for improvements.
  • you have enough memory.
  • your CPU is fast enough.
  • you have as many CPUs as you need.

  • We can find out why your disk so busy and suggest solutions and also offer solutions to slow system performance.

    We can fix SQL Server Query problems?
    We can help you design and optimize queries and stored procedures to improve query performance. We’ll also address:

  • reduced query speed
  • increased blocking
  • error causes
  • rebuilding indexes
  • updating statistics

  • Eliminating confusion about patches and service packs
    Applying patches and service packs can be confusing. Let us help you determine which patches and service packs you need and install them with minimal disruption. Once a service pack is installed, we can help maximize new features.
    Take advantage of our experience for your upgrades and migrations
    Any upgrade − including upgrading your SQL Server instance from 2000 to 2005 or 2008 − requires planning and experience. Let us help you set up a test environment to test your application against the new version. We can also help you decide if this is the right time to move from a 32-bit version of SQL Server to a more scalable 64-bit version. We’ll show you the advantages of 64-bit system including its ability to handle a growing database.
    Perhaps you are ready to move from MS Access or another database to SQL Server. We can help you with that, too. We’ve moved many databases from other platforms and databases to SQL Server.

    Our security audit provides peace of mind
    The safety and security of your data is vital. Our tailor-made security audit will reveal system vulnerabilities and offer patches and procedures to improve your security.

    Review your backup and recovery plan
    We can help you design a backup and recovery strategy to protect your data and provide recovery with minimum downtime. We’ll make sure your backup and recovery plan matches your business needs. We’ll also make sure you are backing up frequently enough to prevent large data loss.

    Use us as a resource for SQL server development
    We’ve worked with many development teams as developers, DBAs and architects. We can help with SQL writing and tuning, reviews of data models, performance and general best practices.
    We can also help with the following issues:
  • Creating a test environment with sensitive data removed. We can help to design a process to safely alter sensitive data.
  • Rolling out changes from development and staging to your production database. We can help by designing procedures or by suggesting state-of-the-art tools and training you to use them.
  • Debugging DTS or SSIS packages. We can help with troubleshooting and implementation.

  • 2.Health Checks for Microsoft SQL

    Our Microsoft SQL Server experts can help you achieve peace of mind when it comes to your SQL Server databases

    The SQL Server Health Check is targeted at assessing the performance, stability and availability of your Microsoft SQL Server based systems. This analysis can be focused on performance, security, migration, upgrade, or availability issues or concerns. An independent or impartial review of your SQL Server environment can sometimes help when teams may be set in their ways or need a little guidance. The goal is to help you save time, money and avoid headaches.
    The results of a Health Check are documented recommendations relating to performance, stability, availability, or the specific focus you requested, of your SQL Server database instances. Our team will be available to go over the report and recommendations with you to address any questions or concerns you may have. The NicEye IT Consulting SQL Server team is then available to assist you with the implementation of any of the recommendations once you approve those efforts. We help clients achieve Increased performance, maximized availability, boosted productivity and peace of mind with their Microsoft SQL Server systems.
    The Health Check for Microsoft SQL Server is a carefully crafted program designed to review the efficiency as well as effectiveness of a Microsoft SQL Server-based database management system. The efficiency of the system is evaluated by determining the extent to which the Microsoft SQL Server products have been utilized; essentially, is the system “firing on all cylinders”?
    The efficiency of a system takes into consideration issues such as:
  • Is the database and operating system properly tuned?
  • Are there sufficient hardware resources for the various applications?
  • Have schemas been normalized or denormalized where appropriate?
  • Have the proper indexes been created?
  • Are critical administrative utilities run regularly?
  • Does the staff have the requisite skills needed to maintain an efficient system?

  • In a complex computing environment, the extent to which these and other issues are addressed will affect the overall efficiency and effectiveness of the systems in place. The SQL Server Health Check addresses these issues of efficiency and effectiveness by having a skilled SQL Server engineer assess your SQL Server-based computing environment over a one to five day period.

    Ideal System Performance
    To achieve the optimal performance for a given system one must ensure the optimal performance of each component of the system. The components addressed in this performance analysis are:
  • Hardware utilization including CPU, I/O bottlenecks, and memory
  • Operating System and storage configuration
  • SQL Server Database Server installation and configuration
  • Client Communications
  • Application Implementation
  • Operations and Maintenance including backup, recovery, consistency checks and others.
  • Each of these components is critically important to the optimal performance of the overall system.
    The following are some of the issues related to each system component.

    Hardware Resources:
    The server hosting your Microsoft SQL Server database relies primarily on three hardware subsystems for efficient performance – CPU, Memory, and I/O.

    A well-architected system will show optimal CPU utilization without queues. A fully utilized CPU is ideal, but an additional check for the number of processes waiting for the CPU is required.

    The I/O subsystem of the server hosting your MS SQL system is critical to the performance of the database and applications. Ideally, the disks in the system will be responding to requests in less than 50 milliseconds, and there will be no queues forming on those disks. Additionally, for large decision support queries, the controllers will be analyzed for bottlenecks and limitations. If RAID is being used on-site, this will be analyzed for its effect on the database and applications. I/O configuration is the most flexible of the resources, since the database and system administrators can easily work together to balance the I/O load across all available resources.

    A large server may contain several gigabytes of main memory. The use of that memory has to be carefully allocated among the critical functions of the server – applications, database, and operating system. The goal is to have ample free memory to meet the peak demands of the workload, while maintaining good cache hit rates in the database and avoiding process swapping.

    Operating System:
    The operating system is the least likely place to find performance issues; however, Microsoft Windows Server does have a number of memory configuration options. These will be analyzed and addressed.

    SQL Server Database Server:
    There are numerous items that relate to database performance. However, key elements of this score will reflect the use of indexes, table fragmentation and I/O balance, optimizer statistics, parameter settings, transaction logging, database layout, session activity, cache utilizations, and others. These areas will be investigated extensively based on the overall behavior of the database and application. Each component of the analysis will be detailed in the report that is delivered at the completion of the service.

    Client Communications:
    There are several optimizations available for client PCs connecting to your MS SQL Server. These will be evaluated for appropriateness in the environment. Additionally, if clients are connecting to SQL Server with older versions of software, there is tremendous opportunity for performance improvements through client library upgrades.

    Application Implementation:
    Database applications can often be enhanced through techniques that have been introduced since the application was originally designed. A discussion with the application developers will aid the DBA in making recommendations for improving the application.

    While the above analysis strives to leverage hardware and software to its fullest potential, this area of the assessment strives to provide operational stability to the environment. Looking at batch jobs, backup and recovery strategies, logging strategies, upgrade strategies, and test platform capability will enable the DBA to provide recommendations for improving up time of the environment.

    During the Performance Analysis, clients will provide access to pertinent systems and key personnel to ensure a thorough and productive assessment. Key individuals within the environment will be the DBA, the System Administrator, the Application Team Leader, and others identified as subject matter experts.

    3. SQL Server Replication

    What we provide
    NicEye IT Consulting’s Engineers will provide recommendations and strategies to set up SQL Server replication to meet your organizational objectives. NicEye IT Consulting also provides the virtual DBA service that monitors your replication server activities. We deliver:

  • Initial assessments and review requirements
  • Design replication system
  • Define the approach & plan
  • Estimate schedule & cost
  • Perform installation
  • Test and validate
  • Training to administer replication server
  • Monitor replication server using Virtuatic DBA when requested

  • What is SQL Server Replication?

    SQL Server Replication is a set of tools that allow data to be automatically moved from one server to another. There are three distinct types of replication available within Microsoft SQL Server:
  • Transactional Replication – In this type of replication information is moved from one server to the other as the transactions occur. This is a good choice for large databases because once it is set up and an initial snapshot is applied it only moves the changes to data between the servers. It is a good choice for a situation where you want to move reporting off the primary server but still require up to the moment data. Since the primary server must be able to exactly identify the rows of data to change on the target server it requires primary keys on the tables to eliminate any possible ambiguity.
  • Transactional Replication with updatable subscriptions – This is similar to Transactional Replication but updates are allowed to subscriptions. This may be an alternative to Merge Replication in some cases. There are many requirements for this type of replication as far as changes that are made to tables, allowable data types, and the use of foreign key constraints among others. NicEye IT Consulting can help you determine if this type of replication would work for your organization.
  • Snapshot replication – In Snapshot replication an entire copy of the data to be replicated is moved to the target server. This is a good choice for smaller databases where it is acceptable for the data to be perhaps a day old. Since Snapshot replication is copying entire tables it doesn’t need to have primary keys on tables. When it’s impossible to modify table structures Snapshot replication may be the best way to replicate.
  • Merge Replication – Merge Replication allows users on the target system to modify data and have that data “merged” back onto the primary source. This is commonly used in applications where someone, perhaps a Sales Rep, needs to download information, make updates to that information while disconnected from the primary database then apply the updates to the primary when reconnected. Because changes could occur to the same record on both the primary and target machines this type of replication requires rules be created to resolve conflicts. Merge replication also requires that a GUID (Globally Unique Identifier) field be added to each table that will be replicated.

  • Who Uses SQL Server Replication and Why?

    A business organization that needs to offload reporting to a separate server
    SQL Server replication can reduce the stress on your production environment caused by user reports. Replication allows your users to run their reports against a replicated copy of your database. This copy can be near real-time (transactional replication) or if there isn’t a need for real-time a copy of production data can be moved to a reporting server off-hours (snapshot replication). In either case it frees up your production server for the important work of serving your customers.

    A business organization that wants to build distributed system
    Data distribution is a tool that helps companies put necessary data in the hands of local decision-makers yet maintain firm central control over the data. With SQL Server replication, data can be shared and replicated between databases, allowing system designers to put the data where it's needed.

    A business organization that wants to have additional backup strategy
    In conjunction with backup, SQL Server replication strategies seek to complement traditional approaches by providing alternative levels of data protection and integrity, while minimizing user disruptions. replication creates a point-in-time copy of the data to be used as the backup source.

    A business organization who wants to set up failover system
    SQL Server replication maintains a near real-time “warm standby” database to which applications can switch with virtually no downtime if the primary site fails. You can manage planned downtime such as routine maintenance, software upgrades and etc. It protect during unplanned downtime due to machine/network outage, for example. It also provides disaster recovery. Any system providing HA services should provide continuous availability of data in any scenarios.

    A business organization that needs to replicate data from Oracle to SQL Server
    SQL Server Enterprise edition supports heterogeneous replication from Oracle to SQL Server and from SQL Server to Oracle. NicEye IT Consulting has experts in SQL Server replication as well as Oracle replication that can make heterogeneous replication work for you.

    4. SQL Server Versions and Platforms

    NicEye IT Consulting supports the most recent versions of Microsoft SQL Server

  • SQL Server 2000 32-bit
  • SQL Server 2005 32-bit
  • SQL Server 2008 32-bit
  • SQL Server 2008 R2 32-bit
  • SQL Server 2000 64-bit
  • SQL Server 2005 64-bit
  • SQL Server 2008 64-bit
  • SQL Server 2008 R2 64-bit

  • We will work with any supported versions of the operating system that are appropriate for the version.
    SQL Server Active & Passive Clustering:
    Do you need to protect against hardware failures interrupting business? Consider using SQL Server on Microsoft Cluster Services. In a Cluster the system automatically fails over to a secondary server in case of a failure. In a cluster the servers share disk resources so we recommend a SAN or RAID array with a high level of hardware redundancy. We can help you choose the right type of Cluster as well as recommend storage solutions. We’ll help you from the design phase through installation and provide ongoing support to maintain performance and uptime.

    SQL Server Database Mirroring:
    Database mirroring is another way to protect your data and provide high levels of uptime. Database mirroring is available on SQL 2005 and SQL 2008. There are multiple types of database mirroring some of which are available only on SQL Server Enterprise edition. We can help you choose and implement the right type of mirroring based on your business needs, version of SQL Server, and hardware capabilities.

    SQL Server Replication:
    SQL Server Replication can be very useful for setting up a reporting database, a test database or even a High Availability fail-over database. Replication works well in situations where there is a good connection between servers and is a good option for moving data from different versions of SQL Server. We can help you gather requirements, implement, and manage your replication solution.

    Log Shipping
    Log shipping can be a valuable strategy for High availability and disaster recovery in situations where a moderate amount of time to recovery is acceptable, a small amount of data loss is not critical and the locations and versions of SQL Server make database mirroring or clustering impractical. We can assist you with all aspects of Log Shipping.

    SQL Server Performance Tuning
    SQL Server performance can degrade for many reasons. We see issues where data sizes increase, applications change, hardware fails and a host of other problems. We have the experience and training to diagnose and fix performance problems.

    SQL Server hardware and configuration problems
    Is your Memory configured correctly? Is your database configured to get the maximum performance from your CPU and disk system? We have extensive experience in finding and removing performance bottlenecks. We have helped many Companies determine such things as:

  • Do I have enough memory?
  • Is my CPU fast enough and do I have as many as I need?
  • Why is my disk so busy and what can I do about it?
  • I have good hardware – why is my system so slow?

  • SQL Server Query Tuning
    Are your queries performing as well as they should? We can assist you in the design and optimization of queries and stored procedures. In addition we help find the reasons behind:
  • Why does this query that used to run quickly now takes forever?
  • Why am I seeing so much blocking?
  • What’s causing this error?
  • Should I rebuild my indexes?
  • Should I update statistics?

  • Patches and Service Packs
    Applying patches and service packs can be confusing. We have the expertise to help you determine the appropriate patches and Service packs and get them installed with a minimum of disruption. Once a service pack is installed we can help you to take advantage of any new features that may now be available.

    SQL Server Health Checks
    Do you wonder if your SQL Server is performing at its best? We can make an in-depth analysis of your system and provide you with a “Plain English” SQL Server Health Check document that gives you an overview of your system and provides suggestions for improvements. We have experienced dba’s look at all aspects of your system from configuration to performance to availability to security.

    Upgrades and Migrations
    Upgrading your SQLSERVER instance from 2000 to 2005 or 2008? Whichever versions you work with, migrating to a new version of SQL Server takes planning and experience. We can help you set up a test environment to test your application against the new version of SQL Server. We can also help you decide if this is the right time to move from a 32 bit version of SQL Server to a more scalable 64 bit version. We’ll show you where a 64 bit system would provide advantages and add the ability to handle a growing database.
    Are you ready to move from MS Access to SQL Server? Are you considering moving from another database to SQL Server? We can help you with your migration needs. We have moved databases from many other platforms and databases to SQL Server.

    Security
    The safety and security of your data is vital. We can provide a security audit tailored to your needs. We will help you determine vulnerabilities and suggest the appropriate patches and procedures to improve your security.

    Backup and Recovery
    Does your backup strategy match your business needs? Are you backing up frequently enough to prevent a large data loss? We can help you design a backup and recovery strategy that matches your needs to protect your data as well as providing you recovery with minimum downtime.

    SQL Server Development
    Do your developers need help in writing efficient SQL? We work with the development teams of many clients, either in the developer, DBA or architect roles. We can help with SQL writing and tuning, reviews of data models, performance, and general best practices.
    Do you need to create a test environment with sensitive data removed? We can help to design a process to safely alter sensitive data.
    Do you need assistance rolling out changes from development and staging to your production database? We can help by designing procedures or by suggesting state of the art tools and providing training in their use.
    Do you need help debugging DTS or SSIS packages? We can help with troubleshooting and implementation.

    5. SQL Server 2012 New Features and Enhancements

    Hadoop Integration
    Hadoop integration allows organizations to move data back and forth from Hadoop to SQL Server. This allows the strong data analysis tools included in SQL Server 2012 to be used to analyze and report on unstructured Hadoop data.
    NicEye IT Consulting can help you import and export data with an existing Hadoop cluster.
    SQL server Hadoop connectors allow the import of unstructured data from Hadoop into SQL Server tables where it can be integrated with data warehouse and BI solutions. The ability to submit a MapReduce or Hive request through SQL Server Integration Services substantially improves the ability to take advantage of a NoSQL database.

    Distributed Replay
    Distributed Replay helps companies test changes or a real workload without impacting your production servers. Distributed Replay allows us to collect a workload from a production server and the “replay” that workload on a test system. It is particularly helpful in assessing the impact of hardware changes, performance tuning and configuration changes.
    NicEye IT Consulting can help you set up and use Distributed Replay in SQL Server 2012.
    Distributed Replay is a powerful tool that allows us to capture a workload from a production server and replay that on another SQL Server. This will enhance testing ability for performance as well as providing a “real” test for determining

    Enhanced PowerShell Support
    PowerShell gives companies a rich scripting language that has capabilities built on .Net. Using PowerShell allows automation of many tasks that would previously required user interaction with the servers.
    NicEye IT Consulting can help you write, troubleshoot and implement PowerShell scripts.
    New PowerShell cmdlets enhance the ability to manage SQL Server with PowerShell.

    User Defined Server Roles
    User Defined Server Roles provide companies with a fine grained permission control at a server level rather than at a database level. This will help to maintain consisten application of security policies acrodd all databases on a server.
    NicEye IT Consulting can help you implement User Defined Server Roles. We can help you with creation of these roles and setting permissions.
    Previously Server roles were fixed and no additions could be made. With this change a Server role may be created that will apply to all databases on the server. This will substantially simplify management where users need to access multiple databases with the same capabilities.

    Master Data Services
    SQL Server Master Data Services provides a single location for all data. It is designed to resolve issue with inconsistent data from multiple sources including non-SQL Server databases.
    NicEye IT Consulting can help implement Master Data Services. We can help with planning, design, implementation and testing.
    Master Data Services allows for data alignment of data from multiple applications. This allows a “single version of the truth”. It also allows management of data consistency across multiple database platforms like Oracle, SQL Server and IBM DB2.

    Power View
    Power View opens up ad hoc reporting for consumers of data. It provides access to data based on PowerPivot workbooks or tabular models deployed to Sql Server Analysis Services 2012.
    NicEye IT Consulting can help with BI needs related to the tools built into SQL Server 2012 as well as previous versions of SQL Server.
    Power View is a feature of SQL Server reporting Services. It provides ad hoc reporting capability. Power View improves on Self-Service BI allowing presentation and data visualization of live data.

    Contained Databases
    Using a contained database can simplify database migrations and also improve the functionality of AlwaysOn.
    NicEye IT Consulting can help you understand and implement Contained databases.
    Contained databases are partially isolated from other databases on an instance of SQL Server. User authentication can be handled within the database and don’t require a SQL Server login. Many activities such as migrating a database to another server can be simplified with a contained database. There are objects that can’t be contained – things like linked servers, jobs, and stored procedures that are in databases external to the contained database. Contained databases can simplify database movement with AlwaysOn.

    Columnstore indexes
    Columnstore indexes add Columnar Storage capabilities to SQL Server 2012. The benefits for BI are substantially improved performance in querying large sets of data. Performance improvements of at least 10x are common in situations where Columnstore indexes are appropriate.
    NicEye IT Consulting can help you determine if Columnstore indexes are a good fit for your needs and also assist in implementing the indexes.
    Columnstore Indexes store data from a column in sets of pages. This is different from a normal SQL Server index where data from rows of data are stored in a set of pages. It is common to see a 10x performance improvement with a dramatic increase in IO.

    SQL Server Data Tools
    SQL Server Data Tools build on the capabilities of the Business Intelligence Design Studio. It adds capabilities for doing development and maintenance of databases with Visual Studio.
    NicEye IT Consulting can work with your developers to help with problem resolution and performance enhancement.
    SQL Server Data Tools is a replacement for Business Intelligence Development Studio. It allows you to do everything that you could do in BIDS as well as schema and data comparison, SQLCLR development, stored procedure debugging and tools for database development.

    Always On
    AlwaysOn provides enhanced availability of your critical SQL Server databases. With AlwaysOn you reduce unplanned downtime as well as planned downtime. AlwaysOn combines High Availability with Disaster Recovery.
    NicEye IT Consulting can assist you with an AlwaysOn implementation from planning to implementation to testing.
    AlwaysOn Availability Groups – Availability Groups enhance the feature set of database mirroring. Availability groups improve control over when failover occurs and allow groups of databases to fail as a unit. Availability groups allow you to configure up to four replicas of the group.
    Windows Server Failover Clustering – Availability Groups take advantage of enhancements to Windows Clustering. Windows Server Failover clustering solves two big problems: Problems with clustering SQL Server across subnets and the requirement for shared storage.

    6. Contact Us for Microsoft SQL Server Licensing

    In addition to offering SQL Server support, we can help you navigate Microsoft SQL Server licensing. Our expert team can coach you through your licensing needs evaluating your actual or intended usage, required features, hardware and other business rules to assure optimal performance and value.

    7. FAQs

    Below are the Frequently Asked Questions about the remote DBA/database administration services offered by Virtuatic DBA to address the database system administration and management needs of clients.

    1. What is Virtuatic DBA?
    Virtuatic DBA is a remote DBA/database administration service offering from NicEye IT Consulting to address the database system administration and management needs of its subscribers. Virtuatic DBA remotely monitors critical Microsoft SQL Server database operational functions and statistics on a daily basis to help ensure system availability, optimum performance and trouble-free operation, so you have expert database administrators available, when your system needs them. Our expert database administrators are also on-call and can be contacted by you with questions, or to get help when you need it.

    2. How does Virtuatic DBA work?
  • Statistics about your systems are collected throughout the day and sent to Virtuatic DBA service centers at regular intervals, where they are automatically filtered and centrally stored. A heartbeat process monitors the availability of your system and the communications channel to the Virtuatic DBA service centers. A primary and backup Virtuatic DBA database specialist are assigned to manage and monitor your systems and account.
  • When the statistics arrive, if monitored indicators are out of tolerance, an alert is generated automatically and Virtuatic DBA database specialists are notified. The Virtuatic DBA database specialist immediately notifies you of any critical issues and will work, with you, to a resolution. If non-critical issues are discovered, they will be documented and discussed with you during your regular status briefing, and then tracked to resolution.
  • Your Virtuatic DBA database specialist, for operational trend analysis identification, reviews past and present operational and performance data. Operational trends are important to system planning and in troubleshooting performance issues. Any trends will be documented and discussed with you during your regular status briefings and available reports.
  • The statistical information collected about your system and a complete case tracking history of our database specialist's actions are available, in the My Database area of this web site, for Virtuatic DBA subscribers. A quick online tour is available.
  • You will have a dedicated Virtuatic DBA available for database administration services and advice regarding any aspect of database design, troubleshooting, administration or management. These assigned Virtuatic DBA engineers will already be familiar with the key aspects of your system, installation, application and requirements, so when you have a problem or want some coaching you can speak to someone who already knows the basics about your system. These services are available by telephone or on-site consultation. The key feature is that expert help is available when it is needed, whether the need is for 30 minutes or several weeks.

  • 3. I don't have or want a full-time DBA. Why do I need Virtuatic DBA?
    An often overlooked fact is that most business information systems, whether developed in-house or purchased 'off the shelf' from application vendors, are designed to utilize a commercially available relational database management system. In order to properly maintain optimal performance and ensure system availability, someone who understands the technology must be assigned the task of supporting the database component of the business application. In most cases a full-time DBA is not a perfect fit, but Virtuatic DBA allows you to have a DBA on your terms, only when you need one.

    4. I already have a full-time DBA. Why do I need Virtuatic DBA?
    Are you looking to augment your current DBA staff? Do you need more coverage due to increased workload or attrition? Do you need coverage while your current DBA takes vacation or goes to training? Want to free up your DBA from doing routine maintenance to work on critical new business issues? Virtuatic DBA can support your current DBA by taking over the everyday monitoring and tuning tasks and alerting your DBA when issues are found. Short term coverage is also available for those times that your DBA needs to be away from your business. Your DBA gets support when it's needed and wanted.

    5. What does Virtuatic DBA cost?
    There is a monthly fee that covers the basic database operation monitoring and management features of the basic service and up to a set number of hours of remote consulting support per month. Since the service can be customized to meet your specific needs it is best to contact a Virtuatic DBA representative. Please contact VirtuaticDBA@NicEye.com or fill out our information request form.

    6. What do I do if I want some help with my database system?
    Your assigned Virtuatic DBA database specialist is a phone call away and is available for telephone, remote and on-site consulting, support and coaching. Since specific database specialists are assigned to monitor your systems they will already be familiar with your installation and setup which should save you and us time.

    7. Does Virtuatic DBA include backup and recovery?
    The monitoring of standard backup completion is included with the basic service. Virtuatic DBA does have the experience and resources to help you meet your entire backup and recovery needs and can customize the service offering as required.

    8. Is Virtuatic DBA a tool that can automatically tune the database engine?
    Not exactly. Virtuatic DBA is a tool to be used by you, where our experienced DBAs gather and analyze the information about your Microsoft SQL Server database to allow for its proper tuning. Expert guidance or consulting in tuning your database engine is always available from our experienced engineers.

    9. How will this service work in conjunction with my software vendor support?
    Relying on the vendor of the application that rides on the database does not yield an adequate level of database management. Their main focus is support of the application so they are not equipped to offer database support on a widespread basis to their client base. They cannot provide the regularly scheduled database management program required to meet the need. Often times, the vendor is familiar with the database only as a platform on which the software was built and is not able to give the necessary level of support. The Virtuatic DBA service is primarily focused on the database portion of your application. Since the service is highly customizable we can work with your software vendor support staff just as we would work with you. Your Virtuatic DBA can work with them on your behalf to represent your needs as they relate to your business and your database.

    10. What are the primary ways Virtuatic DBA will save me money?
    A few good examples of how Virtuatic DBA can provide return on investment are as follows:
  • The cost of database system downtime or of a poorly performing database system cannot easily be measured. Virtuatic DBA can keep your system properly tuned, even as your business or usage changes, through its regular monitoring of critical database operational functions and statistics ensuring system availability, trouble-free and optimum operation.
  • The time spent finding a qualified candidate to fill a database management position can be long. Virtuatic DBA has a staff of experienced professionals available when you want or need them.
  • The cost of a highly skilled database management professional can be high. Virtuatic DBA shares these professionals between a limited set of accounts. You get the quality support you want when you desire or require it.
  • The problem of retaining or training your skilled professionals can get expensive. You no longer have the worry of the training or retention cycle for your skilled professionals since Virtuatic DBA has the expert staff working for you from our offices.

  •  

     

     

     

     

     

    Copyright ©2013. All Rights Reserved.
    ^ Go to top