(CarlosFigueira) There has historically been in Microsoft many ways of doing the same thing. That’s one of the original goals of WCF when it was created: unify the 5 or so different ways of creating distributed applications using the Microsoft stack (ASMX services, COM+, .NET Remoting, MSMQ and one
Other News
A post about RESTful services
(Yi-Lun Luo) This is the first article in a planned series of blog posts. There will be two or three posts in all. Today the All-In-One Code Framework sample Story Creator has a web role, which contains a RESTful service that allows you to upload stories to Windows Azure.
Issues with the system_health session in SQL Server 2012
The ever alert Jonathan Kehayias (Blog | Twitter) sent me a question recently asking about the Extended Event UI used for showing predicates. In particular, he was wondering about the predicate for the wait_info event that is defined in the system_health session and was wondering what was going on.
Dropped Tables, Hiding Extents and Slow DBA_FREE_SPACE Queries
(Martin Widlake) My last post was on slow dictionary queries caused by having many, many thousands of extents in your database. This post is about a special case of this problem, which I encountered recently.
Finding Data in Temp Tables
(digitaleagle) Here’s a simple little trick for Application Engines that have Temporary Tables assigned.
Quick Tip – Comparing Explain Plans with SQL Developer
(Jeff Smith) SQL optimization and tuning is fun for a lot of folks. For others it’s a affirmation that the database is ‘magic.’ I fall somewhere in the middle. No matter where you fall on that spectrum however, it’s pretty safe to assume that at some point you will look at an execution plan for insi
Using Dynamic Classes to Pass Data
(Peter Vogel) In an earlier tip on using tuples to return multiple values from a method, several readers noted that the tuple’s property names (Item1, Item2) left a lot to be desired — you couldn’t really call those names “self-documenting”.
Why I think SQL_MODE is useless…
(Anders Karlsson) I think the SQL_MODE setting is a sort-of good idea, but that the implementation of it is useless, more or less. What I would want from a feature like this is to allow me to control the quality of the data in the database, but that is not what SQL_MODE does, regrettably.
Production Modeling Made More Accurate
(Troy Coleman) One significant challenge DBAs face is validating the access path of SQL from test to production environments. Even if the SQL looks great when run in a test environment, it may perform poorly once it’s moved to the production system. Oftentimes this is because the code simply doesn’t
Scripting for DB2 LUW – Why Perl?
(Ember Crooks) Perl is my favorite scripting language. This was actually a conscious choice.