(Ben Snaidero) If you read my previous tip on Using the replay feature within SQL Server Profiler you should now know how to replay simple SQL Server traces. But what if there is a lot of concurrency in your application that can’t easily be replicated. This tip will look at the SQL Server Distribute
Author: SSWUG Research
ASP.NET Performance: Performance Counters on Windows Client + IIS Express
(Xinyang Qiu) I learned recently that ASP.NET performance counters are not available on Windows 7 or 8 (client) when running with IIS Express (or the Dev10 default of Cassini). Fortunately, the fix is easy: run Visual Studio as Administrator.
AutoComplete Textbox in MVC Using jQuery and WebAPI
(Raj Kumar) This article explains how to use the TextBox AutoComplete feature in MVC 4 using the Web API and jQuery.
Vector Processing (SIMD) in DB2 10.5 with BLU Acceleration
(Chris Eaton) In a previous blog posting I wrote about how we do compression and encoding in DB2 BLU Acceleration and in that video we spoke about how DB2 pre packs encoded data into register length “chunks” on the database pages.
Oracle GoldenGAte (11.2.1.0.1 and later) and Oracle Enterprise Manager 12c
(Bobby Curtis) Oracle Enterprise Manager 12c is quickly becoming the central monitoring tool for all of Oracle’s products (if not now, will be soon). One product that Oracle Enterprise Manager 12c can monitor is Oracle Golden Gate.
How do PostgreSQL security_barrier views work?
(Craig Ringer) You might have seen the support added for security_barrier views in PostgreSQL 9.2. I’ve been looking into that code with an eye to adding automatic update support for them as part of progressing row-level security work for the AXLE project, and I thought I’d take the chance to explai
A LINQ Style Simple Moving Average Operator
(Richard Carr) Raw data series with extreme peaks and troughs can be difficult to interpret. One way to remove sudden spikes is by applying a simple moving average calculation. This article describes a simple moving average extension method with a LINQ style.
RAC Attack – Installing a 2-node RAC Database on Your Laptop
(Ian Jones) Terry Sutton and I recently had the pleasure of volunteering at a session of 12cR1 “RAC Attack” lab held at the November Conference of the North California Oracle Users Group (NoCOUG). Jimmy Brock from NoCOUG also volunteered and we had several other experts drop by and help out.
SQL SERVER – Statistics for Read-Only Database are in TempDB
(Pinal Dave) Here is the question I received when I was explaining about Statistics in SQLLive360 event in Orlando.
How JSON and Big Data Will Shape the Internet of Things
(Ashwin Viswanath) The catchphrase “Internet of Things” may seem like a relatively new term, but in reality has been around since the late ‘90s, when there was a desire to more efficiently track the flow of goods for supply chain purposes. The enabling technology was RFID which made it possible to r