Archive

Archive for the ‘SSC’ Category

SQL Saturday Tirana (Albania)

Image

I’m very exciting to announce that we will have next SQL Saturday event in Albania, Tirana, which is going to be held on 4th Oct, 2014.

While around the World there are many SQL Saturday, our one will be very attractive and we just have first submissions from well-known speakers and why not if you want to be part of our community you can apply for a session at least and later on the next month we will create the agenda with full details (who will speak, what will speak etc).

I will be there also where I decide to speak something between SQL and Azure SQL Databases, to be more specific my session will cover lot of info how to work with SQL Databases and publishing them in to the Azure then how to administer them from the Azure portal and much more…

So, from here I encourage you to  be part of our SQL Community and you will be very welcome!

See you at SQL Saturday Albania (Tirana) #sqlsat344 #sqlsatAlbania #sqlsatTirana …

 

MCSA in 90 days… & lot of resources

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 Server MVP for the 2nd time in row!

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!

mvplogo

 

 
Categories: General, MVP, SQL Server, SSC Tags: ,

SQL Server 2014 CTP2 …ready to download

Announced and available for download the SQL Server 2014 CTP2:

Release Note:
http://msdn.microsoft.com/en-us/library/dn169381%28v=sql.15%29.aspx?lc=1033

Download Location:
http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx

…and something that is very welcome for the community is the live from the PASS Summit 2013 is here:

PASS Summit 2013 – Live

Enjoy…

Recap of our SQL Saturday #225 in Kosovo, Prishtina

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 FoundationPASSMicrosoftICK (Innovation Center Kosovo), RedgateWroxPluralSightxSQL SoftwareDigjitale.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:

SAMSUNG376867_520255384704434_593745047_n977773_520255574704415_602179905_o972292_520282468035059_2139260685_n971482_520255631371076_1151810174_n970792_520255651371074_1277558398_nCIMG1827

facebook_-1940239923310222_520255731371066_1613676137_n

375162_520282464701726_869796670_n970712_520254081371231_961765014_nSAMSUNGSAMSUNGSAMSUNGSAMSUNGCIMG1825521980_520255771371062_1605210000_n

Categories: Events, Free, MVP, PASS, SSC

SQL Saturday Kosovo #225

sqlsat225_web

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.

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:

Error4064

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:

OptionConn

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.

Testing

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.

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

Categories: General, MVP, SQL Server, SSC Tags: ,

Ctrl+R in SSMS 2012

After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like in early versions, and one of the most shortcut key that I had problem after my installation of the SQL Server 2012 in the SSMS has been well known shortcut Ctrl+R to remove the last results pane from the SSMS! Ok lets take a look few steps how to activate it in the new SSMS of the SQL Server 2012:

Select > Tools > Customize … click “Keyboard”

In the list window scroll down and find to select “Window.ShowResultsPane”
Go to “Use new shortcut in:” – select “SQL Query Editor”
Go to “Press shortcut keys” text box and press Ctrl+R
Click “Assign” and finally OK!

Now, when you execute a select statement in SSMS and you have results set, you can remove them, pressing Ctrl+R, that is very often used from the Developers and DBA to clear the results pane!

This is very little help and enjoy it!

Stay Tuned…!

Follow

Get every new post delivered to your Inbox.

Join 880 other followers