News

News

• June 24, 2005 24 Jun'05

  Java driver for SQL Server updated

  Microsoft has begun a public test for an updated version of its Java Database Connectivity (JDBC) Driver.

• June 08, 2005 08 Jun'05

  SQL Server's reporting tool goes across the board 2

  While announcing when SQL Server 2005 and Visual Studio 2005 will ship, Microsoft senior vice president Paul Flessner also outlined plans for tools, previews and editions of the company's database management platform.

• June 08, 2005 08 Jun'05

  SQL Server's reporting tool goes across the board

  While announcing when SQL Server 2005 and Visual Studio 2005 will ship, Microsoft senior vice president Paul Flessner also outlined plans for tools, previews and editions of the company's database management platform.

• May 13, 2005 13 May'05

  Ensuring SQL Server data integrity

  Ensuring SQL Server data integrity on many fronts is covered in this step-by-step guide.

• May 13, 2005 13 May'05

  Step 7: Use a "check-in/check-out" mechanism for contested data

  Get help handling contention for updating a particular row in SQL Server.

• Sponsored News

  • Cloud Governance Doesn’t Have to Be a Resource Drain: The Benefits of Automated Policy Management

    Sponsored by CloudHealth - As enterprises continue to add new use cases and workloads to their cloud portfolio, the stakes keep rising for potential governance speed bumps. Business users and IT professionals alike are now using the cloud for everything from compliance and security to cloud-native application development and infrastructure optimization. But this makes policy management more difficult, time consuming and costly, especially with so many cloud services being purchased and deployed outside the scope, visibility and control of a centralized IT operations group. See More

  • Reaping Economic Benefits from Improved Cloud Management

    Sponsored by CloudHealth - In the era of Cloud 1.0, early adopters were often drawn to the cloud because it allowed them to reduce Capex and move to a more predictable subscription pricing model. In recent years, cloud adoption has surged because organizations have recognized that it not only reduces their hardware purchases and per-seat software licenses but provides many operational benefits as well. See More

  • Security Can Be Enhanced in the Cloud―But Only If You Make It a Priority

    Sponsored by CloudHealth - For more than a decade, the biggest gating factor in cloud computing adoption was perceived security risks. IT professionals and business leaders alike were often extremely concerned about a perceived loss of control of mission-critical data and essential applications when moved to the cloud. See More

  View All Sponsored News
• May 13, 2005 13 May'05

  Step 4: Be careful how you enforce internal referential integrity through triggers

  Learn how to properly use triggers to protect SQL Server data integrity rules.

• May 13, 2005 13 May'05

  Step 6: Don't expose interfaces that create dynamic SQL to the end user

  Be careful not to create poisoned code when using dynamic SQL.

• May 13, 2005 13 May'05

  Step 2: Segregate data aggressively into files and filegroups

  Find out how data segregation can help you preserve SQL Server data integrity in this step of our step-by-step guide.

• May 13, 2005 13 May'05

  Step 1: Back up, optimize and enable safety features

  Step 1 of our data integrity guides explains how to develop your data integrity strategy.

• May 13, 2005 13 May'05

  Step 5: Use constraints and relationships to keep out bad data

  Learn why you must use SQL Server's CHECK constraints to enforce constraints on inserted data.

• May 13, 2005 13 May'05

  Step 3: Consider using implicit transactions

  Get up to speed on server-level options to add another layer of integrity protection.

• May 12, 2005 12 May'05

  Visual FoxPro 9.0 more SQL Server friendly

  The recent update to the Microsoft development platform -- with new features such as an enhanced report writer -- finds fans in the database application development community.

• May 06, 2005 06 May'05

  Microsoft offers update for SQL Server 2000

  Service Pack 4 rolls up previous fixes for the database management software and adds some new features as well.

• May 02, 2005 02 May'05

  Fixes, features added to SQL Server tool

  An update for Microsoft's SQL Server Reporting Services breaks from the software company's typical routine for service packs.

• April 08, 2005 08 Apr'05

  Step 5: Deploy hotfixes

  Learn how to deploy hotfixes in this SQL Server patch management guide.