SQL Server Identity Values Check
Very few users have any idea how many SQL Server identity values they have remaining on a column.
Database Design
HOW TO: Improve Database Performance Without Changing Code
I’ve stated before that great database performance starts with great database design. So, if you want a great database design you must find someone with great database experience. But where does a person get such experience? We already know that great judgment comes from great experience, and great experience comes from bad judgment. That means … Read more
Enterprise Data World 2015 Recap
Last week I was fortunate enough to attend Enterprise Data World in Washington DC. I was not just at EDW as an attendee, I was also presenting two sessions. Since it was my first EDW that meant I had no idea what to expect either as an attendee or as a presenter. On top of that I was … Read more
Presenting This Week: Enterprise Data World
This week I will be attending Enterprise Data World in Washington, DC. I’m excited to have been given the opportunity to present not one but TWO sessions at the premiere data management conference in the world. On Wednesday, April 1st, I will be presenting a session titled “Designing For Performance or How I Learned To Stop Worrying … Read more
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
The Five DBA Food Groups
Tomorrow is Thanksgiving here in the USA. It’s a day where we are supposed to be thankful for what we have been given and instead we mostly use it as an excuse to eat obscene amounts of food, watch 10 hours of NFL action, and force retail workers to work longer hours in the name of … Read more
