The goal is too present not only technical topics, but also discussion topics that might be controversial. Like what’s better CTEs or TSQL CURSORS? I know this will generate a lot of buzz.
Published author with over 30 years of experience in Business Intelligence, Data Architecture, Data Warehouse Design, Data Modeling, Master Data Management, and Data Quality using the Microsoft BI Stack across several industry sectors such as Finance, Publishing and Automotive.
Masters In Computer Science - Polytechnic Institute of New York, 1986
Bachelor’s Electrical Engineering – Pratt Institute, Brooklyn New York, 1982
Getting back to the blog, my goal is too present not only technical topics, but also current discussion topics that might be controversial. Like what’s better CTEs or TSQL CURSORS?
I know this will generate a lot of buzz.
Or how about, what is better? STAR schema or SNOWFLAKE schema?
I hope that you will give me some feedback, some suggestions or even constructive criticisms and opinions.
Let me know what you want to discuss!
Lastly, I hope I can convince you visit my forum web site and vote on topics. Check it out at:
Here are some topics we will talk about in 2021:
· Traditional Database Design. Who uses it?
· Is data modeling still relevant?
· STAR or SNOWFLAKE schema?
· Is SSAS still viable?
· Is MDX still viable?
· BIG data versus traditional relational databases?
· The battle continues, CTEs versus CURSORS.
By the way, I will use your feedback to create web-based video training course on my web site:
Check it out, I will have introductory, intermediate and advanced courses on the SQL Server BI stack which I know you will find interesting and even helpful if you are considering a career as a SQL Server developer or architect.
By the way, I also have a podcast so check it out at:
Besides some technical podcasts on creating databases, tables and queries with Microsoft SQL Server I will also publish the following podcasts 1st and 2ndquarter 2021:
· Who Is the Grumpy OLD It Guy?
· R/SQL Server support. Is it worth it?
· Python/SQL Server support. Is it worth it?
· JSON/SQL Server support. Is it worth it?
· XML/SQL Server support. Is it worth it?
· Why do developers hate cursors?
· So, you want to be a SQL Server Architect.
· So, you want to be a SQL Server Developer.
· So, you want to be a DBA? (What’s that?)
· What ever happened to SQL Broker?
Last but not least, please make sure to check out my training web site at:
where you can attend my Grumpy University and become a grumpy old IT guy specializing in Microsoft SQL Server.
See you soon.
Oh yes, I would appreciate any sort of comments, opinions, constructive criticism and suggestions. Please send me an email at:
I would love to hear from you.
The Grumpy Old IT Guy
Are we still designing Conceptual, Logical and Physical Database models?
Which is better?
Is SQL Server Analysis Services a valuable BI platform?
MDX is a complex hard to learn multi-dimensional query language. Who is using it and why?
BIG data, is it really worth it?
Why do you hate CURSORS?