Event – Planning and Executing a Successful SQL Server Database Migration

By | Blog | No Comments
Hillsborough SQL User Group Meeting – 4/27/2017 Please join us at a new location for the Hillsborough SQL User Group on Thursday, April 27th.  Dobler Consulting will be hosting our group at the Corporate Center I – Conference room (Suite 122) located at the West Shore entrance to the International mall.   The address is: 2202 North Westshore Boulevard Suite 122 Tampa, FL 33607 Parking is available at the west entrance (airport side).  Please follow the Visitor parking signs past the garage and around the fountain. Featured Presentation: Planning and Executing a Successful SQL Server Database Migration Carlos Colon, DBA Manager Dobler Consulting Migrating an existing database to SQL Server requires much more than just moving the schema and data. They key to a successful database migration effort includes designing the target system, identifying all components from the existing system that will need to be migrated, and allowing adequate time for changes and testing. In this session we will discuss all the different database components and configuration items that will need to be considered during the migration effort, how to utilize the SQL Server Migration Assistant as a planning and implementation tool, what components cannot be migrated (and what can be done (more…)

How to Hire the Right DBA, Remote or Onsite

By | Blog | No Comments
In this post, let’s take a closer look at how to hire the best database administrator for your company. Establish and Share Your Expectations For the benefit of your company and your potential candidates, clearly define the DBA’s role and your expectations in a thoughtful, detailed job description. Provide a thorough, specific list of daily and periodic tasks the DBA will perform. Clarify whether the DBA will be providing production support, development support, or support for a hybrid of the two, wherein several third party applications are involved. Production vs. Non-Production DBAs The prime objective of a production database administrator is to keep your system running with as little disruption as possible. A DBA in this scenario, would rather keep today’s business processes running before taking radical actions to resolve an issue, this is a case by case decision and needs careful consideration. A non-production DBA is more likely to approach things differently, using trial and error and being more cavalier about when to perform system reboots, checks and maintenance. DBAs should instinctively seek to isolate the problem, minimize its impact on workflow, and keep the production system running. A key trait to actively seek in a DBA is the (more…)
DBA burnout

Avoid DBA Burnout: 5 Steps for Management

By | Blog | No Comments
As the importance of database administrators – DBAs – continue to grow, along with a strong economy that offers an abundance of DBA job openings, many companies are concerned about the threat of DBA turnover. Your DBA is responsible for the performance, integrity, and most importantly, the security of your database every day, including nights, weekends, and holidays. Any down time, and your company can suffer lost revenue, or even worse, a significant data breach. The nature of this work lends itself to burnout because it is a daily, ongoing challenge and seemingly never complete. With these constant stresses, many DBAs often feel overlooked and as though they perform a thankless job. Some fear they’re only noticed when the inevitable hiccups in database systems occur. There is no shortage of job opportunities for talented DBAs, and there are only so many to go around. More and more companies are making it a priority to keep their DBAs happy to avoid burnout and thereby minimizing the chance they will proactively seek out a new opportunity. Following are some practical ways to keep your DBA engaged at your company to reduce the risk of turnover. 5 Steps to Prevent Burning Out Your (more…)
Sybase Cluster

Remote Database Service: Empowerment For Your DBA

By | Database Technology Trends | No Comments

Consider your database administrator (DBA). Most DBAs spend their workdays on capacity planning, installation, configuration, migration, performance monitoring, security, troubleshooting, backup, and data recovery — after they have resolved all the trouble tickets and answered all the panic-stricken user calls.

Read More

FREE Webinar: SAP ASE Security Features – The Most Important Information For Your Organization

By | Webinars | No Comments

Join us for the “SAP ASE Security Features – The Most Important Information For Your Organization” Webinar,

Thursday, March 19th, 1pm EST

The recent data security breaches make it painfully clear, security as we know it changed forever. As FBI Director James Comey recently stated “There are two kinds of big companies in the United States. There are those who’ve been hacked by the Chinese, and those who don’t know they’ve been hacked by the Chinese.” How do you navigate these rough waters? As a DBA Manager, how do you ensure your layer is protected? Read More

ISUG-TECH Annual Conference 2014 – A Stellar Inaugural Performance

By | Database Technology Trends, Sybase | No Comments

ISUG2014Dobler Consulting just completed their first major sponsorship of a major event and we are happy that it was the ISUG-TECH Conference in Atlanta. To summarize the inaugural ISUG-TECH Conference 2014 in one word, outstanding. That was the feedback we got from the attendees and also from our fellow sponsors. Yes, at first it felt like a huge family reunion as attendees arrived at the hotel on Sunday for the per-conference workshops and on Monday for the conference itself. But the high spirits continued after the attendees enjoyed high quality workshops and presentations. I believe there was not a single presentation that didn’t get the highest marks. Read More

Tampa Bay International Sybase User’s Group Chapter Enhances Member Benefits

By | Press Releases, What's New | No Comments
[lead] Peter Dobler, of Dobler Consulting, www.doblerconsulting.com, is spearheading the Tampa Bay International Sybase Users Group with monthly meetings to share best practices for becoming more effective Sybase DBA’s, database designers, and software engineers. [/lead] Dobler plans to strengthen the group by creating regular, on-going meetings to exchange ideas with like-minded database professionals, and promote Sybase technology information sharing. Because of SAP’s current position with Sybase, new interest in Sybase technology is gaining a large foothold with companies world-wide. Sybase User Groups are connecting members to share best practices, new technologies, performance topics, valuable content, and fresh ideas through ISUG meetings. Dobler says:”It’s been several years since a Sybase User Group meeting has been held in Tampa. Now is the time to restart this event, and rally the Sybase community in Tampa.” Dobler’s main focus is to keep members abreast of the latest goings-on in the technology arena. He is dedicated to help database professionals achieve their goals, and improve their company’s Sybase systems by brainstorming about Sybase technology. Dobler’s goal is to provide added benefits to members:”Every attempt will be made to have renowned speakers, and attractive topics to draw diverse attendees. Although the main focus is on current (more…)

Sybase Ranks as Number 1 in IDC White Paper for Lowest Database Costs Over 5 Years

By | Sybase | No Comments
International Data Corporation (IDC), the premier provider of market intelligence, and advisory services for IT companies, has written an insightful white paper about the true cost of database ownership for companies: “Calculating the True Cost of RDBMS Ownership and How Sybase ASE Stacks Up: A Guide for SAP Business Suite Users.” IDC interviewed 12 large organizations with over 12,000 employees who have RDBMS systems, who are in a variety of industries. Six of the companies are running databases from multiple vendors. Here are some of their conclusions. (Note: These findings are for a five year total cost per 100 users and a 240 gigabyte database). Sybase ASE 15.7 total costs for the 5 years are $339,773. Using Sybase saved each of these 12 companies $128,580 over other RBDMS. These savings were reflected in IT staffing, hardware, software licenses, and database downtimes. The following features contributed to this large cost savings: Automated functions for DBA’s Self-management capabilities for databases to tune themselves Data compression to reduce storage footprint Large object blocks (LOBs) stored in-row, rather than as separate objects. In-place execution of operations instead of using temp storage After describing Sybase’s ability to lower the total costs of operation, IDC suggests (more…)

Sybase ASE 15 Cluster Edition Step-By-Step Installation – Part 5

By | Sybase Tips, Technology Tips & Tricks | No Comments

Part 5 is the final part of the series and shows how to add an additional node to an existing Sybase cluster.

The 5 parts of this series are:

The instructions designed that non-Sybase DBA can perform these tasks. Sybase DBA will find that the steps are very similar to your standard ASE installation.

Please click here to read about how to setup and test the Sybase Cluster.

Add an Additional Node to the Sybase Cluster

Preparation

The process adding a node to the cluster can be executed when the cluster is active. The steps are very simple and non-intrusive.

Note: As a pre-requisite the steps to setup the Linux environment for the original nodes must be followed before actually adding a node to the Sybase ASE cluster. The new node should already be configured with all network adapters, all the disks should have be mounted with right permissions etc.. Since the /sybase filesystem is a NFS share no other extra steps are needed for this preparation step. Simply follow the steps in the installation description. The only new raw filesystem that will be added is the temp device for the tempdb on the new node. This will be the new raw device raw 9 and must be mounted to all nodes.

The new /etc/raw looks like this and has to be the same in all nodes (asece1,asece2,asece3):

sybase@asece3:~> cat /etc/raw
# /etc/raw
#
# sample configuration to bind raw devices
# to block devices
#
# The format of this file is:
# raw:
#
# example:
# ---------
# raw1:hdb1
#
# this means: bind /dev/raw/raw1 to /dev/hdb1
#
# ...
raw1:sdb1
raw2:sdc1
raw3:sdd1
raw4:sde1
raw5:sdf1
raw6:sdg1
raw7:sdh1
raw8:sdi1
raw9:sdj1
sybase@asece3:~>

Please make sure that the /dev/raw/raw9 is owned by the sybase user.

Read More

Sybase ASE 15 Cluster Edition Step-By-Step Installation – Part 4

By | Sybase Tips, Technology Tips & Tricks | No Comments

Part 4 of the 5 part series on the step by step installation post focuses on setting up the Sybase cluster. Part 1 has a list and links to the download pages for this software.

The 5 parts of this series are:

The instructions designed that non-Sybase DBA can perform these tasks. Sybase DBA will find that the steps are very similar to your standard ASE installation.

Please click here to read about how to install the Sybase software.

Sybase Setup

Run uafstartup.sh

Before continuing with the cluster install, each node needs to have a running agent waiting for the connection. Without this agent Sybase Cluster Edition will not install nor run.
On asece1 and asece2 as user sybase run this command.

$SYBASE_UA/bin/uafstartup.sh &

This is the out from running the command. Make sure no errors are displayed.

sybase@asece1:~> $SYBASE_UA/bin/uafstartup.sh &
[1] 12142
sybase@asece1:~>
Node: asece1
Operating System: Linux
OS Architecture: x86_64
OS Version: 2.6.16.60-0.21-default
JAVA Runtime: /sybase/shared/jre150_012
java version "1.5.0_12"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
Java HotSpot(TM) 64-Bit Server VM (build 1.5.0_12-b04, mixed mode)
Message level: WARN
Creating a UAF nodes subdirectory representing the node asece1
Agent Home: /sybase/UAF-2_5/nodes/asece1
2008-11-25 15:44:53,500 INFO [main] Starting Unified Agent...
2008-11-25 15:44:53,508 INFO [main] Version: 2.5.0(983)
2008-11-25 15:44:53,705 INFO [main] Initializing BootstrapService...
2008-11-25 15:44:53,705 INFO [main] Starting BootstrapService...
2008-11-25 15:44:54,196 INFO [main] Host: asece1.cluster.local
2008-11-25 15:44:54,199 INFO [main] Agent home: /sybase/UAF-2_5/nodes/asece1
2008-11-25 15:44:54,409 INFO [main] Loading 7 primordial services...
2008-11-25 15:44:54,616 INFO [main] Registered Agent Service
2008-11-25 15:44:55,253 INFO [main] Initializing Agent Service...
2008-11-25 15:44:55,257 INFO [main] Starting Agent Service...
2008-11-25 15:44:55,802 INFO [main] Registered Environment Service
2008-11-25 15:44:56,516 INFO [main] Registered Configuration Service
2008-11-25 15:44:57,229 INFO [main] Registered Session Service
2008-11-25 15:44:57,543 INFO [main] Registered Security Service
2008-11-25 15:44:58,180 INFO [main] Registered Service Registration Service
2008-11-25 15:44:58,218 INFO [main] Initializing Service Registration Service...
2008-11-25 15:44:58,219 INFO [main] Starting Service Registration Service...
2008-11-25 15:44:58,656 INFO [main] Validated 9 extended services.
2008-11-25 15:44:58,656 INFO [main] Check circular dependencies...
2008-11-25 15:44:58,657 INFO [main] OK. No circular dependencies are found.
2008-11-25 15:44:58,837 INFO [main] Initializing RMI Service...
2008-11-25 15:44:58,928 INFO [main] Starting RMI Service...
2008-11-25 15:44:59,588 INFO [main] Agent URL in long format: service:jmx:rmi:///jndi/rmi://asece1.cluster.local:9999/agent
2008-11-25 15:44:59,588 INFO [main] Agent URL in short format: rmi://asece1.cluster.local:9999
2008-11-25 15:44:59,589 INFO [main] TDS Service will not be registered because registerOnStartup is false.
2008-11-25 15:44:59,592 INFO [main] SNMP Service will not be registered because registerOnStartup is false.
2008-11-25 15:44:59,593 INFO [main] DeploymentService: Found 1 dependencies.
2008-11-25 15:44:59,593 INFO [main] Dependent service RemoteShellService needs to be registered...
2008-11-25 15:44:59,809 INFO [main] DeploymentService: successfuly resolved dependencies.
2008-11-25 15:44:59,931 WARN [main] The template directories has been preset to: [/sybase/UAF-2_5/nodes/asece1/templates] 2008-11-25 15:45:00,275 INFO [main] SelfDiscoveryService: Found 1 dependencies.2008-11-25 15:45:00,279 INFO [main] Dependent service RMIService already registered.
2008-11-25 15:45:00,280 INFO [main] SelfDiscoveryService: successfuly resolved dependencies.
2008-11-25 15:45:00,801 INFO [main] Initializing Plugin Registration Service...2008-11-25 15:45:00,801 INFO [main] Starting Plugin Registration Service...
2008-11-25 15:45:00,875 INFO [main] Validated 2 plugin directories.
2008-11-25 15:45:01,238 INFO [main] Plugin registered. Updating lookup info...
2008-11-25 15:45:01,392 WARN [main] The Sybase home directory should be specified in the com.sybase.sysam agent-plugin.xml file.
2008-11-25 15:45:01,786 WARN [main] The Sysam home directory should be specified in the com.sybase.sysam agent-plugin.xml file.
2008-11-25 15:45:01,789 WARN [main] Log file could not be located. This may be that the license manager has not been started
2008-11-25 15:45:02,240 INFO [main] Plugin com.sybase.ase.snmp_2.0.0: Found 2 dependencies.
2008-11-25 15:45:02,419 INFO [main] Validated 9 extended services.
2008-11-25 15:45:02,420 INFO [main] Check circular dependencies...
2008-11-25 15:45:02,420 INFO [main] OK. No circular dependencies are found.
2008-11-25 15:45:02,425 INFO [main] TdsService: Found 1 dependencies.
2008-11-25 15:45:02,425 INFO [main] Dependent service RMIService already registered.
2008-11-25 15:45:02,426 INFO [main] TdsService: successfuly resolved dependencies.
2008-11-25 15:45:02,849 INFO [main] Validated 9 extended services.
2008-11-25 15:45:02,850 INFO [main] Check circular dependencies...
2008-11-25 15:45:02,850 INFO [main] OK. No circular dependencies are found.
2008-11-25 15:45:03,770 INFO [main] Plugin com.sybase.ase.snmp_2.0.0: successfuly resolved dependencies.
2008-11-25 15:45:04,059 INFO [main] Plugin registered. Updating lookup info...
2008-11-25 15:45:04,076 INFO [main] Finished loading primordial services.
2008-11-25 15:45:04,076 INFO [main] Bootstrap completed successfully.
sybase@asece1:~>

Run sybcluster

Read More