Esoteric

The inside scoop on SQL / debugging you won't find anywhere else!
Posts
  • Esoteric

    Licensing changes in SQL Server 2008 R2

    • 0 Comments
    In case you are not aware, there have been some significant licensing changes in the SQL 2008 R2 release, especially with the introduction of the DataCenter edition as the top-of-line edition. SQL Books Online documents the facts, as always, but sometimes...
  • Esoteric

    DB Mirroring Tips

    • 0 Comments
      Here are some essential things to consider when trying to tune a DB mirroring setup. They revolve round the following concepts: The effect of Virtual Log Files (VLFs) on recovery and therefore failover times The interplay (or lack thereof) between...
  • Esoteric

    LinkedIn Group for Premier Field Engineering India

    • 0 Comments
    My team, Premier Field Engineering (India) recently created a group on LinkedIn ( http://www.linkedin.com/groups?gid=3761475&trk=hb_side_g ) which we will use to share our experiences, upcoming offerings, career opportunities and more. Membership...
  • Esoteric

    Windows Mobile Device Center: missing Icons

    • 0 Comments
    I recently acquired a new Windows Mobile phone and was using the Windows Mobile Device Center to set up the partnership with my laptop. In the process, I came to a stage where I had to activate IRM as per the steps in Activate Information Rights Management...
  • Esoteric

    t-SQL Anti-Pattern: Index Key Order and Query Expression Order

    • 0 Comments
    This is really not a T-SQL anti-pattern as much as it is a database design issue, but we see it so often that it’s worthwhile bringing it up and clarifying things. For illustrating the scenario, let’s examine the table Person.Contact in the AdventureWorks...
  • Esoteric

    OPTION(RECOMPILE) redux (a.k.a. Parameter Embedding Optimization not working)

    • 0 Comments
    A long time ago, I had blogged about the perils of ‘wildcard’ query patterns. As a response to one of the comments in that post, I learnt about a new optimization introduced in SQL 2008 wherein the OPTION (RECOMPILE) hint would help in these kind of cases...
  • Esoteric

    SQLDiag Configuration Tool released

    • 0 Comments
      My colleague and friend, boB Taylor (the spelling is not a typo – please visit http://www.opsvault.com/meet-our-contributors and see why) has recently released a GUI tool which allows you to configure the XML files required for SQLDiag to capture...
  • Esoteric

    Opinion Poll: Are PRINT statements considered harmful?

    • 0 Comments
    Today during a discussion a point came up around the role of PRINT statements in production code. While most data access today is routed through a data access layer (typically .NET or JDBC) and is focussed on consuming result sets (or executing U/I/D...
  • Esoteric

    TEMENOS T24 Core Banking Optimized on Microsoft SQL Server Database Platform

    • 0 Comments
    I found these links today in response to a customer question around 'real world' benchmarks for financial applications running on SQL Server. These benchmarks describe the TEMENOS T24 Core Banking system, which is probably as 'real world' as it gets....
  • Esoteric

    MDX Studio Quick Tips

    • 0 Comments
    Recently I had to use MDX Studio for some MDX query tuning. 2 quick tips: Latest download link for MDX Studio can be obtained from the support forum at http://ssas-info.com/forum/3-mdx-studio/ The earlier versions of MDX Studio are referenced from Mosha...
  • Esoteric

    Failover cluster (group) maximum failures limit

    • 0 Comments
    My colleague reported that during testing forced failover for a SQL database engine instance, it just ‘failed’ and refused to fail over to the other node in a 2-node cluster. The failure in this case was initiated by shutting down the local...
  • Esoteric

    T-SQL Anti-pattern of the day: Prefix codes stored in (n)varchar fields

    • 0 Comments
    In the course of my work as a SQL Server Premier Field Engineer, we tend to see a lot of patterns in code. Some of these patterns do not lend themselves to optimal performance. This post is the first in a series of such 'how not to code' tips which would...
  • Esoteric

    'Interesting Events' from ReadTrace

    • 0 Comments
    I'm sure many of you are aware of the wonderful RML Tools (description here and x86 download here ) and specifically the ReadTrace tool. Maybe you are also aware of SQLNexus which relies on ReadTrace for the trace analysis. At some point in time when...
  • Esoteric

    Using PowerShell to cleanup older versions of files

    • 0 Comments
    I only recently started using PowerShell and was amazed with the flexibility and ease of use. Here's a sample script I put together after a few hours of playing around. I have also described the scenario around the requirement for this script. Task at...
  • Esoteric

    Howto: Have a Clustered instance of SQL Server listen on multiple virtual IP addresses

    • 0 Comments
    Recently a colleague asked me if there were any changes specific to Windows Server 2008 which allow SQL Server (clustered instance) to listen on multiple subnets. There was only one change in Windows 2008 to my knowledge (which I have detailed in this...
  • Esoteric

    Connectivity related questions

    • 0 Comments
    Some time back there were some connectivity related questions thrown at me: Q1. We know about the Dedicated Admin Connection (DAC) and how it is useful for troubleshooting service hang issues. We also know that DAC should only be used when necessary...
  • Esoteric

    Exploring LINQ

    • 0 Comments
    I just got some time to look into newer things, and one of the most intriguing is LINQ (Language INtegrated Query). I'm just sharing some useful links I came across over a night of browsing for information: http://msdn2.microsoft.com/hi-in/library...
  • Esoteric

    Enforcing password policy for all SQL Authentication Logins

    • 0 Comments
    One of my customers recently asked me how we can enforce the CHECK_POLICY option for all logins created on the SQL 2005 instance. Since by default this is enforced on a per-login basis, we cannot by default have it at a server level. But by using DDL...
  • Esoteric

    Tracer tokens in Transactional Replication

    • 0 Comments
    A new feature of SQL Server 2005 Transactional Replication is the ability to use "Tracer Tokens" to measure true latency between publisher-distributor and also distributor-subscriber. More details at Measuring Latency and Validating Connections for Transactional...
  • Esoteric

    Wait types in SQL Server

    • 0 Comments
    Troubleshooting performance issues in SQL Server involves studying the wait types and wait times associated with the queries executing. However, the relevance of each of the various wait types in the output can be a mystery. For SQL Server 2000, the...
  • Esoteric

    Resources from TechEd sessions

    • 0 Comments
    Several attendees have asked for the resources section from our presentations at TechEd India. Enjoy! Blogs SQLCAT: http://blogs.msdn.com/sqlcat WINCAT: http://blogs.msdn.com/wincat Slava Oks’ blog: http://blogs.msdn.com/slavao Product Feedback...
  • Esoteric

    Replication and Linked Servers

    • 0 Comments
    Problem I recently hit upon an issue with trying to setup a linked server to an instance which was already a subscriber to a publication. When replication is setup, it actually creates a remote server for the subscriber. However that ‘remote server’ is...
  • Esoteric

    Reportviewer and drillthrough

    • 0 Comments
    I was doing some testing the other day with a ReportViewer control hosted in a WinForms application to do local mode report processing. As some of my reports had a drillthrough / navigation option set, I had setup a set of DrillthroughEventHandler to...
  • Esoteric

    The meaning of CID in output of kernel debugger commands

    • 0 Comments
    Recently someone asked me what was the real meaning of the ‘Cid’ field which appears in the output of commands such as !process and !thread in the kernel debugger (kd). Though from a practical perspective I was aware that these represent the Process ID...
  • Esoteric

    Low Fragmentation heap details

    • 0 Comments
    Quick post here: I recently came across a great presentation by Richard Johnson which among other things talks about the implementation details behind ntdll’s Low Fragmentation Heap. While officially not much documentation is available on this subject...
Page 4 of 5 (124 items) 12345