(Ben Nadel) I spend a lot of time thinking about how to improve the performance of my AngularJS apps. Not in a “premature optimization” way – more like in a “customers are complaining” kind of way. As such, I like to stop and noodle on any aspect of the code that may be leveraged for better performa
Other News
Introducing ServiceStack
(Ravi Kiran) ServiceStack is a configuration free, code-first, light-weight framework built on top of ASP.NET for building services and web applications. This article will get you started with ServiceStack and also get your hands dirty with it.
3 Game-Changing IBM DB2 pureScale Enhancements
(Dave Beulke) Another set of great INSIGHT announcements that were somewhat drowned out by all the Watson hoopla were all the enhancements that are happening with DB2 pureScale. For those unfamiliar with DB2 pureScale, it is the multi-node cluster configuration providing the industry’s best scalabil
Bringing Informix Technology to the World’s Fastest Growing Database Market
(Sajan Kuttappa SWG) If someone wanted more proof that Informix is technologically a step ahead of competitors, IBM provided evidence in China! Even the hardest cynic would find it difficult to rebuff the fact that the adoption of a locally innovated version of the Informix database for the burgeoni
Materialized Views
Materialized views are enabled by creating an index on a view definition. You have to define the view with Schema Binding enabled in order to create an index. Moreover, if you have a materialized view you cannon change the schema of a table without first disabling the view, because the view depends on the schema of the table(s) on which […]
What You Need to Know about BI in SharePoint 2013
(Errin O’Connor) Business Intelligence (BI) capabilities in SharePoint 2013 are vast and in many cases are achieved with a combination of SharePoint and Microsoft Office or SharePoint and SQL Server’s capabilities.
Implement a Service-Oriented Architecture with REST APIs
(Michael Sansoterra) For quite a while, we’ve all heard the buzz surrounding a “service-oriented architecture” (SOA). The promise of SOA is to allow applications to communicate with one another in real time, whether on a private network or across the world, using the platform-independent, standard H
Useful DB2 administrative functions and views
(Henrik Loeser) Did you know that there are about 80 (eight-zero) administrative views in the SYSIBMADM schema in DB2 that are ready for use? I have used several of them and also looked into the documentation, but 80 is quite a lot. (Almost) All of them are documented in the DB2 Knowledge Center in
EXEC sp_executeSQL
(Richard_RP) Today I am going to talk about the stored proc sp_executesql and the benefits it has over EXEC @SQL. Microsoft actually recommend that you use the sp_executesql stored procedure instead of the EXECUTE statement.
Drop and Recreate all Synonyms
(Arthur Olcot) Had a quick job the other day restoring a pair of databases under different names which is all straight forward enough, but each database in the pair uses quite a few synonyms to access objects in the other database.