DatabaseJournal.com Staff

[From Softpedia] While Microsoft is making its way toward the next generation of its data platform, the company is also kicking up a notch older releases of SQL Server. The free version of SQL Server 2008 is currently available for download, complete with the first service pack released earlier this year. Customers are free to […]

by Jeffrey Garbus Executive Summary: In this past year, the author has had multiple customers accelerate their migrations to ASE 15 with one goal in mind: taking advantage of Very Large Storage Structures (VLSS) in ASE 15 so that they can increase the size of their growing databases to something with an almost unlimited upside. […]

>>Script Language and Platform: SQL SERVER 2000 The procedure will list code, name and current state of each service that is installed on the machine where SQLSERVER2000 is running. EXEC sp_services Author: mikr0s CREATE PROCEDURE sp_services AS CREATE TABLE #services (ident SMALLINT identity, fld NVARCHAR(200)) –get output of command in temporary table INSERT INTO #services […]

>>Script Language and Platform: SQL Server This udf_SuggestUserName function generates usernames based on date of birth, zipcode, username, firstname and lastname. It also generates zodiac username based on date of birth. Useful in suggesting a list of usernames to the person who is trying to register and if the username already exist in the database. […]

[From PR Newswire] MCLEAN, Va., Nov. 24 /PRNewswire-FirstCall/ — MicroStrategy Incorporated, a provider of business intelligence (BI) software, today announced that its free reporting software package, MicroStrategy Reporting Suite, provides a seamless interface to Microsoft Analysis Services. Microsoft SQL Server Analysis Services (SSAS) provides online analytical processing and data mining functionality for business intelligence applications. […]

by Shailesh Khanal If you have SQL Server or Oracle databases in a Microsoft Windows clustered environment, then you’ll want to keep virtual servers running on their preferred nodes, especially if you have more than one virtual database in a cluster. However, sometimes you may discover that database servers are not performing well and you […]

>>Script Language and Platform: MSSQL This script is used to read the data from a flat file and then populate it into the database table. Currently the path and the table names are hardcoded which can be made a parameter variable if the path is not fixed. Author: Alok Vyas SET QUOTED_IDENTIFIER OFF GO SET […]

[From InternetNews] LOS ANGELES – Microsoft kicked off its Professional Developer Conference (PDC09) with the announcement that its Windows Azure cloud platform would be available on Jan. 1, 2010, and new features and functionality would quickly follow suit. The article continues at http://www.internetnews.com/software/article.php/3848866/Microsoft+Offers+Azure+Availability+New+Tools.htm

>>Script Language and Platform: SQL Server This script can be used on both SQL 2000 and SQL 2005 to find the Aunthentication mode set for the sql instance. Author: Vijendran.R Download Script: serverAuth.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these […]

[From Computerworld] Oracle’s seemingly botched migration to a new My Oracle Support portal this week has users worldwide hopping mad over what they are calling severe performance and access issues. The problems, which one poster to the Oracle-L mailing list dubbed a “fiasco,” are reportedly being fixed. But overall, the flap is a lesson learned […]

[From Network World] In a sweeping announcement, Brocade and Oracle last week introduced a variety of solutions designed specifically for use with Oracle database and applications. Based on existing partnerships with NetApp, Sun/StorageTek and EMC, Brocade and Oracle have put together end-to-end networking packages for data warehousing, business applications and virtualization environments. The article continues […]

>>Script Language and Platform: MS SQL 7.0 and MS SQL 2000 This stored procedure can be used by database administrators to inform users before breaking the user’s conenction to the database prior to doing a restore or upgrade. Previously, users were notified by individual email or a phone call. Now, using this single command, every […]