SelectViews – THE SQL Server Show The show has been updated and you can check it out now. The show asks for additional feedback on SharePoint (and explains a bit more about what we’re considering) – so we need your feedback. Also, information about what SSDS actually is, and is not. The 60-second SQL Server tip of the day, information […]
Other News
SSDS, The Cloud and Managed Services
SelectViews – Updated Show Link (Sorry about the issue with the show link on Friday) – The show has been updated and you can check it out now. The show asks for additional feedback on SharePoint (and explains a bit more about what we’re considering) – so we need your feedback. Also, information about what SSDS actually is, and is […]
SQL Trusted Connections with ASP.NET
(blowdart) Hard coding passwords into your application or your web site is a bad thing. Microsoft SQL has the ability to use “trusted connections” to authenticate your database connection against your login name, so no passwords are ever sent to SQL server, just your login name and an authentication
Quirks Mode – Using the DOCTYPE Tag
(Jennifer Kyrnin) If you’ve been designing Web pages for more than a few months, you are most likely aware of the difficulty in writing a page that looks the same in all browsers. In point of fact, it’s impossible. Many browsers were written with special items that only they could handle. Or they ha
Declarative Data Filtering
(Steve Muench) In this column, we continue our exploration of the new features in the upcoming Oracle JDeveloper/Oracle Application Development Framework (Oracle ADF) 11g release by looking at a new feature called view criteria. The view criteria feature provides a declarative filtering mechanism th
Use Functional Programming Techniques in the .NET Framework
(Ted Neward) A recent entry into the Microsoft .NET Framework family, F# provides type safety, performance, and the ability to work like a scripting language, all as part of the .NET environment. This functional language was created by Don Syme of Microsoft Research as a syntax-compatible OCaml vari
On setting commit_write
(René Nyffenegger) Recently, I had a company call me because they had a performance problem. After inquiring how that problem manifested itself, they told me that they needed to update an application with lots of data to a newer relase and that they used a «tool» that migrated that data. The estimat
News on DB2 Optimization Expert for z/OS V1.2 and DB2 Optimization Service Center Version 1.1
In this technote we summarize the main enhancements provided in this release. DB2 for z/OS Version 8 support is also included among these enhancements.
Ajax and XML: Ajax for tables
(Jack D Herrington) One strong suit of Asynchronous JavaScript + XML (Ajax) is presenting data from the server to users in a dynamic fashion. Discover several techniques that use Ajax for dynamic data display using tables, tabs, and gliders.
Bind Peeking, Ad Hoc Queries, Stable Performance. On 10G you can only pick any two.
(Christo Kutrovsky) I got to troubleshoot an amazing situation a few weeks ago. I think, we can all agree that assuming we are on a supported configuration of a production release of Oracle, it is essentially inconceivable that allowing a single query to run on your system can flip another query’s p