Groupby Free Sql Server Training

SQL Server Infernals - A Beginner's Guide to SQL Server Worst Practices with Gianluca Sartori

Informações:

Sinopsis

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 Ove