June 2007 - Posts

If you've not been able to attend any of the SQL Server 2008 Livemeetings over the past month introducing some of the new features in SQL Server 2008 then don't worry, they are all available for viewing on demand using the following link 

SQL Server 2008 Archived Livemeeting Events

There is one left on the schedule for Friday 29th on the new MERGE SQL statement

Posted by sqldbatips | with no comments
Filed under:

If you have been trying out the new Declarative Management Framework policies you may have run across an issue trying to use an Execution mode of Check on Schedule with the error "Could not load file or assembly Microsoft.SqlServer.DmfSqlClrWrapper" being reported in the policy job history.

The Declarative Management DLL, which runs inside the SQLCLR, did not get signed as part of the build process. Running the command below will disable strong name verification for this assembly. Client-side checking of policies: "Test Policy" and "Run Now" will function as expected without the fix. Policy automation (enforce, check on change, and check on schedule), though, will require applying the fix.

The fix is very simple. Launch a command line and run the following command:

"C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\Bin\sn.exe" -Vr Microsoft.SqlServer.DmfSqlClrWrapper,89845DCD8080CC91

Thanks to Dan Jones for the fix details in his forum post

Posted by sqldbatips | with no comments

The SQL Server 2008 Product Overview whitepaper is now available. It details some of the upcoming enhancements to SQL Server in the 2008 release (note that almost all of these are NOT in the June CTP). Some of the key engine features I'm looking forward to are

  • Native Backup Compression
  • Enhanced Data Compression
  • Data Auditing
  • Transparent data encryption
  • Proper Resource Governor

These features all help with the current pain points of ever increasing storage requirements, database consolidation, compliance and auditing.

Posted by sqldbatips | with no comments
Filed under:

If you have questions, comments, issues with the June CTP of SQL Server 2008, a new set of MSDN web forums are now available. For reporting bugs use the SQL Server Connect Feedback channel as usual. For comments about the documentation, use the feedback links in the June CTP of SQL Server Books Online (BOL)

SQL Server 2008 Web Forums
SQL Server Connect Feedback

Posted by sqldbatips | with no comments
Filed under:

You can now download the June CTP of SQL Server 2008 ("Katmai") from the Microsoft Connect site. Downloads are available in executable or iso format and x86 and x64 versions. The June CTP of SQL Books Online (BOL) is also available. Note that you do need need to register for the CTP in order to download the files.

Connect SQL Server 2008 site

Posted by sqldbatips | 1 comment(s)
Filed under: ,