(Scott Murray) I have used the Top and Bottom T-SQL functions in SQL Server; do the same functions exist in the SQL Server Analysis Services (SSAS) or MDX? If so, how do they work? Can you provide some examples? Check out this tip to learn more.
Author: SSWUG Research
System log analysis using InfoSphere BigInsights and IBM Accelerator for Machine Data Analytics
(Vincent Cailly) When understood, logs are a goldmine for debugging, performance analysis, root-cause analysis, and system health assessment. In this real business case, see how InfoSphere BigInsights and the IBM Accelerator for Machine Data Analytics are used to analyze system logs to help determin
Some Thoughts on the MySQL REPLACE Command
(Ike Walker) In yesterday’s post I was fairly prescriptive about how to do an upsert in MySQL. I’m aware that there are other ways to do an upsert in MySQL, but I intentionally emphasized INSERT … ON DUPLICATE KEY UPDATE over REPLACE because I think it’s almost always the better choice.
IBM DB2 10.5 with BLU Acceleration vs. Niche Columnar Vendors
(Chris Eaton) Continuing on the BLU comparisons, this video covers Vertica, ParAccel, and Vectorwise. Paul and I primarily discuss the lack of enterprise hardening and how that compares to the benefits of having BLU acceleration backed right into the DB2 engine.
4 Tips for Solving SQL Server Architectural Problems
(Jayleen Heft) Perhaps the biggest problem with SQL Server architectural flaws is that they commonly lie hidden and dormant until application concurrency increases enough for them to manifest.
Customizing Routes in ASP.NET MVC – Custom RouteBase implementations
(Suprotim Agarwal) MVC Routing is pretty flexible in itself and as we recently saw in Friendly URLs in ASP.NET Web Forms , we can mix and match old web forms style URLs with modern friendly URLs even keeping both side by side.
Comparing Asp.Net Web API Routing and Asp.Net MVC Routing
(Shailendra Chauhan) As you know, Routing is a pattern matching system that monitor the incoming request and figure out what to do with that request. A URL pattern is matched against the routes patterns defined in the Route dictionary in an Order and the first match wins.
Removing or Customizing View Engines in MVC
(Abhimanyu Kumar Vatsa) In this article you will learn how to remove or customize View Engines which is not being used by application.
Inspecting a Temporary Table or Uncommitted Table rows in a Debug Session
(Dermot O’Neill) Debugging a procedure using SQL Developer is really neat. But I ran into an issue whereby I wanted to inspect the rows of a temporary table while I was debugging a stored procedure. I was unable to browse and inspect the rows in the temporary table as the debug session is on a diffe
ORA-00960
(Andrew Reid) This was tested on Oracle 11. I tried to sort on a column which appeared more than once in the SELECT list, and got an ORA-00960: