Archive

Posts Tagged ‘Learning’

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 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.

New road to the SQL Server 2012 Certifications

MS has announced the new road for the SQL Server Certifications. All of the interested folks knows that the old way was with MCTS (DBA, DB Dev & BI) and MCITP (DBA, DB Dev & BI) series.

Now, the new way is to earn the MCSA pack that is in combination of 3 exams:

Exam 461 - Querying MS SQL Server 2012
Exam 462 – Admin a MS SQL Server 2012
Exam 463 – Implementing DataWarehouses with SQL Server 2012

Also the upgrade road is available, so everything you need in details are here.

After MCSA Certification series for the SQL Server 2012 that is in the same level like MCTS and where these certifications validates a set of core SQL Server 2012 skills that are relevant across multiple solution areas, the next level will be MCSE for the SQL Server 2012 that are more specific type:

Data Platform – for building and administering data solutions including Cloud.
BI – Business Intelligence solutions and reports.

Data Platform = MCSA + Exams (464 & 465)
BI = MCSA + Exams (466 & 467)

Upgrades are available also for both MCSE Certifications on SQL Server 2012 …for more info >>> Data Platform & BI  

Stay Tuned and wish you success with new certifications! 

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

Get every new post delivered to your Inbox.

Join 815 other followers