(Peter Vogel) In an earlier column, I showed how to call a stored procedure from Entity Framework without having to mess with connection and parameter objects (though you could mess with connection and parameter objects if you wanted to).
Other News
Learn HTML5 – Part 3: Server-sent Events APIs
(Manish Tewatia) You might be interested in learning HTML5 from the very first article of this series since this is the third part of my Learn HTML5 series.
Efficient, scalable caching using ESQL shared variables in WebSphere Message Broker and IBM Integration Bus
(Tim Dunn, Gerardo Brenner and Emir Garza) ESQL shared variables are often used to cache the contents of database tables in WebSphere Message Broker and IBM Integration Bus. The problem with this approach is that ESQL SELECT operations perform sequential searches, which become progressively slower a
Writing Your First Java Program
(Rogers Cadenhead) During this hour, you create your first Java program by entering it into a text editor. When that’s done, you save the program, compile it, and test it out. Then you break it on purpose and fix it again, just to show off.
MSSQL Server Error Logs
(timdunn) MSSQL Server error logs exist in the same folder that contains the installed server bits. They’re text files. Easy-as-pie to read, right?
Cycle SQL Server Error Logs based on size using PowerShell
(Jeffery Yao) The SQL Server error log is notorious for growing really large when certain things happen; like repeated login failures, stack dumps or other errors. In cases when trace flag 3226 is not turned on and there are hundreds of databases being backed up the error log can also grow really bi
SQL Insert from Query
(Michael McLaughlin) Sometimes my students find new errors that I’ve never seen. One student did that this week by including an ORDER BY clause in a subquery that feeds an INSERT statement. It raises an ORA-00907 exception, like:
DBMS_MONITOR.SESSION_TRACE_ENABLE
(Andrew Reid) This happened on Oracle 11.2. I had a problem with a 3rd party application hosted in the UK with users in another country. The front-end application was failing regularly with ORA-01426. I needed to know which SQL was causing these errors.
Counting the many rows of Oracle GoldenGate
(Bobby Curtis) With any Oracle GoldenGate replication configuration, it is always good to monitor what is going on. One aspect that many people want to know is how can I validate that every record is being transferred to the target system.
Some fun with Bluemix, Cloud Foundry, Python, JSON, and the Weather
(Henrik Loeser) Today, I wanted to try out running a Python application in IBM Bluemix. And I wanted to check out weather reports for some possible weekend destinations. Why not combine it?