Browse by Tags

Related Posts
  • Blog Post: 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 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 for your firm. Microsoft provides two versions of...
  • Blog Post: Kronos WFC 6.2 Support for Microsoft Platforms

    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 for Microsoft Hyper-v, SQL Server 2008 and Windows...
  • Blog Post: 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 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 they save. Indexes primary use is to find records...
  • Blog Post: SQL Server High Availability for Kronos Workforce Central Suite

    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, freeing your workforce to focus on productivity...
  • Blog Post: 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 consists of at least three passes: Prototype migration : the purpose is to learn the steps required for your migration. Discover and resolve unexpected issues. The outcome should be a checklist...
  • Blog Post: Non Default Database Settings for SQL Server with Kronos Workforce Central Suite

    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 optimal levels. Kronos and Microsoft recommend the...
  • Blog Post: 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 for SQL Server ISV Administrators ". I have found that ISV Administrators are often Professional Engineers (P.E.) -- rich in business knowledge and light in Information Technology expertise. In this...
  • Blog Post: 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 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 Engine Tuning Advisor to identify performance...
  • Blog Post: 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 [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...
  • Blog Post: Using RCSI with Kronos

    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 created by super-users' ad hoc queries. RCSI...
  • Blog Post: Migrating from Oracle to SQL Server

    [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 those days, computer manufacturers often had different...
  • Blog Post: Kronos’ tips: Improving Performance

    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 in workforce management software implementations...
  • Blog Post: Migration: The value gained moving from Oracle to SQL Server 2008R2

    [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 like dBase II were power-user friendly but...
  • Blog Post: All Good Things Come to an End - Why You Should Upgrade

    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 Server 2008 webcast and that is upgrades. SQL...
  • Blog Post: TechNet Webcast: Deploying Kronos Workforce Management Solutions Using SQL Server 2008

    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 of Workforce Central, and you can use the built-in...
  • Blog Post: Kronos: Fifth Third Bank managing 21,000 employees on SQL Server

    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 states at over 1200 locations. The following solutions...
  • Blog Post: Kronos: Scalability Whitepaper for SQL Server 2005

    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 not allow its selection. The white paper may be...
  • Blog Post: Kronos Workforce Central 6.1 and Microsoft SQL Server 2008

    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 workforce productivity. Now shouldn't an application...
  • Blog Post: Meet Microsoft at Kronos User Conference in Las Vegas (November 8th–11th)

    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 at 10 AM PT. In this session I will be co-presenting...
  • Blog Post: Kronos’ tip: Avoiding an installation issue

    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 in workforce management software implementations....
  • Blog Post: 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 . 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 working off valid but stale past knowledge. Two...
  • Blog Post: Kronos: One Server or Two?

    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 to optimize your setup right out of the gate...
  • Blog Post: 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 issues encountered dealing with the degree of access that Javed Iqbal, a Kronos employee and migration expert, was granted. Javed is using SQL Server Migration Assistant for Oracle (SSMA4O) version...
  • Blog Post: Kronos: Oracle to SQL Server Migration – Part 1

    [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, on a Kronos Migration and thought that I should...
  • Blog Post: Kronos: Improving the performance of ad-hoc reports up to 3600%

    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 ideal. One part of the solution is the use of read...