The goal is to present not only technical topics but also discussion topics that might be controversial. What’s better, CTEs or TSQL cursors? (I know this will generate a lot of buzz.) We also discuss anything related to the SQL Server BI stack and topics of interest to the SQL Server developer. We also discuss and show examples of using Avatars for virtual instructors!
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 will soon have a podcast on SQL server topics, so be on the lookout!
Here are some topics:
· 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.
Cheers …
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?
Here is a sample of my Italian virtual professor(not an actual person, I made the name up) who will teach one of my SQL Server courses this Fall, 2024.
Here is a sample of my French virtual professor(not an actual person, I made the name up) who will teach one of my French SQL Server courses coming this fall, 2024.
Here is a sample of my German virtual professor (not a real person) who will teach one of my Italian SQL Server courses coming this fall 2024.
Last but not least, Here is a sample of my Indian virtual professor(not an actual person; I made the name up) who will teach one of my SQL Server courses for the Indian community
coming this fall, 2024.