If you download the July release of SQL Server Management Studio 2016 Please go and download the SQL Server Management Studio July 2016 Hotfix update from here https://msdn.microsoft.com/en-us/library/mt238290.aspx
It is a very important fix that resolve issues produced in the July update that causes you miss important commands in the right-click menu on tables and stored procedures
Here are the Linked customer bug requests:
Welcomes you to the first SQL Server 2016 event in the Middle East at AlFaisal University on 23/4/2016
We are so glad to announce SQL Gulf #3 event , Riyadh 2016 which will be held at Al-Faisal University on 23th April where top notch MVP, MCM and MCA experts are coming from different countries worldwide Australia , US, UK and Germany to speak to you about SQL Server 2016 ONLY…! It is the first event ever in the middle east to reveal about the latest Microsoft SQL Server 2016 technologies and techniques ,the event is for both male and female ,come to register here ASAP http://waja.com.sa/SQLGulf3/
Speakers
Yesterday I was having a discussion with one of the Analyst regarding an item we were going to ship in the release. And we tried to check and validate the data if it was getting populated correctly or not. To just get the count-diff of records in pre & post release I used this Query:
To my surprise he mentioned to use COUNT(1) instead of COUNT(*), and the reason he cited was that it runs faster as it uses one column and later uses all columns. It was like a weird feeling, what to say… and I just mentioned “It’s not, and both are same”. He was adamant and disagreed with me. So I just kept quite and keep on using COUNT(*) 🙂
But are they really same or different? Functionally? Performance wise? or by any other means?
Let’s check both of them.
The MSDN BoL lists the syntax as
View original post 314 more words
Microsoft CEO Satya Nadella is visiting Egypt as a special keynote speaker during the Microsoft Developers Conference, which DONE on the 5th of January, 2016. The conference is the perfect opportunity to brush up on the latest tools, technologies and topics such as big data, machine learning, IoT and cross platform development.
Microsoft Developers Conference is meant to bring the Top IT industry Influencers and brush up on the latest tools and technology, such as Big Data, Machine Learning, Internet of Things, and Cross Platform Development.
Microsoft’s C.E.O., Satya Nadella,Greetings from Cairo. Today I met with Walid Khairy and Ahmed Najeeb, developers and co-founders of indie game studio 2024. Egypt is becoming an innovation hub within the region, and it was great to see the creativity and passion of Egyptian developers and startups. -SN – See more at: http://iconosquare.com/p/1155976999660073731_524549267#sthash.L8aepkub.dpuf
I completed 4 Years as SQL Server blogger with my small Community SQL Server Consultation Community (http://mostafaelmasry.com)
I started it from 2012 and I will not stop sharing the information ad the new Technology in SQL Server
You can check the WordPress annual Report for the last 4 years from here
DB Cloud TECH 