Welcome back to another week of SQL University. The winter season is behind us and Spring has sprung (finally) and that’s why I haven’t been wearing pants or shoes since March 21st. Give it a try yourself and you’ll be surprised as to how the promise of good weather can really improve your daily outlook. … Read more
Welcome back to SQL University! Today we talk about Very Large DataBases (VLDBs). I hope this blog post helps get you pointed in the right direction with regards to architecting and building your very own VLDB someday. (Chances are you already have one and maybe don’t know it yet!) Let’s get it started. tempdb First … Read more
Welcome back to another week of SQL University where the topic is Performance Tuning. Show of hands: how many people think performance tuning is hard? OK, put your hands down, you are sitting at a computer and it looks really weird. Anyway, many folks think performance tuning is hard and here are the main reasons: … Read more
Welcome back to another week of SQL University. This week we are going to spend some time getting familiar with SQL Azure, which is really just a fancy term for ‘distributed computing’. And while you may not have a need for such a thing today you should spend time getting familiar with SQL azure because … Read more
Welcome back to SQL University! I hope you enjoyed your Spring Break last week. Today’s topic is all about storage, so let’s get started. tempdb The first thing you need to understand is that SQL Server reads all data into memory in order to perform operations. Often you will hear people say how they could … Read more
Welcome back to SQL University. It is now March, which is Women’s History Month, which means we get things started with the topic of Women in Technology. I know what you are thinking: “Tom, you are not a woman, how could you write about such a topic?” I have no idea, but I am going … Read more
