Category Archives: SQL Server

SQL Server SSMS 16.3 Release

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 – call for Speakers…

PASSi

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…

 

 

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