SQL Updates Newsletter – December 2014

Recent Releases and Announcements    ·         SQL Server 2014 CU5 o   http://support.microsoft.com/kb/3011055 ·         SQL Release Services Blog o   http://blogs.msdn.com/b/sqlreleaseservices/ ·         Microsoft Security Bulletin Summary for December 2014 o   There is a critical IE, Office, and Windows update for this month: o   https://technet.microsoft.com/library/security/ms14-dec ·         New Microsoft Intune capabilities o   http://blogs.technet.com/b/mackblog/archive/2014/12/02/new-microsoft-intune-capabilities.aspx ·         Security Compliance Manager Baselines for…


Ruby Text Objects

Chinese characters are used to represent syllables and words in a number of East Asian languages. In each language, the characters are pronounced differently and their meanings may differ as well. To help clarify the pronunciation and/or semantics, “ruby text” can be used. In vertical text layout, ruby text is positioned vertically to the right…


IN CASE OF A PROXY WHILE UPLOADING YOUR VHD TO WINDOWS AZURE USING POWERSHELL

Sometimes when you are trying to do certain process on Windows Azure via Powershell you receive an ambiguous error with no specific error message, make sure that you don’t have a proxy in the environment blocking your communication to Windows Azure, If you do have one, then run the below command and then retry what…


HOW TO ALLOW PING FUNCTIONALITY TO WINDOWS AZURE MACHINES?

The Ping functionality on Windows Azure VM is blocked by default for security reasons, to be to enable them you can do that from the Windows firewall advanced features on each VM or you can login on the virtual machine and open the command prompt as an administrator and execute this command.   netsh advfirewall…


HOW TO COPY YOUR VMS FROM ONE REGION TO ANOTHER REGION ON WINDOWS AZURE?

A lot of customers start by creating their Virtual machines on Windows Azure on any Datacenter they encounter without caring about the latency or the performance and later on they discover that this Datacenter doesn’t provide them with the optimum performance they are looking for so they start looking for a way to move their…


HOW TO CREATE HIGHLY AVAILABLE (LOAD BALANCED) FTP SERVER ON WINDOWS AZURE?

There are a lot of blog posts that explains how to create a FTP Server on Windows Azure, the best one that I’ve encountered was this one. http://itq.nl/walkthrough-hosting-ftp-on-iis-7-5-a-windows-azure-vm-2/ by Ronald Wildenberg So in this post I won’t explain how to create a FTP server on Windows Azure, I’ll explain how to create highly available load balanced FTP…


Better together: Visual Basic 14 and the Visual Studio 2015 Debugger

“Lambdas! Lambdas! Lambdas! Lambdas! …” If you hadn’t heard, Visual Studio 2015 will support the use of lambda expressions in the debugger windows. We’re all very excited to deliver on this longstanding TOP customer request. When LINQ was introduced in 2008 it was a game changer for the way .NET developers think about and code…


New Language Features in Visual Basic 14

“Visual Basic 14” is the version of Visual Basic that will ship with Visual Studio 2015. In this blog post I’ll talk specifically about the VB language improvements in this release. (Separately, there are a whole host of IDE and project-system improvements as well). There are two overall themes to the language improvements: (1) Make…


Guidelines for Setting SQL Permissions on Mount Point Folders

You can use Windows Disk Management to assign a mount-point folder path (rather than a drive letter) to a volume. In this manner you can access a new volume via a child folder path of a different volume’s drive letter. For example, say you have three 100GB volumes Vol1, Vol2, Vol3. We can initially mount…