Esoteric

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

    window.open without address bar

    • 1 Comments
    Recently we were struggling with trying to figure out how to suppress the address bar for a popup window opened using JavaScript’s window.open method. Normally, there is an option there which allows you to specify ‘location=no’ and the address bar is...
  • Esoteric

    Programmatically Getting version of loaded assembly

    • 1 Comments
    I recently had to determine at runtime the version of the assembly containing a particular type. After some searching I hit upon this: System.Reflection.Assembly.GetAssembly(typeof(MyNamespace.MyType)).GetName().Version.ToString() Do note that this will...
  • Esoteric

    Web installer for obtaining / installing debugging tools (WinDbg)

    • 1 Comments
    Recently there has been a change to the way you obtain downloads of the WinDbg family of Debugging Tools for Windows. The classic link for the direct download of these installers was http://www.microsoft.com/whdc/devtools/debugging/default.mspx. Unfortunately...
  • Esoteric

    Performance Dashboard Reports in SQL Server 2008

    • 1 Comments
    While Activity Monitor in SQL 2008 does a good job depicting waiting tasks, top N queries etc.; many DBAs are simply too familiar with the erstwhile SQL Server 2005 Performance Dashboard Reports. While officially Microsoft does not support the usage of...
  • Esoteric

    T-SQL Anti-pattern of the day: comparing DATETIME field with date-only literal

    • 1 Comments
    Scenario It is a pretty common situation to have transaction date-time stored in a DATETIME field. The problems start with the fact most applications used GETDATE() or some such equivalent at the client side to record the order date-time stamp. So a typical...
  • Esoteric

    Some notes on database snapshots

    • 1 Comments
    Overview I recently conducted some tests to double check the exact behavior of database snapshots when: Snapshots are created on volumes which are much smaller than the actual database size Metadata-only operations such as DROP TABLE are executed DDL...
  • Esoteric

    VISUAL STUDIO REMOTE DEBUGGER HISTORY

    • 1 Comments
    Let's say you use the Visual Studio Remote Debugger extensively, and with a wide variety of remote targets. Very quickly the list of qualifiers (see the image below to understand what I refer to) can grow quickly with 'noise' items. If you were curious...
  • Esoteric

    My Favorite SQL Server Blogs

    • 1 Comments
    At our workshops and during other customer interactions, we are usually asked for links to good blogs and reading materials. Here is a list of my favorite SQL-related blogs, arranged in no specific order. http://blogs.msdn.com/craigfr : Craig Freedman...
  • Esoteric

    The role of STOPAT in RESTORE DATABASE

    • 1 Comments
    Previously in SQL Server 2000, the STOPAT clause was provided for RESTORE LOG wherein you can "halt" the recovery process at a particular point in time. This feature is very useful for recovering from accidental user errors and such. Now in SQL Server...
  • Esoteric

    SQL Server setup log locations and more

    • 1 Comments
    In order to efficiently troubleshoot problems involving failed setup, we need to use the setup logs. Once you know where the log files are located, you can start troubleshooting. What to look for in the log files is a separate topic in itself, but at...
  • Esoteric

    Concurrency of Full, Differential and Log backups on the same database

    • 1 Comments
    Overview Many a time, we are asked by customers about the effect of overlapping backup schedules: for example, whether they can backup the transaction log at the same time that a long-running complete backup of the database is taking place. Books Online...
  • Esoteric

    NOT NULL and SWITCH TO PARTITION

    • 1 Comments
    Today I was to execute a ALTER TABLE... SWITCH TO PARTITION... operation to SWITCH an unpartitioned table into a partitioned table. I had taken care of the normal documented prerequisites: Same schema for both tables CHECK CONSTRAINT on the unpartitioned...
  • Esoteric

    SQL Worker Thread Stack Sizes

    • 1 Comments
    Recently during some internal discussions we had a lot of talk around the stack sizes for various SQL builds. Here is the summary of that talk: SQL Server Build OS Build Stack Size SQL Server x86 (32-bit) x86 (32-bit) 512 KB SQL Server x86 (32-bit) x64...
  • 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...
Page 3 of 5 (120 items) 12345