Stored Procedure Optimization
Ahmad Osama (MVP, Sr. Consultant, SQLMaestros)
Stored procedures in SQL Server provide multiple benefits such as encapsulating complex business logic, easy deployments and maintenance, data accessibility to name a few. Store Procedures are essential for any database deployment. Optimizing Stored Procedure performance is critical to increasing your application performance. Did you ever come across a situation when a stored procedure, working perfectly the other day, suddenly takes longer to execute? Did you ever come across a situation where a procedure takes longer time to execute for certain set of parameter values? If yes, then this session is for you. This session is an extract from Ahmad’s Advanced SQL Developer Master Class, the only T-SQL Master Class in India. If you are a T-SQL developer, .Net developer writing T-SQL code or a BI developer, this is a must attend session for you.
SQL Server Index Tuning
Amit R S Bansal (MCM, MVP, SQLMaestros)
Having the right indexing strategy is super-critical to SQL Server performance. Join Microsoft Certified Master Amit Bansal in this demo-packed session and learn how to tune SQL Server Indexes. Both clustered and non-clustered indexes will be covered extensively and you can take the learnings back to your environment and apply immediately. Time to become an indexing hero!
Here is the photo collection!
[fbalbum url=”https://www.facebook.com/media/set/?set=a.1789194364684005.1073741908.1396871917249587&type=1&l=7e63febdb6″ limit=10]
Event Resources | Orginal Emailer