(Jason Brimhall) There comes a time when mistakes are made. Sometimes those mistakes can be as annoying as a spelling mistake during the creation of a stored procedure. When a mistake such as that happens, we are given a few choices.
Other News
More than sp_help
(Kenneth Fisher) If you have worked with SQL Server for very long you have probably run across the extremely useful system function called sp_help. This handy little function will return a list of the objects in the database if you don’t pass in a parameter.
SQL Server – Aborted Online Index Operation & Observed Elevated Values for PWAIT_MD_RELATION_CACHE and MD_LAZYCACHE_RWLOCK Wait Types
(Suresh Raavi) Last week on one of our production servers, we’ve encountered a strange issue which is relatively new (only applicable for SQL Server 2012 and 2014 versions). Based on the symptoms observed and doing a quick Bing search found we encountered a product bug!
Node.js on Azure via Visual Studio and Git
(Jon Gallant) I was just messing around with Node.js Tools for Visual Studio and Azure and ran into a few gotchas while getting everything setup. Hopefully this helps you get going.
Exploring Data Insights with IBM InfoSphere Master Data Management and IBM Watson Explorer
(Uday Nandam and Whei-Jen Chen) Today’s businesses, applications, social media, and online transactions generate more data than ever before. This data can be explored and analyzed to provide tremendous business value.
Entity Framework Code First Simplicity
(Peter Shaw) Ok, so you’ve heard all about Entity Framework (EF), and about how marvelous it is, so you’ve gotten all fired up about it, and thought woo, yea! Time for me to get my EF hat on. Then you start reading the docs, and looking at the examples, and suddenly the realization sinks in.
Sometimes a Delegate Is Enough
The decision to use a Delegate over inheritance is pretty straight forward in my simple understanding. Inheritance is best when you have a number of methods or properties that must follow a specific contract, ie. an interface. When all you want to do is to dynamically determine what method to call, which may have a different internal behavior, but share […]
Derivation by Implied Restriction: a missing derivation type for XML Schemas?
(Rick Jelliffe) By now XSD users are pretty aware of the severe limitations in the complex type derivation mechanisms provided by XML Schemas.
IBM Knowledge Center a DB2 for z/OS Resource
(Troy Coleman) As I’ve often noted, I prefer storing DB2 for z/OS manuals in PDF format. Even though keeping them updated is a challenge, I believe that being able to access all this information from my laptop is well worth the effort.
What are the top five reasons for choosing remote database support?
(Laura) No prizes for guessing that cost is a major factor for many organisations that choose remote database support. However, it’s not as clear-cut as you may think. When we looked at this issue more closely we discovered that under the umbrella of “Cost” there were many other factors at play.