SSMS

HOW TO: Connect To A Windows Azure VM Using SQL Server Management Studio

HOW TO: Connect To A Windows Azure VM Using SQL Server Management Studio

In 2013, right before I was helping to deliver a precon seminar at TechEd on Windows Azure SQL Database, Microsoft made available the ability for customers to use virtual machines running in Windows Azure. This allowed for users to run on-premises version of SQL Server but have the instance hosted in the cloud. The natural(…)

BREAKING NEWS: Microsoft SQL Server Will Do What You Tell It To Do

BREAKING NEWS: Microsoft SQL Server Will Do What You Tell It To Do

The voice on the other end of the line was concerned. It would appear that their server was having memory issues. But they already knew the answer, the memory issues were ‘expected’ due to the fact that they were running Microsoft SQL Server. “SQL Server is a memory hog, it uses all that the server has!”(…)

The Shocking Truth About Microsoft Connect

The Shocking Truth About Microsoft Connect

The truth is this: It works. Oh sure, the process may be slower than molasses in the winter. And the overall experience may be as frustrating as helping your parents with their email. But it really does work. Here is my example. I was using the Google the other day and came across this Connect item: https://connect.microsoft.com/SQLServer/feedback/details/481566/policy-evaluation-screen-is-difficult-to-read(…)