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!
SQL Saturday Kosovo #225, happened last week and I’m very happy that we did for the first time in Balkan region!
Special thanks goes to the sponsors Ipko Foundation, PASS, Microsoft, ICK (Innovation Center Kosovo), Redgate, Wrox, PluralSight, xSQL Software, Digjitale.com, Nescafe as well as Albanian SQL Server Users Group > ALSSUG.
We had just one track this time and with great speakers & their strong experience ( Dejan Sarka, Niko Neugebauer, Mladen Prajdic, Turgay Sahtiyan and Matija Lah), and for more details about their presentations you can find here.
As first time SQL Saturday in our country, the event went well and we had 118 registered attendees and 82 were present in the event for all the day of the 18th May, 2013. Thanks to the Niko as my mentor for this successfully event and I need to say thank you also to my friends who helped me a lot during the organization of the event (Betim Drenica, Florim Maxhuni, Milot Rexhepi).
Starting to look forward for the next one, soon! … stay tuned!
Some of the photos of our event:
I’m so exciting to announce that the SQL Saturday Kosovo is going to be held on May 18, 2013 and it’s our firs time SQL Saturday where I will speak also. However I’ve started the challenge journey to organize things properly. The most important thing here for our local community is that the list of the speakers will be all the MVPs for SQL Server.
More information will be in our official website at SQL Saturday #225 Kosovo.
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:
ALTER LOGIN [Blue] WITH DEFAULT_DATABASE=[TESTING2];
For more info about this error, you can check here.
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.
Free tools are very welcome to the community, while the creators are open to the community as well! I discussed more early about free tools (here & here) , so today let me show you the great tool for SSMS and it supports the SQL Server Deanli 2011 CTP1.
The SSMS Pack Tool is available for download, here – so you can check & download and you can use it totally free!
Have a nice SQLing!
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