I am in Atlanta this week for Tech-Ed…right after I watch the launch of the Space Shuttle on Monday morning. Despite my commitments to both of those events I cannot ignore my SQL University duties, so here is this week’s post. We are going to talk about the internals of SQL Server, a topic that [...]

I may be at SQL Rally this week but that doesn’t excuse me from my SQL University duties. Today we are going to talk about SQL Server Analysis Services. While most nearly everything in the BI stack is outside my comfort zone I should remind you all that I stayed at a Holiday Inn Express [...]

So, once again I find myself needing to do a SQL University post on a topic we have already covered this semester. Which also means that once again I am going to mail it in and just point you to the post I wrote earlier, which is also a re-post of something I had already [...]

So, it looks like we have a second week of Powershell for SQL University. Honestly, I wish I could say I saw this coming in the lesson plan, but I didn’t. So I don’t have much new to share with you since my last post on Powershell. And since this isn’t sweeps week, I think [...]

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.
Today’s [...]

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 up, a question [...]