At Directi, we are taking a hard look at the way our applications need to store and retrieve data, and whether we really need to use a traditional RDBMS for all scenarios. This does not mean that we will eschew relational systems altogether. What it means is that we will use the best tool for [...]
David Litchfield has published a comparison of the security of the SQL Server and the Oracle products at http://www.databasesecurity.com/dbsec/comparison.pdf and he has clearly pointed out that SQL Server 2005 is more secure. For those of us who do not know Litchfield’s work, here is a bio copy-pasted from http://www.oreillynet.com/pub/au/1609: "David Litchfield leads the world in [...]
This is funny. Oracle finally has a visual db dev tool. "My God, it’s about time. It’s way late," Mike Hichwa, vice president of software development at Oracle, said in a phone interview Thursday. "We should’ve had this four to five years ago." I couldn’t agree more. Welcome to civilization folks!
On a recent mailing list discussion, Veer Wangoo asked: "DOT NET CLR only uses thread-based scheduling and does not support Fiber-mode scheduling; however, SQL Server can use Fiber-mode scheduling as well. How does SQL 2005 Handle this Limitation?" Answering this question led to a lot of soul-searching and I finally managed to answer this in [...]
Ken Henderson is updating his SQL Architecture book for 2005 and is looking for some feedback. Please do visit this blog entry and offer your suggestions.
I am in Bangalore tomorrow and day after at the Intel Developer Forum where I am doing a lab on Data Mining using SQL Server 2005. BTW, if you follow that linkm you’ll find that they’ve got the title of the lab wrong – it’s mentioned as SQL Server 2005 Reporting Services. The session abstract [...]
Kimberly Tripp has put up the draft of a whitepaper on SQLCLR for the DBA. This will eventually end up on MSDN. I especially liked some of the last few sections: Source Code management, Release management and Warning Signs. This is stuff people use in real life and is very useful information, all under one [...]
Someone recently pointed me to http://www.quickshift.com/Product_QS-SQL.shtml. These guys claim 3x and 4x times performance gains with SQL Server. The product apparently sits between the OS and SQL Server and they improve performance by managing the "flow of data and operations." They don’t give details on the technology up front – you need to contact them [...]