(Robert Sheldon) Master Data Services (MDS), released with SQL Server 2008 R2 Enterprise Edition, is Microsoft’s offering for companies grappling with mounting stacks of all-important master data. The aim, as with all master data management (MDM) products, is to ensure the accuracy of information cr
Other News
DB2 10 Temporal Tables: Three Analysis Points for DB2 Performance
(Dave Beulke) When I designed and implemented my first data warehouse for E.F. Hutton back in 1988, I quickly understood that the quality of the data answers were the most important measure of success.
Important Caveats When Using pt-online-schema-change
(Ben Black) Using pt-online-schema-change is a great way to change a table without downtime or switching over to a secondary database first. While using it on production systems, we found some interesting issues to consider.
Getting Started with SQL Server Report Builder 3.0
(Arshad Ali) SQL Server Reporting Services (SSRS) has a report development/authoring tool called Report Designer (Business Intelligence Development Studio) for creating managed reports. Though Report Designer has an intuitive interface for creating simple to complex reports, it can be a little compl
How to programmatically identify system and user databases on a SQL Server instance
(Nakul Vachhrajani) I am sure that when preparing installers for your products, you would have come across a requirement to filter out the system databases deployed on a SQL Server instance when presenting a list of available SQL Servers to the user.
InfoSphere Optim and the complete business object, Part 2: Discover your complete business objects
(John Haldeman) Knowing your relationships and understanding the complete business object are crucial for successful test data management, data privacy, application retirement, and data growth products.
Some Dare to Predict
Some Dare to Predict I’ll be honest with you; I have no clue what is coming next. I foresee a lot of growth in distributed data and processing technologies. That is a bit of a wimpy prediction based on the current velocity. Agile SDLC will continue to grow. Even though it has not been shown to produce more successful software […]
What will the future be?
What will the future be? I don’t know if I am a hoarder or a pack-rat. When it comes to tech journals, I just can’t seem to throw them away. Recently I have been going back through my piles to see what we thought the future held 10-15 years ago. It’s really interesting to see what ideas became reality and […]
Simple XML to JSON with PHP
(Sean Biefeld) Hello all, it’s been a while since I have blogged anything, been extremely busy with personal events in my life. So to get back into the swing of things I am going to KISS this post.
Building LINQ Queries at Runtime in F#
In an article about building LINQ queries at runtime in C# 3.0 [1], I described how you can build a LINQ query dynamically, for example by combining a set of conditions using the ‘or’ operator in the where clause. I mentioned that the way I implemented it is largely influenced by the F# language, wh