(Dave Beulke) To figure out the best temporal table design aspects you need to think of the various options and considerations that will affect its performance. The most important aspect for your temporal table is the answers that your applications or users are expecting from it.
Other News
SQL Server Integration Services (SSIS)-Export Data using Wizard
(Karthikeyan Anbarasan) In this article we will see how to export data from SQL Server using the wizard which is provided with SSMS (SQL server Management Studio). Using SSMS we can perform many tasks such as copying data from one server to the other or from one data source to the other in a variety
Converting between MySQL Date and Time Formats
(Rob Gravelle) All of the larger systems that I’ve helped develop necessitated storing some combination of date and time fields. Almost universally, these fields presented difficulties of some kind or another.
Preventing Entity Expansion Attacks in JAXB
(Blaise Doughan) This post will cover how to protect yourself from the entity expansion attack when you are using JAXB.
Managing failed flows using the Failed Event Manager API in WebSphere Process Server
(Phani Madgula and Ashok Poralu) The Recovery component is an intriguing subject in WebSphere Process Server because it provides a fundamental service that helps administrators re-initiate their failed flows. To provide this service, the Recovery component captures the request data and embeds it in
Introduction to Heterogeneous Replication in SQL Server
(Murali Krishnan) One of my clients contacted me about replicating data to non SQL Server databases. My client has a new business partner whose application runs on an Oracle database. Part of the business deal is to replicate data between the two environments. We are already using SQL Server to SQ
MS New Browser – IE9
SelecTViews – THE SQL Server Video Show with Stephen Wynkoop Watson! You may have seen him on Jeopardy! – Stephen Baker joins us on the show today talking about what was learned with the project. Stephen Baker wrote the book (literally) on the Watson project and all that it entailed – do not miss this show… [Watch the Show] MS […]
Data warehousing and the mainframe
(Willie Favero) Stewart Alsop II, one-time editor-in-chief and executive vice-president of the weekly magazine infoWorld is probably more familiar to those of us that dabble in the wonderful world of mainframes becuase of the statement he made in the March 1991 issue of his InfoWorld Magazine.
Visual Studio 2010 SP1
(Scott Guthrie) Last week we shipped Service Pack 1 of Visual Studio 2010 and the Visual Studio Express Tools.
OBI 11g Prompts are Context / Data Type Sensitive
(Christian Screen) You just have to love Oracle Business Intelligence and the enhancements over OBI 10g. Again, my recommendation is to get OBI 11g in your org as soon as possible. At a minimum a dev environment just so you can check out the cool features like the one this blog post talks about, d