Mar 11, 2012
In this web page article lists a summary of each company and what they’ve done to win the TDWI Data Warehousing Institute Awards for 2011. If you don’t know what these awards are, it is one of the most prestigious awards that highlight best data warehousing practices. The contestants can apply to different categories of [...]
Mar 4, 2012
This article talks about a new application that was recently released that allows you to monitor their SQL Server in real time on a windows phone. This application is aimed towards IT managers and database administrators that want to keep a close eye on their databases without going through the hassle of accessing their SQL [...]
Feb 26, 2012
In this article the author talks about Microsoft Azure Database, Microsoft’s cloud database, and how it is transforming to be more like SQL server by having features that you will find only in SQL servers. He states that Microsoft is trying to gain on the race against Amazon and Google and one way to attempt [...]
Feb 20, 2012
In this article the author talks about SQL injection and how it’s been around for more than a decade and many companies do not know how to deal with it or not even implementing solutions to fix this widespread problem. SQL injection is a code injection technique that exploits vulnerability in websites software where arbitrary [...]
Feb 13, 2012
In this article the author talks about how Sony fails at many security measures. Sony’s PlayStation Network and Sony Online Entertainment has been compromised in the past but now, even though you would think they would wise up a little bit, has been compromised again by SQL injection attack method. Specifically, Sony BMG Greece was [...]
Feb 6, 2012
In this article the author focuses on the importance of proper data types in order to maintain data quality. He gives us some general tips and rules to follow to ensure the correct type is chosen. First, if the data is numeric, favor SMALLINT, INTEGER, OR DECIMAL Data types. Second, if the data is a [...]
Jan 30, 2012
In this article the author talks about the employment demands of ERD vs. UML. Whether employers prefer one over the other and with the ever fast changing IT field it’s sometime difficult to gauge what skills are preferred in the profession but with all these job search tools online it’s possible to gauge where the [...]
Jan 22, 2012
In this article, the author talks about how conceptual data modeling is a necessity. That it is impossible to have good data quality without first understanding what the data is supposed to represent. He goes on saying that if you don’t understand what the relationship thoroughly. He even uses the analogy that it’s kind of [...]
Jan 14, 2012
In this article, the author states that people that work with anything related to databases are often asked by their organization to take on the job of data modeling even though it does not specify it on their job description. With that said, he gives us some basic data modeling concepts everyone working with databases [...]
Jan 6, 2012
Summary: The iraq war is over but the U.S. is keeping a database of about 3 million Iraqis using biometric technology and also has a database of afghan’s. The U.S. military has been using these biometric scanners throughout the war and used it to collect biometric data if they wanted to become iraqi police, work [...]
