SQL Server 2005 Express to 2008 Express

-
I faced with two simple problems, while I was moving from MS-SQL Server 2005 Express(SQLS2005E) 2005 to MSSQL Server 2008 Express(SQLS2008E).

First of all, I received a warning that I cannot change a table when the changes I made require the table re-creation.
This is something new in SQLS2008E, then I go to Tools>Options>Designers and make sure that "Prevent saving changes that require table re-creation" option is unchecked.

Another interesting behavior in SQLS2008E that when you navigate to see Stored Procedure within Object Explorer via Databases>DBName>Programmability>Stored Procedures it says "See Object Explorer Details for objects in this folder" and just shows the System Stored Procedures in the Object Explorer window. You can view the object explorer details from the View menu but I always use F7 shortcut for that.

Comments

Post a Comment

Popular posts from this blog

Space Character Problem on IE 6, 7, and 8

-
Most of the time, we need to put space in between two HTML elements to separate them. There are bunch of ways to achieve this but the following are the most common ones that I use: Space character ( ) CSS Margin (margin-right/margin-left) Space character is so natural separate them but CSS margin gives more flexibility. Also recently, I found out that in IE 6, 7, 8, extra space characters between HTML elements are not rendered as intended. For instance regular space character ( ) is rendered without the space on older version of IE (older than 9) a   b Result in IE 6, 7, 8: ab Whereas, if you use CSS (e.g. margin-right: 4px), all versions of IE renders it correctly a b Result in all IEs: a b
Read more

Does Netflix work on iOS 5 Beta 4?

-
Yes, finally Netflix works on iOS 5 Beta 4!! Two days ago I updated Netflix to a new version and boom it not works on iOS 5 now. But in my opinion iOS 5 is still not ready for a release to public. Here is the latest bug I faced with; After my update to iOS 5 Beta 4, alarm clock on the phone did not work! I had to reset the alarm clock to make it working again, huh.
Read more

AWS encryption chart (SSE-S3 vs SSE-KMS vs SSE-C)

-
IN TRANSIT AT REST SSL/TLS Server Side Managed Keys Client Side Managed Keys S3 (SSE-S3) Each object is encrypted with a key. Amazon encrypts the key with a master key, which rotates regularly. AWS Key Management Service (SSE-KMS) Allows you to audit trail (who and when used the key), extra cost and you manage the master key. Customer provided (SSE-C) User manages the keys but encryption done by Amazon User encrypts the data on client-side and uploads to S3
Read more