Whether or not you agree with using SQL to query Active Directory, it is an option, and this article shows how it can be done. There are three ways to query Active Directory (AD) from SQL Server: Using CLR Stored Procedures, using the OpenRowset command, and using the OpenQuery command. This article focuses on the OpenRowset and OpenQuery commands. OpenRowset.
Continue reading the main story. With the cost of some lifesaving cancer drugs exceeding $100,000 a year, more than 100 influential cancer specialists from around the world have taken the unusual step of banding together in hopes of persuading some leading pharmaceutical companies to bring prices down.rices for cancer drugs have been part of the debate over health care costs for several years â and recently led to a public protest from doctors at a major cancer center in New York.
Jazz Pharmaceuticals (JAZZ) has pushed up the price of its narcolepsy drug Xyrem fourfold since 2006, and it's a good example of how prescription costs in the U.S. are out of control.Xyrem now costs as much as $35,000 per year of treatment, and the company says it could double the price again without anyone noticing.azz president Bob Myers said he's not done yet. Another 22 percent price increase was scheduled for Xyrem on Nov. 1, he said told the conference call: Even at our highest dose ... after the price increase the annual cost for 12 prescriptions per month is still only $35,000 per year.