-
Recent Posts
- Registration is open for PASS Data Community Summit! 2022/04/05
- Intelligent Query Processing Session Follow Up 2020/11/16
- Move a VM with Azure Resource Mover 2020/09/24
- Build Your Brand Presentation 2020/08/18
- Azure Data Studio Notebooks and SQL Prompt 2020/06/04
Categories
- Cloud computing (1)
- Database Administration (7)
- High Availability (1)
- Internals (1)
- Life in IT (32)
- Security (2)
- SQL Server 2016 (3)
- SQL Server Administration (5)
- SSIS (6)
- SSRS (8)
- T-SQL (12)
- T-SQL Window Functions (12)
- Uncategorized (26)
Monthly Archives: May 2014
When should I use a stored proc and when should I use a view?
I taught an Introduction to T-SQL class this week in Colorado. It was such a great week teaching and was probably the best group of students I have ever taught. There were lots of questions, and I realized that several would … Continue reading
Posted in T-SQL
Leave a comment
Kids and Coding
Tomorrow morning I am headed to Denver to speak the first meeting of the first PASS physical WIT chapter. As a representative of the PASS Virtual WIT chapter, I answered questions, asked questions, and generally was a resource available for … Continue reading
Posted in Life in IT
Leave a comment
Using Distinct with Window Aggregates
This past Saturday I presented my T-SQL Window Function Performance session at the Atlanta SQL Saturday. There were some interesting questions from the audience that didn’t actually pertain to performance. I didn’t have all the answers since there were some questions … Continue reading
Posted in T-SQL Window Functions
Leave a comment
Aunt Kathi's SQL Server Home 