(Anant Jhingran) In 2001, I had been at the Almaden labs as the head of computer science for a few months. Almaden database folks — Hamid Pirahesh, Eugene Shekita, Bruce Lindsay, and a countless number of others — had started looking into what it means to do XML inside the database. New innovati
Author: SSWUG Research
What Happens When You Leave an Oracle Database in Backup Mode
(Alex Gorbachev) While I was at that fine conference in Scotland, one of our clients did some maintenance on their Windows server where several databases were running. We had just begun supporting this machine, and hadn’t had a chance to test a reboot. And for some reason, backup/recovery wasn’t — u
Formatting Dates in Crystal reports
(Mahesh Chand) If you have a DateTime field in Crystal Reports, you will see Date and Time tab option on the Format Editor when you right click on the field and select Format Field menu item. From the Date and Time tab, you may select the desired format and select OK.
Database Mirroring: FQDNs are Your Friends!
(Adam Machanic) On a recent project for a customer, I learned an imporant Database Mirroring lesson: fully-qualified domain names (FQDNs) are essential!
Databases and PHP
(Kevin Tatroe, Rasmus Lerdorf and Peter MacIntyre) PHP has support for over 20 databases, including the most popular commercial and open source varieties. Relational database systems such as MySQL, PostgreSQL, and Oracle are the backbone of most modern dynamic web sites. In these are stored shopping
FIX: Incorrect data is inserted unexpectedly when you perform a bulk copy operation by using the DB-Library API in SQL Server 2000 Service Pack 4
When you perform a bulk copy operation by using the DB-Library API in Microsoft SQL Server 2000 Service Pack 4 (SP4), incorrect data is inserted unexpectedly.
ASP.NET 2.0: Leaving ViewState on the Server Speeds up Page Delivery
(Paul Kimmel) I hope you made it to TechEd 2007. If you didn’t or made it but didn’t see Jeff Prosise’s ASP.NET tips, I am including one of my favorite TechEd tips. First I’d like to mention that Jeff’s presentation was one of the most polished, professional, and well-delivered presentations I have
Calling an ASMX webservice from Silverlight? Use a static port.
(Jon Galloway) Rob Conery recently posted on Creating a Web Service-Enabled Login Silverlight Control, which is probably a more important topic than many people realize right now. Since Silverlight code runs client side in the user’s browser, many tasks like database access and user authentication r
Building a SQL Server Lab
(Buck Woody) lab·o·ra·to·ry (From the Medieval Latin labrtrium, from Latin labrre, to labor) 1. A room or building equipped for scientific experimentation or research, an academic period devoted to work or study in such a place. 2. A place for practice, observation, or testing
A New Identity for Web Services
(Jason Levitt) It’s practically de rigueur these days for web sites with a lot of users and data to have web services. For example, YouTube.com has a set of REST web services that returns essentially the public-facing video data that users have made available on the site. A harder problem, though, i