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
LinkedIn Group for Premier Field Engineering India
Posted
over 2 years ago
by
Arvind Shyamsundar
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
“Failed to join domain” trying to add Windows 2008 R2 Core to domain
Posted
11 months ago
by
Arvind Shyamsundar
0
Comments
Today I was using SCONFIG (if you don’t know what SCONFIG is, check out these posts to add a Windows 2008 R2 core server to an existing domain. I had set the IP address and ensured that the domain name and credentials are correct, but I kept getting ...
Esoteric
"Operating system error 1398" while backing up database to network share
Posted
10 months ago
by
Arvind Shyamsundar
0
Comments
I was facing this on a VM setup, where the service account of my SQL Server service is a domain account. The DC is also a VM. Here were the symptoms: While backing up the database to the UNC share, I was getting an error: "Operating system error...
Esoteric
Error message: The target database ('xyz') is in an availability group and currently does not allow read only connections
Posted
8 months ago
by
Arvind Shyamsundar
0
Comments
Today while poking around the AlwaysOn Availability Groups feature I came across the above error when testing the read-only access routing configuration. That configuration allows connections with declared ReadOnly intent to be routed to one of the read...
Esoteric
Windows Performance Toolkit: Finding CPU consumer
Posted
8 months ago
by
Arvind Shyamsundar
0
Comments
A colleague of mine recently asked the question ‘I see CPU N is constantly pegged at 100%; is there any good way to determine which specific process is using that specific CPU?’ Well, he already figured that Task Manager or Process Explorer does not provide...
Esoteric
TEMENOS T24 Core Banking Optimized on Microsoft SQL Server Database Platform
Posted
over 2 years ago
by
Arvind Shyamsundar
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
Posted
over 2 years ago
by
Arvind Shyamsundar
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
Posted
over 1 year ago
by
Arvind Shyamsundar
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
.NET Debugging Quick Start
Posted
over 1 year ago
by
Arvind Shyamsundar
0
Comments
Many a time I am asked how to get a head start with debugging .NET issues – hangs / crashes and most commonly, memory issues. So I assembled this list of resources which helps you get started. In addition, if you are a Premier Support subscriber, you...
Esoteric
T-SQL formatter: a PowerShell script
Posted
2 months ago
by
Arvind Shyamsundar
0
Comments
This is a ‘quick-and-not-so-dirty’ version of a T-SQL formatter / ‘pretty printer’ in PowerShell. To use this, please install the SQL 2012 SP1 version of the SQLDOM from the Feature Pack page . (If you already have SQL 2012 client tools on your machine...
Esoteric
“The operation has timed out” while using Power View in Excel 2013
Posted
4 months ago
by
Arvind Shyamsundar
0
Comments
This one is a quick tip. I recently upgraded to Office 2013 RTM and wanted to use the excellent Power View feature which is now an integral part of Excel! However, after I setup my tables (actually I used the Power Pivot data model) I was consistently...
Esoteric
The Top 10 Issues uncovered by the SQL Server Risk Assessment Program (SQLRAP)
Posted
4 months ago
by
Arvind Shyamsundar
0
Comments
Firstly - Happy New Year, everyone! In my job as a Principal Premier Field Engineer at Microsoft Services, I am a regional lead for a proactive risk identification program called the SQLRAP. For over 7 years now we have evolved this from a manually conducted...
Esoteric
Getting worker thread IDs using DMVs
Posted
1 month ago
by
Arvind Shyamsundar
0
Comments
In SQL 2000, the kpid column in sysprocesses was a convenient way to find out the actual worker thread ID (OS level thread identifier) for a given task. How does one do this using the DMVs? Here is a quick way: select R.Session_Id, Th.os_thread_id from...
Esoteric
Education Resources: Mathematics and Chemistry add-ins
Posted
1 month ago
by
Arvind Shyamsundar
0
Comments
Kids in school today are more comfortable working with computers than with pen-and-paper. And for kids with special needs it may actually be the only way for them to express themselves. So I always wondered what we can do to make the learning experience...
Esoteric
Considerations when using the TransactSql.ScriptDOM parsers
Posted
1 month ago
by
Arvind Shyamsundar
0
Comments
Some of you might be aware of the above namespace , which holds an implementation of a first-class T-SQL parser. In this post I would like to explain some of the complexity you will face when dealing with the ScriptDOM yourselves, typically using Visitor...
Esoteric
TechEd India 2013 - ‘T-SQL Horrors’ slides
Posted
1 month ago
by
Arvind Shyamsundar
0
Comments
TechEd 2013 was a grand success! Thank you – those of you who stayed till 6:15PM at the Pune session – and even more to those who engaged me in Q&A till 7PM that evening I was very impressed and happy to see people interested in my talk, even though...
Esoteric
Using the TransactSql.ScriptDOM parser to get statement counts
Posted
1 month ago
by
Arvind Shyamsundar
0
Comments
Today there was a question on the #sqlhelp Twitter hashtag: “Is it possible to get UPDATE/SELECT/INSERT/DELETE statement counts from SQL Server?” Implementation This is a perfect use case for the SQLDOM parser a.k.a. Microsoft.SqlServer.TransactSql.ScriptDom...
Esoteric
‘Cannot resolve the collation conflict’ error message with temp tables
Posted
29 days ago
by
Arvind Shyamsundar
0
Comments
Scenario Today my customer told me that he is facing an error message ‘Cannot resolve the collation conflict’ when executing an JOIN between two tables: a base table and a temporary table. They had recently created the database afresh from scripts and...
Esoteric
SQL Server and Storage / SAN replication (mirroring) tips
Posted
28 days ago
by
Arvind Shyamsundar
0
Comments
Some customers have adopted block level replication of the storage disks (LUNs) as their DR solution for SQL Server databases. Remote mirroring of storage disks sounds great – transparent to the application, replicates every block as-is; so very little...
Esoteric
PowerShell script to extract T-SQL code from RDL files
Posted
21 days ago
by
Arvind Shyamsundar
0
Comments
One of the things I do in my day job at Microsoft Services is to review database design and T-SQL code. Now, when it comes to code, there is a challenge just to find ALL the possible code which hits our database engine. This is because a non-trivial amount...
Esoteric
Effective technical presentations: a mind-map
Posted
21 days ago
by
Arvind Shyamsundar
0
Comments
Over the last year I’ve been fortunate enough to be trained by some top-notch professionals from the world of media and big-stage events on how to deliver world-class sessions – whether it be a multi-day training, a short TechEd session, an online meeting...
Esoteric
PowerShell script to extract T-SQL task code from SSIS packages
Posted
8 days ago
by
Arvind Shyamsundar
0
Comments
Requirement Some time back I presented a PowerShell script which extracts T-SQL code from RDL files. Remember that I created this script to assist me in doing code reviews of ad-hoc SQL snippets which were embedded in the report definition files. Another...
Page 4 of 4 (97 items)
1
2
3
4