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:
You need [...]
sqlrockstar MSSQL, PASS, Professional Development, SQL MVP, SQL University, SQLServerPedia Wiki 4
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 [...]
sqlrockstar MSSQL, PASS, Professional Development, SQL MVP, SQL University, SQLServerPedia Wiki 14
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 load their [...]
sqlrockstar MSSQL, PASS, Professional Development, SQL MVP, SQL University, SQLServerPedia Wiki 1
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 to [...]
sqlrockstar MSSQL, PASS, Professional Development, SQL University, SQLServerPedia Wiki 8
Welcome to this week’s installment of SQL University. I am writing this while in transit to the 2011 MVP Summit. Thankfully (?) Delta could not get an airplane out of the hangar on time at MSP this morning, which led to my 3 hour layover in the Sky Club and several glasses of wine and [...]
sqlrockstar MSSQL, Professional Development, SQL MVP, SQL University, SQLServerPedia Wiki 2
Welcome back to SQL University. The topic for discussion this week is Professional Development (PD), or as I like to call it, “the value you have and your boss doesn’t want you to know about”. OK, maybe not your boss, but trust me when I tell you that there are a lot of managers out [...]
sqlrockstar MSSQL, PASS, Professional Development, SQL MVP, SQL University, SQLServerPedia Wiki 12