Enterprise Applications on Microsoft SQL Server
Fundamentals: Cloning a production database to a test server
Recently I had a conversation with someone who maintains an ISV offering. He is the acting SQL...
Author: Dr GUI Retired Date: 04/22/2011
CA: ARCServe r15 Support for Microsoft Platforms
I have listed below which Microsoft technologies are supported by CA's ARCserve® Backup Version...
Author: Dr GUI Retired Date: 04/22/2011
Tuning Enovia SmarTeam – Indexes – Part 1
[Prior Post in Series] [Next Post in Series] Adding indexes helps SQL Server retrieve records in a...
Author: Dr GUI Retired Date: 04/21/2011
Dassault: Taylor-Deal Aviation picked SQL Server for SolidWorks DB
Taylor-Deal Aviation (TDA), LLC, is an aviation consultancy providing engineering services for...
Author: Dr GUI Retired Date: 04/20/2011
OpenText: Business Development Bank of Canada using SQL Server for their Commercial Lending Solution
On March 28th, 2011 Business Development Bank of Canada (BDC) signed an agreement with the CGI Group...
Author: Dr GUI Retired Date: 04/20/2011
Telvent: The other Grid runs on SQL Server 2008
Telvent’s ArcFM Enterprise GIS Solution is a complete utility GIS solution covering electric,...
Author: Dr GUI Retired Date: 04/19/2011
Kronos: Oracle to SQL Server Migration – The Clock – Part 4
[Prior Post in Series] A reader sent an email asking how long does migration take. A good migration...
Author: Dr GUI Retired Date: 04/19/2011
PROS: Reducing the cost to health care by using SQL Server
A leading health care distribution company selected PROS on SQL Server to increase visibility into...
Author: Dr GUI Retired Date: 04/19/2011
MISYS: Summit FT moved to SQL Server 2008 to reduce costs and improve efficiencies
Misys has announced that Summit FT has migrated its product to SQL Server 2008 (32 bits) and...
Author: Dr GUI Retired Date: 04/18/2011
Itron: Central Maine Power Chooses SQL Server to run their Smart Grid Initiative
Itron's Enterprise Edition Meter Data Management (IEE MDM) with be used for this advanced smart grid...
Author: Dr GUI Retired Date: 04/18/2011
Telvent: ArcFM Support for Microsoft Platforms
I have listed below which Microsoft technologies are supported by Telvent ArcFM with the release of...
Author: Dr GUI Retired Date: 04/15/2011
Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes
[Prior Post in Series] [Next Post in Series] In my prior posts, I looked at adding indexes with...
Author: Dr GUI Retired Date: 04/15/2011
Tuning Enovia Smarteam at Langen Packaging Group – Summary
[Prior Post in Series] [Next Post in Series] Recently I had an opportunity to do an example tuning...
Author: Dr GUI Retired Date: 04/14/2011
Camstar: SQL Server handles their largest customer needs
Camstar Systems is a leading provider of enterprise manufacturing execution and quality systems....
Author: Dr GUI Retired Date: 04/14/2011
Desire2Learn: Improving Performance
Recently I reviewed some public posts on Desire2Learn SQL Server Performance and extracted some...
Author: Dr GUI Retired Date: 04/13/2011
Lawson: Support for Microsoft Platforms
I have listed below which Microsoft technologies are supported by Lawson M3 (7.1) and S3 (9.0)...
Author: Dr GUI Retired Date: 04/13/2011
Kronos: Oracle to SQL Server Migration – SQL Server Agent hiccup – Part 3
[Prior Post in Series] [Next Post in Series] In our prior posts we described some of the human-ware...
Author: Dr GUI Retired Date: 04/12/2011
Telvent: When the lights go out, SQL Server is working to turn them back on!
Telvent’s Responder Outage Management Solution (OMS) reduces outage time for customers from...
Author: Dr GUI Retired Date: 04/12/2011
Itron: Webcast on Best Practices for Deploying Itron Applications on SQL Server in April
Time to mark April 27th, 2011 at 10:00 AM Pacific on your calendars! Lonnye Bower, Developer...
Author: Dr GUI Retired Date: 04/11/2011
Desire2Learn: University of Colorado at Boulder Migrates to Desire2Learn Learning Suite on SQL Server
In February 2011, Desire2Learn announced that the University of Colorado at Boulder will be...
Author: Dr GUI Retired Date: 04/11/2011
Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes
[Prior Post in Series] [Next Post in Series] In my last post Fundamentals: Creating a Workload by...
Author: Dr GUI Retired Date: 04/08/2011
Desire2Learn: Support for Microsoft Platforms
I have listed below which Microsoft technologies are supported by Desire2Learn with the release of...
Author: Dr GUI Retired Date: 04/07/2011
CSC Point In: Insurance Administration Software is now on SQL Server
POINT IN supports end-to-end processing for all lines of insurance coverage, the company is...
Author: Dr GUI Retired Date: 04/06/2011
Kronos: Oracle to SQL Server Migration – Performance – Part 2
Author: This article is written by our contributing author Ken Lassesen. His bio can be found here...
Author: SQL Server ISV Date: 04/05/2011
Siemens PLM’s UniCam FX now running on SQL Server
I’ve been catching up on press releases for Siemens and noticed this one from January, 2011....
Author: Dr GUI Retired Date: 04/04/2011
Fundamentals: Creating a Workload by Using a Trace Log
[Next Post in Series] This is the kick-off post of a regular Friday series of posts, "Basic Skills...
Author: Dr GUI Retired Date: 04/01/2011
INFOR ERP: Flick Packaging choice SQL Server to control costs
Flick Packaging Company provides military and various commercial industries with packaging systems....
Author: Dr GUI Retired Date: 03/30/2011
INFOR ERP: Navico uses SQL Server and Syteline to replace older ERP system
Navico is a worldwide supplier of marine electronics with 2,500 employees globally. For Enterprise...
Author: Dr GUI Retired Date: 03/29/2011
Adding enhanced password constraints to SQL Server
[Prior Post in Series] [Next Post in Series] In my prior posts on applying PCIDSS standards to...
Author: Dr GUI Retired Date: 03/29/2011
Temporal constraints on Login in SQL Server
[Prior Post in Series] [Next Post in Series] In my prior posts on applying PCIDSS standards to...
Author: Dr GUI Retired Date: 03/28/2011
INFOR ERP: Finding all tables that uses a specific column name
Author: This article is written by our contributing author Ken Lassesen. His bio can be found here...
Author: SQL Server ISV Date: 03/22/2011
Kronos’ tips: Improving Performance
Advisor and Reviewer: Bryan deSilva, Managing Director and Chief Evangelist at Improvizations.com....
Author: Dr GUI Retired Date: 03/21/2011
Kronos’ tip: Avoiding an installation issue
Advisor and Reviewer: Bryan deSilva, Managing Director and Chief Evangelist at Improvizations.com....
Author: Dr GUI Retired Date: 03/21/2011
OPENTEXT Acquires Metastorm–a SQL Server based BPM product
On February 18, 2011 OPENTEXT acquired the Business Process Management (BPM) firm Metastorm, a...
Author: Dr GUI Retired Date: 03/15/2011
Best Practices Analyzer Exceptions expected for Dassault Systèmes ENOVIA
If you run the SQL Server 2005/2008R2 Best Practices Analyzer (see my prior post) on a for Dassault...
Author: Dr GUI Retired Date: 03/11/2011
Best Practices Analyzer Exceptions expected for PTC’s Windchill
If you run the SQL Server 2005/2008R2 Best Practices Analyzer (see my prior post) on a PTC Windchill...
Author: Dr GUI Retired Date: 03/11/2011
SQL Server Security – Additional Resources
[Prior Post in Series] The intellectual property (IP) stored on SQL Server in your PLM may be your...
Author: Dr GUI Retired Date: 03/11/2011
Expiring sessions after 15 minutes on SQL Server
[Prior Post in Series] [Next Post in Series] In my prior posts on applying PCIDSS standards to...
Author: Dr GUI Retired Date: 03/10/2011
Adding failed SQL Server Logon Support to a PLM SQL Server
[Prior Post in Series] [Next Post in Series] In my prior post on securing PLM systems (Enovia and...
Author: Dr GUI Retired Date: 03/07/2011
Best Practices Analyzer for ISV SQL Servers to protect your company’s property
The intellectual property(IP) or other valuable information may be stored on SQL Server in your ISV...
Author: Dr GUI Retired Date: 03/07/2011
Migrating from Oracle to SQL Server
[Next Post in Series: Kronos Migration] My first experience with data migration dates from the...
Author: Dr GUI Retired Date: 03/04/2011
Don’t let documents and mixed media complicate your product!
For the last twenty-five years, I have faced the pain of needing to store documents and mixed media...
Author: Dr GUI Retired Date: 03/04/2011
Improving SQL Server Security to PCIDSS Standards
Author: This article is written by our contributing author Ken Lassesen. His bio can be found here....
Author: SQL Server ISV Date: 03/02/2011
Right sizing ISV installations for the best bang for the buck!
Author: This article is written by our contributing author Ken Lassesen. His bio can be found here....
Author: SQL Server ISV Date: 02/28/2011