(Shlomi Noach) I happen to use stored routines with MySQL. In fact, my open source project common_schema heavily utilizes them. DBA-wise, I think they provide with a lot of power (alas, the ANSI:SQL 2003 syntax feels more like COBOL than a sane programming language, which is why I use QueryScript in
Author: SSWUG Research
Simple Notifications using jQuery
(ArunkumarGudelli) Today I will explain how to implement Simple Client Side Notifications using jQuery.
Library cache lock scripts for RAC
(Bobby Durrett) I’ve been having issues for a long time now with an Exadata RAC database that has user reports experiencing library cache lock waits. The challenge is to figure out what is holding the library cache locks that the queries are waiting on.
SSRS Performance Troubleshooting: Where did we spend the time before the report even started executing?
(Meer Al) I recently dealt with couple of scenarios, where, we struggled to understand, at first, why the report was taking so long to finally render, yet, the TimeDataRetrieval, TimeProcessing, TimeRendering in ExecutionLog2 View did not explain the total report processing time.
Per request lifetime management for UserManager class in ASP.NET Identity
(suhasbj) We recently released the 2.0.0-beta1 version of ASP.NET Identity. Learn more here by visiting this link. This is an update to 2.0.0-alpha1 and adds the two-factor auth feature along with a few bug fixes. To learn more about the Alpha release, please visit this link.
SQL Server Indexed Views: The Basics
(Jes Borland) Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style of SQL expression. They aren’t there for reasons of performance, and so indexed views are designed to remedy this shortcoming. They’re great in certain circumstances but
SQL Server configuration files
(Matt Bowler) Problem: You require the ability to perform a repeatable standardised installation of multiple instances of SQL Server or the ability to create as-built documentation of an installation.
Troubleshooting Concurrency – A Demo
(Michael J. Swart) So you’ve read about how I generate concurrent activity by calling s_DoSomething super often. And you’ve even seen examples of how I define s_DoSomething. Now, you can watch me put all that stuff in action in this screencast.
DB2 For i Odds And Ends
(Michael Sansoterra) IBM i 7.1 and its various incremental releases have introduced many great new features in DB2 for i. Many of the features have been covered in Four Hundred Guru tips. This tip will cover some of the less exciting, yet important features that may have gone unnoticed. Best of all,
Collecting Changed Row Keys in ADF BC DoDML Method
(Andrejus Baranovskis) If you ever had a question – how to collect information about all changed rows in the transaction, I will provide an answer in this post. As you perhaps already know, doDML method from Entity Implementation class is invoked per each changed row.