Adam Machanic, SQL Server Practice Lead for The Pythian Group, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
I was just reviewing my calendar for the next several weeks and noticed that
the Toronto SQLTeach conference is now
only a few weeks away. This conference includes quite a few interesting SQL Server-related
sessions, on topics ranging from best practices, to performance, to some of
the new SQL Server 2008 features. I fully expect this to be a great show.
I am doing two breakout sessions during the main conference:
- SQL Server 2005: Authorization, Privilege, and Access Control. In this
talk I cover SQL Server 2005’s enhancements around granting permissions via
stored modules (i.e., stored procedures, views, functions)
- Designing Highly Concurrent Database Applications. In this talk I get
into the business requirements behind supporting concurrent processes, and the
areas where SQL Server (and every other database product) falls short. I then go
on to show how to solve the problems in the database programmatically.
I am also doing a full-day post-conference session on SQLCLR
programming. This will be the first time that I will be presenting all
of my SQLCLR material in a single day; should be fun. I will take attendees from
the basics all the way through some advanced applications and techniques, so if
you’re interested in becoming a SQLCLR expert I highly recommend attending.
The conference starts in just three weeks, but it is not too late to register.
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Adam Machanic
Adam Machanic is the SQL Server Practice Lead for The Pythian Group, a leading provider of wholly and partially outsourced remote administration of the enterprise database tier, for over 100 customers around the world. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "Expert SQL Server 2005 Development" (Apress, 2007) and "Inside SQL Server 2005: Query Tuning and Optimization" (Microsoft Press, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP).