Working with a .Net
From exposing data that is traditionally not available to queries, to simplifying queries against dynamic data, SQLCLR can provide handling of special use cases, and even greatly enhance performance.
Nearly 10 years after it was first introduced, SQLCLR remains something of a pariah in the world of SQL Server. In this session, we’ll re-explore what’s possible with SQLCLR, key considerations, and security concerns. We’ll discuss reasons to implement SQLCLR, and reasons not to.
- Robert (Blog | LinkedIn) experienced his first infection with computing fever in 1978. He has since typically worked in roles that allow him to combine his knowledge of business and computing. Rob is the author of several best-selling books on software development, and has been certified in multiple arenas of both business and technology. He is currently a Software Architect for Huron Legal, and resides with his wife and two youngest children in Vancouver, WA.
SQL Server Performance Tuning – Tidbits for Beginners
Maintaining SQL Server performance is a constant task. Whether you are a developer or an administrator, there are many things that you can do to avoid those poorly performing queries. In this short session I’ll discuss some common guidelines and offer some tidbits for developing fast queries; and if you already have some poorly performing queries, I’ll show you some ways to identify and fix them.
- Vern (LinkedIn) is an independent SQL Server consultant and contract trainer in Portland, OR. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been working with databases for over 20 years, and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server skills gained from the mixture of academic and practical experiences acquired from his classroom instructing and consulting contracts.
- Featured Sponsor: ServerLogic
ServerLogic provides innovative software products, IT staffing and placement services, corporate website development and hosting services, eGovernment consulting services, and IT infrastructure support for Global 2000 companies, startups, and government.
Visit the Serverlogic website for more details.
Interject Data Systems is the Refreshments Sponsor for January.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL and generously providing the meeting venue.