X
Software Functionality Revealed in Detail
We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.
Get free sample report

Compare Software Solutions
Visit the TEC store to compare leading software solutions by funtionality, so that you can make accurate and informed software purchasing decisions.
Compare Now
 

 my sql commands


NoSQL for My BI Solution?
Every day business intelligence (BI) gets closer to chaos. Don’t get me wrong—I’m by no means saying that BI will one day become obsolete and that you'll need

my sql commands  for My BI Solution? Every day business intelligence (BI) gets closer to chaos. Don’t get me wrong—I’m by no means saying that BI will one day become obsolete and that you'll need to avoid it at all costs. On the contrary, what I mean is that BI will have to go outside the box into a world where data is not nicely structured within well-defined databases and using Structured Query Language—best known as SQL . Because BI is no longer being used by only a small number of users (information worker

Read More


Software Functionality Revealed in Detail

We’ve opened the hood on every major category of enterprise software. Learn about thousands of features and functions, and how enterprise software really works.

Get free sample report
Compare Software Solutions

Visit the TEC store to compare leading software by functionality, so that you can make accurate and informed software purchasing decisions.

Compare Now

Documents related to » my sql commands

Case Study: Virtual Radiologic Speeds Delivery of Life-Saving Reports


Virtual Radiologic manages life-saving patient data, but it struggled with slow SQL performance and prohibitive upgrade costs. By avoiding legacy storage vendors and selecting a modern hybrid flash/HDD solution, it dramatically improved SQL performance, slashed costs, and accelerated delivery of radiology results to clients, ultimately improving healthcare delivery. Learn how in this real-world case study.

my sql commands  Study: Virtual Radiologic Speeds Delivery of Life-Saving Reports Virtual Radiologic manages life-saving patient data, but it struggled with slow SQL performance and prohibitive upgrade costs. By avoiding legacy storage vendors and selecting a modern hybrid flash/HDD solution, it dramatically improved SQL performance, slashed costs, and accelerated delivery of radiology results to clients, ultimately improving healthcare delivery. Learn how in this real-world case study. Read More

Up Close and Personal: Martin Schneider, Senior Director of Communications at SugarCRM-Part 2


In part one of my interview with Martin Schneider, Senior Director of Communications at SugarCRM, we discussed the history of SugarCRM and the open source customer relationship management (CRM) space. Part 2 describes SugarCRM’s approach to development, their partner ecosystem, and how social media has changed CRM.Q: About development—most of it is done by your team of programmers

my sql commands  In part one of my interview with Martin Schneider , Senior Director of Communications at SugarCRM , we discussed the history of SugarCRM and the open source customer relationship management (CRM) space. Part 2 describes SugarCRM’s approach to development, their partner ecosystem, and how social media has changed CRM. Q: About development—most of it is done by your team of programmers, right?   A: That’s correct. Engineering is done more than 90 percent in house. We have set up this model because, Read More

Taking Stock of Infor’s HCM “Inventory Items” - Part 2


Part 1 of this blog series started by expressing the “New Infor” sentiments (backed up with concrete examples and rationale) following my recent attendance of Inforum 2012. Then the article provided some historical background and described the lineage of the products that currently form the Infor10 HCM portfolio. The article also detailed some technical and organizational issues on both the

my sql commands  examples and rationale) following my recent attendance of Inforum 2012 . Then the article provided some historical background and described the lineage of the products that currently form the Infor10 HCM portfolio. The article also detailed some technical and organizational issues on both the former heritage Infor and Lawson Software ’s human resource (HR) and talent management products’ side. In light of these issues, which were discussed in Part 1 , it is small wonder that some market observers Read More

Businesses in Motion: SAP HANA + Microsoft Kinect, and More


A recent note that landed on my plate really grabbed my attention: As part of a long partnership, Microsoft and SAP jointly gave a demo in which Microsoft Kinect was used to exploit SAP’s HANA capabilities. Seeing data being managed by a motion-based device made me want to write a post speculating about the way users and computers will interact in the future. First: Is it too early

