I was honored to be part of very first & very high professional workshop about the vmware and SQL Server. Among us were lot of vmware and SQL Server Experts from Europe and US like MVPs, MCM, vExperts, vmware CTOA, etc
Awesome experience …
SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SSMS 16.3 release includes initial beta support to allow SSMS to display appropriately on high-resolution monitors.
For more info about this update you can read >>> here
For everything about the SSMS you can check >>> here
Stay tuned …!
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals, with lot of the tech sessions covering a lot for the Database Development, Database Administration, BI, Cloud, Professional Developement, Training, Tips’n’Tricks and much more.
It is going to be held on 25-28 Oct, 2016 in Seattle – US and here it is the offical website:
http://www.sqlpass.org/summit/2016/Welcome.aspx
Call for speakers is now open and you can find more details how to apply and submit your abstracts in the link-location below:
http://www.sqlpass.org/summit/2016/Speakers/CallForSpeakers.aspx
Stay Tuned…
Take a look this awesome document for the Azure SQL DB technical deployment with lot of the details that you need to know about the Azure SQL DBs
Click to download and enjoy SQL DB deployment in Azure.
Stay Tuned…
Another free resource for learning and gaining your knowledge that might be possible to earn MCSA Certifications with few efforts. Here is the link: 90 Days to MCSA – where you have 6 videos, 3 per Windows 2012 and 3 others for SQL Server 2012 MCSA Certification prep. There are also some additional resources like Discussion Forums and Resource Wikis. In the right corner, you have another resource, Certification Challenge where you can find more and more info about Certs path!
A good news for the Exams, is that you can win a voucher to save 20 % + Second Shot for free (just in case if you failed!!!), check here, a great offer from Microsoft Virtual Academy – another great resource for the courses about the SQL Server.
Knowledge is the Power – Learning is the key!
Learn & Enjoy!
I’m honored to be recognized as SQL Server MVP for the 2nd time in row and thank you Microsoft to honored me again! Thank you also to our great SQL Community and SQL Family!
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 2008 features that are not supported by Azure SQL Database:
SQL Server 2005 features that are not supported by Azure SQL Database
Other features that are not supported as well:
For more information you can check here.
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.
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!
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
Dukagjin Maloku 