August 2007 - Posts
One frequently asked question is if SQL Server is the only option to store content in a sharepoint environment. The confustion stems from the fact that SQL Server is a requirement for installing sharepoint. The answer is, there is no necessity to store
Read More...
This is a great site to bookmark for SQL Server best practices. There are best practices in several areas of the product. For some reason, the search engines do not always bring this site as the top hits: http://technet.microsoft.com/en-us/sqlserver/bb331794.asp
Read More...
If you have used SQL 2005 encryption before, you might have hated the fact that you need to rewrite you application to access encrypted data. You had to use the encryptbykey and decryptbykey functions to write and read encrypted data. Well, the good news
Read More...
If you guys havent heard of msdewey, you should definitely check it out - www.msdewey.com Search for the word " Lord of the rings" for example. Enjoy :)
Read More...
An interesting topic/discussion i came across today is connecting to SQL Server 2005 64 bit server from 64 bit clients. What options does one have? There are several good references out there. The best one i could find on this was the Data Access roadmap
Read More...
I just created this blog and hope to post some useful tidbits. I am a database technology specialist and so work with the SQL Server product. I will try to post interesting information about SQL Server and the database world in general.
Read More...
