SQL Vulnerability Assessment Available in SSMS
The SQL Vulnerability Assessment (VA) feature in now available in SSMS (SQL Server Management Studio)!
SSMS
Installing SQL Server vNext on Red Hat Enterprise Linux in Azure
Today I wanted to help walk you through how to be up and running with SQL Server on Linux so that you can kick the tires on this version yourself.
Using Templates With SQL Server Management Studio
I love learning new things. I feel like a kid again at times, my eyes get wide as I imagine new possibilities using whatever things it is I have found. This is how I felt last week when I came across a feature of SQL Server Management Studio (SSMS) that I had not seen before … Read more
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 … Read more
Viewing SQL Server 2008 R2 Audit Logs Using SSMS 2012
Short version of this post: you can’t. I’m fairly certain Microsoft won’t be able to return the hours I spent trying to view the SQL Server 2008 R2 audit logs using SSMS 2012. But they don’t have too, really, because they know I can’t quit them at this point. This all came about recently as … Read more
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!” … Read more
