(Chris Yates) Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you by Sebastian Meine Blog | Twitter.
Other News
12c Performance Analysis
(Simon Greener) I am nearing the end of writing up a performance analysis of Oracle 12c’s new spatial performance improvements.
Filling In Missing Values Using the T-SQL Window Frame
(Dwain Camps) Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase ‘Quirky Update’ tricks to perform the many permutations of running totals in SQL Server. One of these related problems is the ‘Data Smear’. Do win
EXECUTE Privilege on DBMS_SPM not sufficient
(Hemant K Chitale) Here is a quick demo to show that the “ADMINISTER SQL MANAGEMENT OBJECT” privilege is required for a non-DBA user to use DBMS_SPM even if EXECUTE has been granted on DBMS_SPM.
How semantic Web search is changing WCM
(Geoffrey Bock) As semantic Web search gains importance, companies should examine the way search engines display their business to the world — and consider how to enrich their search results with linked data.
Understanding Dependency Injection in AngularJS
(Shailendra Chauhan) Dependency Injection (DI) is a software design pattern that allows you to remove hard coded dependencies between software components. It allows you to develop loosely coupled components by injecting dependencies either at compile time or run time.
Configure a complete query and workload tuning cycle with InfoSphere Optim Performance Manager V5.3.1
(Cheung-Yuk Wu and Cliff Leung) With the InfoSphere Optim Performance Manager V5.3.1 web console, you can configure your monitored databases for a complete tuning cycle for single queries or workloads for DB2 for Linux, UNIX and Windows, and DB2 for z/OS data servers. You do not have to install Data
OLTP and BI mixed workloads – a merry coexistence in DB2 10.5 ‘Cancun Release’
(Somu Chakrabarty) If you have been using DB2 10.5 with a mix of row and column based tables in the same database you may have experienced slowdown in some of your OLTP queries accessing your row based tables after implementing column based tables.
Set a Breakpoint and Start Debugging in Visual Studio
(Peter Vogel) I didn’t know I could do this until a few weeks ago: While still in Edit mode, you can right-click on a line of code and select Run to Cursor. Visual Studio will compile your application (if necessary), start your application in Debug mode and stop on the line you’ve selected.
Understanding azure role topology changes
(Bibhu) There are two classes which allow us to hook into the events in case of role state/status change; events in the RoleEntryPoint class and events in the RoleEnvironment class. Two of these events, OnStart and OnStop, are present in the RoleEntryPoint class (as seen in my previous post) which y