(Simon J Mudd) While looking at partitioning I recently made a mistake which I guess can happen to others. Often this is due to not fully reading the documentation or scanning it too quickly and misunderstanding what’s being said.
Other News
Dynamic Loading of Objects using XML – Part 2
(Mahadesh Mahalingappa) In this post, I try to extend what I explained in Part 1.
SQL Server Configuration Manager Cannot Connect to WMI Provider
(Manvendra Singh) I am getting this error message – "Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with the SQL Server Configuration Manager. Invalid namespace[0x80041010]" when trying to launc
LINQ Is It the New SQL?
LINQ – Is It the New SQL? I have been using LINQ for Objects a lot recently. It allows me to leverage my set based skills when processing Dot Net IEnumerable objects. This seems to be something I have to do a lot lately. About the same time, I started looking at NHibernate again. I find it interesting that LINQ […]
Using SqlBulkCopy for high performance inserts
(Mike Goatly) In the age of Object Relational Mapping frameworks (ORMs) it seems unusual to ever get “close to the metal” when it comes to persisting data. Developers are getting quite used to being abstracted away from the underlying data access technologies.
Reading and extracting XML data in Python and Blender
(Kevin Yeandel) Just found a Blender App for drawing charts from xml data on my HD that I wrote some months ago.
XML Tutorial Namespaces and Scope
(Jaidev) XML has no owner. Anyone can author an XML document. That is the supreme freedom born of modern times where information exchange has minimal restriction placed on it.
Enabling and Reading event 10046 / SQL Trace
(Tanel Poder) As I’m done with the book and back from a quick vacation (to Prague, which is an awesome place – well, at least during the summer) I promised (in Twitter) that now I’d start regularly writing blog articles again.
Oracle Scheduler, the things you ought to know
(Patrick Barel) At the KScope conference in Long Beach, CA one of the most interesting sessions I attended was a session called: Five Features You Ought to Know About the Oracle Scheduler by Eddie Awad. It was a nice presentation where I actually learned stuff I didn’t know. At least not in relation
Performance impact: implicit type conversions
(Linchi Shea) Often you see an implicit type conversion or a type mismatch causing a performance issue when it trips up the SQL Server query optimizer. A while back though, I ran into a case where a harmless looking type mismatch caused significant performance degradation when there was no bad plan