SQLServerPedia Wiki

You’re Doing It Wrong – Database Standards

You’re Doing It Wrong – Database Standards

Having standards is important. If you don’t believe me, just ask your spouse or significant other. Knowing that such things are important I am willing to wager that your company has spent time putting together a set of standards to be followed with regards to application development, including database standards. I’m here today to tell(…)

The Top 5 SQL Server Features You Aren’t Using And Why

The Top 5 SQL Server Features You Aren’t Using And Why

I’m throwing my money away. I know I am, and yet I still do it. It’s not a lot of money though. See, I pay for a services bundle (phone, internet, cable television) from the one-and-only provider for my town and I’m certain that I am not using every possible feature. For example, I have(…)

Choosing The Cloud Solution Provider That’s Right For You

Choosing The Cloud Solution Provider That’s Right For You

It’s hard to talk architecture these days without a mention of the Cloud finding it’s way into the conversation. Everyone wants to know “is the Cloud right for me?” Unfortunately a lot of people have no idea what “cloud” truly means. Do some digging on what “cloud” means and you will find a lot of information. You(…)

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(…)

Load More