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
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great sessions with tracks about DBA, BI, DB Dev, and Porfessional Development. Once again the presenters will be the top – notch experts and SQL Server MVPs with strong experience and I think that we will have many things to refresh and learn again, also learn something new from them.
You can check the sessions listing by tracks >>> http://tinyurl.com/2w4bkkl
To register for the any session that you are interested click >>> http://tinyurl.com/2uvemqt – is better that you can pick up all sessions if you want, this is the great possibility that you have in 24 HOP!
Have a nice stay with next 24 HOP!
Another free tool for SQL Server that supports SQL Server 2008/2005/2000, comes from xSQL Software, the Script Executor Commnity Edition, that provides for transactional execution of T-SQL scripts, it is a small application, totally free to use and very powerful for the DBAs and also Developers that allows you to run multiple T-SQL scripts. It runs on Windows OS, it is client – server, it has .Net framework 2.0 installed.
There is some nice features of this small and very powerful tool:
Execute multiple T-SQL scripts at once
Support different transactional execution modes
Robust scripts execution error handling
Command line options for batch execution
Simple and intuitive interface
For more details and free to download, you can check it here
~~~Have a nice SQLing
Getting Started with SQL Azure – Very nice & short document about SQL Azure beginning process. This is the official document that is published from Microsoft, this document provides guidelines on how to sign up for SQL Azure, it has 23 pages and illustrated with examples and figures on how to start with SQL Azure server and databases.
Author: Selcin Turkarslan
Technical Reviewr: David Robinson & Lubor Kollar
Published: July 2010.
For more info and download check here