(Bipin Joshi) While working with Entity Framework developers mostly use LINQ to Entities to query database. However, at times you may need to execute raw queries against the database. A common scenario is when you wish to generate an SQL query dynamically. Luckily, EF allows you to execute raw queri
Author: SSWUG Research
Why Transaction Log Auto Growths are degrading your performance
(Klaus Aschenbrenner) In this blog posting I want to talk a little bit in more detail why you should avoid Auto Growth operations on the Transaction Log. In my various consulting engagements I see a lot of SQL Server databases, that are running with the default file configuration for the initial siz
Insights into the Visual Studio 2013 Enhancements
(V.N.S Arun) In this article I will be taking you through the new features of Visual Studio 2013 IDE, which was released by Microsoft in early November 2013, and provide the readers with insight about the enhancements done to the IDE.
Cross Origin Resource Sharing in MVC 4 using JSONP
(Navin Prasad) Hi, In the below post we will learn how to extend MVC framework to support jsonp requests.
Oracle X$ tables – Part 1 – Where do they get their data from?
(Tanel Poder) It’s long-time public knowledge that X$ fixed tables in Oracle are just “windows” into Oracle’s memory. So whenever you query an X$ table, the FIXED TABLE rowsource function in your SQL execution plan will just read some memory structure, parse its output and show you the results in ta
Flashbook: DB2 11 for z/OS – The Database for Big Data and Analytics
(Susan Visser) Rather than me telling you about it, I’m sharing content from experts:
Changing OEM12c Repository retention settings
(Bobby Curtis) Today, I’ve been working on a script to pull some sizing/metric information out of the Oracle Enterprise Manager (OEM) repository database. As I was working through (pulling my hair out…lol) the details; I had a discussion with an good friend.
ADF BC Application Module Instance Timeout and Web Session Timeout Dependency
(Andrejus Baranovskis) What happens with AM instance, when Web session times out? I would like to answer this question. To find an answer, I have developed sample application with special settings for AM configuration – AMInstanceTimeoutApp.zip.
JPA EclipseLink ORM.XML Mapping for Index
(Nicholas Rinard Keene) There may be other, harder ways to do it, but here’s the easy way to add an index on a column when using EclipseLink and XML mappings for JPA. Simply add an empty “index” tag inside the “basic” tag for that entity.
Solved: How to install Python ibm_db DB2 driver on RHEL
(Kevin Rice) Problem 1: I kept getting a message about not having include files installed. First, I had to get a sysadmin to install the files. But, he didn’t finish the job, quite. I had to soft link it myself. That is, the include files are installed by default in /opt/ibm/db2/V10.1, but link