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.

A week far away…24 HOP!

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 >>>

To register for the any session that you are interested click >>> 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!

A great free tool for SQL Server…

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 (doc)

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.

Document details:

Author: Selcin Turkarslan

Technical Reviewr: David Robinson & Lubor Kollar

Published: July 2010.

For more info and download check here

~~~Stay Tuned!