Category Archives: SQL Server 2008

Everything that is related to SQL Server 2008

SQL Server features that are not supported by Azure SQL Database

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
  • Replication
  • Extended Store Procedure
  • SQL Server Agent

For more information you can check here.

SQL Server Sample Databases – All Versions

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!

Stay Tuned!


24 HOP recordings

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

Stay Tuned

Soon will start 24 Hrs of PASS – free SQL knowledge stuff

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

Stay Tuned!

SQL Server 2008 R2 System Views Map

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…

SAC in SQL 2008 (R2)

SAC (Surface Are Configuration) was the great possibility to configure the SQL Server 2005, so there were some options to configure the DAC(Dedicated Admin Connection), using xp Store Procedures, CLR Integration, AdHoc remote Queries that enables the OPENROWSET & OPENDATASOURCE support, SQL Mail etc.

Now in SQL Server 2008 and SQL 2008 R2, you cannot find anymore the SAC as config tool! You can configure Surface Area via SSMS (SQL Server Management Studio) using the FACETS, that are located at the SQL Server Instance >> right click >> Facets as shown in the fig below:



Choose the correct Facets in our case the Surface Area Configuration. As you can see, you have lot of the Facets except the SAC Facets, that you can configure for the SQL Server.




At the first view all the features are disabled by default, so you have possibility to change the values for each feature from Flase to True, to activate them for your SQL Server. It is recommended, to enable only those features that you need, otherwise you will leave the possiblity for any potential attack!



Important thing here, is that you don’t need to restart you database engine to affect the changes and you can use the button “Export Current State as Policy…” to export the current configuration then apply to the other SQL Server with the same Surface Area Configuration features.
On the other hand if you want to know more about the facets in SQL Server 2008 (R2), it would be better to visit this location.