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.

Fixing: SQL Server Error 4064 …

An error that is known how to solve it, I was the victim today with it and when I started the SSMS, I saw that error. I’m telling you here how to fix it as fast info and references from MS.

This error usually comes when your DB no longer exists or it is in suspect mode or has been detached or offline etc, and you will have the pop-up message with error description and the number 4064:

Ok, as you can see the user Blue cannot connect in the default database and the login failed!

Fixing this error is really easy, so you can try again to login with that user but first before to Connect, you must go to the Options that is in right corner below and you will be asked for the Connection Properties on the second tab of the login dialog box and you must enter the master database in the drop-down box, see the fig below and hit Connect:

Now you will be able to connect in your SQL Server. So what’s next!? As I said, some of the reason why it happened are described above, so now you can check for the correct DB that must be as default DB of that user. After that to be sure for the next connection you need to change the default DB via T-SQL or GUI:

GUI: Open the SSMS  on the right, you have object Explorer, go to Security > Logins > Find your login and right click > Properties. You will have the dialog box like shown in the fig below.

Or you can use the T-SQL script:

USE [master]
GO
ALTER LOGIN [Blue] WITH DEFAULT_DATABASE=[TESTING2];
GO

For more info about this error, you can check here.

ALSSUG & ALNUG Second Meeting

Yesterday, my friend Betim Drenica (B | T) as Leader of the ALNUG (Albanian .Net Users Group) and I as leader of the ALSSUG (Albanian SQL Server Users Group) have organized second meeting of our UG in very lovely environment at Innovation Center of Kosovo, in Prishtina.

We had nice sessions about SQL Server window Functions, C# 5, Web Services yesterday & today and two light talks. Event went well and we had a great audience around 45 people. Also lot of the discussions and encouraging the audience to speak something from their experience in the next events.

Need to say “thank you” to our sponsors and supporters: ICK (Innovation Center of Kosovo), STIKK (Kosovo Association of Information and Communication Technology), and other sponsors that are available in our official website!

Honored with MVP award!

 

I’m so honored to be recognized as an MVP for SQL Server by Microsoft!
Thank you Microsoft and the SQL Server Community.

My journey was started more than 4/5 years ago and the first person that I have discussed lot and lot about my activities for my local community for the SQL Server was the Editor of the SQL Server Central – Steve Jones (Tweetiutiu) so, thank you Steve, encouraging me to start activities with my blog and other stuff that is related to the SQL Server!

Now, this award that really makes me happy and so honored to be part of the elite (MVP) technical people that I’m proud to be part of it, makes me to do more  for my local community and also for the SQL Family in global community!

Once again I would like to say Congratulations to the new MVPs and all renewed MVPs as well!

All the best and Stay Tuned!
Dugi

SQL Server 2008 R2 – Service Pack 2 now available

SQL Server Team, has announced the Service Packe 2 available for the SQL Server 2008 R2.

All the details are here 

Stay Tuned…!

SQL Server 2012 Express RC

The new version of the lovely SQL Server edition, Express Edition!

Take a look the new link for the download and you have many possibilities for the download – (32/64 bit, multilingual etc).

SQL Server 2012 Express RC

http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx

Stay Tuned!

Albanian SQL Server Users Group–First Meeting

Today, I’m so excited to announce that we had the first meeting of our Users Group – Albanian SQL Server Users Group and I’m very happy that we made the possibilities to organize this great event with our great sponsors that support us and everything was so attractive for the attendees.

We presented our program as Albanian SQL Server Users Group to the attendees where we have discussed lot about our mission, our activities, how the others can involve in the Users Group activities, how we can collaborate with others in the community, our partnership with others etc. Also in our today’s agenda were some presentations including New Features in SQL Server 2012 RC0 – presenting from Betim Drenica (Blog > http://betimdrenica.wordpress.com/ | @betimdrenica), and from other colleges Rexhep Kqiku (@rkqiku) & Adem Gashi (@dudemqe) that have presented about new features in Visual Studio 2011.

In this day, we have promoted also two new registered Users Group that are live now and soon they will organize their first meetings, they are Albanian .Net Users Group and Kosova Microsoft Infrastructure Group. According to this now we have three active Users Groups and I hope that our community will be so active and informed with new products and new features in existing products of the Microsoft’s technology.

It was a huge interest from the attendees to have this kind of the meetings being part of the Users Group and involving their self with lot of the contribution in Users Group activities in the future, what I appreciate a lot their readiness and as the leader of the Albanian SQL Server Users Group it gives me encouragement and willpower to be more and more active and engaged with our great and enthusiastic community.

Stay Tuned …