Welcome back to SQL University, this week we are going to learn about data warehouses. I still remember the first time I saw what was described as a data warehouse. It was really just a bunch of excel spreadsheets shoved into SQL 2000 in a manner that allowed folks to run queries against and if … Read more
Welcome back to another week of SQL University. This week’s lesson is on security, you know, that thing that most people never think about until it is too late? Or put another way, that thing that people never want you to mention. Ever. Well, that’s too bad because this time we are going to mention … Read more
Welcome to another week of SQL University. I will continue to step outside my comfort zone by giving you some advice on how to get started with SQL Server Reporting Services. I am by no means an expert, but I have dabbled with SSRS from time to time. I know just enough to be dangerous, … Read more
[This is a re-post from the last SQLU SSIS week, because I haven’t learned anything new since then!] Welcome back to SQL University! This week I am going to step *way* outside my comfort zone and talk about SSIS. I am not embarrassed to say that I have little to no practical experience as an … Read more
[Note: I took my original SQLU blog post for Powershell and updated it for use this week. So, if you’ve heard me say all these things before, now you know why.] Welcome back to SQL University, the only university conducted entirely through blog posts, has no exams, and is organized by a chicken. This week … Read more
Welcome back to SQL University. This week the topic is capacity planning. As your DBA Coach it is my role to help you understand the different levels for the subject at hand. Capacity planning is a subject that applies to just about everything in life; how much money is left in your bank account, how … Read more