my sql commands  note that landed on my plate really grabbed my attention: As part of a long partnership, Microsoft and SAP jointly gave a demo in which Microsoft Kinect was used to exploit SAP’s HANA capabilities. Seeing data being managed by a motion-based device made me want to write a post speculating about the way users and computers will interact in the future. First: Is it too early for adoption of this type of technology? Well, maybe not. It seems the door might be opening for a new way of interacting with Read More

How to Overcome SQL Server Maintenance Challenges


For SQL server administrators, it is very important to analyze SQL server performance and storage structure regularly, and get information that will help to manage SQL server capacity, performance and storage issues, as well as its forecast future requirements. Administrators should be completely aware of the entire SQL server environment and the status of different performance and storage parameters. Download the white paper.

my sql commands  to Overcome SQL Server Maintenance Challenges For SQL server administrators, it is very important to analyze SQL server performance and storage structure regularly, and get information that will help to manage SQL server capacity, performance and storage issues, as well as its forecast future requirements. Administrators should be completely aware of the entire SQL server environment and the status of different performance and storage parameters. Download the white paper. Read More

Prophet 21


Prophet 21 enterprise software solution for wholesale distribution, utilizes a Windows-based platform and a Structured Query Language (SQL) Server database. This technology gives Prophet 21the familiarity of other Windows programs and can shorten the learning curve for new users. Prophet 21 includes the following functionality: order management, which features one-screen quote and order entry, customer relationship management (CRM), and pricing and availability features; inventory management, which can help reduce inventory levels while improving customer service; warehouse management, which provides flexible real-time control, and is designed to help minimize inventory losses, decrease shipping errors, and increase profitability; purchasing, which automates processes from a centralized location in order to optimize buying power and inventory levels across multiple warehouses and stocking locations; financial management, which includes real-time general ledger capabilities as well as cash collections and accounts receivable processes; and reporting and analysis. In addition, Prophet 21 is fully compatible with Trading Partner Connect, which can help streamline the commerce process between distributors, manufacturers/suppliers, and end users. Prophet 21 can be implemented either on site or remotely via an application service provider (ASP) or a hardware hosting option.

my sql commands   Read More

CRM for the Finance and Banking Industry - Part 1


How many different systems does a bank employee use when changing a customer’s contact information? The last time I moved and had to change my address, the bank employee used two systems, asked three or four of her co-workers for help, and took about 15 minutes to do it because the information from one system did not transfer right away to the other system. It goes without saying that this was not

my sql commands  and had to change my address, the bank employee used two systems, asked three or four of her co-workers for help, and took about 15 minutes to do it because the information from one system did not transfer right away to the other system. It goes without saying that this was not my best experience dealing with banks, but not the worst either. Actually, having implemented business solutions in the past, I find it quite amusing when it happens because it reminds me of the “good old days” when I used to Read More

Databases and ERP Selection: Oracle vs. SQL Server


The database is an essential component of enterprise applications such as enterprise resource planning (ERP) and enterprise asset management (EAM). This white paper outlines the advantages and disadvantages of the Oracle and Microsoft SQL Server database platforms. How do the two compare when it comes to reliability, scalability, and total cost of ownership (TCO) when integrated with enterprise software?

my sql commands  and ERP Selection: Oracle vs. SQL Server The database is an essential component of enterprise applications such as enterprise resource planning (ERP) and enterprise asset management (EAM). This white paper outlines the advantages and disadvantages of the Oracle and Microsoft SQL Server database platforms. How do the two compare when it comes to reliability, scalability, and total cost of ownership (TCO) when integrated with enterprise software? Read More

Inprise/Borland Challenges Other Vendors to Open-Source Their Database Code


In a move which will challenge other database vendors to open-source their SQL databases, Inprise/Borland Corporation has announced it is releasing the source code for its InterBase 6 cross-platform SQL database. It will provide the database on multiple platforms, including Linux, Windows NT, and Sun Solaris, make the database available at no charge, and spin the InterBase division off into a separate company.

