(Peter Vogel) In this month’s article in the print edition of Visual Studio magazine ( WCF and Service Oriented Architectures ), I looked at the major components of a Service Oriented Architecture (SOA) and showed how to use Visual Studio 2010 and WCF 4 to implement those components.
Other News
Passing Table Valued Parameter to Stored Procedure: Part 1
(Pradeep Chandraker) Before SQL Server 2008, there were three options to pass bulk data into a stored procedure, but each had their own drawbacks.
Efficient backup and recovery with DB2 advanced recovery solution
(Thuan Bui and Ivan Nikittin) Learn how a fictitious company improves their backup and recovery strategies with IBM DB2 advanced recovery solution.
SQL Server Reporting Services Tutorial
(Ray Barley) SQL Server Reporting Services 2008 (SSRS) is a feature included in the SQL Server 2008 product. We use SSRS to design, develop, test, and deploy reports. SSRS was originally slated to be released with SQL Server 2005 but it wound up being released a little bit ahead of SQL Server 2005
Could I Be Wrong?
Could I Be Wrong? Reading Eric Lippert’s blog is always entertaining and instructional. Today I was reading and came across his posting titled, “Maybe there’s something wrong with the universe, but probably not.” His point, often we assume software problems come from the other guy, not issues we have created ourselves. One comment to the blog pretty much sums it […]
Query Plans Who is Using Them?
SelecTViews With Stephen Wynkoop Find out the latest news involving the Office 365 launch, LaCie’s CloudBox and more. Query Plans –Who is Using Them? In a response to my interest in how folks are using query plans, Neil writes with some tips he has found. One of the key things Neil points on is how to handle Nested Loop Joins […]
Understanding SharePoint 2010 Claims Based Security
(Altaf Gilani) Last week, Mark Massad and I worked with Paul Stubbs to publish this video for Channel 9. In this video, we talk about some tips and tricks for setting up SharePoint 2010 Claims, instrumentation techniques that would be helpful while debugging claims and claims augmentation.
Fast Parallel Rollback and Large Transactions
(Kellyn Pot’Vin) The SMON spit out this error after the cycle of the db on the rollback of the huge insert into the largest table in one of our warehouse environments. I had serious concerns about a poor execution plan and wondered what we were going to be in for on the rollback and with good reaso
Performance schema performance tuning
(Marc Alff) One of the most important question users ask before deciding to use the performance schema is: what is the overhead ? The underlying concern of course is to make sure deploying the performance schema does not negatively impact production (“First, do no harm”).
JAXB and Complex Types with Simple Content
(Blaise Doughan) A common question that appears on the forums is something like: “How do I map an object to an XML element with attributes and text in JAXB?”.