MORE ABOUT ME

database Tag

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

db-mirror-meme
Doing it Wrong: Database Mirroring

Just a quick post for some Friday fun.If you want to know how to do database mirroring right, start with this MSDN link: http://msdn.microsoft.com/en-us/library/ms189852.aspxAnd if you are thinking of buying yourself a nice book on Christmas on database mirroring, I'd recommend this one: Pro SQL Server 2008 Mirroring...

create_index_orig_edited
Do You Make These 5 Database Design Mistakes? [SLIDESHOW]

A while back I wrote a post on the five database design mistakes you don't want to make. I always meant to build slides for the post but never seemed to have the time. I finally found a few odd moments here and there over the past few weeks and...

HOW TO: Restore the Master Database in SQL Server 2014

I like having a routine. Most people do, I suppose. There's some comfort in knowing what lies ahead, what comes next.The same holds true for restoring the master database in SQL Server 2014, because it's the same routine as what I posted for SQL Server 2012.For those of you too...

row-page-rz
Size Matters: Table Rows and Database Data Pages

I'm on my way to the PASS Business Analytics conference today. If you are attending, and you are reading this blog post, come find me and Rob Collie (blog | @powerpivotpro) during the welcome reception on Wednesday night; we'd love to talk data.Speaking of data...