my sql commands  NASA, and the U.S. Army, so support for the product is sure to continue. Read More

My PLM Video Playlist on YouTube


A little heads-up: We’re going to start having videos on TEC’s Web site. We'll produce videos in the future but the first step we’ll start with is a library of links to freely available ones from YouTube. Although YouTube mainly serves as a source of entertainment, there are videos for other purposes as well. After a little searching and watching, here is my playlist of YouTube videos related to

my sql commands  and watching, here is my playlist of YouTube videos related to product lifecycle management (PLM) . Dr Michael Grieves - Author and International PLM Expert : This video contains an interview with Dr. Grieves at the European PLM Summit on June 25 th , 2008. Although the interview took place nearly two years ago, his opinions on how to understand the PLM concept are still highly valuable. Lean Product Development : This video is actually an introduction to a course titled Lean Product Development given by Read More

Dassault Systèmes Introduces “Licensed to Cure”


While the tagline didn't really tickle my fancy, it's evidence that Dassault Systèmes’ novel go-to-market approach is apparently by industry. Within each industry, there are multiple “experiences”—software packages that address specific business needs, if you will. The "Licensed to Cure" solution looks like a core product lifecycle management (PLM) functionality package for medical

my sql commands  tagline didn't really tickle my fancy, it's evidence that Dassault Systèmes’ novel go-to-market approach is apparently by industry. Within each industry, there are multiple “experiences”—software packages that address specific business needs, if you will.  The Licensed to Cure solution looks like a core product lifecycle management (PLM) functionality package for medical device manufacturers (similar to the recent “Perfect Shelf” experience for retail and consumer goods manufacturing). Read More

Legacy ERP Modernization: Prudence is Gold


I am sure that after reading my previous blog post on manufacturing legacy systems many readers saw me as just another soldier of AS/400 system’s army of opponents and probably would not expect any future pro-System i/AS/400 publications. This is definitely not the case—I am not a legacy system opponent. The message I’ve been trying to deliver in my blog posts is  that a well-thought out, balanced

my sql commands  sure that after reading my previous blog post on manufacturing legacy systems many readers saw me as just another soldier of AS/400 system’s army of opponents and probably would not expect any future pro-System i/AS/400 publications. This is definitely not the case—I am not a legacy system opponent. The message I’ve been trying to deliver in my blog posts is  that a well-thought out, balanced, and systematically  formed business software portfolio is important even though the platform of the Read More

They do it like that in the Balkans -- Select and deploy ERP, I mean (Part I)


The launch of TEC’s blog has somewhat coincided with my visit to Belgrade, Serbia (what used to be Yugoslavia and then Serbia @ Montenegro) for personal reasons. Those several days spent in my homeland in late October/early November (whereby I missed my beloved Boston Red Sox’ winning the MLB World Series ’07 Championship, darn it!) I at least used this time to also learn about the enterprise

my sql commands  November (whereby I missed my beloved Boston Red Sox’ winning the MLB World Series ’07 Championship , darn it!) I at least used this time to also learn about the enterprise applications market in that region, and maybe even in the entire Balkan region. I have never seen any such market report from any other analyst house about this (possibly obscure) region, and I thought this topic might be of interest to our (curious) readers as well as to me. To be fair, I've seen other similar trip reports, such Read More

Bad Customer Support Is Not a Software Problem


A couple of days ago, my laptop decided (all on its own) to jump off my desk. Lucky for me, it survived almost completely undamaged except for a broken latch, which seemed easy enough to fix. So I decided to order the replacement part and fix it myself. Since I didn’t know exactly what part I needed to order, I started by calling the vendor’s Technical Service number. I

my sql commands  couple of days ago, my laptop decided (all on its own) to jump off my desk. Lucky for me, it survived almost completely undamaged except for a broken latch, which seemed easy enough to fix. So I decided to order the replacement part and fix it myself. Since I didn’t know exactly what part I needed to order, I started by calling the vendor’s Technical Service number. I described the problem and asked if the rep could tell me what part I needed, whether it was available, and how much it cost. He Read More