This site outlines in excellent detail how you create and use Joins. From inner joins to outer joins and unions, each option is explained and outlined. While the site focuses on SQL Server, additional tips and information are provided for other platforms where possible.

(John MacIntyre) When I needed a pivot table or Crosstab type of view in SQLServer, I was disapointed to not find anything resembling the MS Access Crosstab query. There are tools available, but I didn’t want to pay the kind of money they were asking and felt it necessary to learn how to do this mys

Read more on how to create tables with SQL, the different options available and more. You’ll even have a chance to try your statements right on the site.

(David Worthington and Nate Mook) Microsoft has put pen to paper in outlining its vision for Windows Update. Even though version 4 is still in use by beta testers, Microsoft has drawn up its roadmap for the service’s next generation, which includes SP2 for Windows XP and an updated release of Intern

(Dennis Callaghan) Salesforce.com will announce at its inaugural Dreamforce user and developer conference in San Francisco new versions of its namesake hosted CRM application service and sforce hosted application server. Salesforce.com is adding a SQL-like interface to their product, opening the

(Jeremy Kadlec) Is your organization faced with pending audits, resulting in long and tedious meetings to try to achieve compliance? Have you been hearing a foreign set of acronyms around the water cooler like HIPAA, SOX, GLBA and SAS 70? Have these new sets of requirements been causing consternatio

(Mike Gunderloy) Here’s a problem many developers have faced: your application is out there with customers, it’s cranking along, and you’ve fixed some bugs or enhanced some features. Now you need to update the SQL Server database that it depends on, without losing customer data. You’ve got the SQL s

(Martin LaMonica) Is Microsoft’s new version of Windows a radical innovation or a return to the company’s winner-take-all software strategy from a decade ago? The next operating system, code-named Longhorn, promises a huge leap forward from current versions of Windows, with better graphics, stor

(Itzik Ben-Gan) Tracing client requests and server responses isn’t easy if you’re using SQL Server versions before 6.5. A freeware tracing tool called SQLEye, a network Open Data Services (ODS) sniffer, can do the job, but it’s hard to set up and complex to use, even for basic traces.

(Joe McKendrick) Business intelligence and analytics used to be a closed process in which a small room of analysts loaded sales figures into proprietary software or onto spreadsheets to generate reports for corporate decision makers. Now, three trends are sweeping away this process, but threaten to