Archive

Posts Tagged ‘SQL Server’

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 …

 

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

Tech Days 2012 in Kosovo

Another Tech Days Prishtina where I will speak about SQL Server 2012 for IT Pros. After a success event in Tirana (Albania), next week in Tech Days Kosovo 2012, I’m honored to be part of the speakers team, where I will speak about SQL Server 2012 new arrivals. According to the previous Tech Days events we will have a great audience over 350 attendees, seems this year will be more than that! However, the event will have in parallel two tracks, the Dev Track with the speakers (Karl Davies-Barrett, Betim Drenica, Arian Celina, Rexhep Kqiku & Lamir Shkurti) and IT Pro Track with speakers (Damien Caro, Dimitar Grozdanov, Driart Elshani & Dukagjin Maloku). The agenda information:

IT Pro Track: aka DPro-Track, while all speakers name started with D!

  • Damien Caro – All about the Cloud-s
  • Dimitar Grozdanov – Learn how to start building your privat cloud
  • Driart Elshani – MS Forefront TMG implementation in the Kosova’s Government IT infrastructure (success story)
  • Dukagjin Maloku – 10 reason to love SQL Server 2012
  • Damien Caro – Windows Server 8

Dev Track

  • Karl Davis-Barrett – Windows 8 a ride on the Metro Application Platform
  • Betim Drenica – Windows Phone Applications using Windows Azure
  • Arian Celina – MVC 4 and WebAPI
  • Lamir Shkurti – 10 reason to love SQL Server 2012 for Developers
  • Rexhep Kqiku – What’s new in VS11 (oriented in ALM)

Links to register for  Tech Days & IT Camp are:

Tech Days Kosovo 2012

IT Camp

Stay Tuned!

Tech Days Albania 2012

I’m very excited for the invitation to present at TechDays Albania 2012, which will be held on April 19, 2012 in Tirana. The event will be held on the perfect environment of the Tirana International Hotel. Well, for the first time we have only Albanian speakers except our guest Karl Davies Barrett. I will be honored to present Top 10 reason to Love SQL Server 2012 for Developers, where I will try to bring really ten things that are attractive for the developers in SQL Server 2012.

In parallel with the Tech Days Albania 2012, the Microsoft will organize also the IT Camp which is totally oriented to the Cloud Technology.

Agenda for the Tech Days Albania 2012:

What’s New – Windows 8

It’s Windows reimagined and reinvented from a solid core of Windows 7 speed and reliability. It’s an all-new touch interface. It’s a new Windows for new devices.

Windows Identity Foundation

The Windows Identity Foundation helps simplify user access for developers by externalizing user access from applications via claims and reducing development effort with pre-built security logic and integrated .NET tools.

10 reason to love SQL Server 2012 for the Developers

Microsoft SQL Server is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.

MVC 4 for Web Applications

ASP.NET MVC 4 is a framework for developing highly testable and maintainable Web applications by leveraging the Model-View-Controller (MVC) pattern. The framework encourages developers to maintain a clear separation of concerns among the responsibilities of the application – the UI logic using the view, user-input handling using the controller, and the domain logic using the model.

Take a ride on the Metro Application Platform

What should you be doing to prepare for Windows 8, and to what extent will you have to revise your existing skill set? This session answers these questions and more as it takes you under the hood and demonstrates how to write Metro applications

What’s New in Visual Studio 11

This section contains information about some of the important enhancements to Visual Studio 11 Beta

I will put the list of the speakers who will cover the agenda above:

Arben Murtaj – Microsoft Albania, Technology Strategist
Karl Davis Barrett (@karl_db) – Developer Platform Evangelist @ Microsoft
Elton Ropi – Software Architect at ikubINFO
Dukagjin Maloku (@DugiDBA)- Leader of the Albanian SQL Server Users Group
Betim Drenica (@betimdrenica)- Leader of the Albanian .Net Users Group
Arian Celina (@ariancelina)- Software developer

Stay Tuned

Categories: Events, SSC Tags: , ,

24HOP Spring 2012 recordings

Many of the folks who are the PASS members, can have the possibility to watch 24 Hrs of PASS Spring 2012 if someone has missed the presentations. So, after interesting presentations, the PASS have posted the recordings and you can watch them on demand offline.

Take a look the list of the presentations and all the instructions how to watch them are described on the post.

Have a nice time with 24HOP Spring 2012.

Stay Tuned.

Categories: Events, SSC Tags: , , ,

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!

Follow

Get every new post delivered to your Inbox.

Join 880 other followers