TechNet Blogs

Resources

Benchmarks
Kronos WFC 6.1 on SQL 2008 Benchmark: This white paper describes how SQL Server 2008 provides an optimal, enterprise ready, highly scalable data platform for Kronos Workforce Central® version 6.1, as demonstrated in a number of large-scale benchmarking studies performed jointly by Kronos and Microsoft.
Whitepapers
Kronos WFC on SQL Server 2008 Best Practices for Enterprise Customers: This white paper provides best practices for configuring and running Kronos Workforce Central on the SQL Server database platform.
High Availability Options for Kronos Workforce Central Suite on SQL Server: This whitepaper provides recommendations for configuring high availability options for the SQL Server database platform running Workforce Central.
Case Studies
Aerotek, a global Staffing Provider Lowers TCO and Sharpens Competitive Edge : The Kronos-SQL Server solution has lowered Aerotek's total cost of ownership (TCO) and enabled it to better monitor costs, increase reliability, and improve business insights and customer service.

Kronos - related blog posts

| |

Enterprise Applications on Microsoft SQL Server

Kronos: One Server or Two?

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
This is another "Best-of" reposting from our older website. I should add an clarification that by "server" we mean physical boxes and not virtual machines on the same physical server. The original post is here . Here is an easy-to-implement suggestion...
Enterprise Applications on Microsoft SQL Server

Kronos: Fifth Third Bank managing 21,000 employees on SQL Server

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Fifth Third Bancorp is one of the largest banks in the U.S. with over $111 billion in assets and operates in the mid-west. Fifth Third is using Kronos' managed services with full hosting based on Microsoft SQL Server to support 21,000 employees in 12...
Enterprise Applications on Microsoft SQL Server

Kronos: Scalability Whitepaper for SQL Server 2005

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
I have been going though posts on our old blog to select a few "Best of" repostings. While SQL Server 2008 R2 is clearly the best choice, with some recent studies suggesting a 10% performance improvement over SQL Server 2005, often corporate policy may...
Enterprise Applications on Microsoft SQL Server

Migration: The value gained moving from Oracle to SQL Server 2008R2

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[DB2 Migration Value] [ Sybase Migration Value ] In the early 1980's I was an Oracle Developer on mainframes and on MS-DOS using Oracle 5.1 on MS-DOS (distributed on some 20+ diskettes -- I still have them). It was an interesting time because PC products...
Enterprise Applications on Microsoft SQL Server

Kronos: Improving the performance of ad-hoc reports up to 3600%

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
One of Kronos' features is the ability to build ad-hoc reports. With SQL Server, the ability for a power-user to generate almost any type of report exists. The issue often arises that while you get your report -- eventually; the performance time is not...
Enterprise Applications on Microsoft SQL Server

Kronos: Oracle to SQL Server Migration – The Clock – Part 4

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] A reader sent an email asking how long does migration take. A good migration consists of at least three passes: Prototype migration : the purpose is to learn the steps required for your migration. Discover and resolve unexpected...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Improving Insert and Update Performance by Dropping Unused Indexes

Posted over 2 years ago

by Ken Lassesen
- 3 Comments
[Prior Post in Series] [Next Post in Series] In my prior posts, I looked at adding indexes with Database Engine Tuning Advisor. In this post, I will look at the other side of the coin and delete indexes that are unused or that cost more resources than...
Enterprise Applications on Microsoft SQL Server

Kronos: Oracle to SQL Server Migration – SQL Server Agent hiccup – Part 3

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] [Next Post in Series] In our prior posts we described some of the human-ware issues encountered dealing with the degree of access that Javed Iqbal, a Kronos employee and migration expert, was granted. Javed is using SQL Server...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Running Database Engine Tuning Advisor and Selecting Indexes

Posted over 2 years ago

by Ken Lassesen
- 1 Comments
[Prior Post in Series] [Next Post in Series] In my last post Fundamentals: Creating a Workload by Using a Trace Log , I illustrated how to create a workload. In this post, I will look at the complimentary step, using the log as input to the Database...
Enterprise Applications on Microsoft SQL Server

Kronos: Oracle to SQL Server Migration – Performance – Part 2

Posted over 2 years ago

by SQL Server ISV
- 3 Comments
Author: This article is written by our contributing author Ken Lassesen. His bio can be found here [Prior Post in Series] [Next Post in Series] This is part of the post-arc started by this overview of Migrating from Oracle to SQL Server ,...
Enterprise Applications on Microsoft SQL Server

Fundamentals: Creating a Workload by Using a Trace Log

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Next Post in Series] This is the kick-off post of a regular Friday series of posts, " Basic Skills for SQL Server ISV Administrators ". I have found that ISV Administrators are often Professional Engineers (P.E.) -- rich in business knowledge and...
Enterprise Applications on Microsoft SQL Server

