In this webcast we will look at ways to improve your SQL Server code and some approaches that can make a big difference in overall performance and maintainability. Some of the things we will look at include: use of cursors, missing indexes, use of temporary tables and a lot more.
In this webinar we will target some of the most common areas of performance categories, such as disaster recovery, index optimization, query optimization, disk, memory, network, processor, database configuration, server configuration, security, deadlocks, blocking processes, long running jobs, open transactions, and wait stats.
DBAs often find themselves doing data modeling as an extra task, and may need some guidance on how to do this effectively. In this webinar we will show you some data modeling tips with ER/Studio, including reverse-engineering, using submodels, color-coding, and more.
In this webcast we will look at SQL Server connection issues and how to diagnose and resolve them. Attend this webcast and learn from Robert Davis who is a Microsoft Certified Master in SQL Server and a Data Platform MVP.