sql server

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

SQL Server Troubleshooting Useful Links

SQL Server Troubleshooting Useful Links

When it comes to troubleshooting performance issues with SQL Server queries, you don’t need an advanced degree in rocket surgery. You just need an idea of what the possible bottlenecks are and then apply some common sense. I “bucketize” performance issues by following a process of asking some simple questions. It goes something like this: Are all queries(…)

How To Avoid Butchering Your Windows Azure SQL Database Designs

How To Avoid Butchering Your Windows Azure SQL Database Designs

I met a man once who told me how he wanted to be a butcher but his hands weren’t steady enough. So, he decided to become a dentist instead. The man, of course, was my dentist. And he said those words as he started up his drill. Good times. I often think about that dentist(…)

Load More