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: Benchmarking Series "The Benchmarking Process" (5/5)

    [Prior Post in Series] In this 5 part Benchmarking Series we have discussed: The Need for Benchmarking The Elements of a Benchmark The Applicability/Usage of a Benchmark Benchmark Sizing Guide We're now going to discuss the Benchmarking Process itself. "How do you measure...
  • Blog Post: TempDB - True, False, and It Depends

    Play along and see if you get the questions right.... TempDB is used for storing temporary user objects, such as global or local temporary tables, temporary stored procedures, table variables, or cursors. TRUE - This is just a warm up so we're all on the same page :) TempDB is available...
  • Blog Post: SQL Server 2008 R2 High Availability Options for Temenos T24 - Part 1 of 4: Failover Clustering

    [Next Post in Series] SQL Server 2008 R2 Enterprise and Data Center editions comes standard with a number of high availability options. Temenos' T24 application can make use of many of these options depending on the customer's tolerance for downtime and data loss. In a T24 implementation, SQL Server...
  • Blog Post: Great SQL Server Whitepapers – all in one location

    SIlvano Coriani has done a great job compiling the most relevant SQL Server whitepapers available on SQL CAT and Technet sites. These papers are categorized into the major categories of Performance and Tuning, High Availability and DR, Security, Manageability, Migrations and Upgrade and Business Intelligence...
  • Blog Post: SQL Server 2008 R2 High Availability Options for Temenos T24 - Part 4 of 4: Replication

    [Prior Post in Series] The Temenos T24 application can make use of many of the high availability features that come with SQL Server 2008 R2 Enterprise and Data Center editions. In part 1 of this series about high availability options for Temenos T24, we took a look at Failover Clustering. In part...
  • Blog Post: SQL Server 2008 R2 High Availability Options for Temenos T24 - Part 2 of 4: Database Mirroring

    [Prior Post in Series] [Next Post in Series] The Temenos T24 application can make use of many of the high availability features that come with SQL Server 2008 R2 Enterprise and Data Center editions. In part 1 of this series about high availability options for Temenos T24, we took a look at Failover...
  • Blog Post: Benchmarking Series "Introduction" (0/5)

    [Next Post in Series] Starting next week we will be doing a 5 part blog series on benchmarking. We're going to discuss: The Need For Benchmarking The Elements of a Benchmark The Applicability/Usage of a Benchmark Benchmark Sizing Guide The Benchmarking Process If you've...
  • Blog Post: Backups: Doing it right so you can recover quickly!– Automating the backups

    [Prior Post] [Next Post] Getting backups scheduled appropriately tends to be a slow process with a lot of keying and mouse clicks. The process can be simplified by the use of a couple of scripts that will backup every database on your SQL Server (including databases added to your SQL Server later...
  • 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: PTC: An example of a production Windchill Backup plan

    Patrick Lee is the Windchill Administrator at Sierra Nevada Corporation (SNC). He shared his backup plan with me for their production databases. SNC has 4 instances of Windchill (3 @ version 9.1 M030, 1 @ version 10) with production databases approaching 20 Gigabytes in size. His Windchill...
  • Blog Post: Tuning Enovia Smarteam – End Solution

    [Prior Post in Series] The result of the tuning exercise is TSQL shown below. The items included are those suggested by Database Engine Tuning Advisor (DTA) evaluated as being prime candidates by the author. The performance improvement expected is at least 15% and may be considerably more. A trace...
  • Blog Post: Benchmarking Series "The Applicability/Usage of a Benchmark" (3/5)

    [Prior Post in Series] [Next Post in Series] In Part 2 of the Benchmarking Series we discussed the different pieces needed to create a successful benchmark. Now that we know the elements and why we need benchmarks we're going to look at some of the ways you might use the results found in your benchmark...
  • Blog Post: OpenText: Guidance for Administrators

    Contributed by Steve Simpson Optimizing your database is the key to good performance. OpenText libraries are created with generic performance parameters to support the basic document and record creation for an average customer site. Indexes created on the database by Library Generator benefit when...
  • Blog Post: SQL Server Security – Additional Resources

    [Prior Post in Series] The intellectual property (IP) stored on SQL Server in your PLM may be your firm’s greatest asset. Its value is more than credit card records (credit cards can be cancelled if lost, IP can’t). It is equivalent to a state secret for your firm. The logical solution...
  • Blog Post: Tuning Enovia SmarTeam – Indexes – Part 1

    [Prior Post in Series] [Next Post in Series] Adding indexes helps SQL Server retrieve records in a table faster. There is a special type of index called ‘clustered’; a clustered index determines the physical order of the records on the disk. For the most common reads, you want the records...
  • Blog Post: Tuning Enovia SmarTeam - Indexes - Conclusion

    [Prior Post in Series] [Next Post in Series] In this part, I will deal with the fact that many remaining tables do not have clustered indexes on them. In my humble opinion, ANY reasonable order of the disk will perform better than a random order, so putting a clustered index on every table is a must...
  • Blog Post: Misys: Managing Risk & Compliance in a Volatile Market: Streamlining Trades and Ensuring ROI (Free Aberdeen Webinar!)

    Global financial turmoil has grown, from the credit crisis crippling many financial institutions, to the current debt crisis that is bringing much valuation uncertainty to the capital markets. Within this market uncertainty is the firms continued commitment to reduce operational risk and cost, ensure...
  • Blog Post: 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 Systèmes ENOVIA or SmarTeam, the BPA report might show the exception shown below. Do not correct it – this is by design and you should click [Exclude this Result]. For any other exception...
  • Blog Post: Index Fragmentation–“If it isn’t broken, don’t fix it”

    Indexes get fragmented. It’s a fact of database life and something that every DBA has to deal with but we do get a choice on HOW we deal with it. The phrase “If it isn’t broken, don’t fix it” is made in reference to SQL Server Maintenance Plans and more specifically the...
  • Blog Post: Benchmarking Series "The Elements of a Benchmark" (2/5)

    [Prior Post in Series] [Next Post in Series] In Part 1 of the Benchmarking Series we discussed the need for a proper benchmark and how a benchmark can play an important role in Release Management, Scalability, and Troubleshooting Performance. When we talk about the elements, we're talking about...
  • Blog Post: OpenText Content World 2010 Presentation on Technical Architecture, Tips and Tricks

    OpenText announced today via twitter that over 100 OTCW (OpenText Content World) breakout presentations were available for download. Steve Simpson (a Senior Principal Product Specialist from OpenText) did a presentation on OpenText eDOCS DM 5.3 - Technical Architecture, Tips and Tricks which goes...
  • Blog Post: Recommendations for Monitoring Performance of the Temenos T24 Database Tier

    You should perform system monitoring during development of your system and periodically during production. Before “going live,” look for bottlenecks and gauge your ability to scale to your expected long-term workload. Once in production, you should create a performance baseline and monitor...
  • Blog Post: 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 on an Enovia SmarTeam installation. Marc Young at xML Solutions arranged for me to work with the folks at Langen Packaging Group in Mississauga, Ontario. Mirek Tokarz facilitated the access: dealing...
  • 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...