(Don Kiely) The ability to write stored procedures and other code modules in C#, VB, or any other .NET language has long been one of the most enticing features in what was then the upcoming SQL Server 2005. Both developers and DBAs are finally able to break the shackles of Transact-SQL (T-SQL) and C
Other News
Snippets, widgets and other levels of AJAX development
Gartner analyst Ray Valdes recommends orgs focus on usability and usercentric design from the start of any AJAX project. It’s not about using shiny new tech for the sake of it, he says. Using AJAXto improve the user experience is how you’ll create real business benefit, Valdes told Senior Editor Kat
Capitalizing on SOA
(Arulazi Dhesiaseelan) Service Oriented Architecture (SOA) is another strategic milestone in the enterprise architecture world. Many enterprises fuel the myth that surmount the today’s SOA mantra. Is it real or hypothetic? Are CTOs and CIOs responsible for this hype? The questions remain unanswered.
The Linux Letter: Shedding Light on LAMP
(Barry L. Kline) The “LAMP” phenomenon has been in the spotlight for a couple of years, yet many people don’t really understand what it is. The acronym has been tossed around so much in varying contexts that its true meaning has become obscured. This month, we’ll shine some light into the murky wate
Omit Commas from Numeric Dates
(Ted Holt) Are you tired of seeing commas (or whatever thousands separator you use) in dates when querying data with SQL? Are your users underwhelmed when you give them a quick-and-dirty report that has dates like 20,060,301 and 20,051,124 on it? Do you wish SQL had some way you could easily reforma
Content Manager OnDemand Guide
(Wei-Dong Zhu, Stephanie G Kiefer, Mike Adair, Martin Pepper and Henry Martens) This IBM Redbook covers a variety of topics relating to the practical application of IBM DB2 Content Manager OnDemand for Multiplatforms Version 7.1, z/OS Version 7.1, and iSeries Common Server Version 5.3. Where necessa
SQL Server 2005 DMVs: Exposing the state of your server
(Adam Machanic) Ever want to find out which connections running T-SQL are blocking other connections? Sure, you could run sp_who or query the syslockinfo table, but what if you wanted more information to help debug the problem? For instance, how would you determine which T-SQL the blocking process w
Creating Dynamic DataSets for Crystal Reports in ASP.NET 2.0
(Chuck Bradley) This article describes how to use the CrystalReportsViewer and Crystal Report Template components within VS 2005 and how to populate a report from a dynamically generated DataSet at runtime without login errors. This is typically known as the “push” method.
Storing Data from Dynamic Controls Using ASP.NET 2.0 Callback
(David Vineyard) While developing with ASP.NET 2.0, I ran into a situation where I needed to create controls dynamically. As usual I started looking for best practice methods by searching the websites and blogs I often turn to. Every example I found talked about the need to recreate the dynamically
Connecting Web services with the System.ServiceModel
(William Tay) The new System.ServiceModel namespace, which is a core component of Windows Vista, will change the way .NET developers look at building and securing services. Before developers can get going with full-fledged secure Web services, they need to know how to enable one Web service to talk