Welcome to TechNet Blogs Sign in | Join | Help

May 2009 - Posts

SQL Server 2008 Security Related Whitepapers

Posted Saturday, May 23, 2009 10:35 PM by spawar
I was just conducting research for improvements in security in SQL Server 2008 and came across the below whitepapers which are great references if you are looking at improving security of your SQL Server environment.   Engine Separation of Duties Read More...
1 Comments

Guest Failover Clustering now supported for virtualised SQL Server

Posted Wednesday, May 20, 2009 12:14 AM by spawar
Just in case you missed it!!! Microsoft Support announced an update to the SQL Server virtualisation support policy.   Guest Failover Clustering is supported for SQL Server 2005 and SQL Server 2008 in a virtual machine for Windows Server 2008 with Read More...
1 Comments

Converting Existing table from BLOB to Filestream

Posted Sunday, May 17, 2009 8:27 PM by spawar
1. Create FILESTREAM filegroup. 2. Add FILESTREAM column to table 3.   Choose one of: a. Write an app to select data from the BLOB column and stream it into the FILESTREAM column b. UPDATE <table> SET <filestream_column> = <blob Read More...
1 Comments

Lots of SQL Server related announcements at Teched 2009 (USA)

Posted Thursday, May 14, 2009 11:14 AM by spawar
Summary of the SQL Server Announcements: Official name for the next release of SQL Server:  SQL Server 2008 R2 This is release name for what was announced earlier as code named ‘Kilimanjaro'. This release includes all the great BI enhancements announced Read More...
0 Comments
 
Page view tracker