Video Programming for IT Professionals
Other News
Microsoft SQL Server 2014: Database Engine key new features – (Part 2)
Microsoft SQL Server 2014: Database Engine key new features – (Part 2) Author: Basit A. Farooq This is the second part of my article series on Microsoft SQL Server 2014: Database Engine key new feature. In this part, I will talk about SQL Server 2014 columnstore indexes. Updateable clustered columnstore index With the release of SQL Server 2012, Microsoft introduced...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
XSLT and Binary File Formats
(Philip Fennell) With all the recent talk of angle bracket taxes and what XML is and isn’t good for, I thought it would be fun to look at taking XSLT to places where it is not normally associated – the generation of binary file formats.
A Multi-Table Trick to Speed up Single-Table UPDATE/DELETE Statements
(Øystein) In MySQL, query optimization of single-table UPDATE/DELETE statements is more limited than for SELECT statements. I guess the main reason for this is to limit the optimizer overhead for very simple statements.
Isolating DB2 for z/OS Accounting Data at the WebSphere Application Level
(Robert Catterall) Back in the 1990s, almost all of the DB2 for z/OS-accessing transactional applications I encountered were of the CICS variety. Often, a given DB2 subsystem served as the database manager for multiple CICS-based applications. In such cases, isolation of DB2 accounting information (
Putting my DB / Apex install through the wringer
(Gary Myers) I was mucking around trying to get APEX on one of my PCs to be visible on the internet.
My Favorite Features (part 2)
(Jeff Davies) In my last blog entry I showed you two of my favorites features in Service Bus 12c (included in Oracle Mobile Suite 12c and SOA Suite 12c). In this blog, I’ll mention another new feature that is very powerful, giving enterprises the ability to create standardized service implementation
Free script to very quickly and cheaply estimate the size of an index if it were to be rebuilt
(Carlos Sierra) A good friend of mine recently asked me if edb360 included a section showing indexes that would benefit of a rebuild. I replied “not yet” and basically committed to add something.
SQL Server Profiler showing 9003 Exception when CDC is configured
(Chris Skorlinski) While troubleshooting a customers environment I encountered the following 9003 Exception error message captured in SQL Server Profiler.
DB2 monitoring: Migrate from snapshot monitor interfaces to in-memory metrics monitor interfaces
(Scott Walkty, Mike Springgay, Laura McGlinchey and Shakti Tripathy) IBM DB2 for Linux, UNIX and Windows Version 9.7 introduced a lightweight monitor infrastructure and a set of interfaces that reports monitor elements from this infrastructure.