Sign in
Esoteric
The inside scoop on SQL / debugging you won't find anywhere else!
Blog - News
All postings are provided AS IS with no warranties, and confer no rights. Additionally, views expressed herein are my own and not those of my employer, Microsoft.
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Tags
.NET
AlwaysOn
Analysis Services
Aviation BI
Education
Excel
MSPFE
PowerShell
Production debugging
Reporting Services
ReportViewer
ScriptDOM
SQL
SQL Architecture
SQL General
SQL High Availability
SQL Performance
SQL Replication
SQLDOM
SSRS
T-SQL Anti-patterns
Upgrade
Upgrade Advisor
VS.NET
WinDbg
Who's viewing?
Visitor Log
Blog - Link List
Useful SQL Blogs
SQL CAT Blog
SQL Server Storage Engine team blog
Sunil Agarwal and others from the SE team
Slava Oaks's weblog
A must-read blog if you are interesting in SQLOS internals
QP team blog
Query Processor team's blog
CSS SQL Team
Bob Dorr, Bob Ward and the entire CSS SQL Escalation team. Highly recommended!
Craig Freedman
Nitty-gritty details of the optimizer, plans, parallelism etc. Probably the most detailed explanations on those topics anywhere on the Internet.
SQL Release Services
Keep an eye on this to be alerted of new CUs, SPs etc.
SQL Programmability
CSS SQL Replication Team
Paul Randal
SQL PFE Blog
Robert Bruckner (SSRS)
David Lean (SQL Spatial)
SQL Server CSS Team India
Nacho's SQL Blog
SQL PFE Israel
Check out their Service Pack / CU list!
SQL Tools
RML Utilities (x86)
RML Utilities (x64)
SQL Nexus
PAL
SQL Server 2005 Performance Dashboard Reports
SQLRAP Scoping Tool v1.2
SQL Perf Stats Script
SQL Best Practices Toolbox (DMV Scripts)
Team web pages
Premier Field Engineering (India)
Microsoft CSS Jobs
Microsoft Premier Support
Microsoft SQL Server Risk Assessment Program
Data sheet for SQLRAP
Microsoft Premier Support Offerings
Debugging Links
Reiley Yang's blog
DumpAnalysis.org
CTS Platforms EE blog
OSR Online (home of the NT Insider)
Ken 'Skywing' Johnson
Home of the Advanced Windows Debugging book
Mark Russinovich's blog
Alex Ionescu
VC++ team blog
MSDN Channel 9 'Going Deep' shows
BI (SSAS, MDX, SSRS, SSIS)
Karan Gulati's blog
Chris Webb
Jeffrey Wang's blog
Stacia Misner
Valentino Vranken
Archive
Archives
May 2013
(2)
April 2013
(5)
March 2013
(4)
February 2013
(2)
January 2013
(1)
December 2012
(2)
November 2012
(2)
October 2012
(6)
September 2012
(10)
July 2012
(1)
May 2012
(3)
March 2012
(3)
November 2011
(2)
April 2011
(2)
February 2011
(3)
December 2010
(1)
September 2010
(2)
August 2010
(1)
June 2010
(3)
May 2010
(5)
February 2010
(1)
January 2010
(1)
December 2009
(3)
October 2009
(1)
August 2009
(1)
July 2009
(2)
June 2009
(1)
May 2009
(1)
April 2009
(1)
January 2009
(2)
December 2008
(7)
November 2008
(2)
August 2008
(3)
April 2008
(1)
December 2007
(1)
June 2007
(3)
August 2006
(1)
June 2006
(5)
MSDN Blogs
>
Esoteric
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Esoteric
Tip of the day: "An attempt was made to load a program with an incorrect format" .NET P/INVOKE issue
Posted
over 4 years ago
by
Arvind Shyamsundar
9
Comments
The other day I was using a 3rd party utility which was built on the .NET platform. My primary work computer happens to be a x64 installation. So on this computer when I fired the utility up, and tried to perform some tasks it would error with a .NET...
Esoteric
Priority boost details – and why it’s not recommended
Posted
over 3 years ago
by
Arvind Shyamsundar
7
Comments
Some times, we see customer has (accidentally or otherwise) enabled the option ‘boost priority’ for SQL Server worker threads. In general Microsoft does not recommend that you set this option. Why? First a bit of background. When we set the ‘priority...
Esoteric
T-SQL Anti-pattern of the day: 'all-in-one' queries
Posted
over 5 years ago
by
Arvind Shyamsundar
7
Comments
Scenario A common requirement for enquiry queries on an OLTP database is to have search criteria which are very specific ('get me details for for OrderID = NNNN') and also the occasional reports which ask for all the orders ('get me all the orders...
Esoteric
SQL Server 2000 / 2005 Failover Cluster Pre-installation Checklist
Posted
over 4 years ago
by
Arvind Shyamsundar
6
Comments
Here's a quick checklist before you install an instance of SQL Server on a failover cluster; or any service pack or hotfix for an instance. Following this list should eliminate 90% of the most common causes of setup failure. Please note that this checklist...
Esoteric
Symbols and symbol files
Posted
over 7 years ago
by
Arvind Shyamsundar
5
Comments
Some of us are unaware of the relevance of proper symbols files. The symbol file is a deliverable just like the binary. Though it is not required for running the application, it is very important to debug issues which arise in production. What are...
Esoteric
Quick Tip: vfbasics!_AVRF_EXCEPTION_LOG_ENTRY symbol not resolved?
Posted
over 4 years ago
by
Arvind Shyamsundar
4
Comments
I was debugging some issues with the help of Application Verifier and WinDbg. Since I was onsite I did not have any access to Microsoft’s private symbol servers, so I was using the public symbol server ( http://msdl.microsoft.com/download/symbols ). On...
Esoteric
AlwaysOn Availability Groups Connectivity Cheat Sheet
Posted
9 months ago
by
Arvind Shyamsundar
4
Comments
Today we were discussing the AlwaysOn connectivity options, and the various combinations therein of Readable Secondary setting and the connection strings became very complex. So I have summarized all the possible outcomes in the pivot tables below. ...
Esoteric
A curious case: CLR/COM Interop leak
Posted
8 months ago
by
Arvind Shyamsundar
4
Comments
Background A customer asked me a question last week: in CLR-COM interop case, who is responsible to free up a string returned from COM? My understanding was that the interop layer setup by .NET will automatically take care of this. However, I thought...
Esoteric
TechEd India 2013 – Bengaluru
Posted
3 months ago
by
Arvind Shyamsundar
4
Comments
I just delivered a session on ‘T-SQL Horrors: how NOT to code’ at TechEd India. The response has been great, and those of you who see this after attending my session, thank you very much for your interest and participation! What I appreciate the most...
Esoteric
Microsoft Report Viewer 2012 update: a ‘gotcha’ to be aware of
Posted
6 months ago
by
Arvind Shyamsundar
3
Comments
Something which I have been waiting for a long time has finally been released! The ReportViewer 2012 redistributable RTM package is available for download now! Deployment notes FYI, ReportViewer is used by Management Studio (SSMS), other utilities and...
Esoteric
Named constraints: two sides to the story!
Posted
3 months ago
by
Arvind Shyamsundar
3
Comments
Background Constraints in SQL Server are of the following types: CHECK constraints DEFAULT constraints Foreign key constraints NULLable constraint UNIQUE constraint PRIMARY KEY constraint BTW, if you are wondering what a NULLable constraint is, it is...
Esoteric
Getting TaskUnzip to work with SQL Server Integration Services (SSIS) 2012
Posted
6 months ago
by
Arvind Shyamsundar
3
Comments
Background It is a very common requirement in SSIS packages to extract contents of a compressed ZIP file, and then process that file in a data flow. From what I can see, it appears that TaskUnzip is quite a popular way to achieve this. So as part of the...
Esoteric
Debugging Toolbox
Posted
over 4 years ago
by
Arvind Shyamsundar
3
Comments
This one is a quickie for an easy reference to most commonly used debugging tools and links. I hope you find it useful, and kindly indicate your feedback on this page by using the comments section or by rating the post! Debugging Toolbox Tool Key Usage...
Esoteric
Windows, SQL Server and Multi-Core / Hyper-Threading
Posted
over 5 years ago
by
Arvind Shyamsundar
3
Comments
Very often we get asked a question about 'how many processors does my SQL Server 200x Edition really support'. This post hopes to summarize the considerations and actual limits. SQL Licensing is per socket First, let's take a look at the Books Online...
Esoteric
Rolling upgrade of 1 instance from 2-node, 2-instance sql failover cluster to slipstreamed sql 2008 SP1
Posted
over 4 years ago
by
Arvind Shyamsundar
2
Comments
Now that SQL Server 2008 SP1 is released (download link here ), it is time to test a very interesting capability: Service Pack slipstreaming. That means that you can save some time by doing an 'integrated' installation of SQL 2008 which includes the SP1...
Esoteric
T-SQL Anti-pattern of the day: UPPER() and LOWER()
Posted
over 5 years ago
by
Arvind Shyamsundar
2
Comments
This one is even more common and therefore has a high impact: the usage of the above functions in WHERE clause predicates. I've examined each in some detail below. Here's a typical example I see, based off the AdventureWorks database. Scenario To illustrate...
Esoteric
How to assign a static port to a SQL Server named instance - and avoid a common pitfall
Posted
9 months ago
by
Arvind Shyamsundar
2
Comments
While Books Online clearly mentions the steps to Configure a Server to Listen on a Specific TCP Port we still see people missing out on one small but important detail in these steps: they forget to delete the entry (0 or some random port) for dynamic...
Esoteric
AlwaysOn Availability Groups Listener: connectivity details
Posted
9 months ago
by
Arvind Shyamsundar
2
Comments
Today in some discussions with my colleagues we were looking at the AlwaysOn Listener which allows SQL Server client applications to be abstracted from the details of the AlwaysOn Availability Group implementation. On the surface, The Listener essentially...
Esoteric
Parallel Data Warehouse resources
Posted
over 2 years ago
by
Arvind Shyamsundar
2
Comments
I’ve recently started learning about SQL Server Parallel Data Warehouse (PDW) appliance. In the course of learning, I came across some links and resources in connection with this appliance, which I will share in this blog post. I will keep it updated...
Esoteric
‘No Disks suitable for cluster disks’: one more possible cause
Posted
over 1 year ago
by
Arvind Shyamsundar
1
Comments
Today in the lab I was working on a test 3-node cluster. I was using Hyper-V for this. We normally use the iSCSI Software Target for testing, so I had set that up on a central VM and then published the target to all the VMs. The disks were seen in...
Esoteric
Performance Dashboard Reports in SQL Server 2008
Posted
over 3 years ago
by
Arvind Shyamsundar
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
Programmatically Getting version of loaded assembly
Posted
over 3 years ago
by
Arvind Shyamsundar
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)
Posted
over 3 years ago
by
Arvind Shyamsundar
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
window.open without address bar
Posted
over 2 years ago
by
Arvind Shyamsundar
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
Implementing MDX Drillthrough in SSRS
Posted
over 1 year ago
by
Arvind Shyamsundar
1
Comments
Let’s say for some reason your users want to implement MDX DRILLTHROUGH statement (equivalent to the cube action provided by most OLAP browsers) in SSRS. Here’s a step-by-step way to implement this. For the purposes of this walkthrough...
Page 1 of 4 (97 items)
1
2
3
4