(Marcin Policht) In the recent tutorials published on this forum, we have been discussing the primary characteristics of Slowly Changing Dimension (SCD) Data Flow Transformation in SQL Server 2008 R2 Integration Services. So far, we have covered its Changing Attribute and Historical Attribute option
Other News
DB2 best practices: Deploying IBM DB2 Express-C with PHP on Ubuntu Linux
(Craig Tobias and Farzana Anwar) This best practice article provides a step-by-step approach to installing and configuring IBM DB2 Express-C software, PHP Hypertext Preprocessor, and Apache HTTP Server on a system running the Ubuntu Linux operating system.
SQL Server Compressed Backups Disk Space Needs
(Matteo Lorini) SQL Server 2008 and later offers the ability to create compressed backup files. When creating the compressed backup, how much space is really needed and when does the space get allocated for the backup file? In this tip we take a look at how compressed backup files are created with
Is Entity Framework the Next ODBC?
Is Entity Framework the Next ODBC? What made ODBC a viable technology? It created a single interface for which drivers could be written allowing access to a data store. ODBC drivers were written for text files, Excel Documents, Microsoft Exchange, ISAM Files, Relational Databases, and much more. The key was, there was a common interface used by an ODBC consumer; […]
Should SQL Support Regular Expressions?
Should SQL Support Regular Expressions? One of my smaller goals for this year is to become more proficient using Regular Expressions. Spending a majority of the last two decades in pure SQL allowed me to miss this gem. As I use Regular Expressions more and more, I have come to appreciate the elegance of the utility, and wonder how it […]
Efficient multidimensional data modeling with InfoSphere Data Architect
(Thuan Bui) This demo shows how a data architect at a fictional company uses IBM InfoSphere Data Architect to efficiently create multidimensional data models of a new data mart, which can be used for business intelligence and analytical reports.
Plan is same, Wait profile is different ?
(Coskan Gundogar) Here comes the nice one, What would you check when you are on 3 node RAC where 4 different database are balanced with services and Developer of one of the DBs come and asked you why their newly deployed batch is 3 times slower on PRD comparing to QA box which was snap copied (stora
HTML Helpers For Forms In Razor Web Pages
(Mike Brind) A nugget that has remained partially hidden from view within the Web Pages framework is the HtmlHelper class. Parts of this class peek out in the template sites provided in WebMatrix where validation is performed and related messages displayed, but a vast range of methods designed for r
Actively monitoring replication connectivity with MySQL’s heartbeat
(Miguel Angel Nieto) Until MySQL 5.5 the only variable used to identify a network connectivity problem between Master and Slave was slave-net-timeout. This variable specifies the number of seconds to wait for more Binary Logs events from the master before abort the connection and establish it again.
Webinar: Upgrade Security in Your Oracle R12 Upgrade
The upgrade from Oracle E-Business Suite (EBS) 11i to R12 is a unique opportunity to improve the security of your implementation by resolving existing security issues, configuring R12 securely, and taking advantage of new security features in R12.