(Scott Guthrie) Earlier this week the data team released the CTP5 build of the new Entity Framework Code-First library.
Other News
Top 10 SQL Hierarchical Data Processing Capabilities
(Michael M. David) I have been writing on the topic of ANSI SQL Transparent XML Hierarchical Processing for Database Journal for almost a year now. This topic has presented a number of new and powerful capabilities that I will review in this Top 10 article.
Equivalent of Oracle KEEP function in DB2
(Vikram Khatri) Equivalent of Oracle KEEP can be in DB2 using a nested query OVER (PARTITION BY ..) and then using MAX and MIN on top of it without having any extra sort.
OBIEE 11g: Getting Started – Part I
(chet justice) A few weeks ago I procured some nifty hardware. Slowly but surely I’ve begun to build out certain VMs. Currently, this one computer serves as 4:
Getting History of Table Sizes in MySQL
(Peter Zaitsev) One data point which is very helpful but surprisingly few people have is the history of the table sizes. Projection of data growth is very important component for capacity planning and simply watching the growth of space used on partition is not very helpful.
Moving datafile from one diskgroup to another in ASM – 10.2.0.4
(Anand) Most of you would already be knowing the various methods of moving the datafiles from one diskgroup to another.From Oracle ASM 11g we have ‘cp’ command in asmcmd utility which makes things much easier.As this is more kind of a note i prepared for myself,lets get started.
Command-line utilities for SQL Server database tuning
This section focuses on command-line utilities for SQL Server database tuning, such as the dta command line utility and how it, along with its counterpart, the graphical Database Engine Tuning Advisor, does an analysis on its given workload and provides recommendations. And we’ll look at tablediff c
DB2 10 Security SECADM Considerations
(Dave Beulke) In addition to the introduction of ROLES, encryption and masking of data, DB2 10 takes a giant step forward with security and DB2 audits with the new SECADM authority.
Implementing web services transactions in WebSphere Process Server V7
(Rajiv Madassery) This tutorial provides instructions to implement a transaction between an IBM WebSphere Process Server V7 business process and an external web service running on WebSphere Application Server V7. The tutorial will provide steps to be carried out in IBM WebSphere Integration Develope
Keep Up With MS Packaging
Featured Script Base64 Decoder This function takes a Base64 encoded string and decodes it. This function does not work for unicode data… (read more) Keep Up With MS Packaging One of the things about we can count on in Microsoft Packaging and Licensing is that it will change. I was recently shocked to find out that some of the SQL […]