SQL Server is in the Cloud as Windows Azure SQL Database, but in the Cloud, still have some limitations that are not supported and here are some of them (short info):
SQL Server 2008 R2 features that are not supported by Azure SQL Database:
- SQL Server Utility
- Master Data Services
SQL Server 2008 features that are not supported by Azure SQL Database:
- Change Data Capture
- Data Auditing
- Data Compression
- Extended Events
- Filestream Data
- Integrated Full-Text Search
- Policy-Base Management
- Resource Governor
- SQL Server Replication
- Transparent Data Encryption
SQL Server 2005 features that are not supported by Azure SQL Database
- Common Language Runtime (CLR and CLR User-Defined Types)
- Database Mirroring
- Service Broker
- Table Partitioning
- XML Indexing
Other features that are not supported as well:
- Backup and Restore
- Extended Store Procedure
- SQL Server Agent
For more information you can check here.
Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server version to another (SQL Server 2012RC0 / 2008 R2 / 2008 / 2005) and when you trying some scripts that you can find here in SSC articles or anywhere else, some of the scripts cannot be test because of the version that you have installed! However, you can have a machine with lot of the resources where you can install any kind of the version that you want to test things so in all SQL Server installation you need to have Sample DBs that are very usefull for testing purposes then I’m puting here the great resource from the CodePlex where you can find all sample databases for almost all versions of the SQL Server including SQL Server 2012 RC0!
Take a look this location here and enjoy the Sample Databases in any version of the SQL Server that you have installed!
For all of you, that you have missed any session from the last 24 HOPass – you can check here
24 Session of the last 24 Hours of PASS are available for viewing online, it is a nice place where you can win knowledge about the SQL Server and once again thanks to the PASS HQ while they put all sessions online
Next, wish you to enjoy the PASS Summit 2011 for the all attendees
Yes, 24 Hours of PASS will start soon two days in row, 7-8 September 2011! Just for info for those who didn’t know before or forget to register for a great SQL Knowledge stuff from the well known SQL Professionals, who are ready to spread their knowledge to the others with no cost at all! – so a BIG THANK YOU goes to them!
Well, the location where to register for the Online presentations and where you can see every details about two days training for SQL, is here.
Anyone wants to know what is happening live about 24 Hours of PASS, check via Twitter tag #24HOP
Update from Microsoft for SQL Server 2008 & 2008 R2. There is the graphical map of the system views included SQL Server 2008 and SQL Server 2008 R2 and the relationship between them. The map is similar to the Microsoft SQL Server 2008 version and includes updates which are also applicable for the Microsoft SQL Server 2008.
Check for the details and download here
Have a nice SQLing…
Just for info that the incoming 24 Hours of PASS now has bonus sessions …you can check for the details and register >>> http://bit.ly/9uyxNX