(Dimitar Madjarov) This article actually is an heir of my first article from this topic about programming with Oracle and C#. The first article is available for reading on next web address “Processing with C#, Oracle transactions and Oracle exceptions”. In my first article I describe an alternative
Author: SSWUG Research
Dealing with case and accents in SQL Server
(Arthur Fuller) Collation describes the code page, case sensitivity, accent sensitivity, and language or alphabet in use. I often see collation handled on a per-database scale. For instance, in my experience, most DBAs in North America go with the default collation, which is case insensitive. The co
DB2 Express-C – free to build, deploy, distribute – now backed by IBM Support
(Chris Eaton) A year ago, IBM delivered DB2 Express-C with the tag line free to build, deploy, distribute. That’s was pretty cool to have a free version of DB2 that includes pureXML and is the same codebase that you get with DB2 Enterprise for Linux and Windows. I really think the best thing here is
Secure, Reliable Web Services with Apache
(Kyle Gabhart) Open source computing has gained a tremendous degree of momentum in the last few years. Nowhere is this more evident than in the area of web services and Service-Oriented Architecture (SOA). The Apache Foundation alone has more than 20 SOA/WS projects. One of the common obstacles for
Recovering MEMORY tables during slave start up
(Il Corra) Using MEMORY tables in MySQL is very useful; they are stored in memory and they are usually not so big in order to avoid a huge utilization of RAM. They are very fast.
Choosing between CLR and T-SQL stored procedures: a simple benchmark
(Greg Larsen) In my previous article (Building my First SQL Server 2005 CLR) I wrote about my experiences coding and implementing my first SQL Server 2005 CLR procedure. The idea was to: –Provide a “learn through my pain” tutorial for people considering adoption of CLR functionality –Demonstr
Multitable insert
(MD) Multitable insert is a feature I’ve read about many times, but I’ve never taken the time to read up on it or play with the way this SQL statement works. I figure making a post about it will give me the reason I need to learn more about it.
High Availability: Meeting the Global Challenge
(Michael Di Stefano) Distributed computing environments are being deployed in topology and scale never before seen. As implementations multiply, this revolutionary era in computing brings with it a number of unique challenges and possibilities, such as high availability. As global firms strive to ma
Query XML data from a table with XML data type
(Muthusamy Anantha Kumar) The objective of this article is to guide Microsoft SQL Server Database Administrators on how to: –Create XML Schema –Create a table with XML data type –Import XML file to the table with XML data type –Query the XML file –Query the XML file and produce resu
DB2 is Open for business!
(Chris Gruber) The news of the yearly subscription opens new business models for DB2. DB2 Express-C is a free database without any limits in database size. I could go on and on about how many free database offerings limit your deployments, but I won’t.