Sunday, August 15, 2010

MS SQL 2008 R2 useful features

Yes ,SQL server 2008 has a new version again. Its R2 folks. Im going to give you some basic and useful ways to use the new features
  • Policy based management (PBM) --control database,table, trigger and object names
  • Resource governer --take control of your memory and processor again
  • Back up compression ---Dont need more SAN LUNS
  • data file encrytion --- someone stole your mdf files..no worries
  • filestream--- replace BLOB with this
  • New report builder 3.0 --more charts and datasets added
  • New database mirroring recovery options
  • totally rebuild database replication engine
  • New sharepoint integration..

No comments:

Post a Comment