Kronos: Oracle to SQL Server Migration – Part 1

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Prior Post in Series] [Next Post in Series] This is part of the post-arc started by this overview of Migrating from Oracle to SQL Server , and deals with experiences with Kronos migrations. I have been following Kronos’ employee, Javed Iqbal...
Enterprise Applications on Microsoft SQL Server

Kronos’ tips: Improving Performance

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Advisor and Reviewer: Bryan deSilva, Managing Director and Chief Evangelist at Improvizations.com . His bio can be found here . Recently I had a conversation with Bryan deSilva, Chief Evangelist of Improvizations , a firm that specializes...
Enterprise Applications on Microsoft SQL Server

Kronos’ tip: Avoiding an installation issue

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
Advisor and Reviewer: Bryan deSilva, Managing Director and Chief Evangelist at Improvizations.com . His bio can be found here . Recently I had a conversation with Bryan deSilva, Chief Evangelist of Improvizations , a firm that specializes...
Enterprise Applications on Microsoft SQL Server

Best Practices Analyzer for ISV SQL Servers to protect your company’s property

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
The intellectual property(IP) or other valuable information may be stored on SQL Server in your ISV product. Its value is more than credit card records (credit cards can be cancelled if lost, IP can’t). It may be the equivalent of a state secret...
Enterprise Applications on Microsoft SQL Server

Migrating from Oracle to SQL Server

Posted over 2 years ago

by Ken Lassesen
- 0 Comments
[Next Post in Series: Kronos Migration] My first experience with data migration dates from the 1970’s when a firm was moving from a Honeywell Mainframe (64KB of memory, no DASD -- just tape drives) to an IBM 4331 (2 MB of memory and DASD). In...
Enterprise Applications on Microsoft SQL Server

Right sizing ISV installations for the best bang for the buck!

Posted over 2 years ago

by SQL Server ISV
- 0 Comments
Author: This article is written by our contributing author Ken Lassesen. His bio can be found here . Recently I have seen two configurations that caused me to shake my head in disbelief. In reality, the problem is the classic one of people...
Enterprise Applications on Microsoft SQL Server

All Good Things Come to an End - Why You Should Upgrade

Posted over 3 years ago

by SQL Server ISV
- 0 Comments
With Microsoft announcing the release of the Community Technology Preview 1 (CTP1) of SQL Server 2011 (Code name: Denali) I felt it was appropriate to mention something that was discussed in the Deploying Kronos Workforce Management Solutions using SQL...
Enterprise Applications on Microsoft SQL Server

Kronos WFC 6.2 Support for Microsoft Platforms

Posted over 3 years ago

by Aranu
- 4 Comments
It was great to meet customers at Kronosworks last week in Las Vegas. Microsoft had two packed sessions – one in the Retail and the other in the Healthcare track. At our booth we met lots of customers who were excited about the 6.2 release and support...
Enterprise Applications on Microsoft SQL Server

Non Default Database Settings for SQL Server with Kronos Workforce Central Suite

Posted over 3 years ago

by SQL Server ISV
- 0 Comments
The installation of Microsoft SQL Server is very straight forward with usually little changes to be made as most of the default options are what most users will need. Some applications require these default options to be changed in order to perform at...
Enterprise Applications on Microsoft SQL Server

Using RCSI with Kronos

Posted over 3 years ago

by SQL Server ISV
- 0 Comments
Author: This article is written by our contributing author Ken Lassesen. His bio can be found here . Recently, I observed the impact that turning on RCSI had on a Kronos installation, and I was impressed by the reduction in blockages that were...
Enterprise Applications on Microsoft SQL Server

Meet Microsoft at Kronos User Conference in Las Vegas (November 8th–11th)

Posted over 3 years ago

by Aranu
- 0 Comments
Technorati Tags: Kronos Will you be attending the Kronosworks conference in Las Vegas in two weeks? I will be presenting at two sessions at the conference along with some customer and Kronos speakers. The first session will be on Tuesday November 9th...
Enterprise Applications on Microsoft SQL Server

Kronos Workforce Central 6.1 and Microsoft SQL Server 2008

Posted over 3 years ago

by SQL Server ISV
- 0 Comments
Kronos helps organizations across a variety of industries manage their most valuable, and expensive, strategic asset—their workforce. How? By giving them the tools they need to help them control labor costs, minimize compliance risk, and improve...
Enterprise Applications on Microsoft SQL Server

SQL Server High Availability for Kronos Workforce Central Suite

Posted over 3 years ago

by SQL Server ISV
- 0 Comments
The Kronos® Workforce Central® suite provides the end-to-end solution to help your company executives, supervisors, and employees excel in all areas of workforce management. Workforce Central automates your labor-intensive administrative processes...
Enterprise Applications on Microsoft SQL Server

TechNet Webcast: Deploying Kronos Workforce Management Solutions Using SQL Server 2008

Posted over 3 years ago

by SQL Server ISV
- 0 Comments
Kronos Workforce Central is one of the most widely deployed solutions used for employee management in nearly every industry. Using Microsoft SQL Server 2008 database software to power Workforce Central lets you take full advantage of the capabilities...