GroupBy – Free SQL Server Training
About This Show
GroupBy.org is free technical training by the community, for the community. Volunteer speakers submit abstracts at GroupBy.org and you – the attendee – vote to pick the sessions. Want to present your own session or just vote on others? Join us at GroupBy.org.
Most Recent Episode
SQL Server Infernals - A Beginner's Guide to SQL Server Worst Practices with Gianluca Sartori
6 days ago
Are you faced with complaints from users, poor performing code from developers, and regular requests to build reports? Do you uncover installation and configuration issues on your SQL Server instances? Have you ever thought that in dire times avoiding Worst Practices could be a good starting point? If the answer is “yes”, then this session is for you: together we will discover how not to torture a SQL Server instance and we will see how to avoid making choices that turn out to be not so smart in the long run. You are probably thinking: “Hey, wait, what about Best Practices?”. Sometimes Best Practices are not enough, especially for beginners, and it is not always clear what happens if we fail to follow them. Worst Practices can show the mistakes to avoid. I have made lots of mistakes throughout my career: come and learn from my mistakes! Circles in the SQL Server Hell: Design sins: Undernormalizers Generalizers Shaky Typers Anarchic Designers Inconsistent Baptists Development sins: Environment Pollutors Overly Optimistic Testers Indolent Developers Installation sins: Stingy Buyers Next next finish installers Maintenance sins: Careless caretakers Performance killers