Expanding the Market: MS SQL Server 2017 and Linux

By | Blog, Database Technology Trends, SQL Server
Microsoft’s exciting cross-platform product, SQL Server 2017, is poised to reach a whole new audience. Recently this industry leader has joined the growing trend of support for open source solutions.  Our team is continually investigating new innovations for our clients, and we wanted to share what we have discovered about new features and performance. Why Now? Linux is becoming increasingly popular thanks to its security, stability, and efficiency.  Its design protects against virus and malware attacks with a complex architecture and secure user account structure.  With more and more businesses choosing Linux, Microsoft realized they were forcing clients to manage multiple environments by keeping SQL Server only on Windows.  Rohan Kumar, then General Manager of Microsoft Database Systems, discussed the decision with Frederic Lardinois for Tech Crunch.  “We had a couple of discussions in the past where it wasn’t approved,” he told Lardinois, but four years ago his team recognized the value of expanding, so they pitched the idea once again. “The biggest surprising part was that we were expecting a whole lot of back and forth. It was really surprising to see how quickly the decisions got made,” recalls Kumar. How? With the company’s support in place, Kumar’s team needed (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…)

SAP Sybase Replication Server 15.6 | Real Time Loading into SAP Sybase IQ

By | White Papers | No Comments

SAP Sybase has developed a new, innovative and dynamic staging technology, allowing full use of the native, high-speed data load mechanism SAP Sybase IQ offers . . . Real Time Loading (RTL).

RTL addresses the need to have another system prepare the data for load by taking real time data movement from the source database, and applying staging technology to the data transfer in the background.

Up until now, the only option for loading data from an Online Transaction Processing (OLTP) database . . . airline reservation systems, financial transactions, etc., into a SAP Sybase IQ data warehouse was a so-called staging process. Staging means that the OLTP is isolated from the data warehouse loading process to ensure data integrity, due to the rapidly changing data content in the OLTP database systems.

Direct replication into SAP Sybase IQ was limited to low data movement environments. The reason lies in the fundamental differences on how SAP Sybase IQ processes data, and data movement strategies SAP Sybase Replication Server applies.

SAP Sybase IQ is a column vector database. Retrieving a single row requires assembling the row from each column component. This process makes row by row processing ineffective, and the so- called “trickle feed” loading of SAP Sybase IQ nearly impossible. The advantage of a column vector database is in the unmatched speed for complex data retrieval operations and data aggregation on huge data sets.

Download the White Paper for FREE!!

Read More

Newsletter August 2012

By | Dobler Consulting Newsletter | No Comments
[lead]

Hello, Readers!

Summer is racing by, and 2012 is moving along faster than I had imagined.  I am happy to bring you the first newsletter on our new multi-device website, where you can view content from anywhere. Our “words to the world” are now available on pc’s, tablets, and mobile phones. Please take some time to see our new look on our expanded website at www.doblerconsulting.com. Viewing it from your tablet or smartphone will demonstrate its flexibility. Send me a note if you want a website like this one. 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…)

Database Technology For 2012

By | SQL Server, Sybase | No Comments

Everywhere we turn this year, we see database technology companies continuing to grow and expand with new offerings for improving computer systems to help you support your company’s important business decisions.

This month’s newsletter describes 3 database technologies that offer new promise for improving performance: Sybase® ASE 15.7, Sybase® IQ 15.4, and Microsoft SQL Server® 2012 RC0.

Sybase® ASE.15.7

Read More

Newsletter December 2011

By | Dobler Consulting Newsletter | No Comments
[lead]

To all my readers, Happy Holidays! I hope your holidays with family and friends are a source of joy this year. During this time, I’m grateful for you, as my loyal email subscribers. Thank you for reading my newsletter, and giving me the opportunity to share technology information to help improve your database skills and knowledge to become more successful.

I appreciate your continued support! Read More