(Sergey Syrovatchenko) When dealing with the performance database any detail should can never be neglected, because even the smallest thing can turn out to be a great opportunity for query optimization. Generally, one needs a significant amount of experience to detect that kind of details easily. Bu
Author: SSWUG Research
SSWUGtv: Check out how the combination of ViSX with Microsoft SQL Server ensures dramatically accelerated and consistent database performance,
Video Programming for IT Professionals
Creating Treeview in jQuery
(Arpit Jain) In this article, we will learn how to create a treeview in jQuery. Treeview is used for representing hierarchy. You can use it for many purposes. So let’s create it.
How can we bring query to the data?
(Peter Zaitsev) Baron recently wrote about sending the query to the data looking at distributed systems like Cassandra. I want to take a look at more simple systems like MySQL and see how we’re doing in this space.
DB2 for z/OS: Something You Might Not Know About Character String Literal Values
(Robert Catterall) Here’s something I imagine a lot of you (or programs written by you) do all the time: issue DB2 for z/OS-accessing SQL statements that contain character string literal values. Below is a query that I issued from Data Studio earlier today, targeting a table that I’d created on one
Identifying Incompatibility Issues When Migrating SQL Server Database to Windows Azure
(Marcin Policht) In our most recent article published on this forum, we have presented general support options for data-oriented services in Windows Azure, focusing in particular on SQL Database (formerly referred to as SQL Azure Database).
RMAN Duplicate from Active Database – ASM to non-ASM
(Marko Sutic) In this post I want to explain how to create duplicate database from active 11gR2 database using RMAN. There are many blog posts covering that subject but most of them are covering non-ASM to non-ASM, ASM to ASM or non-ASM to ASM duplications. I want to cover ASM to non-ASM duplicati
#Oracle RAC One Node – Video
(Uwe Hesse) Based on the Grid Infrastructure, RAC One Node is a RAC Database with only one instance running. This architecture reduces unplanned as well as planned downtime. If the server crashes that holds the instance of a RAC One Node database, that instance can failover to another node in the cl
Asynchronous Solution Load Performance Improvements in Visual Studio 2013
(Ben Bradley) Over the past few years, the Visual Studio team has been working hard to improve Visual Studio performance and scalability when working with large solutions. One area of particular interest to many of you has been our initial solution load times. For Visual Studio 2012, we implemented
connect_proc and locales: Connecting the dots for combined fun
(Henrik Loeser) Last year in a blog article I had written about some fun I had with different locales and the dayname function in DB2. Last week I showed you links to customize the application environment. Why not combine the two for some added fun? Let me show you how to connect the dots. I am goin