-
Recent Posts
- Update from Nikita 2025/04/09
- Help requested for a friend of PASS Summit 2024/11/19
- 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
Categories
- Cloud computing (1)
- Database Administration (7)
- High Availability (1)
- Internals (1)
- Life in IT (33)
- Security (2)
- SQL Server 2016 (3)
- SQL Server Administration (5)
- SSIS (6)
- SSRS (8)
- T-SQL (12)
- T-SQL Window Functions (12)
- Uncategorized (27)


Author Archives: Kathi Kellenberger
I’m back…
After three weeks off work to recover from surgery, I go back tomorrow. My commute is about 10 steps. If I actually had to drive to an office for work, I would have needed at least another week off. I am still sleeping … Continue reading
Posted in Life in IT
3 Comments
How to use PIVOT
I recently explained how to write a PIVOT query to a group of new T-SQL developers. I have to admit that the syntax is complicated enough, and I use PIVOT infrequently enough, that I always have to look up how … Continue reading
Posted in T-SQL
Leave a comment
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
