About Us: SQL Server MVP Stephen Wynkoop founded SSWUG.ORG in 1999 as one of the first cross-platform sites to cover enterprise technologies. Since then, the site has gone from being a part-time hobby to a reputable content provider with thousands of articles and video-based training sessions. Our mission is to provide relevant news and information on data management, collaboration software,...
Other News
Monitor DB Transactional Blocking Locks in Oracle 9i
(Roger Eisentrager) This script will both alert and capture relavent data on Oracle SQL blocking locks events.
MySQL – The Real Broadband Brain
(Om Malik) In a broadband enabled life, no piece of software is as crucial as a database – from our cell phone records, our blog entries, our address books, and of course all the information we need to store about our music collections, digital downloads and emails. In an effort to understand th
.NET Remoting and Event Handling in VB .NET
(Paul Kimmel) You can implement very advanced solutions with .NET Remoting. XML Web Services is an example of a general .NET Remoting solution. If you are writing distributed applications you can often use XML Web Services as an easy form of Remoting. That said, let’s talk about .NET Remoting.
Filling Classrooms Through Intelligent Analysis
(Scott Eden) Because American universities compete for students almost as fiercely as businesses do for customers, business intelligence has been on campus for some time, and Florida State University was among the earliest in higher education to adopt it. The Tallahassee school has been using so
Share Your Data as XML
(Sean Dillon) XML has quickly become the de facto mechanism for sharing data between disparate information systems. IT departments are deciding between purchasing native XML databases and converting existing data from relational and object-based storage to an XML model that can be shared with busine
Index Internal Information
(Kalen Delaney) The sysindexes system table contains information about your index structures that you can’t get through information schema views. Every database has a sysindexes table, which contains one row for every index and one row for every column-based statistics on a table. In general, Mi
Versioning
(Andre Vigneau) The question is why do you want to know which version of Microsoft SQL Server you’re running? In my case it is for compatibility purposes. Applications or scripts might not always be compatible with older versions of SQL Server. Also in the same way applications or scripts might n
Creating Surrogate Numeric Keys for Tables
(Tom Reid) A common feature of database systems is that certain tables are required to have a unique numerical key that can be used to identify records. A lot of effort is sometimes expended using all sorts of convoluted coding schemes to ensure that this happens. What a lot of people don’t know
What Makes a Good Product
(Arjen Lentz) This article explores a few thoughts and observations that I see as relevant for the creation and marketing of open source in the real world. It is based on part of the keynote “How to Eat an Elephant” which I presented at the AUUG Annual Conference in Melbourne, September 2004.