SQLServerPedia Wiki

Help Keep PASS Summit Awesome for Everyone

Earlier this week I saw this post from Chris Webb (blog | @technitrain) regarding a session he is delivering at the upcoming PASS Summit. When I read the abstract there was one section that jumped out at me (emphasis mine): If you’ve been to PASS Summit before, you know that social media...

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...

Announcing the IS [NOT] NULL Newsletter

Today I want to officially announce the IS [NOT] NULL newsletter.You may have seen me mention the IS [NOT] NULL newsletter on Twitter and Facebook in previous weeks but today I want to show off the shiny new landing page, built by the Business Betties.I've mentioned before that this blog...

Lost Data

DBAs get paid for performance but we keep our jobs with recovery.Being able to recover data is the most important job function you have as a DBA.  If you can't recover your data because database backups are missing, or corrupt, then you should consider a new line of work.The year is...